Database crash
Mar 03 18:08:08 pleroma[1324]: 18:08:08.231 [error] Process #PID<0.7346.9> on node :"pleroma@127.0.0.1" raised an exception
Mar 03 18:08:08 pleroma[1324]: ** (DBConnection.ConnectionError) connection not available and request was dropped from queue after 815ms. This means requests are coming in and your connection pool cannot serve them fast enough. You can address this by:
Mar 03 18:08:08 pleroma[1324]: 1. By tracking down slow queries and making sure they are running fast enough
Mar 03 18:08:08 pleroma[1324]: 2. Increasing the pool_size (albeit it increases resource consumption)
Mar 03 18:08:08 pleroma[1324]: 3. Allow requests to wait longer by increasing :queue_target and :queue_interval
Mar 03 18:08:08 pleroma[1324]: See DBConnection.start_link/2 for more information
Mar 03 18:08:08 pleroma[1324]: (ecto_sql 3.4.5) lib/ecto/adapters/sql.ex:593: Ecto.Adapters.SQL.raise_sql_call_error/1
Mar 03 18:08:08 pleroma[1324]: (ecto_sql 3.4.5) lib/ecto/adapters/sql.ex:526: Ecto.Adapters.SQL.execute/5
Mar 03 18:08:08 pleroma[1324]: (ecto 3.4.6) lib/ecto/repo/queryable.ex:192: Ecto.Repo.Queryable.execute/4
Mar 03 18:08:08 pleroma[1324]: (ecto 3.4.6) lib/ecto/repo/queryable.ex:17: Ecto.Repo.Queryable.all/3
Mar 03 18:08:08 pleroma[1324]: (pleroma 2.2.2) lib/pleroma/activity.ex:321: Pleroma.Activity.restrict_deactivated_users/1
Mar 03 18:08:08 pleroma[1324]: (pleroma 2.2.2) lib/pleroma/activity.ex:217: Pleroma.Activity.get_create_by_object_ap_id/1
Mar 03 18:08:08 pleroma[1324]: (pleroma 2.2.2) lib/pleroma/web/mastodon_api/views/status_view.ex:249: Pleroma.Web.MastodonAPI.StatusView.render/2
Mar 03 18:08:08 pleroma[1324]: (pleroma 2.2.2) lib/pleroma/web/views/streamer_view.ex:45: Pleroma.Web.StreamerView.render/2
Mar 03 18:08:08 pleroma[1324]: 18:08:08.233 [error] Process #PID<0.7353.9> on node :"pleroma@127.0.0.1" raised an exception
Environment
- Installation type (OTP or From Source): OTP
- Pleroma version (could be found in the "Version" tab of settings in Pleroma-FE): 2.2.2
- Elixir version (
elixir -v
for from source installations, N/A for OTP): N/A - Operating system: Ubuntu 20.04.2 LTS x86_64
- PostgreSQL version (
psql -V
): psql (PostgreSQL) 12.6
Edited by Bane Biddix