WaspW
Wasp•12mo ago
jason

I messed up my db migrations...

Hi all.. I messed up my db migration and now I have no idea how to fix this. This 'migration' stuff is kind of insane, but I'm willing to put up with it because the framework itself is so solid.

Anyways, I have my OpenSaaS project being tracked by git. I was trying to implement a new feature, which included a change to the schema.prisma file, which required a db migration. However, I later decided to just roll back to the last git commit. This messed up my migration, the errors weren't specific at all about what I should do so I think I just removed the latest migration directory? It got super messed up, so I just reset the entire db using "wasp db reset".

It looked like it was working fine after reset. But now, I'm making more changes to the db schema, and tried migrating it. But it threw an error about the last migration from before I reset.

[   Db  !] Error: P3015
[   Db  !]
[   Db  !] Could not find the migration file at /srv/web/opensaas_first_project/app/.wasp/out/db/migrations/20250103154636_interview_strengths_improvments_skillscores_migration/migration.sql. Please delete the directory or restore the migration file.
[   Db  !]


I tried, from the /app directory, running:
wasp clean
rm -rf .wasp/
rm -rf node_modules/
npm install
wasp db start
wasp db reset

But it's STILL talking about the old migration. Is it somewhere in my .git folder? What the hell is causing this headache?
Was this page helpful?