permission denied for relation teammembership

Bug #225642 reported by Colin Watson
2
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.net/ubuntu-queue/incoming, found ['upload-20080502-110359-004298', 'upload-20080502-110440-004299']
2008-05-02 10:05:07 DEBUG Considering upload upload-20080502-110359-004298
2008-05-02 10:05:07 DEBUG Moving upload directory /srv/launchpad.net/ubuntu-queue/incoming/upload-20080502-110359-004298 to /srv/launchpad.net/ubuntu-queue/failed/upload-20080502-110359-004298
2008-05-02 10:05:07 DEBUG Moving distro file /srv/launchpad.net/ubuntu-queue/incoming/upload-20080502-110359-004298.distro to /srv/launchpad.net/ubuntu-queue/failed/upload-20080502-110359-004298.distro
2008-05-02 10:05:07 DEBUG Considering upload upload-20080502-110440-004299
2008-05-02 10:05:07 DEBUG Considering changefile gcc-3.3_3.3.6-17ubuntu1_source.changes
2008-05-02 10:05:07 DEBUG Finding fresh policy
2008-05-02 10:05:07 DEBUG Verifying signature on gcc-3.3_3.3.6-17ubuntu1_source.changes
2008-05-02 10:05:07 INFO Processing upload gcc-3.3_3.3.6-17ubuntu1_source.changes
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_3.3.6-17ubuntu1.dsc
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_3.3.6-17ubuntu1.dsc
2008-05-02 10:05:07 DEBUG gcc-3.3_3.3.6.orig.tar.gz found in Primary Archive for Ubuntu
2008-05-02 10:05:07 DEBUG Pumping gcc-3.3_3.3.6.orig.tar.gz out of the librarian
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_3.3.6-17ubuntu1.diff.gz
2008-05-02 10:05:10 DEBUG Finding and applying overrides.
2008-05-02 10:05:10 DEBUG Checking for gcc-3.3/1:3.3.6-17ubuntu1 source ancestry
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.defaultrenewalperiod, Person.postcode, Person.subscriptionpolicy, Person.teamowner, Person.merged, Person.creation_rationale, Person.renewal_policy, Person.dis
playname, Person.hide_email_addresses, Person.creation_comment, Person.password, Person.name, Person.datecreated, Person.logo, Person.registrant, Person.openid_identifier, Person.teamdescription, Person.verbose
_bugnotifications, Person.country, Person.addressline2, Person.addressline1, Person.city, Person.account_status_comment, Person.personal_standing_reason, Person.phone, Person.mugshot, Person.defaultmembershippe
riod, Person.account_status, Person.province, Person.personal_standing, Person.visibility, Person.icon, Person.organization, Person.homepage_content FROM Person, TeamMembership WHERE TeamMembership.team = 9258
77 AND TeamMembership.status = 2 AND TeamMembership.person = Person.id) UNION (SELECT Person.id, Person.defaultrenewalperiod, Person.postcode, Person.subscriptionpolicy, Person.teamowner, Person.merged, Person.
creation_rationale, Person.renewal_policy, Person.displayname, Person.hide_email_addresses, Person.creation_comment, Person.password, Person.name, Person.datecreated, Person.logo, Person.registrant, Person.open
id_identifier, Person.teamdescription, Person.verbose_bugnotifications, Person.country, Person.addressline2, Person.addressline1, Person.city, Person.account_status_comment, Person.personal_standing_reason, Per
son.phone, Person.mugshot, Person.defaultmembershipperiod, Person.account_status, Person.province, Person.personal_standing, Person.visibility, Person.icon, Person.organization, Person.homepage_content FROM Per
son, TeamMembership WHERE TeamMembership.team = 925877 AND TeamMembership.status = 3 AND TeamMembership.person = Person.id)) AS SETOP_TMP ORDER BY person_sort_key(displayname, name)
 -> http://launchpadlibrarian.net/14084480/8R19gYWoQG7pcGxUAC9BiJxSGoY.txt (ERROR: permission denied for relation teammembership

