© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•10mo ago•
1 reply
Latte macchiato

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 migrate

No 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 migrate

No 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:
    {
      "idx": 12,
      "version": "7",
      "when": 1744673080355,
      "tag": "0012_illegal_thunderball",
      "breakpoints": true
    }
    {
      "idx": 12,
      "version": "7",
      "when": 1744673080355,
      "tag": "0012_illegal_thunderball",
      "breakpoints": true
    }

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).
 id |                               hash                               |  created_at   
----+------------------------------------------------------------------+---------------
  1 | c8247b1414021feec941aa336b4a72c641121c7d33c2b8777d7c5eddb93e65cd | 1744573954728
  2 | 211b9351539ea30813dca97ce5ca8407a1502cdf4386087731268b1384079d69 | 1744575957391
  3 | a1ee3df3b64174a8846fbae593ea6141fb097989bc320bfbcd4113af7f2fb0aa | 1744583579085
  4 | e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855 | 1744685000000
  5 | d78451866ef1b91187ec487e3337d06242b1b2be3b1da02763611b41debee474 | 1744585806582
  6 | 62e417a21159ad433efc2a653ee7079749881ba75d0a5caf2d98a32be8977889 | 1744589238926
  7 | c2188cb9222dacea49b5598d093de3ec7262fb8cd7ae4de13a3a7ea3f2cfdadb | 1744621830859
  8 | 1850ad8eaa340a31e1f85bba335e0be00d67b03a9e60024448fbc6e458d1f5cc | 1744625049182
  9 | b0732433775616a265b5ef5916a3bf74d5bf809bc774c1fbafa09b989e2b86ce | 1744625049183
 10 | d236a5bb6035bacf4ce659515234e9b4020ac1328aaae58fd9978498dba422eb | 1744625049184
 11 | 6fffd6493d4e6099cb252ec5238fa9d148da7cdcbda4be6ffe241d8e01c00199 | 1744628403236
 12 | fffa2a3cbde7f8ee5bcdbee77e0ba6102f172621f5546dbf5439166f4c4dbe43 | 1744635620765
 id |                               hash                               |  created_at   
----+------------------------------------------------------------------+---------------
  1 | c8247b1414021feec941aa336b4a72c641121c7d33c2b8777d7c5eddb93e65cd | 1744573954728
  2 | 211b9351539ea30813dca97ce5ca8407a1502cdf4386087731268b1384079d69 | 1744575957391
  3 | a1ee3df3b64174a8846fbae593ea6141fb097989bc320bfbcd4113af7f2fb0aa | 1744583579085
  4 | e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855 | 1744685000000
  5 | d78451866ef1b91187ec487e3337d06242b1b2be3b1da02763611b41debee474 | 1744585806582
  6 | 62e417a21159ad433efc2a653ee7079749881ba75d0a5caf2d98a32be8977889 | 1744589238926
  7 | c2188cb9222dacea49b5598d093de3ec7262fb8cd7ae4de13a3a7ea3f2cfdadb | 1744621830859
  8 | 1850ad8eaa340a31e1f85bba335e0be00d67b03a9e60024448fbc6e458d1f5cc | 1744625049182
  9 | b0732433775616a265b5ef5916a3bf74d5bf809bc774c1fbafa09b989e2b86ce | 1744625049183
 10 | d236a5bb6035bacf4ce659515234e9b4020ac1328aaae58fd9978498dba422eb | 1744625049184
 11 | 6fffd6493d4e6099cb252ec5238fa9d148da7cdcbda4be6ffe241d8e01c00199 | 1744628403236
 12 | fffa2a3cbde7f8ee5bcdbee77e0ba6102f172621f5546dbf5439166f4c4dbe43 | 1744635620765


I am at my wits end with debugging this.
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources
Was this page helpful?

Similar Threads

Recent Announcements

Similar Threads

SQLite migrations are not being applied
Drizzle TeamDTDrizzle Team / help
3y ago
Migrations not being applied (drizzle-orm/node-postgres/migrator)
Drizzle TeamDTDrizzle Team / help
3y ago
Determining successfully applied migrations
Drizzle TeamDTDrizzle Team / help
2y ago
How to mark migration as applied?
Drizzle TeamDTDrizzle Team / help
13mo ago