knex timeout acquiring a connection. the pool is probably full. are you missing a code example
Example 1: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?
"pool": {
"min": 2,
"max": 6,
"createTimeoutMillis": 3000,
"acquireTimeoutMillis": 30000,
"idleTimeoutMillis": 30000,
"reapIntervalMillis": 1000,
"createRetryIntervalMillis": 100,
"propagateCreateError": false
},
Example 2: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?
require('dotenv').config();
module.exports = {
development: {
client: 'mysql2',
connection: {
port: process.env.db_port,
host: process.env.db_host,
database: process.env.db_name,
user: process.env.db_user,
password: process.env.db_key,
connectTimeout: 90000
},
debug: true,
pool: {
min: 1,
max: 20,
},
migrations: {
directory: __dirname + '/knex/migrations',
},
seeds: {
directory: __dirname + '/knex/seeds',
},
}
};