Critical: DB Connection Pool Limit Exceeded Causing Authentication Failures

[cbrain-dev-new]

Description

A critical error has been detected where the DB connection pool limit is being exceeded in context.ts, causing Postgres queries to hang and leading to database session token validation failures within the tRPC auth context.

Impact

• Validation of database session tokens is failing.
• Postgres queries are hanging, potentially affecting transaction integrity and app performance.

Steps to Reproduce

1. Trigger multiple auth sessions.
2. Observe connection failures and query hangs logged in Sentry.

Severity

• Critical

Suggested Solutions

• Investigate connection pool settings and increase limits.
• Optimize usage of connection pooling in context.ts.
• Consider implementing a retry mechanism for failed queries.

References

• Sentry Error

Please prioritize this issue given its critical nature.