升级失败

[jkjoy]

Error: P3009  25/01/06 08:53:31errormigrate found failed migrations in the target database, new migrations will not be applied. Read more about how to resolve migration issues in a production database: https://pris.ly/d/migrate-resolve  25/01/06 08:53:31errorThe `20240516050303_init` migration started at 2024-12-23 00:50:47.313267 UTC failed  25/01/06 08:53:31errorELIFECYCLE  Command failed with exit code 1.  25/01/06 08:53:31errorELIFECYCLE  Command failed with exit code 1.  25/01/06 08:53:31errorELIFECYCLE  Command failed with exit code 1.

貌似是迁移数据库失败,这是什么问题呢

[moonrailgun]

looks first migration has been failed.
can you check your database link is right and check database table _prisma_migrations?

[jkjoycn]

looks first migration has been failed. can you check your database link is right and check database table _prisma_migrations?

[email protected] start:docker /app/tianji
pnpm start:docker:db && pnpm start
[email protected] start:docker:db /app/tianji
cd src/server && pnpm db:migrate:apply && pnpm db:migrate:script
@tianji/server@ db:migrate:apply /app/tianji/src/server
prisma migrate deploy
Prisma schema loaded from prisma/schema.prisma
Datasource "db": PostgreSQL database "tianji", schema "public" at "jkjoy-pg-cs13mq:5432"
43 migrations found in prisma/migrations
Error: P3009
migrate found failed migrations in the target database, new migrations will not be applied. Read more about how to resolve migration issues in a production database: https://pris.ly/d/migrate-resolve
The 20240516050303_init migration started at 2024-12-23 00:50:47.313267 UTC failed
ELIFECYCLE  Command failed with exit code 1.
ELIFECYCLE  Command failed with exit code 1.
ELIFECYCLE  Command failed with exit code 1.

[moonrailgun]

ok, i think here is some problem when migration. you can:

• check database migration sql one by one
• check database's _prisma_migrations table, if normal, its should have much record.
• if you have no more idea. export all data, clear table, run migration sql to rebuild database struction, and import data again.