Launchpad itself

Replication lag checks do not understand PG 9.1 streaming replication

Bug #1014661 reported by Stuart Bishop
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Stuart Bishop

Bug Description

The replication lag checks only support Slony-I replication. They need to support both Slony-I and PostgreSQL 9.1 streaming replication so we can migrate.

Related branches

lp://staging/~stub/launchpad/replication
Abel Deuring (community): Approve (code)
Aaron Bentley (community): Approve
Diff: 196 lines (+106/-19)
7 files modified
daemons/cache-database-replication-lag.py (+53/-0)
database/replication/helpers.py (+1/-0)
database/schema/comments.sql (+4/-0)
database/schema/patch-2207-28-1.sql (+9/-0)
database/schema/security.cfg (+6/-0)
database/schema/trusted.sql (+22/-0)
lib/canonical/launchpad/webapp/dbpolicy.py (+11/-19)
Stuart Bishop (stub)
Changed in launchpad:
importance: Undecided → High
assignee: nobody → Stuart Bishop (stub)
status: New → In Progress
Revision history for this message
Launchpad QA Bot (lpqabot) wrote :

Fixed in stable r15444 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/15444>.

tags: added: qa-needstesting
Changed in launchpad:
status: In Progress → Fix Committed
Revision history for this message
Launchpad QA Bot (lpqabot) wrote :

Fixed in stable r15448 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/15448>.

Revision history for this message
Stuart Bishop (stub) wrote :

qastaging continues to run with this update, so qa-ok. Once this is on staging too, we can update the staging dbs and confirm the load balancing works as desired.

tags: added: qa-ok
removed: qa-needstesting
Revision history for this message
Stuart Bishop (stub) wrote :

Discovered a database started in recovery mode, such as after a hard shutdown, was detected as a lagged replica causing tests to fail. Need to update the check to only report xlog replay time as lag when the database is actually a hot standby.

Stuart Bishop (stub)
tags: added: qa-bad
removed: qa-ok
William Grant (wgrant)
tags: added: bad-commit-15448
William Grant (wgrant)
Changed in launchpad:
status: Fix Committed → In Progress
Revision history for this message
Launchpad QA Bot (lpqabot) wrote :

Fixed in stable r15462 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/15462>.

tags: added: qa-needstesting
removed: qa-bad
Changed in launchpad:
status: In Progress → Fix Committed
William Grant (wgrant)
tags: added: qa-ok
removed: qa-needstesting
William Grant (wgrant)
Changed in launchpad:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

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