gistfile1.txt

Attaching to mastodon1_db_backend_1
db_backend_1       | LOG:  database system was shut down at 2018-10-31 01:32:17 UTC
db_backend_1       | LOG:  MultiXact member wraparound protections are now enabled
db_backend_1       | LOG:  database system is ready to accept connections
db_backend_1       | LOG:  autovacuum launcher started
db_backend_1       | ERROR:  duplicate key value violates unique constraint "index_statuses_on_uri"
db_backend_1       | DETAIL:  Key (uri)=(https://misskey.xyz/notes/5bd91c467b2dfd00434b79e9/activity) already exists.
db_backend_1       | STATEMENT:  INSERT INTO "statuses" ("uri", "account_id", "created_at", "updated_at", "reblog_of_id", "conversation_id", "local") VALUES ('https://misskey.xyz/notes/5bd91c467b2dfd00434b79e9/activity', 64610, '2018-10-31 03:06:46.343000', '2018-10-31 03:06:46.889563', 100988039339141311, 9648149, FALSE) RETURNING "id"
db_backend_1       | ERROR:  insert or update on table "status_stats" violates foreign key constraint "fk_rails_4a247aac42"
db_backend_1       | DETAIL:  Key (status_id)=(100400112024074897) is not present in table "statuses".
db_backend_1       | STATEMENT:  INSERT INTO "status_stats" ("status_id", "created_at", "updated_at") VALUES (100400112024074897, '2018-10-31 12:00:09.560919', '2018-10-31 12:00:09.560919') RETURNING "id"
db_backend_1       | ERROR:  insert or update on table "status_stats" violates foreign key constraint "fk_rails_4a247aac42"
db_backend_1       | DETAIL:  Key (status_id)=(100400112024074897) is not present in table "statuses".
db_backend_1       | STATEMENT:  INSERT INTO "status_stats" ("status_id", "created_at", "updated_at") VALUES (100400112024074897, '2018-10-31 12:00:09.658788', '2018-10-31 12:00:09.658788') RETURNING "id"
db_backend_1       | ERROR:  duplicate key value violates unique constraint "index_custom_emojis_on_shortcode_and_domain"
db_backend_1       | DETAIL:  Key (shortcode, domain)=(blobmiou, heislandmine.mydns.jp) already exists.
db_backend_1       | STATEMENT:  INSERT INTO "custom_emojis" ("shortcode", "domain", "image_file_name", "image_content_type", "image_file_size", "image_updated_at", "created_at", "updated_at", "uri", "image_remote_url") VALUES ('blobmiou', 'heislandmine.mydns.jp', 'ee5a0b0ab04f7b66.png', 'image/png', 9127, '2018-11-01 08:19:58.733978', '2018-11-01 08:19:58.913783', '2018-11-01 08:19:58.913783', 'https://heislandmine.mydns.jp/emoji/custom/blobmiou.png', 'https://heislandmine.mydns.jp/emoji/custom/blobmiou.png') RETURNING "id"
db_backend_1       | ERROR:  duplicate key value violates unique constraint "index_statuses_on_uri"
db_backend_1       | DETAIL:  Key (uri)=(https://mstdn.maud.io/users/r8_gre/statuses/100995231902386018/activity) already exists.
db_backend_1       | STATEMENT:  INSERT INTO "statuses" ("uri", "account_id", "created_at", "updated_at", "reblog_of_id", "conversation_id", "local") VALUES ('https://mstdn.maud.io/users/r8_gre/statuses/100995231902386018/activity', 30562, '2018-11-01 09:35:39', '2018-11-01 09:35:41.181068', 100995175931327294, 9687475, FALSE) RETURNING "id"
db_backend_1       | ERROR:  insert or update on table "status_stats" violates foreign key constraint "fk_rails_4a247aac42"
db_backend_1       | DETAIL:  Key (status_id)=(100889396818020879) is not present in table "statuses".
db_backend_1       | STATEMENT:  INSERT INTO "status_stats" ("status_id", "created_at", "updated_at") VALUES (100889396818020879, '2018-11-01 11:49:32.712517', '2018-11-01 11:49:32.712517') RETURNING "id"
db_backend_1       | ERROR:  insert or update on table "status_stats" violates foreign key constraint "fk_rails_4a247aac42"
db_backend_1       | DETAIL:  Key (status_id)=(100877043424219528) is not present in table "statuses".
db_backend_1       | STATEMENT:  INSERT INTO "status_stats" ("status_id", "created_at", "updated_at") VALUES (100877043424219528, '2018-11-01 11:49:57.661618', '2018-11-01 11:49:57.661618') RETURNING "id"
db_backend_1       | ERROR:  deadlock detected
db_backend_1       | DETAIL:  Process 2340 waits for ShareLock on transaction 39594169; blocked by process 2358.
db_backend_1       | 	Process 2358 waits for ShareLock on transaction 39594166; blocked by process 2340.
db_backend_1       | 	Process 2340: UPDATE "media_attachments" SET "status_id" = NULL WHERE "media_attachments"."id" IN (SELECT "media_attachments"."id" FROM "media_attachments" WHERE "media_attachments"."status_id" = 100871490411835675 ORDER BY "media_attachments"."id" ASC)
db_backend_1       | 	Process 2358: DELETE FROM "statuses" WHERE "statuses"."id" = 100871490411835675
db_backend_1       | HINT:  See server log for query details.
db_backend_1       | CONTEXT:  while updating tuple (44668,21) in relation "media_attachments"
db_backend_1       | STATEMENT:  UPDATE "media_attachments" SET "status_id" = NULL WHERE "media_attachments"."id" IN (SELECT "media_attachments"."id" FROM "media_attachments" WHERE "media_attachments"."status_id" = 100871490411835675 ORDER BY "media_attachments"."id" ASC)
db_backend_1       | ERROR:  insert or update on table "status_stats" violates foreign key constraint "fk_rails_4a247aac42"
db_backend_1       | DETAIL:  Key (status_id)=(100993647916200873) is not present in table "statuses".
db_backend_1       | STATEMENT:  INSERT INTO "status_stats" ("status_id", "created_at", "updated_at") VALUES (100993647916200873, '2018-11-01 13:11:07.019609', '2018-11-01 13:11:07.019609') RETURNING "id"
db_backend_1       | ERROR:  insert or update on table "status_stats" violates foreign key constraint "fk_rails_4a247aac42"
db_backend_1       | DETAIL:  Key (status_id)=(101001068110925051) is not present in table "statuses".
db_backend_1       | STATEMENT:  INSERT INTO "status_stats" ("status_id", "created_at", "updated_at") VALUES (101001068110925051, '2018-11-02 10:34:55.470734', '2018-11-02 10:34:55.470734') RETURNING "id"
db_backend_1       | ERROR:  insert or update on table "status_stats" violates foreign key constraint "fk_rails_4a247aac42"
db_backend_1       | DETAIL:  Key (status_id)=(100503145473770206) is not present in table "statuses".
db_backend_1       | STATEMENT:  INSERT INTO "status_stats" ("status_id", "created_at", "updated_at") VALUES (100503145473770206, '2018-11-02 13:09:43.322479', '2018-11-02 13:09:43.322479') RETURNING "id"
db_backend_1       | ERROR:  deadlock detected
db_backend_1       | DETAIL:  Process 4544 waits for ShareLock on transaction 39703007; blocked by process 4543.
db_backend_1       | 	Process 4543 waits for ShareLock on transaction 39703000; blocked by process 4544.
db_backend_1       | 	Process 4544: UPDATE "accounts" SET "statuses_count" = 7483, "updated_at" = '2018-11-02 19:19:49.917202' WHERE "accounts"."id" = 4728
db_backend_1       | 	Process 4543: UPDATE "accounts" SET "statuses_count" = 32005, "updated_at" = '2018-11-02 19:19:49.938626' WHERE "accounts"."id" = 9126
db_backend_1       | HINT:  See server log for query details.
db_backend_1       | CONTEXT:  while updating tuple (12677,8) in relation "accounts"
db_backend_1       | STATEMENT:  UPDATE "accounts" SET "statuses_count" = 7483, "updated_at" = '2018-11-02 19:19:49.917202' WHERE "accounts"."id" = 4728
db_backend_1       | ERROR:  insert or update on table "status_stats" violates foreign key constraint "fk_rails_4a247aac42"
db_backend_1       | DETAIL:  Key (status_id)=(100922925693910890) is not present in table "statuses".
db_backend_1       | STATEMENT:  INSERT INTO "status_stats" ("status_id", "created_at", "updated_at") VALUES (100922925693910890, '2018-11-04 03:06:41.957664', '2018-11-04 03:06:41.957664') RETURNING "id"
db_backend_1       | ERROR:  insert or update on table "status_stats" violates foreign key constraint "fk_rails_4a247aac42"
db_backend_1       | DETAIL:  Key (status_id)=(100920440385274077) is not present in table "statuses".
db_backend_1       | STATEMENT:  INSERT INTO "status_stats" ("status_id", "created_at", "updated_at") VALUES (100920440385274077, '2018-11-04 03:06:55.932968', '2018-11-04 03:06:55.932968') RETURNING "id"
db_backend_1       | ERROR:  insert or update on table "status_stats" violates foreign key constraint "fk_rails_4a247aac42"
db_backend_1       | DETAIL:  Key (status_id)=(100864235271093530) is not present in table "statuses".
db_backend_1       | STATEMENT:  INSERT INTO "status_stats" ("status_id", "created_at", "updated_at") VALUES (100864235271093530, '2018-11-04 03:10:37.110596', '2018-11-04 03:10:37.110596') RETURNING "id"
db_backend_1       | ERROR:  insert or update on table "status_stats" violates foreign key constraint "fk_rails_4a247aac42"
db_backend_1       | DETAIL:  Key (status_id)=(100864235271093530) is not present in table "statuses".
db_backend_1       | STATEMENT:  INSERT INTO "status_stats" ("status_id", "created_at", "updated_at") VALUES (100864235271093530, '2018-11-04 03:10:37.133242', '2018-11-04 03:10:37.133242') RETURNING "id"
db_backend_1       | ERROR:  insert or update on table "status_stats" violates foreign key constraint "fk_rails_4a247aac42"
db_backend_1       | DETAIL:  Key (status_id)=(100835890189954384) is not present in table "statuses".
db_backend_1       | STATEMENT:  INSERT INTO "status_stats" ("status_id", "created_at", "updated_at") VALUES (100835890189954384, '2018-11-04 03:12:20.441093', '2018-11-04 03:12:20.441093') RETURNING "id"
db_backend_1       | ERROR:  deadlock detected
db_backend_1       | DETAIL:  Process 6659 waits for ShareLock on transaction 39786899; blocked by process 6696.
db_backend_1       | 	Process 6696 waits for ShareLock on transaction 39786903; blocked by process 6705.
db_backend_1       | 	Process 6705 waits for ExclusiveLock on tuple (14692,3) of relation 16402 of database 12404; blocked by process 6659.
db_backend_1       | 	Process 6659: UPDATE "accounts" SET "statuses_count" = 41578, "updated_at" = '2018-11-04 03:13:54.976977' WHERE "accounts"."id" = 12380
db_backend_1       | 	Process 6696: UPDATE "accounts" SET "statuses_count" = 13285, "updated_at" = '2018-11-04 03:13:54.988433' WHERE "accounts"."id" = 67646
db_backend_1       | 	Process 6705: UPDATE "accounts" SET "statuses_count" = 41578, "updated_at" = '2018-11-04 03:13:55.000158' WHERE "accounts"."id" = 12380
db_backend_1       | HINT:  See server log for query details.
db_backend_1       | CONTEXT:  while updating tuple (14692,3) in relation "accounts"
db_backend_1       | STATEMENT:  UPDATE "accounts" SET "statuses_count" = 41578, "updated_at" = '2018-11-04 03:13:54.976977' WHERE "accounts"."id" = 12380
db_backend_1       | ERROR:  deadlock detected
db_backend_1       | DETAIL:  Process 6696 waits for ShareLock on transaction 39786903; blocked by process 6705.
db_backend_1       | 	Process 6705 waits for ShareLock on transaction 39786899; blocked by process 6696.
db_backend_1       | 	Process 6696: UPDATE "accounts" SET "statuses_count" = 13285, "updated_at" = '2018-11-04 03:13:54.988433' WHERE "accounts"."id" = 67646
db_backend_1       | 	Process 6705: UPDATE "accounts" SET "statuses_count" = 41578, "updated_at" = '2018-11-04 03:13:55.000158' WHERE "accounts"."id" = 12380
db_backend_1       | HINT:  See server log for query details.
db_backend_1       | CONTEXT:  while updating tuple (14122,8) in relation "accounts"
db_backend_1       | STATEMENT:  UPDATE "accounts" SET "statuses_count" = 13285, "updated_at" = '2018-11-04 03:13:54.988433' WHERE "accounts"."id" = 67646
db_backend_1       | ERROR:  deadlock detected
db_backend_1       | DETAIL:  Process 6705 waits for ShareLock on transaction 39787006; blocked by process 6698.
db_backend_1       | 	Process 6698 waits for ShareLock on transaction 39787003; blocked by process 6705.
db_backend_1       | 	Process 6705: UPDATE "accounts" SET "statuses_count" = 51641, "updated_at" = '2018-11-04 03:16:04.665144' WHERE "accounts"."id" = 35532
db_backend_1       | 	Process 6698: UPDATE "accounts" SET "statuses_count" = 13283, "updated_at" = '2018-11-04 03:16:04.677296' WHERE "accounts"."id" = 67646
db_backend_1       | HINT:  See server log for query details.
db_backend_1       | CONTEXT:  while updating tuple (14095,4) in relation "accounts"
db_backend_1       | STATEMENT:  UPDATE "accounts" SET "statuses_count" = 51641, "updated_at" = '2018-11-04 03:16:04.665144' WHERE "accounts"."id" = 35532
db_backend_1       | ERROR:  deadlock detected
db_backend_1       | DETAIL:  Process 6698 waits for ShareLock on transaction 39787004; blocked by process 6659.
db_backend_1       | 	Process 6659 waits for ShareLock on transaction 39787006; blocked by process 6698.
db_backend_1       | 	Process 6698: UPDATE "accounts" SET "statuses_count" = 13283, "updated_at" = '2018-11-04 03:16:04.677296' WHERE "accounts"."id" = 67646
db_backend_1       | 	Process 6659: UPDATE "accounts" SET "statuses_count" = 51641, "updated_at" = '2018-11-04 03:16:05.720514' WHERE "accounts"."id" = 35532
db_backend_1       | HINT:  See server log for query details.
db_backend_1       | CONTEXT:  while updating tuple (14136,8) in relation "accounts"
db_backend_1       | STATEMENT:  UPDATE "accounts" SET "statuses_count" = 13283, "updated_at" = '2018-11-04 03:16:04.677296' WHERE "accounts"."id" = 67646
db_backend_1       | ERROR:  deadlock detected
db_backend_1       | DETAIL:  Process 6698 waits for ShareLock on transaction 39787054; blocked by process 6706.
db_backend_1       | 	Process 6706 waits for ExclusiveLock on tuple (14088,11) of relation 16402 of database 12404; blocked by process 6685.
db_backend_1       | 	Process 6685 waits for ShareLock on transaction 39787050; blocked by process 6698.
db_backend_1       | 	Process 6698: UPDATE "media_attachments" SET "status_id" = NULL WHERE "media_attachments"."id" IN (SELECT "media_attachments"."id" FROM "media_attachments" WHERE "media_attachments"."status_id" = 100577267059765186 ORDER BY "media_attachments"."id" ASC)
db_backend_1       | 	Process 6706: UPDATE "accounts" SET "statuses_count" = 13280, "updated_at" = '2018-11-04 03:16:55.041072' WHERE "accounts"."id" = 67646
db_backend_1       | 	Process 6685: UPDATE "accounts" SET "statuses_count" = 13281, "updated_at" = '2018-11-04 03:16:54.814276' WHERE "accounts"."id" = 67646
db_backend_1       | HINT:  See server log for query details.
db_backend_1       | CONTEXT:  while updating tuple (27545,40) in relation "media_attachments"
db_backend_1       | STATEMENT:  UPDATE "media_attachments" SET "status_id" = NULL WHERE "media_attachments"."id" IN (SELECT "media_attachments"."id" FROM "media_attachments" WHERE "media_attachments"."status_id" = 100577267059765186 ORDER BY "media_attachments"."id" ASC)
db_backend_1       | ERROR:  deadlock detected
db_backend_1       | DETAIL:  Process 6700 waits for ShareLock on transaction 39787054; blocked by process 6706.
db_backend_1       | 	Process 6706 waits for ShareLock on transaction 39787051; blocked by process 6672.
db_backend_1       | 	Process 6672 waits for ExclusiveLock on tuple (27545,40) of relation 16602 of database 12404; blocked by process 6700.
db_backend_1       | 	Process 6700: UPDATE "media_attachments" SET "status_id" = NULL WHERE "media_attachments"."id" IN (SELECT "media_attachments"."id" FROM "media_attachments" WHERE "media_attachments"."status_id" = 100577267059765186 ORDER BY "media_attachments"."id" ASC)
db_backend_1       | 	Process 6706: UPDATE "accounts" SET "statuses_count" = 13280, "updated_at" = '2018-11-04 03:16:55.041072' WHERE "accounts"."id" = 67646
db_backend_1       | 	Process 6672: UPDATE "media_attachments" SET "status_id" = NULL WHERE "media_attachments"."id" IN (SELECT "media_attachments"."id" FROM "media_attachments" WHERE "media_attachments"."status_id" = 100577267059765186 ORDER BY "media_attachments"."id" ASC)
db_backend_1       | HINT:  See server log for query details.
db_backend_1       | CONTEXT:  while updating tuple (27545,40) in relation "media_attachments"
db_backend_1       | STATEMENT:  UPDATE "media_attachments" SET "status_id" = NULL WHERE "media_attachments"."id" IN (SELECT "media_attachments"."id" FROM "media_attachments" WHERE "media_attachments"."status_id" = 100577267059765186 ORDER BY "media_attachments"."id" ASC)
db_backend_1       | ERROR:  deadlock detected
db_backend_1       | DETAIL:  Process 6706 waits for ShareLock on transaction 39787051; blocked by process 6672.
db_backend_1       | 	Process 6672 waits for ShareLock on transaction 39787054; blocked by process 6706.
db_backend_1       | 	Process 6706: UPDATE "accounts" SET "statuses_count" = 13280, "updated_at" = '2018-11-04 03:16:55.041072' WHERE "accounts"."id" = 67646
db_backend_1       | 	Process 6672: UPDATE "media_attachments" SET "status_id" = NULL WHERE "media_attachments"."id" IN (SELECT "media_attachments"."id" FROM "media_attachments" WHERE "media_attachments"."status_id" = 100577267059765186 ORDER BY "media_attachments"."id" ASC)
db_backend_1       | HINT:  See server log for query details.
db_backend_1       | CONTEXT:  while locking tuple (14098,5) in relation "accounts"
db_backend_1       | STATEMENT:  UPDATE "accounts" SET "statuses_count" = 13280, "updated_at" = '2018-11-04 03:16:55.041072' WHERE "accounts"."id" = 67646
db_backend_1       | ERROR:  insert or update on table "status_stats" violates foreign key constraint "fk_rails_4a247aac42"
db_backend_1       | DETAIL:  Key (status_id)=(100577267059765186) is not present in table "statuses".
db_backend_1       | STATEMENT:  INSERT INTO "status_stats" ("status_id", "created_at", "updated_at") VALUES (100577267059765186, '2018-11-04 03:16:56.890062', '2018-11-04 03:16:56.890062') RETURNING "id"
db_backend_1       | ERROR:  deadlock detected
db_backend_1       | DETAIL:  Process 6701 waits for ShareLock on transaction 39787157; blocked by process 6696.
db_backend_1       | 	Process 6696 waits for ShareLock on transaction 39787156; blocked by process 6701.
db_backend_1       | 	Process 6701: UPDATE "accounts" SET "statuses_count" = 157125, "updated_at" = '2018-11-04 03:19:12.045858' WHERE "accounts"."id" = 8128
db_backend_1       | 	Process 6696: UPDATE "status_stats" SET "reblogs_count" = 0, "updated_at" = '2018-11-04 03:19:12.048519' WHERE "status_stats"."id" = 9061525
db_backend_1       | HINT:  See server log for query details.
db_backend_1       | CONTEXT:  while updating tuple (14106,4) in relation "accounts"
db_backend_1       | STATEMENT:  UPDATE "accounts" SET "statuses_count" = 157125, "updated_at" = '2018-11-04 03:19:12.045858' WHERE "accounts"."id" = 8128
db_backend_1       | ERROR:  duplicate key value violates unique constraint "index_status_stats_on_status_id"
db_backend_1       | DETAIL:  Key (status_id)=(101013125443889115) already exists.
db_backend_1       | STATEMENT:  INSERT INTO "status_stats" ("status_id", "reblogs_count", "created_at", "updated_at") VALUES (101013125443889115, 1, '2018-11-04 13:26:32.151808', '2018-11-04 13:26:32.151808') RETURNING "id"