queued can not query for derived series

Bug #795365 reported by Steve Kowalik
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
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)
Revision history for this message
Launchpad QA Bot (lpqabot) wrote :
tags: added: qa-needstesting
Changed in launchpad:
status: In Progress → Fix Committed
William Grant (wgrant)
tags: added: qa-ok
removed: qa-needstesting
William Grant (wgrant)
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.

Other bug subscribers

Remote bug watches

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