buildd-manager needs to survive database outages

Bug #845397 reported by Stuart Bishop
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
William Grant

Bug Description

'fiera' is defined as a fragile user in database/schema/full-update.py, because we need to shut down the buildd-manager manually before a database update.

We need to ensure it handles database disconnections gracefully with tests using the PGBouncer fixture. We can then remove fiera from the fragile user list.

Revision history for this message
Julian Edwards (julian-edwards) wrote :

There are possibly some situations where it does things on the slaves before a commit, so if the DB is pulled at that point the commit will fail and we get out of state. Non-recoverable actions on the slave should always happen after a commit.

Revision history for this message
Julian Edwards (julian-edwards) wrote : Re: [Bug 845397] [NEW] buildd-manager needs to survive database outages

While fixing this it'd be a good idea to split off retry-depwait to a new DB
user since it also uses fiera.

William Grant (wgrant)
Changed in launchpad:
assignee: nobody → William Grant (wgrant)
status: Triaged → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.