pixelfed / support

Issue tracker for installations of Pixelfed, before a bug is identified.
https://docs.pixelfed.org/running-pixelfed/troubleshooting.html
8 stars 3 forks source link

Integrity constraint violation: 1062 Duplicate entry #126

Open okpierre opened 3 years ago

okpierre commented 3 years ago

Pixelfed v0.10.10

ERROR: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'https://misskey.io/notes/xxx' for key 'uri' (SQL: insert intostatuses(profile_id,url,uri,object_url,caption,rendered,created_at,in_reply_to_id,local,is_nsfw,scope,visibility,cw_summary,id,updated_at) values (174174826544631808, https://misskey.io/notes/xxx, https://misskey.io/notes/xxx, https://misskey.io/notes/xxx, ., <p>.</p>, 2021-02-05 16:43:48, ?, 0, 0, unlisted, unlisted, ?, 263346557821259776, 2021-02-05 16:45:12)) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'https://misskey.io/notes/xxx' for key 'uri' (SQL: insert intostatuses(profile_id,url,uri,object_url,caption,rendered,created_at,in_reply_to_id,local,is_nsfw,scope,visibility,cw_summary,id,updated_at) values (174174826544631808, https://misskey.io/notes/xxx, https://misskey.io/notes/xxx, https://misskey.io/notes/xxx, ., <p>.</p>, 2021-02-05 16:43:48, ?, 0, 0, unlisted, unlisted, ?, 263346557821259776, 2021-02-05 16:45:12)) at /pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php:678)

stacktrace https://pastebin.com/puAtcdTQ