/srv/irclogs.ubuntu.com/2011/06/18/#launchpad-dev.txt

LPCIBotProject parallel-test build #49: STILL FAILING in 1 hr 10 min: https://lpci.wedontsleep.org/job/parallel-test/49/00:10
LPCIBotProject windmill-db-devel build #404: STILL FAILING in 1 hr 6 min: https://lpci.wedontsleep.org/job/windmill-db-devel/404/00:20
LPCIBotYippie, build fixed!00:40
LPCIBotProject db-devel build #646: FIXED in 5 hr 42 min: https://lpci.wedontsleep.org/job/db-devel/646/00:41
LPCIBotProject windmill-db-devel build #405: STILL FAILING in 1 hr 4 min: https://lpci.wedontsleep.org/job/windmill-db-devel/405/04:46
LPCIBotProject parallel-test build #50: STILL FAILING in 1 hr 14 min: https://lpci.wedontsleep.org/job/parallel-test/50/05:10
lifelessallenap: oh hai09:05
LPCIBotProject db-devel build #648: FAILURE in 5 hr 25 min: https://lpci.wedontsleep.org/job/db-devel/648/11:51
allenaplifeless: Something I discovered with that query is that it's looking at a batch of 300 DistroSeriesDifferences. If the batch is reduced to the default (for +localpackagediffs) of 75, the query appears to run 10x faster. So, one solution is to split the query into smaller batches - say 50 - and union them back together.14:23
LPCIBotProject windmill-devel build #251: STILL FAILING in 1 hr 5 min: https://lpci.wedontsleep.org/job/windmill-devel/251/17:28
LPCIBotProject devel build #819: FAILURE in 5 hr 30 min: https://lpci.wedontsleep.org/job/devel/819/21:41
LPCIBotProject parallel-test build #51: STILL FAILING in 1 hr 20 min: https://lpci.wedontsleep.org/job/parallel-test/51/22:03
lifelessallenap: thats interesting; looks like the plan goes screwy ? - one cause for that can be large IN clauses22:12
lifelessallenap: another approach there is to make a temp table, put the ids you want into that table, and then join against it.22:13
LPCIBotProject windmill-db-devel build #406: STILL FAILING in 1 hr 5 min: https://lpci.wedontsleep.org/job/windmill-db-devel/406/22:17

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!