adonisjs/lucid

Knex: Timeout acquiring a connection

Closed this issue · 1 comments

Package version

21.2.0

Describe the bug

All code is available in attached repo develop branch

Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?
    request_id: "xlbr2yumej8t6ppvtl8jy18w"
    x-request-id: "xlbr2yumej8t6ppvtl8jy18w"
    err: {
      "type": "KnexTimeoutError",
      "message": "Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?",
      "stack":
          KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?
              at Client_MySQL2.acquireConnection (/Users/iqbal/office/umrah-api/node_modules/knex/lib/client.js:332:26)
              at runNextTicks (node:internal/process/task_queues:65:5)
              at listOnTimeout (node:internal/timers:555:9)
              at process.processTimers (node:internal/timers:529:7)
              at async QueryRunner.executeUsingManagedConnection (file:///Users/iqbal/office/umrah-api/node_modules/@adonisjs/lucid/build/src/query_runner/index.js:94:28)
              at async ManyToManyQueryBuilder.execQuery (file:///Users/iqbal/office/umrah-api/node_modules/@adonisjs/lucid/build/src/orm/query_builder/index.js:128:22)
              at async ManyToManyQueryBuilder.exec (file:///Users/iqbal/office/umrah-api/node_modules/@adonisjs/lucid/build/src/orm/query_builder/index.js:601:24)
              at async Preloader.processRelationForMany (file:///Users/iqbal/office/umrah-api/node_modules/@adonisjs/lucid/build/src/orm/preloader/index.js:70:24)
              at async Promise.all (index 0)
              at async Preloader.processAllForMany (file:///Users/iqbal/office/umrah-api/node_modules/@adonisjs/lucid/build/src/orm/preloader/index.js:137:9)
      "name": "KnexTimeoutError",
      "status": 500
    }
Screenshot 2024-11-26 at 9 45 25 PM

frontend screen shot of api call

Screenshot 2024-11-26 at 9 51 02 PM

Reproduction repo

https://github.com/awalsolution/umrah-api

Sorry, you have provide more info as this error is super generic from Knex and the repo you have provided is a full-blown app that I do not have to time to setup and go through.

Please narrow down the issue and then report a bug. If you are looking for help, then please use the discussion forum for that 👍