Sentry Errors Related to Database Connectivity Issues
Issues we might be able to reduce via keep alive changes:
| Issue | First Seen | Events | Sentry Link |
|---|---|---|---|
| Rollback failed | 2022-11-29 | 100,904 | View |
| Connection already closed | 2024-05-29 | 9,845 | View |
| ConnectionLost (SSL EOF) | 2026-03-04 | 4,807 | View |
| Total | 115,556 |
database:
name: psycopg2
args:
user: synapse
application_name: <%= application_name %>
password: <%= database.dig("users", "synapse") %>
database: synapse
host: database-primary
port: 5432
cp_min: <%= connection_pool_size %>
cp_max: <%= connection_pool_size %>
+ keepalives: 1
+ keepalives_idle: 60
+ keepalives_interval: 10
+ keepalives_count: 3