🐛 Bug: Nest 8 error

[candideu]

Please confirm if bug report does NOT exists already ?

• I confirm there is no existing issue for this

Steps to reproduce ?

I'm unable to deploy my instance of nocodb on Railway. The deployment link throws a "cannot GET" error.

Desired Behavior

Working deployment

Project Details

NocoDB hosted on Railway

Attachments

Deployment logs (click to view)

[Nest] 10 - 06/05/2023, 2:19:05 AM LOG [NestFactory] Starting Nest application... [Nest] 10 - 06/05/2023, 2:19:05 AM LOG [InstanceLoader] PassportModule dependencies initialized +79ms [Nest] 10 - 06/05/2023, 2:19:05 AM LOG [InstanceLoader] MulterModule dependencies initialized +0ms [Nest] 10 - 06/05/2023, 2:19:05 AM LOG [InstanceLoader] MulterModule dependencies initialized +0ms [Nest] 10 - 06/05/2023, 2:19:05 AM LOG [InstanceLoader] o dependencies initialized +0ms [Nest] 10 - 06/05/2023, 2:19:05 AM LOG [InstanceLoader] DiscoveryModule dependencies initialized +25ms [Nest] 10 - 06/05/2023, 2:19:05 AM LOG [InstanceLoader] EventEmitterModule dependencies initialized +2ms (node:10) NOTE: We are formalizing our plans to enter AWS SDK for JavaScript (v2) into maintenance mode in 2023. Please migrate your code to use AWS SDK for JavaScript (v3). For more information, check the migration guide at https://a.co/7PzMCcy (Use `node --trace-warnings ...` to show where the warning was created) ╔══════════════════════════════════════════════════════════════════════════════╗║ ║║ EXCEPTION OCCURED!! in PGClient @ createDatabaseIfNotExists ║║ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ║║ - - - - - - - - - - - - - - - - - - - - - - ║║ MESSAGE: ║║ Knex: Timeout acquiring a connection. The pool is probably full. Are you ║║ missing a .transacting(trx) call? ║║ ║║ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ║║ - - - - - - - - - - - - - - - - - - - - - - ║║ CODE: ║║ undefined ║║ ║║ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ║║ - - - - - - - - - - - - - - - - - - - - - - ║║ STACK: ║║ KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is ║║ probably full. Are you missing a .transacting(trx) call? ║║ at Client_PG.acquireConnection ║║ (/usr/src/app/node_modules/knex/lib/client.js:307:26) ║║ at async Runner.ensureConnection ║║ (/usr/src/app/node_modules/knex/lib/execution/runner.js:287:28) ║║ at async Runner.run ║║ (/usr/src/app/node_modules/knex/lib/execution/runner.js:30:19) ║║ at async f.createDatabaseIfNotExists ║║ (/usr/src/app/docker/main.js:1:468119) ║║ at async metaDbCreateIfNotExist (/usr/src/app/docker/main.js:1:1313979) ║║ at async Function.create (/usr/src/app/docker/main.js:1:1312760) ║║ at async InstanceWrapper.useFactory [as metatype] ║║ (/usr/src/app/docker/main.js:1:888504) ║║ at async Injector.instantiateClass ║║ (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:355:37) ║║ at async callback ║║ (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:56:34) ║║ at async Injector.resolveConstructorParams ║║ (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:136:24) ║║ ║║ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ║║ - - - - - - - - - - - - - - - - - - - - - - ║║ ║║ ║╚══════════════════════════════════════════════════════════════════════════════╝ KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call? at Client_PG.acquireConnection (/usr/src/app/node_modules/knex/lib/client.js:307:26) at async Runner.ensureConnection (/usr/src/app/node_modules/knex/lib/execution/runner.js:287:28) at async Runner.run (/usr/src/app/node_modules/knex/lib/execution/runner.js:30:19) at async f.createDatabaseIfNotExists (/usr/src/app/docker/main.js:1:468119) at async metaDbCreateIfNotExist (/usr/src/app/docker/main.js:1:1313979) at async Function.create (/usr/src/app/docker/main.js:1:1312760) at async InstanceWrapper.useFactory [as metatype] (/usr/src/app/docker/main.js:1:888504) at async Injector.instantiateClass (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:355:37) at async callback (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:56:34) at async Injector.resolveConstructorParams (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:136:24) { sql: "SELECT datname as database FROM pg_database WHERE datistemplate = false and datname = 'railway'", bindings: undefined } [Nest] 10 - 06/05/2023, 2:20:05 AM ERROR [ExceptionHandler] KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call? Error: KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call? at Function.create (/usr/src/app/docker/main.js:1:1312808) at async InstanceWrapper.useFactory [as metatype] (/usr/src/app/docker/main.js:1:888504) at async Injector.instantiateClass (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:355:37) at async callback (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:56:34) at async Injector.resolveConstructorParams (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:136:24) at async Injector.loadInstance (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:61:13) at async /usr/src/app/node_modules/@nestjs/core/injector/instance-loader.js:56:13 at async Promise.all (index 3) at async InstanceLoader.createInstancesOfProviders (/usr/src/app/node_modules/@nestjs/core/injector/instance-loader.js:55:9) at async Injector.loadProvider (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:88:9) [Nest] 8 - 06/05/2023, 2:20:11 AM LOG [NestFactory] Starting Nest application... [Nest] 8 - 06/05/2023, 2:20:11 AM LOG [InstanceLoader] PassportModule dependencies initialized +76ms [Nest] 8 - 06/05/2023, 2:20:11 AM LOG [InstanceLoader] MulterModule dependencies initialized +1ms [Nest] 8 - 06/05/2023, 2:20:11 AM LOG [InstanceLoader] MulterModule dependencies initialized +0ms [Nest] 8 - 06/05/2023, 2:20:11 AM LOG [InstanceLoader] o dependencies initialized +0ms [Nest] 8 - 06/05/2023, 2:20:11 AM LOG [InstanceLoader] DiscoveryModule dependencies initialized +23ms [Nest] 8 - 06/05/2023, 2:20:11 AM LOG [InstanceLoader] EventEmitterModule dependencies initialized +2ms (node:8) NOTE: We are formalizing our plans to enter AWS SDK for JavaScript (v2) into maintenance mode in 2023. Please migrate your code to use AWS SDK for JavaScript (v3). For more information, check the migration guide at https://a.co/7PzMCcy (Use `node --trace-warnings ...` to show where the warning was created) ╔══════════════════════════════════════════════════════════════════════════════╗║ ║║ EXCEPTION OCCURED!! in PGClient @ createDatabaseIfNotExists ║║ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ║║ - - - - - - - - - - - - - - - - - - - - - - ║║ MESSAGE: ║║ Knex: Timeout acquiring a connection. The pool is probably full. Are you ║║ missing a .transacting(trx) call? ║║ ║║ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ║║ - - - - - - - - - - - - - - - - - - - - - - ║║ CODE: ║║ undefined ║║ ║║ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ║║ - - - - - - - - - - - - - - - - - - - - - - ║║ STACK: ║║ KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is ║║ probably full. Are you missing a .transacting(trx) call? ║║ at Client_PG.acquireConnection ║║ (/usr/src/app/node_modules/knex/lib/client.js:307:26) ║║ at async Runner.ensureConnection ║║ (/usr/src/app/node_modules/knex/lib/execution/runner.js:287:28) ║║ at async Runner.run ║║ (/usr/src/app/node_modules/knex/lib/execution/runner.js:30:19) ║║ at async f.createDatabaseIfNotExists ║║ (/usr/src/app/docker/main.js:1:468119) ║║ at async metaDbCreateIfNotExist (/usr/src/app/docker/main.js:1:1313979) ║║ at async Function.create (/usr/src/app/docker/main.js:1:1312760) ║║ at async InstanceWrapper.useFactory [as metatype] ║║ (/usr/src/app/docker/main.js:1:888504) ║║ at async Injector.instantiateClass ║║ (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:355:37) ║║ at async callback ║║ (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:56:34) ║║ at async Injector.resolveConstructorParams ║║ (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:136:24) ║║ ║║ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ║║ - - - - - - - - - - - - - - - - - - - - - - ║║ ║║ ║╚══════════════════════════════════════════════════════════════════════════════╝ KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call? at Client_PG.acquireConnection (/usr/src/app/node_modules/knex/lib/client.js:307:26) at async Runner.ensureConnection (/usr/src/app/node_modules/knex/lib/execution/runner.js:287:28) at async Runner.run (/usr/src/app/node_modules/knex/lib/execution/runner.js:30:19) at async f.createDatabaseIfNotExists (/usr/src/app/docker/main.js:1:468119) at async metaDbCreateIfNotExist (/usr/src/app/docker/main.js:1:1313979) at async Function.create (/usr/src/app/docker/main.js:1:1312760) at async InstanceWrapper.useFactory [as metatype] (/usr/src/app/docker/main.js:1:888504) at async Injector.instantiateClass (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:355:37) at async callback (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:56:34) at async Injector.resolveConstructorParams (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:136:24) { sql: "SELECT datname as database FROM pg_database WHERE datistemplate = false and datname = 'railway'", bindings: undefined } [Nest] 8 - 06/05/2023, 2:21:11 AM ERROR [ExceptionHandler] KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call? Error: KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call? at Function.create (/usr/src/app/docker/main.js:1:1312808) at async InstanceWrapper.useFactory [as metatype] (/usr/src/app/docker/main.js:1:888504) at async Injector.instantiateClass (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:355:37) at async callback (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:56:34) at async Injector.resolveConstructorParams (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:136:24) at async Injector.loadInstance (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:61:13) at async Injector.loadProvider (/usr/src/app/node_modules/@nestjs/core/injector/injector.js:88:9) at async /usr/src/app/node_modules/@nestjs/core/injector/instance-loader.js:56:13

[pranavxc]

Looks like it's related to your database, can you restart your database and then restart the nocodb app/docker.

[candideu]

@pranavxc you're a life-saver! Restarting the database and redeploying the app worked perfectly!

[candideu]

Potentially related: #390 #1150 #5467