Yesterday I wanted to deploy again and it failed because of a failed migration. I added another field to a table with a value that shall be “TEXT NOT NULL” but that table already has some dummy entries.
So I want to follow the guide Migration troubleshooting in production | Prisma Docs but when I want to rollback a migration is tells me the following:
Migration `20220606170225_development_update` cannot be rolled back because it is not in a failed state.
I tried all the migrations I have and get the same message for all of them but it still doesn’t let me deploy on top of it.
I don’t really care about the data (yet) that is inside this table. How can I resolve this? I can not connect to the prod db with
fly ssh console -C database-cli to do it myself (because its dead?).
Any help is appreciated, as I am quite new to fullstack stuff.