You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In simple terms, I have a very early project on Supabase that I recently need to revive. However, the umami version was v1 at the time, so the corresponding database table fields in Supabase are also from that time. Therefore, I looked at the documentation and tried to migrate and upgrade the data through migrate-v1-v2.
Here is the console log:
Running v0.15.0
✓ DATABASE_URL is defined.
✓ Database connection successful.
✓ Database v1 tables ready for migration.
✓ Database v2 tables found.
✓ Database is ready for migration.
✓ Starting v2 data migration. Please do no cancel this process, it may take a while.
PrismaClientKnownRequestError:
Invalid `prisma.$executeRawUnsafe()` invocation:
Raw query failed. Code: `57014`. Message: `db error: ERROR: canceling statement due to statement timeout`
at Zr.handleRequestError (/Users/zc/code/github/umami/migrate-v1-v2/node_modules/.pnpm/@[email protected][email protected]/node_modules/@prisma/client/runtime/library.js:171:6414)
at Zr.handleAndLogRequestError (/Users/zc/code/github/umami/migrate-v1-v2/node_modules/.pnpm/@[email protected][email protected]/node_modules/@prisma/client/runtime/library.js:171:5948)
at Zr.request (/Users/zc/code/github/umami/migrate-v1-v2/node_modules/.pnpm/@[email protected][email protected]/node_modules/@prisma/client/runtime/library.js:171:5786)
at async Proxy._request (/Users/zc/code/github/umami/migrate-v1-v2/node_modules/.pnpm/@[email protected][email protected]/node_modules/@prisma/client/runtime/library.js:174:10455)
at async runSqlFile (/Users/zc/code/github/umami/migrate-v1-v2/index.js:277:9)
at async migrateData (/Users/zc/code/github/umami/migrate-v1-v2/index.js:109:3)
at async /Users/zc/code/github/umami/migrate-v1-v2/index.js:308:7 {
code: 'P2010',
clientVersion: '4.11.0',
meta: {
code: '57014',
message: 'db error: ERROR: canceling statement due to statement timeout'
}
}
✗ Failed to run sql file /db/postgresql/data-migration-v2.sql.
I tried to search for the keyword 57014 but found nothing.
Perhaps you know some useful information, and I'm really looking forward to someone helping me out~
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
In simple terms, I have a very early project on Supabase that I recently need to revive. However, the umami version was v1 at the time, so the corresponding database table fields in Supabase are also from that time. Therefore, I looked at the documentation and tried to migrate and upgrade the data through migrate-v1-v2.
Here is the console log:
I tried to search for the keyword 57014 but found nothing.
Perhaps you know some useful information, and I'm really looking forward to someone helping me out~
Beta Was this translation helpful? Give feedback.
All reactions