❌ CI/CD pipeline failing due to SQLx migration checksum mismatch

[Wilfred007]

📌 Project Context

This project is a Rust backend using Axum, SQLx, and PostgreSQL.
CI/CD is handled with GitHub Actions.

❌ Problem

The CI pipeline fails during migration with the error:

error: migration 20250411000001 was previously applied but has been modified

🔁 Steps to Reproduce

1. Clone the repo
2. Set DATABASE_URL
3. Run:
   cargo sqlx migrate run

✅ Expected Behavior

Migrations should run successfully in CI.

❗ Actual Behavior

Pipeline fails with checksum mismatch error.

🖥️ Environment

• Rust: (your version)
• SQLx: (your version)
• OS: Ubuntu (GitHub Actions)

📂 CI Workflow

Paste relevant part of .github/workflows/ci.yml

🛠️ What I’ve Tried

• Resetting migrations
• Re-running pipeline
• Ensuring fresh database

🙏 Help Needed

Need help fixing SQLx migration issues in CI/CD pipeline.

[Daniel4000-dev]

@Daniel4000-dev has applied to work on this issue as part of the Stellar Wave Program's 3rd wave.

I would like to work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Daniel4000-dev to this issue.

[drips-wave]

Congratulations, @Daniel4000-dev! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on March 30, 2026.

🧑‍💻 @Daniel4000-dev: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