Release/2.0.0 some issues with db maintenance tasks?
On one of my instances, the DB maintenance tasks I'm trying are failing:
sudo -Hu pleroma MIX_ENV=prod mix pleroma.database bump_all_conversations
gives me (at the end of the output):
00:28:05.575 [debug] QUERY OK source="activities" db=2.7ms SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at" FROM "activities" AS a0 WHERE (a0."data"->>'type' = $1) AND (activity_visibility(a0."actor", a0."recipients", a0."data") = $2) ORDER BY a0."id" ["Create", "direct"]
00:28:05.602 [info] Application pleroma exited: :stopped
00:28:05.616 [debug] QUERY ERROR source="activities" db=40.6ms SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at" FROM "activities" AS a0 WHERE (a0."data"->>'type' = $1) AND (activity_visibility(a0."actor", a0."recipients", a0."data") = $2) ORDER BY a0."id" ["Create", "direct"]
00:28:05.616 [debug] QUERY ERROR source="activities" db=0.0ms SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at" FROM "activities" AS a0 WHERE (a0."data"->>'type' = $1) AND (activity_visibility(a0."actor", a0."recipients", a0."data") = $2) ORDER BY a0."id" ["Create", "direct"]
00:28:05.616 [debug] QUERY ERROR db=0.0ms rollback [] ** (DBConnection.ConnectionError) tcp recv: closed (db_connection) lib/db_connection.ex:1609: DBConnection.stream_fetch/3 (elixir) lib/stream.ex:1407: Stream.do_resource/5 (elixir) lib/stream.ex:1583: Enumerable.Stream.do_each/4 (elixir) lib/stream.ex:876: Stream.do_transform/5 (elixir) lib/stream.ex:1583: Enumerable.Stream.do_each/4 (elixir) lib/enum.ex:3023: Enum.each/2 (ecto_sql) lib/ecto/adapters/sql.ex:886: anonymous fn/3 in Ecto.Adapters.SQL.checkout_or_transaction/4 (db_connection) lib/db_connection.ex:1427: DBConnection.run_transaction/4
sudo -Hu pleroma MIX_ENV=prod mix pleroma.database prune_objects
gives me:
00:26:19.413 [info] Gopher server disabled
00:26:19.413 [info] Pruning objects older than 90 days
00:26:19.522 [info] Application pleroma exited: :stopped ** (DBConnection.ConnectionError) tcp recv: closed (ecto_sql) lib/ecto/adapters/sql.ex:612: Ecto.Adapters.SQL.raise_sql_call_error/1 (ecto_sql) lib/ecto/adapters/sql.ex:545: Ecto.Adapters.SQL.execute/5 (pleroma) lib/mix/tasks/pleroma/database.ex:94: Mix.Tasks.Pleroma.Database.run/1 (mix) lib/mix/task.ex:331: Mix.Task.run_task/3 (mix) lib/mix/cli.ex:79: Mix.CLI.run_task/2
00:26:19.534 [debug] QUERY ERROR source="objects" db=117.6ms queue=2.5ms idle=426.5ms
DELETE FROM "objects" AS o0 WHERE (o0."data"->'to' ? $1 OR o0."data"->'cc' ? $2) AND (o0."inserted_at" < $3) AND (split_part(o0."data"->>'actor', '/', 3) != $4) ["https://www.w3.org/ns/activitystreams#Public", "https://www.w3.org/ns/activitystreams#Public", ~N[2019-12-08 00:26:19], "yo.isurf.ca"]
There doesn't seem to be any further output on these.
I have a 2nd instance that has nothing happening on it yet, and these tasks aren't failing. Same host, same revisions of everything, etc.