NeonN
Neon•2y ago•
5 replies
popular-magenta

Never-ending CONNECTION_CLOSED errors.

So, my node projects makes about one database query call every 10 minutes, and every now and then, I get errors like these:

So, the connection to my database is closing, how do I solve that from happening? Or is it possible to programmatically check if my connection is closed, and if so, re-open it, and run the query again?

The error in text-form:
Error during getGlobalLeaderboards: Error: write CONNECTION_CLOSED ep-wandering-snowflake-a2isl6k2-pooler.eu-central-1.aws.neon.tech:5432
    at TLSSocket.closed (/home/container/node_modules/postgres/cjs/src/connection.js:438:57)
    at TLSSocket.emit (node:events:529:35)
    at node:net:350:12
    at Socket.done (node:_tls_wrap:657:7)
    at Object.onceWrapper (node:events:632:26)
    at Socket.emit (node:events:517:28)
    at TCP.<anonymous> (node:net:350:12)
    at cachedError (/home/container/node_modules/postgres/cjs/src/query.js:170:23)
    at new Query (/home/container/node_modules/postgres/cjs/src/query.js:36:24)
    at sql (/home/container/node_modules/postgres/cjs/src/index.js:112:11)
    at getGlobalLeaderboards (/home/container/Discord Bots/resources/databases/Bomber Bot XP - DB.js:119:41) {
  code: 'CONNECTION_CLOSED',
  errno: 'CONNECTION_CLOSED',
  address: [
    'ep-wandering-snowflake-a2isl6k2-pooler.eu-central-1.aws.neon.tech'
  ],
  port: [ 5432 ]
}
image.png
Was this page helpful?