queued can not query for derived series

Bug #795365 reported by Steve Kowalik on 2011-06-10
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Critical
Steve Kowalik

Bug Description

process-accepted which runs as the queued DB user can not query for a distroseries derived series due to a missing database perm. This has been triggered by a delayed copy in the queue with the DSD feature flags on.

Traceback (most recent call last):
  Module lp.soyuz.scripts.processaccepted, line 274, in main
    queue_item.realiseUpload(self.logger)
  Module lp.soyuz.model.queue, line 626, in realiseUpload
    publishing_records.append(queue_source.publish(logger))
  Module lp.soyuz.model.queue, line 1050, in publish
    pocket=self.packageupload.pocket)
  Module lp.soyuz.model.publishing, line 1476, in newSourcePublication
    distroseries, sourcepackagerelease.sourcepackagename, pocket)
  Module lp.soyuz.model.distroseriesdifferencejob, line 170, in createForPackagePublication
    children = list(derived_series.getDerivedSeries())
  Module lp.registry.model.distroseries, line 1992, in getDerivedSeries
    return [dsp.derived_series for dsp in dsps]
  Module storm.store, line 997, 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 distroseriesparent

Related branches

Changed in launchpad:
status: Confirmed → In Progress
assignee: nobody → Steve Kowalik (stevenk)
Launchpad QA Bot (lpqabot) wrote :
tags: added: qa-needstesting
Changed in launchpad:
status: In Progress → Fix Committed
William Grant (wgrant) on 2011-06-13
tags: added: qa-ok
removed: qa-needstesting
William Grant (wgrant) on 2011-06-14
Changed in launchpad:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers