Need more visibility into the progress of schema updates across master and slave DBs
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Won't Fix
|
High
|
Stuart Bishop |
Bug Description
Each LP rollout at the moment is something of a lottery in terms of timing. Since figuring out whether any of the upgrade.
Ideally we'd have some easy way of determining the progress of updates against the master and each slave DB, and whether they're being blocked in any way.
It would also be useful for the more general case of knowing what's happening on slave DBs to be able to see what the queue of items they're waiting to process is and whether they're blocked in any way.
Changed in launchpad: | |
importance: | Undecided → High |
affects: | launchpad → launchpad-foundations |
Changed in launchpad-foundations: | |
status: | New → Triaged |
Changed in launchpad-foundations: | |
status: | Triaged → New |
status: | New → Triaged |
Changed in launchpad-foundations: | |
milestone: | none → 10.03 |
summary: |
- Need more visibility into the progress of upgrade.py/fti.py/security.py + Need more visibility into the progress of schema updates across master + and slave DBs |
description: | updated |
Changed in launchpad-foundations: | |
milestone: | 10.03 → none |
We can't get this level of detail out of the Slony tools themselves.
We might be able to get meaningful information out of the slony log files.
We could get the slony tools customized to provide less noise and more meaningful feedback.
Have there been blockages detected that were not caused by connections that should have been disconnected? pg_stat_activity can provide information on open connections, and we could write a report to aggregate all the servers if we need to.
Or is this more about getting 'I'm not blocked, I'm busy doing stuff' information? This information should all be in the slony log files. Currently it is buried in a lot of noise. We should consider switching to the Slony-I 2.x series which has apparently cleaned up the logging a lot.