Database policy reevaluated frequently, slowing everything down during database maintenance
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
In Progress
|
Low
|
Colin Watson |
Bug Description
lp.services.
But if the requested database is down (e.g. it's a slave-capable request but the slave is offline), each getStore call will try to connect and only then fall back to the other one, often taking a few milliseconds if it fails at the pgbouncer level. If a request context available, a failed connection should probably blacklist the flavour for the remainder of the request.
This could potentially also cause weird behaviour if a DB is flaky, as you'd end up with repeated requests for an object returning two from different stores.
There's possibly also another bug here: LaunchpadDataba
Changed in launchpad: | |
assignee: | nobody → Colin Watson (cjwatson) |
status: | Triaged → In Progress |