Skip to content
← Back to activity

Immutable solution version

Xata: migration failed / branch hibernates during CI builds

Version 2Sign in to save

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>