Launchpad itself

authdb Store for scripts connecting to incorrect database

Bug #464161 reported by Stuart Bishop on 2009-10-30

This bug affects 5 people

Affects		Status	Importance	Assigned to	Milestone
	Launchpad itself	Fix Released	Critical	Gary Poster	Launchpad itself 3.1.11

Bug Description

The OpenIDAssociationPruner step in garbo-hourly.py is attempting to update tables in a slave database:

Traceback (most recent call last):
  File "/srv/launchpad.net/production/launchpad-rev-8536/lib/canonical/launchpad/scripts/garbo.py", line 721, in main
    tunable_loop.run()
  File "/srv/launchpad.net/production/launchpad-rev-8536/lib/canonical/launchpad/scripts/garbo.py", line 66, in run
    abort_time = self.abort_time).run()
  File "/srv/launchpad.net/production/launchpad-rev-8536/lib/canonical/launchpad/utilities/looptuner.py", line 107, in run
    self.operation(chunk_size)
  File "/srv/launchpad.net/production/launchpad-rev-8536/lib/canonical/launchpad/scripts/garbo.py", line 155, in __call__
    result = self.store.execute("""
  File "/srv/launchpad.net/production/launchpad-rev-8536/eggs/storm-0.15-py2.4-linux-x86_64.egg/storm/store.py", line 104, in execute
    return self._connection.execute(statement, params, noresult)
  File "/srv/launchpad.net/production/launchpad-rev-8536/eggs/storm-0.15-py2.4-linux-x86_64.egg/storm/databases/postgres.py", line 249, in execute
    return Connection.execute(self, statement, params, noresult)
  File "/srv/launchpad.net/production/launchpad-rev-8536/eggs/storm-0.15-py2.4-linux-x86_64.egg/storm/database.py", line 217, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/srv/launchpad.net/production/launchpad-rev-8536/eggs/storm-0.15-py2.4-linux-x86_64.egg/storm/databases/postgres.py", line 259, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/srv/launchpad.net/production/launchpad-rev-8536/eggs/storm-0.15-py2.4-linux-x86_64.egg/storm/database.py", line 299, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  File "/srv/launchpad.net/production/launchpad-rev-8536/eggs/storm-0.15-py2.4-linux-x86_64.egg/storm/database.py", line 342, in _check_disconnect
    return function(*args, **kwargs)
InternalError: Slony-I: Table openidassociation is replicated and cannot be modified on a subscriber node

Tags: