ArchivePermission allows duplicated rows

[Julian Edwards]

This is fine until you come to delete one and you get a NotOneError.

Example:
launchpad_prod_3=# select * from archivepermission where packageset=109;
 id | date_created | person | permission | archive | component | sourcepackagename | packageset | explicit
-----+----------------------------+---------+------------+---------+-----------+-------------------+------------+----------
 769 | 2011-11-03 19:37:40.072146 | 3666300 | 1 | 1 | | | 109 | f
 755 | 2011-10-13 14:45:10.404165 | 16139 | 1 | 1 | | | 109 | f
 731 | 2011-10-13 14:45:10.404165 | 16139 | 1 | 1 | | | 109 | f

[Raphaël Badin (rvb)]

I've checked ubuntu/oneiric and ubuntu-leb/oneiric: no other duplication.

[Julian Edwards (julian-edwards)]

Precise has got *many* duplicated permissions for its packagesets and the timestamps are all at the time that precise was initialised. This means there's a bug in initialize-distroseries.py.

[Colin Watson (cjwatson)]

I have a test exercising this behaviour and am working on a fix, hopefully in time for initialising Q.

[William Grant (wgrant)]

https://pastebin.canonical.com/64714/ is an analysis of the broken production data.

[Launchpad QA Bot (lpqabot)]

r15137 in stable (http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/15137) is part of this bug's fix.

[Launchpad QA Bot (lpqabot)]

r15145 in stable (http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/15145) is part of this bug's fix.

[Stéphane Graber (stgraber)]

Filed bug 1025441 to clear the remaining duplicates from the DB.