© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•3y ago•
12 replies
pbochis

drizzle-kit push:mysql drops unchanged primary key & introspect:mysql fails hard

drizzle-kit version: 0.19.3
database: Planetscale
drizzle.config.ts:
export default {
    schema: './src/lib/db/schema.ts',
    out: './src/lib/db/migrations',
    driver: 'mysql2',
    dbCredentials: {
        connectionString: process.env.DATABASE_URL,
    },
} satisfies Config;
export default {
    schema: './src/lib/db/schema.ts',
    out: './src/lib/db/migrations',
    driver: 'mysql2',
    dbCredentials: {
        connectionString: process.env.DATABASE_URL,
    },
} satisfies Config;


Running drizzle-kit push:mysql errored out because it was trying to drop a primary key

  sql: 'ALTER TABLE `TrainingRegistrations` DROP PRIMARY KEY;',
  sqlState: '42000',
  sqlMessage: 'target: master-data.-.primary: vttablet: rpc error: code = InvalidArgument desc = Incorrect table definition; there can be only one auto column and it must be defined as a key (errno 1075) (sqlstate 42000) (CallerID: wg09dvsn07hoyy0q9wzp): Sql: "alter table TrainingRegistrations drop primary key", BindVars: {REDACTED}'}
  sql: 'ALTER TABLE `TrainingRegistrations` DROP PRIMARY KEY;',
  sqlState: '42000',
  sqlMessage: 'target: master-data.-.primary: vttablet: rpc error: code = InvalidArgument desc = Incorrect table definition; there can be only one auto column and it must be defined as a key (errno 1075) (sqlstate 42000) (CallerID: wg09dvsn07hoyy0q9wzp): Sql: "alter table TrainingRegistrations drop primary key", BindVars: {REDACTED}'}

As per https://orm.drizzle.team/kit-docs/overview#prototyping-with-db-push i understood that drizzle-kit executes a schema introspection, and then diffs it against my current schema.
So i ran a schema introspection, and the result very wrong
Attached screenshots of the current table structure, obtained by running
SHOW CREATE TABLE [name]
SHOW CREATE TABLE [name]
and the schema that drizzle generated
Screenshot_2023-10-19_at_12.57.45.png
Screenshot_2023-10-19_at_13.02.09.png
Drizzle Kit - DrizzleORM
Drizzle ORM | %s
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

drizzle-kit push error: Multiple primary key defined
Drizzle TeamDTDrizzle Team / help
2y ago
pnpm drizzle-kit push:mysql - error
Drizzle TeamDTDrizzle Team / help
3y ago
drizzle push and primary key order
Drizzle TeamDTDrizzle Team / help
3y ago
drizzle-kit push fails with neon
Drizzle TeamDTDrizzle Team / help
12mo ago