Migrations not being applied, despite being marked as complete
Hi, I have a project with multiple migrations that now seems to not actually apply. Starting fresh with a clear database applies them all without any issue, but trying to migrate an existing database seems to just not do anything:
> db:migrate> drizzle-kit migrateNo config path provided, using default 'drizzle.config.ts'Reading config file '/root/MintyScenarios/drizzle.config.ts'Using 'pg' driver for database querying
> db:migrate> drizzle-kit migrateNo config path provided, using default 'drizzle.config.ts'Reading config file '/root/MintyScenarios/drizzle.config.ts'Using 'pg' driver for database querying
The command terminates after that. The newest migration this is happening with is contained in the journal file:
and is called the proper name in the filesystem as well. Contents:
ALTER TABLE "adventures" ALTER COLUMN "history" SET DATA TYPE jsonb;--> statement-breakpoint[...]
ALTER TABLE "adventures" ALTER COLUMN "history" SET DATA TYPE jsonb;--> statement-breakpoint[...]
The weird part is that it looks like the migration is marked as applied in the DB, despite none of the queries having actually ran (there are 12 migrations in total).