| === yofel_ is now known as yofel | ||
| === r0bby is now known as robbyoconnor | ||
| 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:09 |
| 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:10 |
| maxb | Which would be why it's currently got some packages queued for 25 consecutive import jobs :-( | 11:11 |
| fullermd | It never hurts to make double sure. And triple sure is even better. Which means quadruple sure is totally worth it. Therefor... | 11:21 |
| maxb | Insanity by induction :-) | 11:41 |
| fullermd | Inducing insanity is just one of my skills. | 11:43 |
| * 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:31 |
| maxb | Appears right to me to prune the UDD importer queue of duplicate entries in type 3 (new entry) | 17:32 |
| maxb | Or I guess I could just let it chug through them for a few hours longer | 17:33 |
| === ajmitch_ is now known as ajmitch | ||
| === bradm_ is now known as bradm | ||
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!