Latte macchiato
Latte macchiato
PostsComments
DTDrizzle Team
Created by Latte macchiato on 4/14/2025 in #help
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.
2 replies