I tried to perform a prisma migrate on a table with ~30k rec Prisma #orm-help

I tried to perform a prisma migrate on a table wit...

Gabe O'Leary

10/21/2021, 7:44 PM

I tried to perform a prisma migrate on a table with ~30k records which took ~30 minutes after which I cancelled it and now when I retry it I get this message:

Copy code

The migration `...` failed.
? We need to reset the PostgreSQL database "..." at "...".      
Do you want to continue? All data will be lost. » (y/N)

also if I try to query the table on which the migration was attempted it runs for minutes without returning anything... Seems like I've corrupted my DB. Luckily I don't care that much about this data, but I would like to know what likely went wrong so I can avoid it in the future. This table does have a JSON column with a potentially sizeable amount of data....is that what might've resulted in the migration command taking so long? Also I had datagrip connected to the db when I triggered the migrate...is this an issue?

Gabe O'Leary

10/21/2021, 7:45 PM

also the migration was really simple:

Copy code

-- AlterTable
ALTER TABLE "Status" ADD COLUMN     "favoriteCount" INTEGER NOT NULL DEFAULT 0,
ADD COLUMN     "retweetCount" INTEGER NOT NULL DEFAULT 0;

Gabe O'Leary

10/21/2021, 7:51 PM

also it looks like even if I agree to have my DB reset migrate still seems to hang...

Gabe O'Leary

10/21/2021, 7:51 PM

(v3.2.1 of prisma)

Gabe O'Leary

10/21/2021, 8:10 PM

upgraded to 3.3 to no avail...guess I'll manually reset my DB

Austin

10/22/2021, 6:48 PM

Hey Gabe 👋, What specific command were you running when you got the migration error?

Gabe O'Leary

10/22/2021, 6:50 PM

Hey Austin! I believe it was:

prisma migrate dev

Austin

10/26/2021, 3:46 PM

Would you mind filling out a bug report? I've been chatting with our engineering teams and they would like to take a close look at this one. Thanks so much for providing all this info!

Open in Slack

Previous Next