prune_objects fails -- foreign key violation: hashtags_objects_object_id_fkey
Environment
- Installation type (OTP or From Source): source
- Pleroma version (could be found in the "Version" tab of settings in Pleroma-FE): 2.3.50-180-g15f87cf6-develop
- Elixir version (
elixir -v
for from source installations, N/A for OTP): 1.11.2 - Operating system: Ubuntu 20.04
- PostgreSQL version (
psql -V
): 13.2
Bug description
This might be due to !3213 (merged), commit 108e90b1:
me 23:09:51% env MIX_ENV=prod mix pleroma.database prune_objects --vacuum
** (Postgrex.Error) ERROR 23503 (foreign_key_violation) update or delete on table "objects" violates foreign key constraint "hashtags_objects_object_id_fkey" on table "hashtags_objects"
table: hashtags_objects
constraint: hashtags_objects_object_id_fkey
Key (id)=(892057) is still referenced from table "hashtags_objects".
(ecto_sql 3.4.5) lib/ecto/adapters/sql.ex:593: Ecto.Adapters.SQL.raise_sql_call_error/1
(ecto_sql 3.4.5) lib/ecto/adapters/sql.ex:526: Ecto.Adapters.SQL.execute/5
(pleroma 2.3.50-180-g15f87cf6-develop) lib/mix/tasks/pleroma/database.ex:97: Mix.Tasks.Pleroma.Database.run/1
(mix 1.11.2) lib/mix/task.ex:394: Mix.Task.run_task/3
(mix 1.11.2) lib/mix/cli.ex:84: Mix.CLI.run_task/2
me 23:10:08%