You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Select applicable template from below.
If issue is about oracledb support, tag @ atiertant. For MSSql tag @ smorey2.
Rest of dialects don't need tags.
If issue is about TypeScript definitions, tag @ lorefnon.
Bug
Explain what kind of behaviour you are getting and how you think it should do
This is a bit complicated to debug, but as far as I can tell, we're see an issue where we get a server conn crashed from PgBouncer, and subsequently, queries on our containers start failing with: Client has encountered a connection error and is not queryable. My best guess is that the connection is remaining in the pool. I don't know how to debug this further though.
Error message
Initial error:
error: /* query text here */ - server conn crashed?
at Object.queryBuilder (/app/node_modules/knex/lib/knex-builder/make-knex.js:112:26)
at Function.value (/app/node_modules/knex/lib/knex-builder/make-knex.js:92:29)
at Function.withSchema (/app/node_modules/knex/lib/knex-builder/make-knex.js:270:28)
at DbEntityGateway.shardQueryBuilderHelper (/app/packages/api/src/data/DbEntityGateway.ts:1067:26)
at ctx (/app/packages/api/src/data/DbEntityGateway.ts:1363:12)
at /app/packages/api/src/data/implementations/GroupsImpl.ts:1907:21
at /app/node_modules/p-limit/index.js:23:31
at run (/app/node_modules/p-limit/index.js:23:43)
at /app/node_modules/p-limit/index.js:45:2"
Subsequent errors:
Client has encountered a connection error and is not queryable (no real stack)
Reduced test code, for example in https://npm.runkit.com/knex or if it needs real
database connection to MySQL or PostgreSQL, then single file example which initializes
needed data and demonstrates the problem.
The text was updated successfully, but these errors were encountered:
Environment
Knex version:
^3.1.0
Database + version: AWS RDS PostgreSQL 16.2
OS:
20.11-alpine
containerSelect applicable template from below.
If issue is about oracledb support, tag @ atiertant. For MSSql tag @ smorey2.
Rest of dialects don't need tags.
If issue is about TypeScript definitions, tag @ lorefnon.
Bug
This is a bit complicated to debug, but as far as I can tell, we're see an issue where we get a
server conn crashed
from PgBouncer, and subsequently, queries on our containers start failing with:Client has encountered a connection error and is not queryable
. My best guess is that the connection is remaining in the pool. I don't know how to debug this further though.Initial error:
Subsequent errors:
Client has encountered a connection error and is not queryable
(no real stack)database connection to MySQL or PostgreSQL, then single file example which initializes
needed data and demonstrates the problem.
The text was updated successfully, but these errors were encountered: