Releases: Clinical-Genomics/genotype-api
Release v3.0.18
Release v3.0.17
Patch(database) Rollback un-commited transactions after requests (#147)
Description
Users have reported sporadic problems when using the application. The logs give the following error:
sqlalchemy.exc.PendingRollbackError: Can't reconnect until invalid transaction is rolled back. Please rollback() fully before proceeding (Background on this error at: https://sqlalche.me/e/20/8s2b)
Having read up a bit in the docs i found that using .close()
on a scoped session does not rollback any transactions it has opened. For our purposes .remove()
is what we need since it starts with closing the session but also rolls back any transactions it has open.
Changed
- use SESSION.remove() instead of SESSION.close() after each request
Release v3.0.16
add package (#146) (patch)
add cryptography
Release v3.0.15
Release v3.0.14
Release v3.0.13
Release v3.0.12
Release v3.0.11
close session after dropping/creating tables (#141) (patch)
Description
Fix broken pipe error due to unclosed connection over time
Release v3.0.10
Release v3.0.9
Ensure session is closed (#139)(patch)
Add middleware to ensure the db session is closed before sending the response, so that the connection is released.