Knex: Timeout acquiring a connection

Server provisioning and management
I cannot get past this error with
Adonis v5.
Nodejs 12.x
Postgres 12

Migrate Database Log

Migrate Database 20210414020708
Preparing to migrate the database
KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?
at Client_PG.acquireConnection (/home/cleavr/api.sams-ph.com/releases/20210414020708/build/node_modules/knex/lib/client.js:348:26)

Any insight will help.

Thanks

Hi @jojoyu, welcome to the Cleavr forum!

It’s difficult to tell for sure what the issue is, but I’ve seen on some forums where a version mismatch between Node and Postgres can cause that type of error.

One thing I recommend is updating the Node version to 14. Adonis v5 is moving away from later versions and is more and more going to require v14 or newer. You might give updating Node a try and see if that helps.

We’ll likely update new Adonis 5 site installs to use Node v14 for that reason.

If you give upgrading Node a try, let us know if that fixed the issue or not.

1 Like