permission denied for relation teammembership
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Invalid
|
Undecided
|
Unassigned |
Bug Description
A gcc-3.3 upload to intrepid and a gcc-3.4 upload to hardy-proposed failed. Logs follow.
2008-05-02 10:05:03 INFO creating lockfile
2008-05-02 10:05:07 DEBUG Initialising connection.
2008-05-02 10:05:07 DEBUG Beginning processing
2008-05-02 10:05:07 DEBUG Checked in /srv/launchpad.
2008-05-02 10:05:07 DEBUG Considering upload upload-
2008-05-02 10:05:07 DEBUG Moving upload directory /srv/launchpad.
2008-05-02 10:05:07 DEBUG Moving distro file /srv/launchpad.
2008-05-02 10:05:07 DEBUG Considering upload upload-
2008-05-02 10:05:07 DEBUG Considering changefile gcc-3.3_
2008-05-02 10:05:07 DEBUG Finding fresh policy
2008-05-02 10:05:07 DEBUG Verifying signature on gcc-3.3_
2008-05-02 10:05:07 INFO Processing upload gcc-3.3_
2008-05-02 10:05:07 DEBUG Beginning processing.
2008-05-02 10:05:07 DEBUG Performing DSC verification.
2008-05-02 10:05:07 DEBUG Verifying signature on gcc-3.3_
2008-05-02 10:05:07 DEBUG Verifying the changes file.
2008-05-02 10:05:07 DEBUG Verifying files in upload.
2008-05-02 10:05:07 DEBUG Verifying source file gcc-3.3_
2008-05-02 10:05:07 DEBUG gcc-3.3_
2008-05-02 10:05:07 DEBUG Pumping gcc-3.3_
2008-05-02 10:05:09 DEBUG Verifying uploaded source package by unpacking it.
2008-05-02 10:05:10 DEBUG Copying copyright contents.
2008-05-02 10:05:10 DEBUG Cleaning up source tree.
2008-05-02 10:05:10 DEBUG Done
2008-05-02 10:05:10 DEBUG Verifying source file gcc-3.3_
2008-05-02 10:05:10 DEBUG Finding and applying overrides.
2008-05-02 10:05:10 DEBUG Checking for gcc-3.3/
2008-05-02 10:05:10 DEBUG gcc-3.3 - 1:3.3.6-15ubuntu4 (source) exists in RELEASE
2008-05-02 10:05:10 DEBUG Matthias Klose (2667) is an uploader for main, multiverse, restricted, universe.
2008-05-02 10:05:10 DEBUG Finished checking upload.
2008-05-02 10:05:10 DEBUG Creating queue entry
2008-05-02 10:05:11 DEBUG Setting it to ACCEPTED
2008-05-02 10:05:11 DEBUG Creating PENDING publishing record.
2008-05-02 10:05:13 DEBUG Creating PENDING build for amd64.
2008-05-02 10:05:13 DEBUG Creating PENDING build for i386.
2008-05-02 10:05:13 DEBUG Creating PENDING build for lpia.
2008-05-02 10:05:13 DEBUG Closing bugs.
2008-05-02 10:05:13 ERROR Exception while accepting:
ERROR: permission denied for relation teammembership
SELECT SETOP_TMP.* FROM ((SELECT Person.id, Person.
playname, Person.
_bugnotifications, Person.country, Person.
riod, Person.
77 AND TeamMembership.
creation_rationale, Person.
id_identifier, Person.
son.phone, Person.mugshot, Person.
son, TeamMembership WHERE TeamMembership.team = 925877 AND TeamMembership.
-> http://
SELECT SETOP_TMP.* FROM ((SELECT Person.id, Person.
playname, Person.
_bugnotifications, Person.country, Person.
77 AND TeamMembership.
creation_rationale, Person.
id_identifier, Person.
son.phone, Person.mugshot, Person.
son, TeamMembership WHERE TeamMembership.team = 925877 AND TeamMembership.
2008-05-02 10:05:13 ERROR Unhandled exception from processing an upload
-> http://
SELECT PackageUploadBu
2008-05-02 10:05:13 DEBUG Moving upload directory /srv/launchpad.
2008-05-02 10:05:13 DEBUG Moving distro file /srv/launchpad.
2008-05-02 10:05:13 DEBUG Rolling back any remaining transactions.
2008-05-02 10:05:13 DEBUG Removing lock file: /var/lock/
2008-05-02 10:50:03 INFO creating lockfile
2008-05-02 10:50:08 DEBUG Initialising connection.
2008-05-02 10:50:08 DEBUG Beginning processing
2008-05-02 10:50:08 DEBUG Checked in /srv/launchpad.
2008-05-02 10:50:08 DEBUG Considering upload upload-
2008-05-02 10:50:08 DEBUG Considering changefile gcc-3.4_
2008-05-02 10:50:08 DEBUG Finding fresh policy
2008-05-02 10:50:08 DEBUG Verifying signature on gcc-3.4_
2008-05-02 10:50:08 INFO Processing upload gcc-3.4_
2008-05-02 10:50:08 DEBUG Beginning processing.
2008-05-02 10:50:08 DEBUG Performing DSC verification.
2008-05-02 10:50:08 DEBUG Verifying signature on gcc-3.4_
2008-05-02 10:50:08 DEBUG Verifying the changes file.
2008-05-02 10:50:08 DEBUG Verifying files in upload.
2008-05-02 10:50:08 DEBUG Verifying source file gcc-3.4_
2008-05-02 10:50:08 DEBUG gcc-3.4_
2008-05-02 10:50:08 DEBUG Pumping gcc-3.4_
2008-05-02 10:50:10 DEBUG Verifying uploaded source package by unpacking it.
2008-05-02 10:50:11 DEBUG Copying copyright contents.
2008-05-02 10:50:11 DEBUG Cleaning up source tree.
2008-05-02 10:50:11 DEBUG Done
2008-05-02 10:50:11 DEBUG Verifying source file gcc-3.4_
2008-05-02 10:50:11 DEBUG Finding and applying overrides.
2008-05-02 10:50:11 DEBUG Checking for gcc-3.4/
2008-05-02 10:50:12 DEBUG gcc-3.4 - 3.4.6-6ubuntu3 (source) exists in RELEASE
2008-05-02 10:50:12 DEBUG Matthias Klose (2667) is an uploader for main, multiverse, restricted, universe.
2008-05-02 10:50:12 DEBUG Finished checking upload.
2008-05-02 10:50:12 DEBUG Creating queue entry
2008-05-02 10:50:12 DEBUG Setting it to UNAPPROVED
2008-05-02 10:50:12 DEBUG Building recipients list.
2008-05-02 10:50:12 DEBUG Adding recipient: 'Matthias Klose <email address hidden>'
2008-05-02 10:50:14 DEBUG Sent a mail:
2008-05-02 10:50:14 DEBUG Subject: Waiting for approval: gcc-3.4 3.4.6-6ubuntu4 (source)
2008-05-02 10:50:14 DEBUG Recipients: Matthias Klose <email address hidden>
2008-05-02 10:50:14 DEBUG Body:
2008-05-02 10:50:14 DEBUG Waiting for approval:
2008-05-02 10:50:14 DEBUG OK: gcc-3.4_
2008-05-02 10:50:14 DEBUG OK: gcc-3.4_
2008-05-02 10:50:14 DEBUG OK: gcc-3.4_
2008-05-02 10:50:14 DEBUG -> Component: universe Section: devel
2008-05-02 10:50:14 DEBUG This upload awaits approval by a distro manager
2008-05-02 10:50:14 DEBUG
2008-05-02 10:50:14 DEBUG
2008-05-02 10:50:14 DEBUG -----BEGIN PGP SIGNED MESSAGE-----
2008-05-02 10:50:14 DEBUG Hash: SHA1
2008-05-02 10:50:14 DEBUG
2008-05-02 10:50:14 DEBUG Format: 1.7
2008-05-02 10:50:14 DEBUG Date: Fri, 02 May 2008 11:17:42 +0200
2008-05-02 10:50:14 DEBUG Source: gcc-3.4
2008-05-02 10:50:14 DEBUG Binary: gcc-3.4-base gcc-3.4 gcc-3.4-hppa64 cpp-3.4 cpp-3.4-doc g++-3.4 g77-3.4 g77-3.4-doc libg2c0 libg2c0-dev lib64g2c0 lib32g2c0 libstdc++6-dev libstdc++6-pic libstdc++6-dbg libst
dc++6-doc gpc-2.1-3.4 gpc-2.1-3.4-doc gcc-3.4-soft-float gcc-3.4-doc
2008-05-02 10:50:14 DEBUG Architecture: source
2008-05-02 10:50:14 DEBUG Version: 3.4.6-6ubuntu4
2008-05-02 10:50:14 DEBUG Distribution: hardy-proposed
2008-05-02 10:50:14 DEBUG Urgency: low
2008-05-02 10:50:14 DEBUG Maintainer: Debian GCC Maintainers <email address hidden>
2008-05-02 10:50:14 DEBUG Changed-By: Matthias Klose <email address hidden>
2008-05-02 10:50:14 DEBUG Description:
2008-05-02 10:50:14 DEBUG cpp-3.4 - The GNU C preprocessor
2008-05-02 10:50:14 DEBUG cpp-3.4-doc - Documentation for the GNU C preprocessor (cpp)
2008-05-02 10:50:14 DEBUG g++-3.4 - The GNU C++ compiler
2008-05-02 10:50:14 DEBUG g77-3.4 - The GNU Fortran 77 compiler
2008-05-02 10:50:14 DEBUG g77-3.4-doc - Documentation for the GNU Fortran compiler (g77)
2008-05-02 10:50:14 DEBUG gcc-3.4 - The GNU C compiler
2008-05-02 10:50:14 DEBUG gcc-3.4-base - The GNU Compiler Collection (base package)
2008-05-02 10:50:14 DEBUG gcc-3.4-doc - Documentation for the GNU compilers (gcc, gobjc, g++)
2008-05-02 10:50:14 DEBUG gcc-3.4-hppa64 - The GNU C compiler (cross compiler for hppa64)
2008-05-02 10:50:14 DEBUG gcc-3.4-soft-float - The soft-floating-point gcc libraries (arm)
2008-05-02 10:50:14 DEBUG gpc-2.1-3.4 - The GNU Pascal compiler
2008-05-02 10:50:14 DEBUG gpc-2.1-3.4-doc - Documentation for the GNU Pascal compiler (gpc)
2008-05-02 10:50:14 DEBUG lib32g2c0 - Runtime library for GNU Fortran 77 applications (32bit)
2008-05-02 10:50:14 DEBUG lib64g2c0 - Runtime library for GNU Fortran 77 applications (64bit)
2008-05-02 10:50:14 DEBUG libg2c0 - Runtime library for GNU Fortran 77 applications
2008-05-02 10:50:14 DEBUG libg2c0-dev - GNU Fortran 77 library development
2008-05-02 10:50:14 DEBUG libstdc++6-dbg - The GNU Standard C++ Library v3 (debugging files)
2008-05-02 10:50:14 DEBUG libstdc++6-dev - The GNU Standard C++ Library v3 (development files)
2008-05-02 10:50:14 DEBUG libstdc++6-doc - The GNU Standard C++ Library v3 (documentation files)
2008-05-02 10:50:14 DEBUG libstdc++6-pic - The GNU Standard C++ Library v3 (shared library subset kit)
2008-05-02 10:50:14 DEBUG Launchpad-
2008-05-02 10:50:14 DEBUG Changes:
2008-05-02 10:50:14 DEBUG gcc-3.4 (3.4.6-6ubuntu4) hardy-proposed; urgency=low
2008-05-02 10:50:14 DEBUG .
2008-05-02 10:50:14 DEBUG * Correct makeinfo version check. LP: #205348.
2008-05-02 10:50:14 DEBUG Files:
2008-05-02 10:50:14 DEBUG c1adbf240b3eadb
2008-05-02 10:50:14 DEBUG 20f67c136892521
2008-05-02 10:50:14 DEBUG
2008-05-02 10:50:14 DEBUG -----BEGIN PGP SIGNATURE-----
2008-05-02 10:50:14 DEBUG Version: GnuPG v1.4.6 (GNU/Linux)
2008-05-02 10:50:14 DEBUG
2008-05-02 10:50:14 DEBUG iD8DBQFIGueRStl
2008-05-02 10:50:14 DEBUG ttbzhNUN4bGHwpz
2008-05-02 10:50:14 DEBUG =L6AC
2008-05-02 10:50:14 DEBUG -----END PGP SIGNATURE-----
2008-05-02 10:50:14 DEBUG
2008-05-02 10:50:14 DEBUG
2008-05-02 10:50:14 DEBUG ==
2008-05-02 10:50:14 DEBUG
2008-05-02 10:50:14 DEBUG Announcing to <email address hidden>
2008-05-02 10:50:14 DEBUG
2008-05-02 10:50:14 DEBUG Thank you for your contribution to Ubuntu.
2008-05-02 10:50:14 DEBUG
2008-05-02 10:50:14 DEBUG --
2008-05-02 10:50:14 DEBUG You are receiving this email because you are the uploader, maintainer or
2008-05-02 10:50:14 DEBUG signer of the above package.
2008-05-02 10:50:14 INFO Committing the transaction and any mails associated with this upload.
2008-05-02 10:50:14 DEBUG Considering changefile gcc-3.4_
2008-05-02 10:50:14 DEBUG Finding fresh policy
2008-05-02 10:50:14 DEBUG Verifying signature on gcc-3.4_
2008-05-02 10:50:15 INFO Processing upload gcc-3.4_
2008-05-02 10:50:15 DEBUG Beginning processing.
2008-05-02 10:50:15 DEBUG Performing DSC verification.
2008-05-02 10:50:15 DEBUG Verifying signature on gcc-3.4_
2008-05-02 10:50:15 DEBUG Verifying the changes file.
2008-05-02 10:50:15 DEBUG Verifying files in upload.
2008-05-02 10:50:15 DEBUG Verifying source file gcc-3.4_
2008-05-02 10:50:15 DEBUG gcc-3.4_
2008-05-02 10:50:15 DEBUG Verifying uploaded source package by unpacking it.
2008-05-02 10:50:16 DEBUG Copying copyright contents.
2008-05-02 10:50:16 DEBUG Cleaning up source tree.
2008-05-02 10:50:16 DEBUG Done
2008-05-02 10:50:16 DEBUG Verifying source file gcc-3.4_
2008-05-02 10:50:16 DEBUG Finding and applying overrides.
2008-05-02 10:50:16 DEBUG Checking for gcc-3.4/
2008-05-02 10:50:16 DEBUG gcc-3.4 - 3.4.6-6ubuntu3 (source) exists in RELEASE
2008-05-02 10:50:16 DEBUG Matthias Klose (2667) is an uploader for main, multiverse, restricted, universe.
2008-05-02 10:50:16 DEBUG Finished checking upload.
2008-05-02 10:50:16 DEBUG Creating queue entry
2008-05-02 10:50:17 DEBUG Setting it to ACCEPTED
2008-05-02 10:50:17 DEBUG Creating PENDING publishing record.
2008-05-02 10:50:19 DEBUG Creating PENDING build for amd64.
2008-05-02 10:50:19 DEBUG Creating PENDING build for hppa.
2008-05-02 10:50:19 DEBUG Creating PENDING build for i386.
2008-05-02 10:50:19 DEBUG Creating PENDING build for ia64.
2008-05-02 10:50:19 DEBUG Creating PENDING build for lpia.
2008-05-02 10:50:19 DEBUG Creating PENDING build for powerpc.
2008-05-02 10:50:19 DEBUG Creating PENDING build for sparc.
2008-05-02 10:50:19 DEBUG Closing bugs.
2008-05-02 10:50:20 ERROR Exception while accepting:
ERROR: permission denied for relation teammembership
SELECT SETOP_TMP.* FROM ((SELECT Person.id, Person.
playname, Person.
_bugnotifications, Person.country, Person.
riod, Person.
77 AND TeamMembership.
creation_rationale, Person.
id_identifier, Person.
son.phone, Person.mugshot, Person.
son, TeamMembership WHERE TeamMembership.team = 925877 AND TeamMembership.
-> http://
SELECT SETOP_TMP.* FROM ((SELECT Person.id, Person.
playname, Person.
_bugnotifications, Person.country, Person.
riod, Person.
77 AND TeamMembership.
creation_rationale, Person.
id_identifier, Person.
son, TeamMembership WHERE TeamMembership.team = 925877 AND TeamMembership.
2008-05-02 10:50:22 ERROR Unhandled exception from processing an upload
-> http://
SELECT PackageUploadBu
2008-05-02 10:50:23 DEBUG Moving upload directory /srv/launchpad.
2008-05-02 10:50:23 DEBUG Moving distro file /srv/launchpad.
2008-05-02 10:50:23 DEBUG Rolling back any remaining transactions.
2008-05-02 10:50:23 DEBUG Removing lock file: /var/lock/
Changed in soyuz: | |
status: | New → Invalid |
Changed in malone: | |
assignee: | nobody → intellectronica |
importance: | Undecided → Critical |
milestone: | none → 1.2.4 |
status: | New → Triaged |
Changed in malone: | |
status: | Triaged → In Progress |
Changed in malone: | |
status: | Fix Committed → Fix Released |
The cause for this bug is that the database user under which the uploader runs does not have the permission to read from the TeamMembership table.
We are fixing this in the DB now, and I'll be landing a permanent fix (with a bunch of tests to prove that the relevant bug functions work correctly for all relevant db users).