SELECT SETOP_TMP.* FROM ((SELECT Person.id, Person.defaultrenewalperiod, Person.postcode, Person.subscriptionpolicy, Person.teamowner, Person.merged, Person.creation_rationale, Person.renewal_policy, Person.dis
playname, Person.hide_email_addresses, Person.creation_comment, Person.password, Person.name, Person.datecreated, Person.logo, Person.registrant, Person.openid_identifier, Person.teamdescription, Person.verbose
_bugnotifications, Person.country, Person.addressline2, Person.addressline1, Person.city, Person.account_status_comment, Person.personal_standing_reason, Person.phone, Person.mugshot, Person.defaultmembershipperiod, Person.account_status, Person.province, Person.personal_standing, Person.visibility, Person.icon, Person.organization, Person.homepage_content FROM Person, TeamMembership WHERE TeamMembership.team = 9258
77 AND TeamMembership.status = 2 AND TeamMembership.person = Person.id) UNION (SELECT Person.id, Person.defaultrenewalperiod, Person.postcode, Person.subscriptionpolicy, Person.teamowner, Person.merged, Person.
creation_rationale, Person.renewal_policy, Person.displayname, Person.hide_email_addresses, Person.creation_comment, Person.password, Person.name, Person.datecreated, Person.logo, Person.registrant, Person.open
id_identifier, Person.teamdescription, Person.verbose_bugnotifications, Person.country, Person.addressline2, Person.addressline1, Person.city, Person.account_status_comment, Person.personal_standing_reason, Per
son.phone, Person.mugshot, Person.defaultmembershipperiod, Person.account_status, Person.province, Person.personal_standing, Person.visibility, Person.icon, Person.organization, Person.homepage_content FROM Per
son, TeamMembership WHERE TeamMembership.team = 925877 AND TeamMembership.status = 3 AND TeamMembership.person = Person.id)) AS SETOP_TMP ORDER BY person_sort_key(displayname, name))
2008-05-02 10:05:13 ERROR Unhandled exception from processing an upload
 -> http://launchpadlibrarian.net/14084481/coMw8CA2acFRW65kSuo5UDRgOJG.txt (ERROR: current transaction is aborted, commands ignored until end of transaction block

