Knex timeout error

💬 App Building
1

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!

3

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?