Hello!
We're encountering database connection timeout errors with Knex.js in our Retool application. The error message is 'Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?' during bulk insert operations.
How can we optimize our Retool database resource configuration to prevent these connection pool issues? Are there any recommended settings for connection pool size or timeout values we should implement?
Thanks in advance!
Hi @Vitor_Dal_Pra,
Thanks for reaching out! A couple of follow up questions --
Which resource type are you using? (Retool Database, Postgres, etc)
About how many records are you inserting when you hit this error? Can we see a screenshot of the query? Is there a single bulk insert or a loop?
Does it happen consistently or during times of high app usage?
Hey @Tess!
We were using the Retool Database. And we noticed that the error would happen when our users were doing a bulk upsert with thousands of records. We decided to migrate everything to a postgres databse on aws and it gave us margin to work.
Thank you!
Glad to hear you have a solution! Retool Database is relatively limited for production use cases, so that sounds like a good approach