Connection terminated unexpectedly

[leognmotta]

During development I was not having this issue, connecting to local docker Postgres database, but now I am trying to deploy to digital ocean, and after a while, I get 500 error and that is the message error, it is like if the server is left idle I get this error when trying to run queries, the second request after it works:

select count(*) as "total" from "organization_types" - Connection terminated unexpectedly
    err: {
      "type": "Error",
      "message": "select count(*) as \"total\" from \"organization_types\" - Connection terminated unexpectedly",
      "stack":
          Error: select count(*) as "total" from "organization_types" - Connection terminated unexpectedly
              at Connection.<anonymous> (/Users/leomotta/projects/pagae-server/node_modules/pg/lib/client.js:132:73)
              at Object.onceWrapper (node:events:475:28)
              at Connection.emit (node:events:369:20)
              at Socket.<anonymous> (/Users/leomotta/projects/pagae-server/node_modules/pg/lib/connection.js:57:12)
              at Socket.emit (node:events:381:22)
              at TCP.<anonymous> (node:net:666:12)
      "status": 500
    }

my db connection config:

const databaseConfig: DatabaseConfig = {
  connection: Env.get('DB_CONNECTION'),
  connections: {
    pg: {
      client: 'pg',
      connection: {
        host: Env.get('PG_HOST'),
        port: Env.get('PG_PORT'),
        user: Env.get('PG_USER'),
        password: Env.get('PG_PASSWORD', ''),
        database: Env.get('PG_DB_NAME'),
        ssl: {
          rejectUnauthorized: true,
          ca: fs.readFileSync(path.join(__dirname, '..', 'ca-certificate.crt')),
        },
      },
      migrations: {
        naturalSort: true,
        paths: [
          Application.appRoot + '/database/shared_migrations',
          Application.appRoot + '/database/migrations',
        ],
      },
      healthCheck: false,
      debug: Env.get('NODE_ENV') === 'development',
    },
  },
}

[leognmotta]

I believe lucid has some issue with knex version

started to have this error in production

Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?

[hsharma1996]

This could be server issue also, if you are running on low ram server, The database server might restart causing it to show the same. Consider upgrading your server. I faced same when I was running DB + Adonis on server with 1GB of ram.