SELECT PackageUploadBuild.id, PackageUploadBuild.packageupload, PackageUploadBuild.build FROM PackageUploadBuild WHERE (PackageUploadBuild.packageupload = 500657) LIMIT 1)
2008-05-02 10:05:13 DEBUG Moving upload directory /srv/launchpad.net/ubuntu-queue/incoming/upload-20080502-110440-004299 to /srv/launchpad.net/ubuntu-queue/failed/upload-20080502-110440-004299
2008-05-02 10:05:13 DEBUG Moving distro file /srv/launchpad.net/ubuntu-queue/incoming/upload-20080502-110440-004299.distro to /srv/launchpad.net/ubuntu-queue/failed/upload-20080502-110440-004299.distro
2008-05-02 10:05:13 DEBUG Rolling back any remaining transactions.
2008-05-02 10:05:13 DEBUG Removing lock file: /var/lock/process-upload-insecure.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.net/ubuntu-queue/incoming, found ['upload-20080502-114521-004302']
2008-05-02 10:50:08 DEBUG Considering upload upload-20080502-114521-004302
2008-05-02 10:50:08 DEBUG Considering changefile gcc-3.4_3.4.6-6ubuntu4_source.changes
2008-05-02 10:50:08 DEBUG Finding fresh policy
2008-05-02 10:50:08 DEBUG Verifying signature on gcc-3.4_3.4.6-6ubuntu4_source.changes
2008-05-02 10:50:08 INFO Processing upload gcc-3.4_3.4.6-6ubuntu4_source.changes
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_3.4.6-6ubuntu4.dsc
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_3.4.6-6ubuntu4.dsc
2008-05-02 10:50:08 DEBUG gcc-3.4_3.4.6.orig.tar.gz found in Primary Archive for Ubuntu
2008-05-02 10:50:08 DEBUG Pumping gcc-3.4_3.4.6.orig.tar.gz out of the librarian
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_3.4.6-6ubuntu4.diff.gz
2008-05-02 10:50:11 DEBUG Finding and applying overrides.
2008-05-02 10:50:11 DEBUG Checking for gcc-3.4/3.4.6-6ubuntu4 source ancestry
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_3.4.6.orig.tar.gz
2008-05-02 10:50:14 DEBUG OK: gcc-3.4_3.4.6-6ubuntu4.diff.gz
2008-05-02 10:50:14 DEBUG OK: gcc-3.4_3.4.6-6ubuntu4.dsc
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-Bugs-Fixed: 205348
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 c1adbf240b3eadbf592f430bbe061f97 2113 devel optional gcc-3.4_3.4.6-6ubuntu4.dsc
2008-05-02 10:50:14 DEBUG 20f67c13689252107e1c862439d21e29 396984 devel optional gcc-3.4_3.4.6-6ubuntu4.diff.gz
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 iD8DBQFIGueRStlRaw+TLJwRAuQSAJ9Xb8jAEHZL5xJQBy+6hjwN5eUwKACfXZX3
2008-05-02 10:50:14 DEBUG ttbzhNUN4bGHwpzwHIeIqLM=
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_3.4.6-7ubuntu1_source.changes
2008-05-02 10:50:14 DEBUG Finding fresh policy
2008-05-02 10:50:14 DEBUG Verifying signature on gcc-3.4_3.4.6-7ubuntu1_source.changes
2008-05-02 10:50:15 INFO Processing upload gcc-3.4_3.4.6-7ubuntu1_source.changes
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_3.4.6-7ubuntu1.dsc
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_3.4.6-7ubuntu1.dsc
2008-05-02 10:50:15 DEBUG gcc-3.4_3.4.6.orig.tar.gz found in Primary Archive for Ubuntu
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_3.4.6-7ubuntu1.diff.gz
2008-05-02 10:50:16 DEBUG Finding and applying overrides.
2008-05-02 10:50:16 DEBUG Checking for gcc-3.4/3.4.6-7ubuntu1 source ancestry
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.defaultrenewalperiod, Person.postcode, Person.subscriptionpolicy, Person.teamowner, Person.merged, Person.creation_rationale, Person.renewal_policy, Person.dis
playname, Person.hide_email_addresses, Person.creation_comment, Person.password, Person.name, Person.datecreated, Person.logo, Person.registrant, Person.openid_identifier, Person.teamdescription, Person.verbose
_bugnotifications, Person.country, Person.addressline2, Person.addressline1, Person.city, Person.account_status_comment, Person.personal_standing_reason, Person.phone, Person.mugshot, Person.defaultmembershippe
riod, Person.account_status, Person.province, Person.personal_standing, Person.visibility, Person.icon, Person.organization, Person.homepage_content FROM Person, TeamMembership WHERE TeamMembership.team = 9258
77 AND TeamMembership.status = 2 AND TeamMembership.person = Person.id) UNION (SELECT Person.id, Person.defaultrenewalperiod, Person.postcode, Person.subscriptionpolicy, Person.teamowner, Person.merged, Person.
creation_rationale, Person.renewal_policy, Person.displayname, Person.hide_email_addresses, Person.creation_comment, Person.password, Person.name, Person.datecreated, Person.logo, Person.registrant, Person.open
id_identifier, Person.teamdescription, Person.verbose_bugnotifications, Person.country, Person.addressline2, Person.addressline1, Person.city, Person.account_status_comment, Person.personal_standing_reason, Per
son.phone, Person.mugshot, Person.defaultmembershipperiod, Person.account_status, Person.province, Person.personal_standing, Person.visibility, Person.icon, Person.organization, Person.homepage_content FROM Per
son, TeamMembership WHERE TeamMembership.team = 925877 AND TeamMembership.status = 3 AND TeamMembership.person = Person.id)) AS SETOP_TMP ORDER BY person_sort_key(displayname, name)
 -> http://launchpadlibrarian.net/14085024/8R19gYWoQG7pcGxUAC9BiJxSGoY.txt (ERROR: permission denied for relation teammembership

