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

Bug #760950 reported by Curtis Hovey
16
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
Critical
j.c.sackett

Bug Description

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'

Tags: bugs qa-ok

Related branches

Curtis Hovey (sinzui)
Changed in launchpad:
assignee: nobody → j.c.sackett (jcsackett)
status: Triaged → In Progress
milestone: none → 11.05
Revision history for this message
Launchpad QA Bot (lpqabot) wrote :
tags: added: qa-needstesting
Changed in launchpad:
status: In Progress → Fix Committed
j.c.sackett (jcsackett)
tags: added: qa-ok
removed: qa-needstesting
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.

Duplicates of this bug

Other bug subscribers

Remote bug watches

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