DT
Drizzle Team•3d ago
claudiu

Migration failed, and can't add new migration

Hello, I've tried to add a change to a table 
import { pgTable, serial, text } from 'drizzle-orm/pg-core';

export const categories = pgTable('categories', {
  id: serial('id').primaryKey(),
  name: text('name').notNull().unique(),
  label: text('label').notNull()
});
import { pgTable, serial, text } from 'drizzle-orm/pg-core';

export const categories = pgTable('categories', {
  id: serial('id').primaryKey(),
  name: text('name').notNull().unique(),
  label: text('label').notNull()
});
I run generate and migrate after and my migration failed because I table was already populated with data after the failure I changed to this 
export const categories = pgTable('categories', {
  id: serial('id').primaryKey(),
  name: text('name').notNull().unique(),
  label: text('label')
});
export const categories = pgTable('categories', {
  id: serial('id').primaryKey(),
  name: text('name').notNull().unique(),
  label: text('label')
});
but it's still failing with this error 
PostgresError: column "label" of relation "categories" contains null values
    at ErrorResponse (file:///Users/claudiu/Development/fsega/node_modules/postgres/src/connection.js:788:26)
    at handle (file:///Users/claudiu/Development/fsega/node_modules/postgres/src/connection.js:474:6)
    at Socket.data (file:///Users/claudiu/Development/fsega/node_modules/postgres/src/connection.js:315:9)
    at Socket.emit (node:events:519:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:191:23) {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '23502',
  schema_name: 'public',
  table_name: 'categories',
  column_name: 'label',
  file: 'tablecmds.c',
  line: '6279',
  routine: 'ATRewriteTable'
}
PostgresError: column "label" of relation "categories" contains null values
    at ErrorResponse (file:///Users/claudiu/Development/fsega/node_modules/postgres/src/connection.js:788:26)
    at handle (file:///Users/claudiu/Development/fsega/node_modules/postgres/src/connection.js:474:6)
    at Socket.data (file:///Users/claudiu/Development/fsega/node_modules/postgres/src/connection.js:315:9)
    at Socket.emit (node:events:519:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:191:23) {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '23502',
  schema_name: 'public',
  table_name: 'categories',
  column_name: 'label',
  file: 'tablecmds.c',
  line: '6279',
  routine: 'ATRewriteTable'
}
I checked the migration files 
// BEFORE
ALTER TABLE "categories" ADD COLUMN "label" text NOT NULL;
// BEFORE
ALTER TABLE "categories" ADD COLUMN "label" text NOT NULL;
// AFTER
ALTER TABLE "categories" ALTER COLUMN "label" DROP NOT NULL;
// AFTER
ALTER TABLE "categories" ALTER COLUMN "label" DROP NOT NULL;
I see the second migration it's trying to alter the label column but that column doesn't exist becuase the previous migration failed. How I can handle this?
2 Replies
claudiu
claudiuOP•3d ago
first migration failed with this error 
PostgresError: column "label" of relation "categories" contains null values
    at ErrorResponse (file:///Users/claudiu/Development/fsega/node_modules/postgres/src/connection.js:788:26)
PostgresError: column "label" of relation "categories" contains null values
    at ErrorResponse (file:///Users/claudiu/Development/fsega/node_modules/postgres/src/connection.js:788:26)
oke
oke•3d ago
Since the migration failed, I think you should run drizzle-kit drop and drop the last two migrations concerning this label column, then re-generate migration again

Did you find this page helpful?