SELECT SETOP_TMP.* FROM ((SELECT Person.id, Person.defaultrenewalperiod, Person.postcode, Person.subscriptionpolicy, Person.teamowner, Person.merged, Person.creation_rationale, Person.renewal_policy, Person.dis
playname, Person.hide_email_addresses, Person.creation_comment, Person.password, Person.name, Person.datecreated, Person.logo, Person.registrant, Person.openid_identifier, Person.teamdescription, Person.verbose
_bugnotifications, Person.country, Person.addressline2, Person.addressline1, Person.city, Person.account_status_comment, Person.personal_standing_reason, Person.phone, Person.mugshot, Person.defaultmembershippe
riod, Person.account_status, Person.province, Person.personal_standing, Person.visibility, Person.icon, Person.organization, Person.homepage_content FROM Person, TeamMembership WHERE TeamMembership.team = 9258
77 AND TeamMembership.status = 2 AND TeamMembership.person = Person.id) UNION (SELECT Person.id, Person.defaultrenewalperiod, Person.postcode, Person.subscriptionpolicy, Person.teamowner, Person.merged, Person.
creation_rationale, Person.renewal_policy, Person.displayname, Person.hide_email_addresses, Person.creation_comment, Person.password, Person.name, Person.datecreated, Person.logo, Person.registrant, Person.open
id_identifier, Person.teamdescription, Person.verbose_bugnotifications, Person.country, Person.addressline2, Person.addressline1, Person.city, Person.account_status_comment, Person.personal_standing_reason, Person.phone, Person.mugshot, Person.defaultmembershipperiod, Person.account_status, Person.province, Person.personal_standing, Person.visibility, Person.icon, Person.organization, Person.homepage_content FROM Per
son, TeamMembership WHERE TeamMembership.team = 925877 AND TeamMembership.status = 3 AND TeamMembership.person = Person.id)) AS SETOP_TMP ORDER BY person_sort_key(displayname, name))
2008-05-02 10:50:22 ERROR Unhandled exception from processing an upload
 -> http://launchpadlibrarian.net/14085025/6hy3v0zkw1PKQr6z4ZVirjUfnwr.txt (ERROR: current transaction is aborted, commands ignored until end of transaction block

SELECT PackageUploadBuild.id, PackageUploadBuild.packageupload, PackageUploadBuild.build FROM PackageUploadBuild WHERE (PackageUploadBuild.packageupload = 500674) LIMIT 1)
2008-05-02 10:50:23 DEBUG Moving upload directory /srv/launchpad.net/ubuntu-queue/incoming/upload-20080502-114521-004302 to /srv/launchpad.net/ubuntu-queue/failed/upload-20080502-114521-004302
2008-05-02 10:50:23 DEBUG Moving distro file /srv/launchpad.net/ubuntu-queue/incoming/upload-20080502-114521-004302.distro to /srv/launchpad.net/ubuntu-queue/failed/upload-20080502-114521-004302.distro
2008-05-02 10:50:23 DEBUG Rolling back any remaining transactions.
2008-05-02 10:50:23 DEBUG Removing lock file: /var/lock/process-upload-insecure.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
Revision history for this message
Eleanor Berger (intellectronica) wrote :

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).

Revision history for this message
Eleanor Berger (intellectronica) wrote :

RF 6209

Changed in malone:
status: In Progress → Fix Committed
Changed in malone:
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.