I've run the vacuum several times, but I'll give what you said a shot. I had considered that I turbo-fucked the database somehow, but I'm *really* hoping that's not the case. Should I stop the pleroma service prior to running the vacuum task? Thanks!
Hey @alex , sorry to bother, but I seem to have super duper fucked my server up and I’m not quite sure how to remediate the issue. From what I can gather, there are too many database connections going on for some reason and the overwhelming majority of them are timing out. I upgraded to the latest develop branch of Soapbox-BE (not Rebased) and ran the mix ecto.migrate per the Pleroma administration documents.
I imagine this error is the one that’s causing the majority of my problems:
Oct 18 16:08:18 nicecrew mix[19683]: ** (DBConnection.ConnectionError) connection not available and request was dropped from queue after 153ms. This means requests are coming in and your connection pool cannot serve them fast enough. You can address this by:
Oct 18 16:08:18 nicecrew mix[19683]: 1. Ensuring your database is available and that you can connect to it
Oct 18 16:08:18 nicecrew mix[19683]: 2. Tracking down slow queries and making sure they are running fast enough
Oct 18 16:08:18 nicecrew mix[19683]: 3. Increasing the pool_size (albeit it increases resource consumption)
Oct 18 16:08:18 nicecrew mix[19683]: 4. Allowing requests to wait longer by increasing :queue_target and :queue_interval
Oct 18 16:08:18 nicecrew mix[19683]: See DBConnection.start_link/2 for more information
But there’s also this error and I’m not sure if it’s relevant:
Oct 18 16:08:21 nicecrew mix[19683]: ** (ArgumentError) errors were found at the given arguments:
Oct 18 16:08:21 nicecrew mix[19683]: * 1st argument: the table identifier does not refer to an existing ETS table
Oct 18 16:08:21 nicecrew mix[19683]: (stdlib 3.17.2) :ets.lookup(Pleroma.Web.Endpoint, :__phoenix_url__)
I appreciate any help you can provide because I’m at a complete loss right now.