Hello all! Every now and then my PostgreSQL starts logging “duplicate key value violates unique constraint”. Here are some examples:
2023-10-16 20:33:52.733 CEST [804045] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2023-10-16 20:33:52.733 CEST [804045] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(https://metalhead.club/users/treuss/statuses/111243444580205956) already exists.
2023-10-16 20:33:52.733 CEST [804045] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2023-10-16 20:53:19.579 CEST [792077] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2023-10-16 20:53:19.579 CEST [792077] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(https://chaos.social/users/Venty/statuses/111246143810349702) already exists.
2023-10-16 20:53:19.579 CEST [792077] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2023-10-16 22:23:22.847 CEST [801897] pleroma@pleroma ERROR: duplicate key value violates unique constraint "users_ap_id_index"
2023-10-16 22:23:22.847 CEST [801897] pleroma@pleroma DETAIL: Key (ap_id)=(https://urbanists.social/users/Streetsweeper) already exists.
2023-10-16 22:23:22.847 CEST [801897] pleroma@pleroma STATEMENT: INSERT INTO "users" ("hide_follows_count","following_address","tags","ap_enabled","raw_fields","ap_id","is_locked","show_role","allow_following_move","accepts_direct_messages_from","follower_count","hide_followers","pleroma_settings_store","is_active","is_moderator","default_scope","nickname","banner","also_known_as","is_suggested","is_confirmed","local","last_refreshed_at","emoji","background","hide_followers_count","invisible","fields","following_count","password_reset_pending","hide_favorites","pinned_objects","name","shared_inbox","email_notifications","featured_address","disclose_client","actor_type","bio","inbox","domain_blocks","is_admin","skip_thread_containment","no_rich_text","uri","public_key","note_count","is_approved","hide_follows","follower_address","avatar","is_discoverable","id","inserted_at","updated_at") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55)
Is this something to worry about?
Setup type: OTP
OS: Debian 12
PostgreSQL: 15.3
Akkoma version: 3.10.4-0-gebfb617