duplicate packaging links

Bug #523901 reported by Curtis Hovey
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Curtis Hovey

Bug Description

https://edge.launchpad.net/ubuntu/lucid/+packaging shows that gwibber is listed twice, two project series provide the same distroseries+sourcepackagename. This should impossible because the db constraints were changed, but the contraints may not be correct:

https://edge.launchpad.net/gwibber/+packages shows the two series while https://edge.launchpad.net/ubuntu/lucid/+source/gwibber shows the dominate one.

The code and db need checking to ensure this can no longer happen (may need a code fix)
A query is needed that can purge the older duplicates (may need a separte query)

Related branches

Revision history for this message
Curtis Hovey (sinzui) wrote :

> It's actually called patch-2207-09.0.sql. That's not right.

Thank you. the name should be -0.sql.

I'll need to clean the data again before the constrain is applied...okay there were only 2 bad packages in staging created over 3 months, that was an easy fix.

I cannot create the insane data using the views, but I can see the bzr-upload was created 3 weeks ago. Either the views were fixed in the last release, or there is way to create a duplicate package that does not use +ubuntupkg.

Before we do our next rollout, a losa should ping me if this SQL query returns dupes. I can fix them in a few minutes.
https://pastebin.canonical.com/28142/

Changed in launchpad-registry:
status: Triaged → In Progress
Curtis Hovey (sinzui)
Changed in launchpad-registry:
status: In Progress → Fix Committed
Curtis Hovey (sinzui)
tags: added: qa-needstesting
Curtis Hovey (sinzui)
tags: added: qa-ok
removed: qa-needstesting
Revision history for this message
Curtis Hovey (sinzui) wrote : Bug 523901 Fix released

Fixed released in launchpad-project 10.02.

Changed in launchpad-registry:
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.