search

hypercerts-org / hypercerts-indexer

Indexing service for hypercerts metadata
2 stars 0 forks source link

[db] OP indexer generates errors on batch storage #192

Closed bitbeckers closed 1 month ago

bitbeckers commented 1 month ago

See Railway logs for more details on this error:

Failed to submit request queue error: bind message has 20599 parameter formats but 0 parameters
    at /app/node_modules/.pnpm/pg@8.12.0/node_modules/pg/lib/client.js:526:17
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async PostgresConnection.executeQuery (file:///app/node_modules/.pnpm/kysely@0.27.4/node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js:69:28)
    at async file:///app/node_modules/.pnpm/kysely@0.27.4/node_modules/kysely/dist/esm/query-executor/query-executor-base.js:35:28
    at async #run (file:///app/node_modules/.pnpm/kysely@0.27.4/node_modules/kysely/dist/esm/driver/single-connection-provider.js:24:16)
....

Found an issue describing the problem. We probably need to batch the writing of allowlist record as that's the usual suspect in blowing op tx parsing.

https://github.com/brianc/node-postgres/issues/2579