expire-bugtasks.py, ProgrammingError: permission denied for relation distribution

[Curtis Hovey]

The script oopsed because of a permission problem involving secondary objects that are updated. ie. bug heat calculations affect a broad range of structural objects. The last portion of the error implies we cannot report the oops because the script is not logged in.. All environments use expiration_dbuser: bugnotification.

2011-04-14 04:17:03 INFO Creating lockfile: /var/lock/launchpad-expire-bugtasks.lock
2011-04-14 04:17:14 INFO Expiring unattended, INCOMPLETE bugtasks older than 60 days for projects that use Launchpad
Bugs.
2011-04-14 04:17:24 INFO Found 1812 bugtasks to expire.
2011-04-14 04:17:36 ERROR Unhandled exception
Traceback (most recent call last):
...
  File "/srv/launchpad.net/production/launchpad/cronscripts/expire-bugtasks.py", line 52, in main
    janitor.expireBugTasks(self.txn)
  File "/srv/launchpad.net/production/launchpad-rev-12792/lib/lp/bugs/scripts/bugexpire.py", line 103, in expireBugTasks
    ['status', 'statusexplanation'], user=self.janitor))
...
  File "/srv/launchpad.net/production/launchpad-rev-12792/lib/lp/bugs/model/bug.py", line 1089, in addChange
    self.updateHeat()
  File "/srv/launchpad.net/production/launchpad-rev-12792/lib/lp/bugs/model/bug.py", line 1932, in updateHeat
    store.flush()
...
  File "/srv/launchpad.net/production/launchpad-rev-12792/eggs/storm-0.18.0.99_lpwithnodatetime_r391-py2.6-linux-x86_64.egg/storm/database.py", line 366, in _check_disconnect
    return function(*args, **kwargs)
ProgrammingError: permission denied for relation distribution

Exception raised in formatter:
Traceback (most recent call last):
  File "/srv/launchpad.net/production/launchpad-rev-12792/lib/canonical/launchpad/scripts/logger.py", line 154, in formatException
    url = librarian.remoteAddFile(
AttributeError: 'thread._local' object has no attribute 'interaction'

[Launchpad QA Bot (lpqabot)]

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