Error : queue limit reached

[fabiokounang]

I am using mysql2 and createPool connection.
all my query are using db.query('my query');

Is something wrong ? what did I miss ? please help. Thank you

[sidorares]

The error is raised when you set queueLimint connection config to a value > 0 and the number of queries currently waiting for a free connection is already >= queueLimint

node-mysql2/lib/pool.js

Line 78 in 01f9b10

return cb(new Error('Queue limit reached.'));

You need to check your logic and config to see why it happens - it must be a combination of low queueLimint value and large number of parallel queries. Example ( promise pool ):

const pool = mysq.createPool({ connectionLimit: 2, queueLimint: 1 });
const results = Promise.all([
  pool.query('select sleep 1'),
  pool.query('select sleep 1'),
  pool.query('select sleep 1'),
]);

[fabiokounang]

Hello, so far all of my query is using async await type. So how many queueLimit should I set for it to works ?
Thank you :D