queued can not query for derived series
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.
queue_
Module lp.soyuz.
publishing_
Module lp.soyuz.
pocket=
Module lp.soyuz.
distroseries, sourcepackagere
Module lp.soyuz.
children = list(derived_
Module lp.registry.
return [dsp.derived_series for dsp in dsps]
Module storm.store, line 997, in __iter__
result = self._store.
Module storm.databases
return Connection.
Module storm.database, line 237, in execute
raw_cursor = self.raw_
Module storm.databases
return Connection.
Module storm.database, line 321, in raw_execute
self.
Module storm.database, line 366, in _check_disconnect
return function(*args, **kwargs)
ProgrammingError: permission denied for relation distroseriesparent
Related branches
- Robert Collins (community): Approve
-
Diff: 28 lines (+10/-0)2 files modifieddatabase/schema/security.cfg (+1/-0)
lib/lp/soyuz/tests/test_distroseriesdifferencejob.py (+9/-0)
Changed in launchpad: | |
status: | Confirmed → In Progress |
assignee: | nobody → Steve Kowalik (stevenk) |
tags: |
added: qa-ok removed: qa-needstesting |
Changed in launchpad: | |
status: | Fix Committed → Fix Released |
Fixed in stable r13199 <http:// bazaar. launchpad. net/~launchpad- pqm/launchpad/ stable/ revision/ 13199>.