Postgresql Error (500 server error) - Mastondon-FE - Post database pruning --vacuum
Environment
- Installation type (OTP or From Source):Yunohost
- Pleroma version (could be found in the "Version" tab of settings in Pleroma-FE): 2.1.2
- Elixir version (
elixir -v
for from source installations, N/A for OTP):N/A - Operating system:Linux pop_OS 20.10
- PostgreSQL version (
psql -V
):(PostgreSQL) 11.9 (Debian 11.9-0+deb10u1)
Bug description
PostgreSQL connection errors after running prune database --vacuum. Home timeline failing to load and returning 500 error. Using Soapbox-FE, and switching to Pleroma-FE and Mastodon-FE.
Corrected by turning off Mastodon FE (Show instance specific panel) in settings.
Note - This issue did not affect mobile apps. Only web front ends.
Log Output
Jan 6 16:26:56 ** pleroma[2035]: #PID<0.17798.0> was at location: Jan 6 16:26:56 ** pleroma[2035]: :prim_inet.recv0/3 Jan 6 16:26:56 ** pleroma[2035]: (postgrex 0.15.5) lib/postgrex/protocol.ex:2838: Postgrex.Protocol.msg_recv/4 Jan 6 16:26:56 ** pleroma[2035]: (postgrex 0.15.5) lib/postgrex/protocol.ex:1880: Postgrex.Protocol.recv_bind/3 Jan 6 16:26:56 ** pleroma[2035]: (postgrex 0.15.5) lib/postgrex/protocol.ex:1735: Postgrex.Protocol.bind_execute_close/4 Jan 6 16:26:56 ** pleroma[2035]: (db_connection 2.2.2) lib/db_connection/holder.ex:316: DBConnection.Holder.holder_apply/4 Jan 6 16:26:56 ** pleroma[2035]: (db_connection 2.2.2) lib/db_connection.ex:1255: DBConnection.run_execute/5 Jan 6 16:26:56 ** pleroma[2035]: (db_connection 2.2.2) lib/db_connection.ex:1342: DBConnection.run/6 Jan 6 16:26:56 ** pleroma[2035]: (db_connection 2.2.2) lib/db_connection.ex:539: DBConnection.parsed_prepare_execute/5 Jan 6 16:26:56 ** pleroma[2035]: 16:26:56.653 request_id=FleNWCpJQkZymnMAAScE [error] Internal server error: %DBConnection.Connect$ Jan 6 16:26:56 ** pleroma[2035]: 16:26:56.654 request_id=FleNWCpJQkZymnMAAScE [info] Converted error DBConnection.ConnectionError $ Jan 6 16:26:56 ** pleroma[2035]: 16:26:56.656 [error] #PID<0.17798.0> running Pleroma.Web.Endpoint (connection #PID<0.17796.0>, st$ Jan 6 16:27:11 ** pleroma[2035]: Request: GET /api/v1/timelines/home?with_muted=true&limit=20 Jan 6 16:27:11 ** pleroma[2035]: ** (exit) an exception was raised: Jan 6 16:27:11 ** pleroma[2035]: ** (DBConnection.ConnectionError) tcp recv: closed (the connection was closed by the pool, po$ Jan 6 16:27:11 ** pleroma[2035]: (ecto_sql 3.4.5) lib/ecto/adapters/sql.ex:593: Ecto.Adapters.SQL.raise_sql_call_error/1 Jan 6 16:27:11 ** pleroma[2035]: (ecto_sql 3.4.5) lib/ecto/adapters/sql.ex:526: Ecto.Adapters.SQL.execute/5 Jan 6 16:27:11 ** pleroma[2035]: (ecto 3.4.5) lib/ecto/repo/queryable.ex:192: Ecto.Repo.Queryable.execute/4 Jan 6 16:27:11 ** pleroma[2035]: (ecto 3.4.5) lib/ecto/repo/queryable.ex:17: Ecto.Repo.Queryable.all/3 Jan 6 16:27:11 ** pleroma[2035]: (pleroma 2.1.2) lib/pleroma/pagination.ex:40: Pleroma.Pagination.fetch_paginated/4 Jan 6 16:27:11 ** pleroma[2035]: (pleroma 2.1.2) lib/pleroma/web/activity_pub/activity_pub.ex:1078: Pleroma.Web.ActivityPu$ Jan 6 16:27:11 ** pleroma[2035]: (pleroma 2.1.2) lib/pleroma/web/mastodon_api/controllers/timeline_controller.ex:57: Plero$ Jan 6 16:27:11 ** pleroma[2035]: (pleroma 2.1.2) lib/pleroma/web/mastodon_api/controllers/timeline_controller.ex:5: Plerom$