[11:09] <maxb> Hm.
[11:09] <maxb> We have a bit of a silly bug in the UDD importer
[11:09] <maxb> every 5 minutes, it checks for new source publications on launchpad published since the last publication it saw previously *minus 10 minutes fudge factor*
[11:10] <maxb> Which means every 5 minutes it re-runs the import job for whatever package was most recently uploaded, plus any uploaded within 10 minutes of that
[11:11] <maxb> Which would be why it's currently got some packages queued for 25 consecutive import jobs :-(
[11:21] <fullermd> It never hurts to make double sure.  And triple sure is even better.  Which means quadruple sure is totally worth it.  Therefor...
[11:41] <maxb> Insanity by induction :-)
[11:43] <fullermd> Inducing insanity is just one of my skills.
[17:31]  * maxb wonders if there are any SQL experts around
[17:31] <maxb> UPDATE jobs j JOIN (SELECT MAX(id) maxid, package, COUNT(*) FROM jobs WHERE active AND type = 3 GROUP BY package HAVING COUNT(*) > 1) k ON j.package = k.package SET j.active = 0 WHERE active AND type = 3 AND j.id != k.maxid;
[17:32] <maxb> Appears right to me to prune the UDD importer queue of duplicate entries in type 3 (new entry)
[17:33] <maxb> Or I guess I could just let it chug through them for a few hours longer