backend crashes with "KnexTimeoutError: Knex: Timeout acquiring a connection."

[maxaudron]

runtime has been 38days, there might be some connection pool running full with time or so.

[debug]	2021-05-21 17:55:32: IrcMessageProcessor.ts: Parsing new IRC message
[info]	2021-05-21 17:55:32: IrcMessageProcessor.ts: New message: :Eldbogi!Eldbogi@snoonet.org/user/Eldbogi QUIT :Connection closed
[debug]	2021-05-21 17:55:32: ircconnection.ts: Parsed IRC message: {"ircMessage":{"prefix":"Eldbogi!Eldbogi@snoonet.org/user/Eldbogi","command":"QUIT","params":["Connection closed"]}}

/lmrdashboard/backend/node_modules/knex/lib/client.js:348
        convertedError = new KnexTimeoutError(
                         ^
KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?
    at Client_MySQL.acquireConnection (/lmrdashboard/backend/node_modules/knex/lib/client.js:348:26)
    at runMicrotasks (<anonymous>)
    at runNextTicks (node:internal/process/task_queues:58:5)
    at listOnTimeout (node:internal/timers:524:9)
    at processTimers (node:internal/timers:498:7)
error Command failed with exit code 1.
info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.

[LoLei]

I increased the pool limit (c44c5a6) and timeout (cc18066) as a quickfix, if that doesn't help we may look into using transactions as those are mentioned a few times in related threads (knex/knex#2820). The version upgrade of pg would not help in our case I assume since we're using mysql.