can't remove packages any more

Bug #62428 reported by Colin Watson
2
Affects Status Importance Assigned to Milestone
Launchpad itself
Invalid
Undecided
Unassigned

Bug Description

This was working yesterday, but today:

$ remove-package.py -m '(cjwatson) NBS' -b openoffice.org-l10n-as-in openoffice.org-l10n-mr-in openoffice.org-l10n-or-in openoffice.org-l10n-sh-yu openoffice.org-l10n-ur-in openoffice.org-l10n-ti-er
Working...
Traceback (most recent call last):
  File "/srv/launchpad.net/codelines/current/scripts/ftpmaster-tools/remove-package.py", line 458, in ?
    main()
  File "/srv/launchpad.net/codelines/current/scripts/ftpmaster-tools/remove-package.py", line 392, in main
    to_remove = what_to_remove(packages)
  File "/srv/launchpad.net/codelines/current/scripts/ftpmaster-tools/remove-package.py", line 339, in what_to_remove
    for bpp in bpp_list:
  File "/srv/launchpad.net/codelines/soyuz-production+fix58144/scripts/ftpmaster-tools/../../lib/sqlobject/main.py", line 1650, in __iter__
    return conn.iterSelect(self)
  File "/srv/launchpad.net/codelines/soyuz-production+fix58144/scripts/ftpmaster-tools/../../lib/sqlobject/dbconnection.py", line 882, in iterSelect
    select, keepConnection=True)))
  File "/srv/launchpad.net/codelines/soyuz-production+fix58144/scripts/ftpmaster-tools/../../lib/sqlobject/dbconnection.py", line 792, in __init__
    self.dbconn._executeRetry(self.rawconn, self.cursor, self.query)
  File "/srv/launchpad.net/codelines/soyuz-production+fix58144/scripts/ftpmaster-tools/../../lib/sqlobject/dbconnection.py", line 389, in _executeRetry
    return cursor.execute(query)
psycopg.ProgrammingError: ERROR: permission denied for relation binarypackagepublishing

SELECT BinaryPackagePublishing.id, BinaryPackagePublishing.status, BinaryPackagePublishing.pocket, BinaryPackagePublishing.distroarchrelease, BinaryPackagePublishing.component, BinaryPackagePublishing.section, BinaryPackagePublishing.binarypackagerelease, BinaryPackagePublishing.datecreated, BinaryPackagePublishing.priority, BinaryPackagePublishing.scheduleddeletiondate, BinaryPackagePublishing.datepublished FROM BinaryPackageName, BinaryPackagePublishing, BinaryPackageRelease, SourcePackageName, Build, SourcePackageRelease, DistroArchRelease WHERE BinaryPackagePublishing.binarypackagerelease =
                        BinaryPackageRelease.id AND
                    BinaryPackagePublishing.distroarchrelease =
                        DistroArchRelease.id AND
                    BinaryPackageRelease.binarypackagename =
                        BinaryPackageName.id AND
                    BinaryPackageRelease.build =
                        Build.id AND
                    Build.sourcepackagerelease =
                        SourcePackageRelease.id AND
                    SourcePackageRelease.sourcepackagename =
                        SourcePackageName.id AND
                    DistroArchRelease.distrorelease = 7 AND
                    BinaryPackagePublishing.status = 2 AND BinaryPackageName.name = 'openoffice.org-l10n-as-in'

Please fix this urgently; not being able to clean up old packages is a showstopper for the Edgy beta release.

Tags: lp-soyuz
Revision history for this message
Colin Watson (cjwatson) wrote :

This was due to a partial deployment, and has gone away now that Stuart has updated the code on drescher.

Changed in soyuz:
status: Unconfirmed → Rejected
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.