introspect failing with pscale db
Getting a strange error when running the introspect command. I'm using a connectionString from pscale.
drizzle.config:
- I've included ?ssl={"rejectUnauthorized":true}
script:
"introspect": "drizzle-kit introspect:mysql",
Error:
drizzle.config:
schema: "./schema.ts",
out: "./drizzle",
driver: "mysql2",
dbCredentials: {
connectionString: ...
} schema: "./schema.ts",
out: "./drizzle",
driver: "mysql2",
dbCredentials: {
connectionString: ...
}- I've included ?ssl={"rejectUnauthorized":true}
script:
"introspect": "drizzle-kit introspect:mysql",
Error:
Error: rpc error: code = Unknown desc = uncaught panic: interface conversion: interface is nil, not sqlparser.Expr, vtgate:
at PromiseConnection.execute (/Users/robmartin/Projects/americana-neue/node_modules/.pnpm/drizzle-kit@0.19.11/node_modules/drizzle-kit/index.cjs:35440:26)
at fromDatabase (/Users/robmartin/Projects/americana-neue/node_modules/.pnpm/drizzle-kit@0.19.11/node_modules/drizzle-kit/index.cjs:11845:33)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
code: 'ER_UNKNOWN_ERROR',
errno: 1105,
sql: 'SELECT table_name, column_name\n' +
' FROM information_schema.table_constraints t\n' +
' LEFT JOIN information_schema.key_column_usage k\n' +
' USING(constraint_name,table_schema,table_name)\n' +
" WHERE t.constraint_type='PRIMARY KEY'\n" +
" and table_name != '__drizzle_migrations'\n" +
' AND t.table_schema = ?',
sqlState: 'HY000',
sqlMessage: 'rpc error: code = Unknown desc = uncaught panic: interface conversion: interface is nil, not sqlparser.Expr, vtgate:Error: rpc error: code = Unknown desc = uncaught panic: interface conversion: interface is nil, not sqlparser.Expr, vtgate:
at PromiseConnection.execute (/Users/robmartin/Projects/americana-neue/node_modules/.pnpm/drizzle-kit@0.19.11/node_modules/drizzle-kit/index.cjs:35440:26)
at fromDatabase (/Users/robmartin/Projects/americana-neue/node_modules/.pnpm/drizzle-kit@0.19.11/node_modules/drizzle-kit/index.cjs:11845:33)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
code: 'ER_UNKNOWN_ERROR',
errno: 1105,
sql: 'SELECT table_name, column_name\n' +
' FROM information_schema.table_constraints t\n' +
' LEFT JOIN information_schema.key_column_usage k\n' +
' USING(constraint_name,table_schema,table_name)\n' +
" WHERE t.constraint_type='PRIMARY KEY'\n" +
" and table_name != '__drizzle_migrations'\n" +
' AND t.table_schema = ?',
sqlState: 'HY000',
sqlMessage: 'rpc error: code = Unknown desc = uncaught panic: interface conversion: interface is nil, not sqlparser.Expr, vtgate:The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources
Similar Threads
Was this page helpful?
