Drizzle TeamDT
Drizzle Team•3y ago
focused_morning

introspect failing with pscale db

Getting a strange error when running the introspect command. I'm using a connectionString from pscale.
drizzle.config:
  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:
Was this page helpful?