Open CamTheGoblin opened 5 months ago
Following. I get this a lot using local Turso dev. I end up having to recreate the local SQLite db and push from scratch but with so many changes whilst in dev, it gets frustrating. It's normally when I make changes to the relationships or the columns.
+1. Same error running drizzle-kit push:sqlite
with Turso. Very frustrating experience while on dev, as I have to instantiate new db on every schema changes for push:sqlite
to run properly.
The Issue:
After making a change to the schema, and running drizzle-kit push:sqlite, Requests made from my application started getting the following error:
Environment
drizzle-kit version: 0.20.17 drizzle-orm version: 0.30.8 framework: NextJS
Identified Bug:
The root cause of this error is the fact that the foriegn key values set up using the .references(()=>table.id) syntax in the schema are not being properly migrated, and are left referencing the __oldpush version of the target table (which I assume only exists for a short time during the push:sqlite process)
Work Around:
The foriegn keys were not really neccessary in my case, so I just removed the .references() calls in the schema and everything works now, but I imagine that wont be a good solution for everyone.