K
Kysely9mo ago
bun

what is this error, i started getting it randomly

error: syntax error at or near ")"
at /Users/username/Workspace/company/project/node_modules/.pnpm/registry.npmjs.org+pg@8.11.3/node_modules/pg/lib/client.js:526:17
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async PostgresConnection.executeQuery (file:///Users/username/Workspace/company/project/node_modules/.pnpm/registry.npmjs.org+kysely@0.25.0/node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js:69:28)
at async file:///Users/username/Workspace/company/project/node_modules/.pnpm/registry.npmjs.org+kysely@0.25.0/node_modules/kysely/dist/esm/query-executor/query-executor-base.js:35:28
at async #run (file:///Users/username/Workspace/company/project/node_modules/.pnpm/registry.npmjs.org+kysely@0.25.0/node_modules/kysely/dist/esm/driver/single-connection-provider.js:25:16)
at PostgresConnection.executeQuery (file:///Users/username/Workspace/company/project/node_modules/.pnpm/registry.npmjs.org+kysely@0.25.0/node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js:88:41)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async file:///Users/username/Workspace/company/project/node_modules/.pnpm/registry.npmjs.org+kysely@0.25.0/node_modules/kysely/dist/esm/query-executor/query-executor-base.js:35:28
at async #run (file:///Users/username/Workspace/company/project/node_modules/.pnpm/registry.npmjs.org+kysely@0.25.0/node_modules/kysely/dist/esm/driver/single-connection-provider.js:25:16) {
length: 90,
severity: 'ERROR',
code: '42601',
detail: undefined,
hint: undefined,
position: '22',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'scan.l',
line: '1248',
routine: 'scanner_yyerror'
}
error: syntax error at or near ")"
at /Users/username/Workspace/company/project/node_modules/.pnpm/registry.npmjs.org+pg@8.11.3/node_modules/pg/lib/client.js:526:17
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async PostgresConnection.executeQuery (file:///Users/username/Workspace/company/project/node_modules/.pnpm/registry.npmjs.org+kysely@0.25.0/node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js:69:28)
at async file:///Users/username/Workspace/company/project/node_modules/.pnpm/registry.npmjs.org+kysely@0.25.0/node_modules/kysely/dist/esm/query-executor/query-executor-base.js:35:28
at async #run (file:///Users/username/Workspace/company/project/node_modules/.pnpm/registry.npmjs.org+kysely@0.25.0/node_modules/kysely/dist/esm/driver/single-connection-provider.js:25:16)
at PostgresConnection.executeQuery (file:///Users/username/Workspace/company/project/node_modules/.pnpm/registry.npmjs.org+kysely@0.25.0/node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js:88:41)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async file:///Users/username/Workspace/company/project/node_modules/.pnpm/registry.npmjs.org+kysely@0.25.0/node_modules/kysely/dist/esm/query-executor/query-executor-base.js:35:28
at async #run (file:///Users/username/Workspace/company/project/node_modules/.pnpm/registry.npmjs.org+kysely@0.25.0/node_modules/kysely/dist/esm/driver/single-connection-provider.js:25:16) {
length: 90,
severity: 'ERROR',
code: '42601',
detail: undefined,
hint: undefined,
position: '22',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'scan.l',
line: '1248',
routine: 'scanner_yyerror'
}
1 Reply
koskimas
koskimas9mo ago
It comes from the database. Some query is invalid. I'm guessing you have have a
where('foo', 'in', array)
where('foo', 'in', array)
and the array is empty sometimes