Timeout when connecting to the sqlite database

[atomixer]

Hello, I'm occasionally running into errors when connecting to the sqlite database. We use citizen to version our modules. The way our setup works is we have a pipeline that will do a terraform init/plan in any directories that have changes which will download the relevant modules from citizen. Sometimes the pipeline will have a large build and will do the init/plan in a lot of directories in parallel at once. When this happens, citizen might crash with the following error (unfortunately I don't have a reliable way to reproduce the error). The error with which it fails is below -

PrismaClientUnknownRequestError:
Invalid prisma.module.updateMany() invocation:


Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: ConnectionError(Timed out during query execution.) })
    at RequestHandler.handleRequestError (/snapshot/citizen/stores/sqlite/client/runtime/index.js)
    at RequestHandler.request (/snapshot/citizen/stores/sqlite/client/runtime/index.js)
    at async PrismaClient._request (/snapshot/citizen/stores/sqlite/client/runtime/index.js)
    at async Object.increaseModuleDownload (/snapshot/citizen/stores/sqlite/sqlite.js)
    at async increaseModuleDownload (/snapshot/citizen/stores/store.js)
    at async /snapshot/citizen/routes/download.js {
  clientVersion: '4.3.1'
}

The error happens when citizen tries to increment the download counter for the module in the database.

citizen/stores/sqlite/sqlite.js

Line 94 in 650d286

const increaseModuleDownload = async (options) => {

My question is this, does that increment even need to happen? Is there any other setting we can tweak on sqlite or citizen to increase the timeout?

Thanks!

[b-dean]

This seems to be related to a number of upstream issues in Prisma.

One workaround I found is to add this to your connection uri: ?connection_limit=1