person-transfer-job, ProgrammingError: permission denied for relation account

[Diogo Matsubara]

OOPS-1920REPORTIFSEEN160

Looks like the async code to merge people needs a db permission and a new oops prefix.

[Curtis Hovey (sinzui)]

This error was caused by a queue team membership change.

  ProgrammingError: permission denied for relation account

    Traceback (most recent call last):
  Module lp.services.job.runner, line 203, in runJobHandleError
    self.runJob(job)
  Module lp.services.job.runner, line 174, in runJob
    job.run()
  Module lp.registry.model.persontransferjob, line 229, in run
    admin_emails = self.team.getTeamAdminsEmailAddresses()
  Module lp.registry.model.person, line 1427, in getTeamAdminsEmailAddresses
    to_addrs.update(get_contact_email_addresses(person))
  Module canonical.launchpad.helpers, line 216, in get_contact_email_addresses
    for mail_person in get_recipients(person))
  Module canonical.launchpad.helpers, line 215, in <genexpr>
    str(removeSecurityProxy(mail_person.preferredemail).email)
  Module canonical.launchpad.components.decoratedresultset, line 91, in __iter__
    results = list(self.result_set.__iter__(*args, **kwargs))
  Module storm.store, line 996, in __iter__
    result = self._store._connection.execute(self._get_select())
  Module storm.databases.postgres, line 249, in execute
    return Connection.execute(self, statement, params, noresult)
  Module storm.database, line 237, in execute
    raw_cursor = self.raw_execute(statement, params)
  Module storm.databases.postgres, line 259, in raw_execute
    return Connection.raw_execute(self, statement, params)
  Module storm.database, line 321, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  Module storm.database, line 366, in _check_disconnect
    return function(*args, **kwargs)
ProgrammingError: permission denied for relation account

[Launchpad QA Bot (lpqabot)]

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

[Francis J. Lacoste (flacoste)]

Introduced in the refactoring of person merging to a job.