Close DB sessions in functions that use FastAPI dependency injection - Githubissues

vipyrsec / dragonfly-mainframe

The mainframe for Dragonfly

https://docs.vipyrsec.com/dragonfly-mainframe/

MIT License

4 stars 2 forks source link

Close DB sessions in functions that use FastAPI dependency injection #246

Closed jonathan-d-zhang closed 2 months ago

jonathan-d-zhang commented 2 months ago

Also turn off autobegin to make db transactions more explicit.

Closes #235.

sentry-io[bot] commented 2 months ago

Suspect Issues

This pull request was deployed and Sentry observed the following issues:

‼️ OperationalError: (psycopg2.OperationalError) connection to server at "db-postgresql-nyc1-49998-do-user-11810938-0.... /jobs View Issue
‼️ TimeoutError: QueuePool limit of size 5 overflow 10 reached, connection timed out, timeout 30.00 (Background on... /package View Issue
‼️ OperationalError: (psycopg2.errors.TooManyConnections) remaining connection slots are reserved for non-replication ... /package View Issue

_{Did you find this useful? React with a 👍 or 👎}