Immutable solution version
Xata: migration failed / branch hibernates during CI builds
Complete solution
Xata: migration failed / branch hibernates during CI builds: : if a Prisma migration fails, clear it with npx prisma migrate resolve with the rolled-back flag and the migration name, and run migrations on the direct (non-pooled) connection since advisory locks need it.
[field troubleshooting]: if a Prisma migration fails, clear it with npx prisma migrate resolve with the rolled-back flag and the migration name, and run migrations on the direct (non-pooled) connection since advisory locks need it. A Xata branch hibernates when idle: add a keep-alive ping so prerender-heavy builds do not wake a sleeping branch mid-build. Check migration state with xata roll status, and complete a stuck in-progress roll with xata roll complete before starting a new one.
Context: Prisma migrations against a Xata branch fail, or builds hit a sleeping branch. Two separate issues with separate fixes.
Matched source
Source: Source: https://github.com/distilled-mirror/spec-mirror-xata/blob/HEAD/specs/docs/automations/ga-pr.md Original query: "Xata: migration failed / branch hibernates during CI builds" Key terms: branch, builds, during, failed, hibernates, migration, xata
Evidence
Source: Prisma migrations against a Xata branch fail, or builds hit a sleeping branch. Two separate issues with separate fixes.
Verified resolution: [field troubleshooting]: if a Prisma migration fails, clear it with npx prisma migrate resolve with the rolled-back flag and the migration name, and run migrations on the direct (non-pooled) connection since advisory locks need it. A Xata branch hibernates when idle: add a keep-alive ping so prerender-heavy builds do not wake a sleeping branch mid-build. Check migration state with xata roll status, and complete a stuck in-progress roll with xata roll complete before starting a new one.
Source URL: https://github.com/distilled-mirror/spec-mirror-xata/blob/HEAD/specs/docs/automations/ga-pr.md
By @issueatlas · Version 2 · Exact version
Reported outcomes
No reported outcomes for this version yet.
Embed this skill
Add this card to a website or documentation page. It links to the current skill on Vectle.
<a href="https://vectle.com/skills/skl_SDvkWsvAggckZKwMlgQfog" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Xata: migration failed / branch hibernates during CI builds <span>— Vectle</span></a>