Migration "syncOrm1674499888924" failed, error: deadlock detected

puniko commented

2023-02-05 09:46:53 +00:00

Contributor

didn't have much time to digg into it because i'll be afk for the most of the day today

query: ROLLBACK
Error during migration run:
QueryFailedError: deadlock detected
    at PostgresQueryRunner.query (/home/misskey/misskey/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:21
1:19)                        
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async syncOrm1674499888924.up (file:///home/misskey/misskey/packages/backend/migration/1674499888924-sync-orm.j
s:10:3)                      
    at async MigrationExecutor.executePendingMigrations (/home/misskey/misskey/node_modules/typeorm/migration/Migratio
nExecutor.js:178:17)
    at async DataSource.runMigrations (/home/misskey/misskey/node_modules/typeorm/data-source/DataSource.js:248:35)
    at async Object.handler (/home/misskey/misskey/node_modules/typeorm/commands/MigrationRunCommand.js:60:13) {
  query: 'CREATE UNIQUE INDEX "IDX_71d35fceee0d0fa62b2fa8f3b2" ON "note" ("url") ',
  parameters: undefined,
  driverError: error: deadlock detected
      at Parser.parseErrorMessage (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:287:98)
      at Parser.handlePacket (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:126:29)
      at Parser.parse (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:39:38)
      at Socket.<anonymous> (/home/misskey/misskey/node_modules/pg-protocol/dist/index.js:11:42)
      at Socket.emit (node:events:527:28)
      at addChunk (node:internal/streams/readable:324:12)
      at readableAddChunk (node:internal/streams/readable:297:9)
      at Readable.push (node:internal/streams/readable:234:10)
      at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
    length: 328,
    severity: 'ERROR',
    code: '40P01',
    detail: 'Process 1916190 waits for ShareLock on relation 3105071 of database 3103978; blocked by process 1922165.\
n' +                         
      'Process 1922165 waits for RowShareLock on relation 3105007 of database 3103978; blocked by process 1916190.',
    hint: 'See server log for query details.',
    position: undefined,
    internalPosition: undefined,
    internalQuery: undefined,
    where: undefined,
    schema: undefined,
    table: undefined,
    column: undefined,
    dataType: undefined,
    constraint: undefined,
    file: 'deadlock.c',
    line: '1141',
    routine: 'DeadLockReport' 
  },     
  length: 328,               
  severity: 'ERROR',
  code: '40P01',
  detail: 'Process 1916190 waits for ShareLock on relation 3105071 of database 3103978; blocked by process 1922165.\n'
 +                           
    'Process 1922165 waits for RowShareLock on relation 3105007 of database 3103978; blocked by process 1916190.',
  hint: 'See server log for query details.',
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'deadlock.c',
  line: '1141',
  routine: 'DeadLockReport'

Migration [syncOrm1674499888924](https://akkoma.dev/FoundKeyGang/FoundKey/src/branch/main/packages/backend/migration/1674499888924-sync-orm.js) fails didn't have much time to digg into it because i'll be afk for the most of the day today ``` query: ROLLBACK Error during migration run: QueryFailedError: deadlock detected at PostgresQueryRunner.query (/home/misskey/misskey/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:21 1:19) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async syncOrm1674499888924.up (file:///home/misskey/misskey/packages/backend/migration/1674499888924-sync-orm.j s:10:3) at async MigrationExecutor.executePendingMigrations (/home/misskey/misskey/node_modules/typeorm/migration/Migratio nExecutor.js:178:17) at async DataSource.runMigrations (/home/misskey/misskey/node_modules/typeorm/data-source/DataSource.js:248:35) at async Object.handler (/home/misskey/misskey/node_modules/typeorm/commands/MigrationRunCommand.js:60:13) { query: 'CREATE UNIQUE INDEX "IDX_71d35fceee0d0fa62b2fa8f3b2" ON "note" ("url") ', parameters: undefined, driverError: error: deadlock detected at Parser.parseErrorMessage (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:287:98) at Parser.handlePacket (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:126:29) at Parser.parse (/home/misskey/misskey/node_modules/pg-protocol/dist/parser.js:39:38) at Socket.<anonymous> (/home/misskey/misskey/node_modules/pg-protocol/dist/index.js:11:42) at Socket.emit (node:events:527:28) at addChunk (node:internal/streams/readable:324:12) at readableAddChunk (node:internal/streams/readable:297:9) at Readable.push (node:internal/streams/readable:234:10) at TCP.onStreamRead (node:internal/stream_base_commons:190:23) { length: 328, severity: 'ERROR', code: '40P01', detail: 'Process 1916190 waits for ShareLock on relation 3105071 of database 3103978; blocked by process 1922165.\ n' + 'Process 1922165 waits for RowShareLock on relation 3105007 of database 3103978; blocked by process 1916190.', hint: 'See server log for query details.', position: undefined, internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'deadlock.c', line: '1141', routine: 'DeadLockReport' }, length: 328, severity: 'ERROR', code: '40P01', detail: 'Process 1916190 waits for ShareLock on relation 3105071 of database 3103978; blocked by process 1922165.\n' + 'Process 1922165 waits for RowShareLock on relation 3105007 of database 3103978; blocked by process 1916190.', hint: 'See server log for query details.', position: undefined, internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'deadlock.c', line: '1141', routine: 'DeadLockReport' ```

Johann150 commented

2023-02-05 10:01:27 +00:00

Owner

Was Foundkey running at the same time? If so, please stop it and try the migration again.

puniko commented

2023-02-05 10:02:39 +00:00

Author

Contributor

will try this evening. no time now

puniko commented

2023-02-05 19:13:36 +00:00

Author

Contributor

migration does pass through now, buuuut migration registryRemoveDomain1675375940759 now fails with

  query: 'DELETE FROM "registry_item" AS "a" WHERE "updatedAt" != (SELECT MAX("updatedAt") OVER (PARTITION BY "userId"
, "key", "scope") FROM "registry_item" AS "b" WHERE "a"."userId" = "b"."userId" AND "a"."key" = "b"."key" AND "a"."sco
pe" = "b"."scope")',
  parameters: undefined,
  driverError: error: more than one row returned by a subquery used as an expression

migration does pass through now, buuuut migration registryRemoveDomain1675375940759 now fails with ``` query: 'DELETE FROM "registry_item" AS "a" WHERE "updatedAt" != (SELECT MAX("updatedAt") OVER (PARTITION BY "userId" , "key", "scope") FROM "registry_item" AS "b" WHERE "a"."userId" = "b"."userId" AND "a"."key" = "b"."key" AND "a"."sco pe" = "b"."scope")', parameters: undefined, driverError: error: more than one row returned by a subquery used as an expression ```

Johann150 referenced this issue from a commit

2023-02-05 21:56:24 +00:00

fix registry migration

Johann150 closed this issue

2023-02-05 21:56:24 +00:00

Migration "syncOrm1674499888924" failed, error: deadlock detected #337