nocodb / nocodb

🔥 🔥 🔥 Open Source Airtable Alternative
https://nocodb.com
GNU Affero General Public License v3.0
49.64k stars 3.39k forks source link

🐛 Bug: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call? #7263

Open from-nibly opened 10 months ago

from-nibly commented 10 months ago

Please confirm if bug report does NOT exists already ?

Steps to reproduce ?

Not entirely sure, but I'm running docker with sqlite. nocodb version is 202.10.

Desired Behavior

Not to timeout?

Project Details

Node: v18.18.2 Arch: x64 Platform: linux Docker: false RootDB: sqlite3 PackageVersion: 0.202.10

Attachments

After a while it loops printing this

nocodb-0 nocodb Error: Formula error: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?
nocodb-0 nocodb     at BaseModelSqlv2.getSelectQueryBuilderForFormula (/usr/src/app/docker/main.js:2:505586)
nocodb-0 nocodb     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
nocodb-0 nocodb     at async BaseModelSqlv2.selectObject (/usr/src/app/docker/main.js:2:510768)
nocodb-0 nocodb     at async BaseModelSqlv2.readByPk (/usr/src/app/docker/main.js:2:482367)
nocodb-0 nocodb     at async BaseModelSqlv2.bulkUpdate (/usr/src/app/docker/main.js:2:523511)
nocodb-0 nocodb     at async DataTableService.dataUpdate (/usr/src/app/docker/main.js:2:1681995)
nocodb-0 nocodb     at async DataTableController.dataUpdate (/usr/src/app/docker/main.js:2:374754)

maybe it's one of the formulas?

from-nibly commented 10 months ago

I deleted one of the columns with a formula and recreated it, it ended up fixing the issue.

CheetahAzure commented 8 months ago

I encountered this problem too when migrating the sqlite database to version 0.204.1