Failed to upgrade my misskey instance: migration failed

[xys20071111]

I am trying to upgrade my misskey instance. When I try to migrate the database, it failed.
Here is the log:

> [email protected] migrate /home/misskey/misskey
> cd packages/backend && pnpm migrate


> backend@ migrate /home/misskey/misskey/packages/backend
> pnpm typeorm migration:run -d ormconfig.js

query: SELECT * FROM current_schema()
query: SELECT version();
query: SELECT * FROM "information_schema"."tables" WHERE "table_schema" = 'public' AND "table_name" = 'migrations'
query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC
292 migrations are already loaded in the database.
296 migrations were found in the source code.
FixDriveUrl1721666053703 is the last executed migration. It was executed on Mon Jul 22 2024 16:34:13 GMT+0000 (Coordinated Universal Time).
4 migrations are new migrations must be executed.
query: START TRANSACTION
query: ALTER TABLE "user_profile" ADD "followedMessage" character varying(256)
query: INSERT INTO "migrations"("timestamp", "name") VALUES ($1, $2) -- PARAMETERS: [1723944246767,"FollowedMessage1723944246767"]
query failed: INSERT INTO "migrations"("timestamp", "name") VALUES ($1, $2) -- PARAMETERS: [1723944246767,"FollowedMessage1723944246767"]
error: error: duplicate key value violates unique constraint "PK_8c82d7f526340ab734260ea46be"
query: ROLLBACK
Error during migration run:
QueryFailedError: duplicate key value violates unique constraint "PK_8c82d7f526340ab734260ea46be"
    at PostgresQueryRunner.query (/home/misskey/misskey/node_modules/.pnpm/[email protected][email protected][email protected]/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async InsertQueryBuilder.execute (/home/misskey/misskey/node_modules/.pnpm/[email protected][email protected][email protected]/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33)
    at async MigrationExecutor.insertExecutedMigration (/home/misskey/misskey/node_modules/.pnpm/[email protected][email protected][email protected]/node_modules/typeorm/migration/MigrationExecutor.js:477:13)
    at async /home/misskey/misskey/node_modules/.pnpm/[email protected][email protected][email protected]/node_modules/typeorm/migration/MigrationExecutor.js:234:21
    at async MigrationExecutor.executePendingMigrations (/home/misskey/misskey/node_modules/.pnpm/[email protected][email protected][email protected]/node_modules/typeorm/migration/MigrationExecutor.js:225:17)
    at async DataSource.runMigrations (/home/misskey/misskey/node_modules/.pnpm/[email protected][email protected][email protected]/node_modules/typeorm/data-source/DataSource.js:265:35)
    at async Object.handler (/home/misskey/misskey/node_modules/.pnpm/[email protected][email protected][email protected]/node_modules/typeorm/commands/MigrationRunCommand.js:68:13) {
  query: 'INSERT INTO "migrations"("timestamp", "name") VALUES ($1, $2)',
  parameters: [ 1723944246767, 'FollowedMessage1723944246767' ],
  driverError: error: duplicate key value violates unique constraint "PK_8c82d7f526340ab734260ea46be"
      at /home/misskey/misskey/node_modules/.pnpm/[email protected]/node_modules/pg/lib/client.js:535:17
      at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
      at async PostgresQueryRunner.query (/home/misskey/misskey/node_modules/.pnpm/[email protected][email protected][email protected]/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:184:25)
      at async InsertQueryBuilder.execute (/home/misskey/misskey/node_modules/.pnpm/[email protected][email protected][email protected]/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33)
      at async MigrationExecutor.insertExecutedMigration (/home/misskey/misskey/node_modules/.pnpm/[email protected][email protected][email protected]/node_modules/typeorm/migration/MigrationExecutor.js:477:13)
      at async /home/misskey/misskey/node_modules/.pnpm/[email protected][email protected][email protected]/node_modules/typeorm/migration/MigrationExecutor.js:234:21
      at async MigrationExecutor.executePendingMigrations (/home/misskey/misskey/node_modules/.pnpm/[email protected][email protected][email protected]/node_modules/typeorm/migration/MigrationExecutor.js:225:17)
      at async DataSource.runMigrations (/home/misskey/misskey/node_modules/.pnpm/[email protected][email protected][email protected]/node_modules/typeorm/data-source/DataSource.js:265:35)
      at async Object.handler (/home/misskey/misskey/node_modules/.pnpm/[email protected][email protected][email protected]/node_modules/typeorm/commands/MigrationRunCommand.js:68:13) {
    length: 227,
    severity: 'ERROR',
    code: '23505',
    detail: 'Key (id)=(268) already exists.',
    hint: undefined,
    position: undefined,
    internalPosition: undefined,
    internalQuery: undefined,
    where: undefined,
    schema: 'public',
    table: 'migrations',
    column: undefined,
    dataType: undefined,
    constraint: 'PK_8c82d7f526340ab734260ea46be',
    file: 'nbtinsert.c',
    line: '664',
    routine: '_bt_check_unique'
  },
  length: 227,
  severity: 'ERROR',
  code: '23505',
  detail: 'Key (id)=(268) already exists.',
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: 'public',
  table: 'migrations',
  column: undefined,
  dataType: undefined,
  constraint: 'PK_8c82d7f526340ab734260ea46be',
  file: 'nbtinsert.c',
  line: '664',
  routine: '_bt_check_unique'
}
 ELIFECYCLE  Command failed with exit code 1.
 ELIFECYCLE  Command failed with exit code 1.

[xys20071111]

Okay, I handled these error one by one by drop, create and rename these index, column, enum and table.
Now upgrade success