Timeline not loading with 500 error, no obvious log errors, sus error during bootup though. #389

Closed
opened 2023-05-30 14:57:44 +00:00 by SuperDicq · 2 comments
Contributor

I recently upgraded my instance to Foundkey preview 5 and I can no longer load the timelines, they return a 500 internal server error.

I receive a 500 on the following endpoints trying to load the main page while logged in:
/api/i
/api/meta
/api/notes/timeline
/api/charts/user/notes
/api/server-info
/api/i/notifications

All other requests normally with a 200 status.

The logs do not show any errors and the instance seems to be federating normally which is strange to me.

It does show this error message while booting, but I'm unsure if related:

mei 30 16:32:19 Homura misskey[2520991]:  | __|__ _  _ _ _  __| | |/ /___ _  _
mei 30 16:32:19 Homura misskey[2520991]:  | _/ _ \ || | ' \/ _` | ' </ -_) || |
mei 30 16:32:19 Homura misskey[2520991]:  |_|\___/\_,_|_||_\__,_|_|\_\___|\_, |
mei 30 16:32:19 Homura misskey[2520991]:                                  |__/
mei 30 16:32:19 Homura misskey[2520991]:  FoundKey is an open-source decentralized microblogging platform.
mei 30 16:32:19 Homura misskey[2520991]: --- Homura (PID: 2520991) ---
mei 30 16:32:19 Homura misskey[2520991]: INFO *        [core boot]        Welcome to FoundKey!
mei 30 16:32:19 Homura misskey[2520991]: INFO *        [core boot]        FoundKey v13.0.0-preview5
mei 30 16:32:19 Homura misskey[2520991]: INFO *        [core boot env]        NODE_ENV: production
mei 30 16:32:19 Homura misskey[2520991]: INFO *        [core boot nodejs]        Version v18.12.1 detected.
mei 30 16:32:19 Homura misskey[2520991]: DONE *        [core boot config]        Loaded
mei 30 16:32:19 Homura misskey[2520991]: INFO *        [core boot db]        Connecting...
mei 30 16:32:19 Homura misskey[2520991]: DONE *        [core boot db]        Connected: v13.11 (Debian 13.11-0+deb11u1)
mei 30 16:32:19 Homura misskey[2520991]: DONE *        [core boot]        FoundKey initialized
mei 30 16:32:19 Homura misskey[2520991]: INFO *        [core boot]        Starting 2 workers...
mei 30 16:32:22 Homura misskey[2521008]: (node:2521008) ExperimentalWarning: Importing JSON modules is an experimental feature. This feature could change at any time
mei 30 16:32:22 Homura misskey[2521008]: (Use `node --trace-warnings ...` to show where the warning was created)
mei 30 16:32:23 Homura misskey[2521009]: INFO 2        [queue check-expired]        Checking expired data...
mei 30 16:32:23 Homura misskey[2521009]: INFO 2        [queue check-expired]        Checking expired data...
mei 30 16:32:23 Homura misskey[2521009]: INFO 2        [queue check-expired]        Checking expired data...
mei 30 16:32:25 Homura misskey[2521009]: QueryFailedError: update or delete on table "user" violates foreign key constraint "FK_860fa6f6c7df5bb887249fba22e" on table "drive_file"
mei 30 16:32:25 Homura misskey[2521009]:     at PostgresQueryRunner.query (/home/misskey/misskey/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19)
mei 30 16:32:25 Homura misskey[2521009]:     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
mei 30 16:32:25 Homura misskey[2521009]:     at async DeleteQueryBuilder.execute (/home/misskey/misskey/node_modules/typeorm/query-builder/DeleteQueryBuilder.js:52:33)
mei 30 16:32:25 Homura misskey[2521009]:     at async Queue.checkExpired (file:///home/misskey/misskey/packages/backend/built/queue/processors/system/check-expired.js:42:5) {
mei 30 16:32:25 Homura misskey[2521009]:   query: 'DELETE FROM "user" WHERE "isDeleted" = $1',
mei 30 16:32:25 Homura misskey[2521009]:   parameters: [ 0 ],
mei 30 16:32:25 Homura misskey[2521009]:   driverError: error: update or delete on table "user" violates foreign key constraint "FK_860fa6f6c7df5bb887249fba22e" on table "drive_file"
mei 30 16:32:25 Homura misskey[2521009]:       at Parser.parseErrorMessage (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:287:98)
mei 30 16:32:25 Homura misskey[2521009]:       at Parser.handlePacket (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:126:29)
mei 30 16:32:25 Homura misskey[2521009]:       at Parser.parse (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:39:38)
mei 30 16:32:25 Homura misskey[2521009]:       at Socket.<anonymous> (/home/misskey/misskey/node_modules/pg-protocol/dist/index.js:11:42)
mei 30 16:32:25 Homura misskey[2521009]:       at Socket.emit (node:events:513:28)
mei 30 16:32:25 Homura misskey[2521009]:       at Socket.emit (node:domain:489:12)
mei 30 16:32:25 Homura misskey[2521009]:       at addChunk (node:internal/streams/readable:324:12)
mei 30 16:32:25 Homura misskey[2521009]:       at readableAddChunk (node:internal/streams/readable:297:9)
mei 30 16:32:25 Homura misskey[2521009]:       at Readable.push (node:internal/streams/readable:234:10)
mei 30 16:32:25 Homura misskey[2521009]:       at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
mei 30 16:32:25 Homura misskey[2521009]:     length: 308,
mei 30 16:32:25 Homura misskey[2521009]:     severity: 'ERROR',
mei 30 16:32:25 Homura misskey[2521009]:     code: '23503',
mei 30 16:32:25 Homura misskey[2521009]:     detail: 'Key (id)=(8u156p4jge) is still referenced from table "drive_file".',
mei 30 16:32:25 Homura misskey[2521009]:     hint: undefined,
mei 30 16:32:25 Homura misskey[2521009]:     position: undefined,
mei 30 16:32:25 Homura misskey[2521009]:     internalPosition: undefined,
mei 30 16:32:25 Homura misskey[2521009]:     internalQuery: undefined,
mei 30 16:32:25 Homura misskey[2521009]:     where: undefined,
mei 30 16:32:25 Homura misskey[2521009]:     schema: 'public',
mei 30 16:32:25 Homura misskey[2521009]:     table: 'drive_file',
mei 30 16:32:25 Homura misskey[2521009]:     column: undefined,
mei 30 16:32:25 Homura misskey[2521009]:     dataType: undefined,
mei 30 16:32:25 Homura misskey[2521009]:     constraint: 'FK_860fa6f6c7df5bb887249fba22e',
mei 30 16:32:25 Homura misskey[2521009]:     file: 'ri_triggers.c',
mei 30 16:32:25 Homura misskey[2521009]:     line: '2478',
mei 30 16:32:25 Homura misskey[2521009]:     routine: 'ri_ReportViolation'
mei 30 16:32:25 Homura misskey[2521009]:   },
mei 30 16:32:25 Homura misskey[2521009]:   length: 308,
mei 30 16:32:25 Homura misskey[2521009]:   severity: 'ERROR',
mei 30 16:32:25 Homura misskey[2521009]:   code: '23503',
mei 30 16:32:25 Homura misskey[2521009]:   detail: 'Key (id)=(8u156p4jge) is still referenced from table "drive_file".',
mei 30 16:32:25 Homura misskey[2521009]:   hint: undefined,
mei 30 16:32:25 Homura misskey[2521009]:   position: undefined,
mei 30 16:32:25 Homura misskey[2521009]:   internalPosition: undefined,
mei 30 16:32:25 Homura misskey[2521009]:   internalQuery: undefined,
mei 30 16:32:25 Homura misskey[2521009]:   where: undefined,
mei 30 16:32:25 Homura misskey[2521009]:   schema: 'public',
mei 30 16:32:25 Homura misskey[2521009]:   table: 'drive_file',
mei 30 16:32:25 Homura misskey[2521009]:   column: undefined,
mei 30 16:32:25 Homura misskey[2521009]:   dataType: undefined,
mei 30 16:32:25 Homura misskey[2521009]:   constraint: 'FK_860fa6f6c7df5bb887249fba22e',
mei 30 16:32:25 Homura misskey[2521009]:   file: 'ri_triggers.c',
mei 30 16:32:25 Homura misskey[2521009]:   line: '2478',
mei 30 16:32:25 Homura misskey[2521009]:   routine: 'ri_ReportViolation'
mei 30 16:32:25 Homura misskey[2521009]: }
mei 30 16:32:25 Homura misskey[2520991]: DONE *        [core boot]        All workers started
mei 30 16:32:25 Homura misskey[2520991]: DONE *        [core boot]        Now listening on port 3001 on https://minidisc.tokyo
mei 30 16:32:26 Homura misskey[2521009]: QueryFailedError: update or delete on table "user" violates foreign key constraint "FK_860fa6f6c7df5bb887249fba22e" on table "drive_file"
mei 30 16:32:26 Homura misskey[2521009]:     at PostgresQueryRunner.query (/home/misskey/misskey/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19)
mei 30 16:32:26 Homura misskey[2521009]:     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
mei 30 16:32:26 Homura misskey[2521009]:     at async DeleteQueryBuilder.execute (/home/misskey/misskey/node_modules/typeorm/query-builder/DeleteQueryBuilder.js:52:33)
mei 30 16:32:26 Homura misskey[2521009]:     at async Queue.checkExpired (file:///home/misskey/misskey/packages/backend/built/queue/processors/system/check-expired.js:42:5) {
mei 30 16:32:26 Homura misskey[2521009]:   query: 'DELETE FROM "user" WHERE "isDeleted" = $1',
mei 30 16:32:26 Homura misskey[2521009]:   parameters: [ 0 ],
mei 30 16:32:26 Homura misskey[2521009]:   driverError: error: update or delete on table "user" violates foreign key constraint "FK_860fa6f6c7df5bb887249fba22e" on table "drive_file"
mei 30 16:32:26 Homura misskey[2521009]:       at Parser.parseErrorMessage (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:287:98)
mei 30 16:32:26 Homura misskey[2521009]:       at Parser.handlePacket (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:126:29)
mei 30 16:32:26 Homura misskey[2521009]:       at Parser.parse (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:39:38)
mei 30 16:32:26 Homura misskey[2521009]:       at Socket.<anonymous> (/home/misskey/misskey/node_modules/pg-protocol/dist/index.js:11:42)
mei 30 16:32:26 Homura misskey[2521009]:       at Socket.emit (node:events:513:28)
mei 30 16:32:26 Homura misskey[2521009]:       at Socket.emit (node:domain:489:12)
mei 30 16:32:26 Homura misskey[2521009]:       at addChunk (node:internal/streams/readable:324:12)
mei 30 16:32:26 Homura misskey[2521009]:       at readableAddChunk (node:internal/streams/readable:297:9)
mei 30 16:32:26 Homura misskey[2521009]:       at Readable.push (node:internal/streams/readable:234:10)
mei 30 16:32:26 Homura misskey[2521009]:       at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
mei 30 16:32:26 Homura misskey[2521009]:     length: 308,
mei 30 16:32:26 Homura misskey[2521009]:     severity: 'ERROR',
mei 30 16:32:26 Homura misskey[2521009]:     code: '23503',
mei 30 16:32:26 Homura misskey[2521009]:     detail: 'Key (id)=(8u156p4jge) is still referenced from table "drive_file".',
mei 30 16:32:26 Homura misskey[2521009]:     hint: undefined,
mei 30 16:32:26 Homura misskey[2521009]:     position: undefined,
mei 30 16:32:26 Homura misskey[2521009]:     internalPosition: undefined,
mei 30 16:32:26 Homura misskey[2521009]:     internalQuery: undefined,
mei 30 16:32:26 Homura misskey[2521009]:     where: undefined,
mei 30 16:32:26 Homura misskey[2521009]:     schema: 'public',
mei 30 16:32:26 Homura misskey[2521009]:     table: 'drive_file',
mei 30 16:32:26 Homura misskey[2521009]:     column: undefined,
mei 30 16:32:26 Homura misskey[2521009]:     dataType: undefined,
mei 30 16:32:26 Homura misskey[2521009]:     constraint: 'FK_860fa6f6c7df5bb887249fba22e',
mei 30 16:32:26 Homura misskey[2521009]:     file: 'ri_triggers.c',
mei 30 16:32:26 Homura misskey[2521009]:     line: '2478',
mei 30 16:32:26 Homura misskey[2521009]:     routine: 'ri_ReportViolation'
mei 30 16:32:26 Homura misskey[2521009]:   },
mei 30 16:32:26 Homura misskey[2521009]:   length: 308,
mei 30 16:32:26 Homura misskey[2521009]:   severity: 'ERROR',
mei 30 16:32:26 Homura misskey[2521009]:   code: '23503',
mei 30 16:32:26 Homura misskey[2521009]:   detail: 'Key (id)=(8u156p4jge) is still referenced from table "drive_file".',
mei 30 16:32:26 Homura misskey[2521009]:   hint: undefined,
mei 30 16:32:26 Homura misskey[2521009]:   position: undefined,
mei 30 16:32:26 Homura misskey[2521009]:   internalPosition: undefined,
mei 30 16:32:26 Homura misskey[2521009]:   internalQuery: undefined,
mei 30 16:32:26 Homura misskey[2521009]:   where: undefined,
mei 30 16:32:26 Homura misskey[2521009]:   schema: 'public',
mei 30 16:32:26 Homura misskey[2521009]:   table: 'drive_file',
mei 30 16:32:26 Homura misskey[2521009]:   column: undefined,
mei 30 16:32:26 Homura misskey[2521009]:   dataType: undefined,
mei 30 16:32:26 Homura misskey[2521009]:   constraint: 'FK_860fa6f6c7df5bb887249fba22e',
mei 30 16:32:26 Homura misskey[2521009]:   file: 'ri_triggers.c',
mei 30 16:32:26 Homura misskey[2521009]:   line: '2478',
mei 30 16:32:26 Homura misskey[2521009]:   routine: 'ri_ReportViolation'
mei 30 16:32:26 Homura misskey[2521009]: }
mei 30 16:32:28 Homura misskey[2521009]: QueryFailedError: update or delete on table "user" violates foreign key constraint "FK_860fa6f6c7df5bb887249fba22e" on table "drive_file"
mei 30 16:32:28 Homura misskey[2521009]:     at PostgresQueryRunner.query (/home/misskey/misskey/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19)
mei 30 16:32:28 Homura misskey[2521009]:     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
mei 30 16:32:28 Homura misskey[2521009]:     at async DeleteQueryBuilder.execute (/home/misskey/misskey/node_modules/typeorm/query-builder/DeleteQueryBuilder.js:52:33)
mei 30 16:32:28 Homura misskey[2521009]:     at async Queue.checkExpired (file:///home/misskey/misskey/packages/backend/built/queue/processors/system/check-expired.js:42:5) {
mei 30 16:32:28 Homura misskey[2521009]:   query: 'DELETE FROM "user" WHERE "isDeleted" = $1',
mei 30 16:32:28 Homura misskey[2521009]:   parameters: [ 0 ],
mei 30 16:32:28 Homura misskey[2521009]:   driverError: error: update or delete on table "user" violates foreign key constraint "FK_860fa6f6c7df5bb887249fba22e" on table "drive_file"
mei 30 16:32:28 Homura misskey[2521009]:       at Parser.parseErrorMessage (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:287:98)
mei 30 16:32:28 Homura misskey[2521009]:       at Parser.handlePacket (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:126:29)
mei 30 16:32:28 Homura misskey[2521009]:       at Parser.parse (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:39:38)
mei 30 16:32:28 Homura misskey[2521009]:       at Socket.<anonymous> (/home/misskey/misskey/node_modules/pg-protocol/dist/index.js:11:42)
mei 30 16:32:28 Homura misskey[2521009]:       at Socket.emit (node:events:513:28)
mei 30 16:32:28 Homura misskey[2521009]:       at Socket.emit (node:domain:489:12)
mei 30 16:32:28 Homura misskey[2521009]:       at addChunk (node:internal/streams/readable:324:12)
mei 30 16:32:28 Homura misskey[2521009]:       at readableAddChunk (node:internal/streams/readable:297:9)
mei 30 16:32:28 Homura misskey[2521009]:       at Readable.push (node:internal/streams/readable:234:10)
mei 30 16:32:28 Homura misskey[2521009]:       at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
mei 30 16:32:28 Homura misskey[2521009]:     length: 308,
mei 30 16:32:28 Homura misskey[2521009]:     severity: 'ERROR',
mei 30 16:32:28 Homura misskey[2521009]:     code: '23503',
mei 30 16:32:28 Homura misskey[2521009]:     detail: 'Key (id)=(8u156p4jge) is still referenced from table "drive_file".',
mei 30 16:32:28 Homura misskey[2521009]:     hint: undefined,
mei 30 16:32:28 Homura misskey[2521009]:     position: undefined,
mei 30 16:32:28 Homura misskey[2521009]:     internalPosition: undefined,
mei 30 16:32:28 Homura misskey[2521009]:     internalQuery: undefined,
mei 30 16:32:28 Homura misskey[2521009]:     where: undefined,
mei 30 16:32:28 Homura misskey[2521009]:     schema: 'public',
mei 30 16:32:28 Homura misskey[2521009]:     table: 'drive_file',
mei 30 16:32:28 Homura misskey[2521009]:     column: undefined,
mei 30 16:32:28 Homura misskey[2521009]:     dataType: undefined,
mei 30 16:32:28 Homura misskey[2521009]:     constraint: 'FK_860fa6f6c7df5bb887249fba22e',
mei 30 16:32:28 Homura misskey[2521009]:     file: 'ri_triggers.c',
mei 30 16:32:28 Homura misskey[2521009]:     line: '2478',
mei 30 16:32:28 Homura misskey[2521009]:     routine: 'ri_ReportViolation'
mei 30 16:32:28 Homura misskey[2521009]:   },
mei 30 16:32:28 Homura misskey[2521009]:   length: 308,
mei 30 16:32:28 Homura misskey[2521009]:   severity: 'ERROR',
mei 30 16:32:28 Homura misskey[2521009]:   code: '23503',
mei 30 16:32:28 Homura misskey[2521009]:   detail: 'Key (id)=(8u156p4jge) is still referenced from table "drive_file".',
mei 30 16:32:28 Homura misskey[2521009]:   hint: undefined,
mei 30 16:32:28 Homura misskey[2521009]:   position: undefined,
mei 30 16:32:28 Homura misskey[2521009]:   internalPosition: undefined,
mei 30 16:32:28 Homura misskey[2521009]:   internalQuery: undefined,
mei 30 16:32:28 Homura misskey[2521009]:   where: undefined,
mei 30 16:32:28 Homura misskey[2521009]:   schema: 'public',
mei 30 16:32:28 Homura misskey[2521009]:   table: 'drive_file',
mei 30 16:32:28 Homura misskey[2521009]:   column: undefined,
mei 30 16:32:28 Homura misskey[2521009]:   dataType: undefined,
mei 30 16:32:28 Homura misskey[2521009]:   constraint: 'FK_860fa6f6c7df5bb887249fba22e',
mei 30 16:32:28 Homura misskey[2521009]:   file: 'ri_triggers.c',
mei 30 16:32:28 Homura misskey[2521009]:   line: '2478',
mei 30 16:32:28 Homura misskey[2521009]:   routine: 'ri_ReportViolation'
mei 30 16:32:28 Homura misskey[2521009]: }
I recently upgraded my instance to Foundkey preview 5 and I can no longer load the timelines, they return a 500 internal server error. I receive a 500 on the following endpoints trying to load the main page while logged in: /api/i /api/meta /api/notes/timeline /api/charts/user/notes /api/server-info /api/i/notifications All other requests normally with a 200 status. The logs do not show any errors and the instance seems to be federating normally which is strange to me. It does show this error message while booting, but I'm unsure if related: ```mei 30 16:32:19 Homura misskey[2520991]: ___ _ _ __ mei 30 16:32:19 Homura misskey[2520991]: | __|__ _ _ _ _ __| | |/ /___ _ _ mei 30 16:32:19 Homura misskey[2520991]: | _/ _ \ || | ' \/ _` | ' </ -_) || | mei 30 16:32:19 Homura misskey[2520991]: |_|\___/\_,_|_||_\__,_|_|\_\___|\_, | mei 30 16:32:19 Homura misskey[2520991]: |__/ mei 30 16:32:19 Homura misskey[2520991]: FoundKey is an open-source decentralized microblogging platform. mei 30 16:32:19 Homura misskey[2520991]: --- Homura (PID: 2520991) --- mei 30 16:32:19 Homura misskey[2520991]: INFO * [core boot] Welcome to FoundKey! mei 30 16:32:19 Homura misskey[2520991]: INFO * [core boot] FoundKey v13.0.0-preview5 mei 30 16:32:19 Homura misskey[2520991]: INFO * [core boot env] NODE_ENV: production mei 30 16:32:19 Homura misskey[2520991]: INFO * [core boot nodejs] Version v18.12.1 detected. mei 30 16:32:19 Homura misskey[2520991]: DONE * [core boot config] Loaded mei 30 16:32:19 Homura misskey[2520991]: INFO * [core boot db] Connecting... mei 30 16:32:19 Homura misskey[2520991]: DONE * [core boot db] Connected: v13.11 (Debian 13.11-0+deb11u1) mei 30 16:32:19 Homura misskey[2520991]: DONE * [core boot] FoundKey initialized mei 30 16:32:19 Homura misskey[2520991]: INFO * [core boot] Starting 2 workers... mei 30 16:32:22 Homura misskey[2521008]: (node:2521008) ExperimentalWarning: Importing JSON modules is an experimental feature. This feature could change at any time mei 30 16:32:22 Homura misskey[2521008]: (Use `node --trace-warnings ...` to show where the warning was created) mei 30 16:32:23 Homura misskey[2521009]: INFO 2 [queue check-expired] Checking expired data... mei 30 16:32:23 Homura misskey[2521009]: INFO 2 [queue check-expired] Checking expired data... mei 30 16:32:23 Homura misskey[2521009]: INFO 2 [queue check-expired] Checking expired data... mei 30 16:32:25 Homura misskey[2521009]: QueryFailedError: update or delete on table "user" violates foreign key constraint "FK_860fa6f6c7df5bb887249fba22e" on table "drive_file" mei 30 16:32:25 Homura misskey[2521009]: at PostgresQueryRunner.query (/home/misskey/misskey/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19) mei 30 16:32:25 Homura misskey[2521009]: at process.processTicksAndRejections (node:internal/process/task_queues:95:5) mei 30 16:32:25 Homura misskey[2521009]: at async DeleteQueryBuilder.execute (/home/misskey/misskey/node_modules/typeorm/query-builder/DeleteQueryBuilder.js:52:33) mei 30 16:32:25 Homura misskey[2521009]: at async Queue.checkExpired (file:///home/misskey/misskey/packages/backend/built/queue/processors/system/check-expired.js:42:5) { mei 30 16:32:25 Homura misskey[2521009]: query: 'DELETE FROM "user" WHERE "isDeleted" = $1', mei 30 16:32:25 Homura misskey[2521009]: parameters: [ 0 ], mei 30 16:32:25 Homura misskey[2521009]: driverError: error: update or delete on table "user" violates foreign key constraint "FK_860fa6f6c7df5bb887249fba22e" on table "drive_file" mei 30 16:32:25 Homura misskey[2521009]: at Parser.parseErrorMessage (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:287:98) mei 30 16:32:25 Homura misskey[2521009]: at Parser.handlePacket (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:126:29) mei 30 16:32:25 Homura misskey[2521009]: at Parser.parse (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:39:38) mei 30 16:32:25 Homura misskey[2521009]: at Socket.<anonymous> (/home/misskey/misskey/node_modules/pg-protocol/dist/index.js:11:42) mei 30 16:32:25 Homura misskey[2521009]: at Socket.emit (node:events:513:28) mei 30 16:32:25 Homura misskey[2521009]: at Socket.emit (node:domain:489:12) mei 30 16:32:25 Homura misskey[2521009]: at addChunk (node:internal/streams/readable:324:12) mei 30 16:32:25 Homura misskey[2521009]: at readableAddChunk (node:internal/streams/readable:297:9) mei 30 16:32:25 Homura misskey[2521009]: at Readable.push (node:internal/streams/readable:234:10) mei 30 16:32:25 Homura misskey[2521009]: at TCP.onStreamRead (node:internal/stream_base_commons:190:23) { mei 30 16:32:25 Homura misskey[2521009]: length: 308, mei 30 16:32:25 Homura misskey[2521009]: severity: 'ERROR', mei 30 16:32:25 Homura misskey[2521009]: code: '23503', mei 30 16:32:25 Homura misskey[2521009]: detail: 'Key (id)=(8u156p4jge) is still referenced from table "drive_file".', mei 30 16:32:25 Homura misskey[2521009]: hint: undefined, mei 30 16:32:25 Homura misskey[2521009]: position: undefined, mei 30 16:32:25 Homura misskey[2521009]: internalPosition: undefined, mei 30 16:32:25 Homura misskey[2521009]: internalQuery: undefined, mei 30 16:32:25 Homura misskey[2521009]: where: undefined, mei 30 16:32:25 Homura misskey[2521009]: schema: 'public', mei 30 16:32:25 Homura misskey[2521009]: table: 'drive_file', mei 30 16:32:25 Homura misskey[2521009]: column: undefined, mei 30 16:32:25 Homura misskey[2521009]: dataType: undefined, mei 30 16:32:25 Homura misskey[2521009]: constraint: 'FK_860fa6f6c7df5bb887249fba22e', mei 30 16:32:25 Homura misskey[2521009]: file: 'ri_triggers.c', mei 30 16:32:25 Homura misskey[2521009]: line: '2478', mei 30 16:32:25 Homura misskey[2521009]: routine: 'ri_ReportViolation' mei 30 16:32:25 Homura misskey[2521009]: }, mei 30 16:32:25 Homura misskey[2521009]: length: 308, mei 30 16:32:25 Homura misskey[2521009]: severity: 'ERROR', mei 30 16:32:25 Homura misskey[2521009]: code: '23503', mei 30 16:32:25 Homura misskey[2521009]: detail: 'Key (id)=(8u156p4jge) is still referenced from table "drive_file".', mei 30 16:32:25 Homura misskey[2521009]: hint: undefined, mei 30 16:32:25 Homura misskey[2521009]: position: undefined, mei 30 16:32:25 Homura misskey[2521009]: internalPosition: undefined, mei 30 16:32:25 Homura misskey[2521009]: internalQuery: undefined, mei 30 16:32:25 Homura misskey[2521009]: where: undefined, mei 30 16:32:25 Homura misskey[2521009]: schema: 'public', mei 30 16:32:25 Homura misskey[2521009]: table: 'drive_file', mei 30 16:32:25 Homura misskey[2521009]: column: undefined, mei 30 16:32:25 Homura misskey[2521009]: dataType: undefined, mei 30 16:32:25 Homura misskey[2521009]: constraint: 'FK_860fa6f6c7df5bb887249fba22e', mei 30 16:32:25 Homura misskey[2521009]: file: 'ri_triggers.c', mei 30 16:32:25 Homura misskey[2521009]: line: '2478', mei 30 16:32:25 Homura misskey[2521009]: routine: 'ri_ReportViolation' mei 30 16:32:25 Homura misskey[2521009]: } mei 30 16:32:25 Homura misskey[2520991]: DONE * [core boot] All workers started mei 30 16:32:25 Homura misskey[2520991]: DONE * [core boot] Now listening on port 3001 on https://minidisc.tokyo mei 30 16:32:26 Homura misskey[2521009]: QueryFailedError: update or delete on table "user" violates foreign key constraint "FK_860fa6f6c7df5bb887249fba22e" on table "drive_file" mei 30 16:32:26 Homura misskey[2521009]: at PostgresQueryRunner.query (/home/misskey/misskey/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19) mei 30 16:32:26 Homura misskey[2521009]: at process.processTicksAndRejections (node:internal/process/task_queues:95:5) mei 30 16:32:26 Homura misskey[2521009]: at async DeleteQueryBuilder.execute (/home/misskey/misskey/node_modules/typeorm/query-builder/DeleteQueryBuilder.js:52:33) mei 30 16:32:26 Homura misskey[2521009]: at async Queue.checkExpired (file:///home/misskey/misskey/packages/backend/built/queue/processors/system/check-expired.js:42:5) { mei 30 16:32:26 Homura misskey[2521009]: query: 'DELETE FROM "user" WHERE "isDeleted" = $1', mei 30 16:32:26 Homura misskey[2521009]: parameters: [ 0 ], mei 30 16:32:26 Homura misskey[2521009]: driverError: error: update or delete on table "user" violates foreign key constraint "FK_860fa6f6c7df5bb887249fba22e" on table "drive_file" mei 30 16:32:26 Homura misskey[2521009]: at Parser.parseErrorMessage (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:287:98) mei 30 16:32:26 Homura misskey[2521009]: at Parser.handlePacket (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:126:29) mei 30 16:32:26 Homura misskey[2521009]: at Parser.parse (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:39:38) mei 30 16:32:26 Homura misskey[2521009]: at Socket.<anonymous> (/home/misskey/misskey/node_modules/pg-protocol/dist/index.js:11:42) mei 30 16:32:26 Homura misskey[2521009]: at Socket.emit (node:events:513:28) mei 30 16:32:26 Homura misskey[2521009]: at Socket.emit (node:domain:489:12) mei 30 16:32:26 Homura misskey[2521009]: at addChunk (node:internal/streams/readable:324:12) mei 30 16:32:26 Homura misskey[2521009]: at readableAddChunk (node:internal/streams/readable:297:9) mei 30 16:32:26 Homura misskey[2521009]: at Readable.push (node:internal/streams/readable:234:10) mei 30 16:32:26 Homura misskey[2521009]: at TCP.onStreamRead (node:internal/stream_base_commons:190:23) { mei 30 16:32:26 Homura misskey[2521009]: length: 308, mei 30 16:32:26 Homura misskey[2521009]: severity: 'ERROR', mei 30 16:32:26 Homura misskey[2521009]: code: '23503', mei 30 16:32:26 Homura misskey[2521009]: detail: 'Key (id)=(8u156p4jge) is still referenced from table "drive_file".', mei 30 16:32:26 Homura misskey[2521009]: hint: undefined, mei 30 16:32:26 Homura misskey[2521009]: position: undefined, mei 30 16:32:26 Homura misskey[2521009]: internalPosition: undefined, mei 30 16:32:26 Homura misskey[2521009]: internalQuery: undefined, mei 30 16:32:26 Homura misskey[2521009]: where: undefined, mei 30 16:32:26 Homura misskey[2521009]: schema: 'public', mei 30 16:32:26 Homura misskey[2521009]: table: 'drive_file', mei 30 16:32:26 Homura misskey[2521009]: column: undefined, mei 30 16:32:26 Homura misskey[2521009]: dataType: undefined, mei 30 16:32:26 Homura misskey[2521009]: constraint: 'FK_860fa6f6c7df5bb887249fba22e', mei 30 16:32:26 Homura misskey[2521009]: file: 'ri_triggers.c', mei 30 16:32:26 Homura misskey[2521009]: line: '2478', mei 30 16:32:26 Homura misskey[2521009]: routine: 'ri_ReportViolation' mei 30 16:32:26 Homura misskey[2521009]: }, mei 30 16:32:26 Homura misskey[2521009]: length: 308, mei 30 16:32:26 Homura misskey[2521009]: severity: 'ERROR', mei 30 16:32:26 Homura misskey[2521009]: code: '23503', mei 30 16:32:26 Homura misskey[2521009]: detail: 'Key (id)=(8u156p4jge) is still referenced from table "drive_file".', mei 30 16:32:26 Homura misskey[2521009]: hint: undefined, mei 30 16:32:26 Homura misskey[2521009]: position: undefined, mei 30 16:32:26 Homura misskey[2521009]: internalPosition: undefined, mei 30 16:32:26 Homura misskey[2521009]: internalQuery: undefined, mei 30 16:32:26 Homura misskey[2521009]: where: undefined, mei 30 16:32:26 Homura misskey[2521009]: schema: 'public', mei 30 16:32:26 Homura misskey[2521009]: table: 'drive_file', mei 30 16:32:26 Homura misskey[2521009]: column: undefined, mei 30 16:32:26 Homura misskey[2521009]: dataType: undefined, mei 30 16:32:26 Homura misskey[2521009]: constraint: 'FK_860fa6f6c7df5bb887249fba22e', mei 30 16:32:26 Homura misskey[2521009]: file: 'ri_triggers.c', mei 30 16:32:26 Homura misskey[2521009]: line: '2478', mei 30 16:32:26 Homura misskey[2521009]: routine: 'ri_ReportViolation' mei 30 16:32:26 Homura misskey[2521009]: } mei 30 16:32:28 Homura misskey[2521009]: QueryFailedError: update or delete on table "user" violates foreign key constraint "FK_860fa6f6c7df5bb887249fba22e" on table "drive_file" mei 30 16:32:28 Homura misskey[2521009]: at PostgresQueryRunner.query (/home/misskey/misskey/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19) mei 30 16:32:28 Homura misskey[2521009]: at process.processTicksAndRejections (node:internal/process/task_queues:95:5) mei 30 16:32:28 Homura misskey[2521009]: at async DeleteQueryBuilder.execute (/home/misskey/misskey/node_modules/typeorm/query-builder/DeleteQueryBuilder.js:52:33) mei 30 16:32:28 Homura misskey[2521009]: at async Queue.checkExpired (file:///home/misskey/misskey/packages/backend/built/queue/processors/system/check-expired.js:42:5) { mei 30 16:32:28 Homura misskey[2521009]: query: 'DELETE FROM "user" WHERE "isDeleted" = $1', mei 30 16:32:28 Homura misskey[2521009]: parameters: [ 0 ], mei 30 16:32:28 Homura misskey[2521009]: driverError: error: update or delete on table "user" violates foreign key constraint "FK_860fa6f6c7df5bb887249fba22e" on table "drive_file" mei 30 16:32:28 Homura misskey[2521009]: at Parser.parseErrorMessage (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:287:98) mei 30 16:32:28 Homura misskey[2521009]: at Parser.handlePacket (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:126:29) mei 30 16:32:28 Homura misskey[2521009]: at Parser.parse (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:39:38) mei 30 16:32:28 Homura misskey[2521009]: at Socket.<anonymous> (/home/misskey/misskey/node_modules/pg-protocol/dist/index.js:11:42) mei 30 16:32:28 Homura misskey[2521009]: at Socket.emit (node:events:513:28) mei 30 16:32:28 Homura misskey[2521009]: at Socket.emit (node:domain:489:12) mei 30 16:32:28 Homura misskey[2521009]: at addChunk (node:internal/streams/readable:324:12) mei 30 16:32:28 Homura misskey[2521009]: at readableAddChunk (node:internal/streams/readable:297:9) mei 30 16:32:28 Homura misskey[2521009]: at Readable.push (node:internal/streams/readable:234:10) mei 30 16:32:28 Homura misskey[2521009]: at TCP.onStreamRead (node:internal/stream_base_commons:190:23) { mei 30 16:32:28 Homura misskey[2521009]: length: 308, mei 30 16:32:28 Homura misskey[2521009]: severity: 'ERROR', mei 30 16:32:28 Homura misskey[2521009]: code: '23503', mei 30 16:32:28 Homura misskey[2521009]: detail: 'Key (id)=(8u156p4jge) is still referenced from table "drive_file".', mei 30 16:32:28 Homura misskey[2521009]: hint: undefined, mei 30 16:32:28 Homura misskey[2521009]: position: undefined, mei 30 16:32:28 Homura misskey[2521009]: internalPosition: undefined, mei 30 16:32:28 Homura misskey[2521009]: internalQuery: undefined, mei 30 16:32:28 Homura misskey[2521009]: where: undefined, mei 30 16:32:28 Homura misskey[2521009]: schema: 'public', mei 30 16:32:28 Homura misskey[2521009]: table: 'drive_file', mei 30 16:32:28 Homura misskey[2521009]: column: undefined, mei 30 16:32:28 Homura misskey[2521009]: dataType: undefined, mei 30 16:32:28 Homura misskey[2521009]: constraint: 'FK_860fa6f6c7df5bb887249fba22e', mei 30 16:32:28 Homura misskey[2521009]: file: 'ri_triggers.c', mei 30 16:32:28 Homura misskey[2521009]: line: '2478', mei 30 16:32:28 Homura misskey[2521009]: routine: 'ri_ReportViolation' mei 30 16:32:28 Homura misskey[2521009]: }, mei 30 16:32:28 Homura misskey[2521009]: length: 308, mei 30 16:32:28 Homura misskey[2521009]: severity: 'ERROR', mei 30 16:32:28 Homura misskey[2521009]: code: '23503', mei 30 16:32:28 Homura misskey[2521009]: detail: 'Key (id)=(8u156p4jge) is still referenced from table "drive_file".', mei 30 16:32:28 Homura misskey[2521009]: hint: undefined, mei 30 16:32:28 Homura misskey[2521009]: position: undefined, mei 30 16:32:28 Homura misskey[2521009]: internalPosition: undefined, mei 30 16:32:28 Homura misskey[2521009]: internalQuery: undefined, mei 30 16:32:28 Homura misskey[2521009]: where: undefined, mei 30 16:32:28 Homura misskey[2521009]: schema: 'public', mei 30 16:32:28 Homura misskey[2521009]: table: 'drive_file', mei 30 16:32:28 Homura misskey[2521009]: column: undefined, mei 30 16:32:28 Homura misskey[2521009]: dataType: undefined, mei 30 16:32:28 Homura misskey[2521009]: constraint: 'FK_860fa6f6c7df5bb887249fba22e', mei 30 16:32:28 Homura misskey[2521009]: file: 'ri_triggers.c', mei 30 16:32:28 Homura misskey[2521009]: line: '2478', mei 30 16:32:28 Homura misskey[2521009]: routine: 'ri_ReportViolation' mei 30 16:32:28 Homura misskey[2521009]: } ```
Owner

The v13.0.0-preview5 tag is known broken. Please update to at least v13.0.0-preview5.1

The `v13.0.0-preview5` tag is known broken. Please update to at least `v13.0.0-preview5.1`
Author
Contributor

@Johann150 Oh, oops it seems that I missed that. Thanks, I fixed it.

@Johann150 Oh, oops it seems that I missed that. Thanks, I fixed it.
Sign in to join this conversation.
No Label
feature
fix
upkeep
No Milestone
No Assignees
2 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: FoundKeyGang/FoundKey#389
No description provided.