canonical / ubuntu-com-security-api

The API for CVEs and USNs data.
17 stars 9 forks source link

Rollback db actions when connection invalidated #175

Closed samhotep closed 2 months ago

samhotep commented 2 months ago

Done

Added an error handler for sqlalchemy.exc.PendingRollbackError which occurs when a connection object is invalidated

QA

Issue / Card

Fixes intermittent issue where a timed out transaction (normally on the security/notices.json endpoint) invalidates the current connection and requires a rollback before reconnecting.

image