Skip to content

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%