Can anyone lend me a hand with understanding this error message?
I've got some relations in my schema that are causing the following error on db:push to planetscale:
Error: VT10001: foreign key constraints are not allowed at PromiseConnection.query (/home/hyhy/dev/modulation/node_modules/.pnpm/drizzle-kit@0.19.13/node_modules/drizzle-kit/index.cjs:35481:26) at Command.<anonymous> (/home/hyhy/dev/modulation/node_modules/.pnpm/drizzle-kit@0.19.13/node_modules/drizzle-kit/index.cjs:53292:33) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) { code: 'ER_UNKNOWN_ERROR', errno: 1105, sql: 'ALTER TABLE `modulation_album` ADD CONSTRAINT `modulation_album_artist_id_modulation_artist_id_fk` FOREIGN KEY (`artist_id`) REFERENCES `modulation_artist`(`id`) ON DELETE no action ON UPDATE no action;', sqlState: 'HY000', sqlMessage: 'VT10001: foreign key constraints are not allowed'}
Error: VT10001: foreign key constraints are not allowed at PromiseConnection.query (/home/hyhy/dev/modulation/node_modules/.pnpm/drizzle-kit@0.19.13/node_modules/drizzle-kit/index.cjs:35481:26) at Command.<anonymous> (/home/hyhy/dev/modulation/node_modules/.pnpm/drizzle-kit@0.19.13/node_modules/drizzle-kit/index.cjs:53292:33) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) { code: 'ER_UNKNOWN_ERROR', errno: 1105, sql: 'ALTER TABLE `modulation_album` ADD CONSTRAINT `modulation_album_artist_id_modulation_artist_id_fk` FOREIGN KEY (`artist_id`) REFERENCES `modulation_artist`(`id`) ON DELETE no action ON UPDATE no action;', sqlState: 'HY000', sqlMessage: 'VT10001: foreign key constraints are not allowed'}
Using the stock drizzle config:
import { type Config } from "drizzle-kit";import { env } from "~/env";export default { schema: "./src/server/db/schema.ts", driver: "mysql2", dbCredentials: { connectionString: env.DATABASE_URL, }, tablesFilter: ["modulation_*"],} satisfies Config;
import { type Config } from "drizzle-kit";import { env } from "~/env";export default { schema: "./src/server/db/schema.ts", driver: "mysql2", dbCredentials: { connectionString: env.DATABASE_URL, }, tablesFilter: ["modulation_*"],} satisfies Config;