| wgrant | Ew. | 02:46 |
|---|---|---|
| wgrant | Lots of odd MP OOPSes... | 02:46 |
| wgrant | Can't see how it could be a regression, though. | 02:46 |
| lifeless | mp creation was timing out for the package importer yesterday | 02:52 |
| wgrant | It was OOPSing, not timing out. | 02:52 |
| lifeless | true | 02:53 |
| lifeless | they were getting 500's and not seeing the oops id | 02:54 |
| lifeless | so I was guessing | 02:54 |
| wgrant | Ah. | 02:54 |
| lifeless | bah | 02:55 |
| lifeless | BMP index still timing out | 02:55 |
| wgrant | :( | 02:55 |
| lifeless | https://lp-oops.canonical.com/oops.py/?oopsid=1910B1069#longstatements | 02:55 |
| lifeless | oh right, that wasn't deployed | 02:56 |
| wgrant | You mean the one that landed 64 minutes ago? | 02:57 |
| lifeless | yeah | 02:57 |
| wgrant | HYeh | 02:57 |
| lifeless | 12079.01SQL-launchpad-main-slave | 02:58 |
| lifeless | SELECT BranchMergeProposal.commit_ | 02:58 |
| lifeless | bah, terrible plan | 03:00 |
| lifeless | bug 742916 if you're interested | 03:07 |
| _mup_ | Bug #742916: BranchMergeProposal:+index timeouts - slow query plan <timeout> <Launchpad itself:Triaged> < https://launchpad.net/bugs/742916 > | 03:07 |
| lifeless | BranchRevision needs revision_date denormalised into it | 03:09 |
| wgrant | lifeless: No. | 03:19 |
| wgrant | That will double the size of our biggest table, so I think not :) | 03:19 |
| lifeless | its only 34GB | 03:23 |
| wgrant | True. It's the indices that are really big :/ | 03:25 |
| lifeless | wgrant: we're currently bringing 10K rows in at a time | 03:25 |
| lifeless | wgrant: a bigger table (and another index - shrug) - which stays mostly on disk, would be a net win. | 03:25 |
| lifeless | wgrant: select count(*) from revision where Revision.revision_date >= '2009-11-05 00:21:45.372993+00:00' and Revision.revision_date <= '2009-11-06 15:52:25.310401'; | 03:30 |
| lifeless | count | 03:30 |
| lifeless | ------- | 03:30 |
| lifeless | 9722 | 03:30 |
| lifeless | I suspect a recursive graph traversal query will be faster | 03:31 |
| lifeless | and we should investigate that before denormalising | 03:31 |
| wgrant | lifeless: I personally prefer the "don't store 50000 times more data than necessary" approach. | 03:32 |
| wgrant | lifeless: What do you know about bugnotification? | 03:34 |
| wgrant | https://lpstats.canonical.com/graphs/TableRowCountbugnotification/20100327/20110327/ is somewhat interesting. | 03:34 |
| wgrant | The trend from the start of Feb hasn't been seen before. | 03:35 |
| lifeless | https://lpstats.canonical.com/graphs/TableRowCountbugnotification/20090327/20100327/ | 03:36 |
| wgrant | I guess the pre-release rush could just have been brought all the way back to the start of Feb rather than March. | 03:39 |
| wgrant | But mmm. | 03:39 |
| lifeless | so its a short lived audit trail + work queue | 03:44 |
| lifeless | on qastaging | 03:45 |
| lifeless | select min(date_emailed) from bugnotification; | 03:45 |
| lifeless | min | 03:45 |
| lifeless | --------------------------- | 03:45 |
| lifeless | 2011-01-14 23:05:53.30206 | 03:45 |
| LPCIBot | Project windmill build #105: STILL FAILING in 1 hr 9 min: https://lpci.wedontsleep.org/job/windmill/105/ | 04:36 |
| wallyworld | thumper: ping | 06:34 |
| === almaisan-away is now known as al-maisan | ||
| === al-maisan is now known as almaisan-away | ||
| LPCIBot | Project windmill build #106: STILL FAILING in 1 hr 11 min: https://lpci.wedontsleep.org/job/windmill/106/ | 08:54 |
| LPCIBot | Yippie, build fixed! | 08:59 |
| LPCIBot | Project db-devel build #492: FIXED in 5 hr 19 min: https://lpci.wedontsleep.org/job/db-devel/492/ | 08:59 |
| cjwatson | 7990 N T Mar 26 William Grant Test results: tar-xz => devel: FAILURE | 11:12 |
| cjwatson | 7991 N Mar 26 noreply@launchp [Merge] lp:~cjwatson/launchpad/tar-xz into lp:launchpad | 11:12 |
| cjwatson | wgrant: ^- do I need to do something about that failure, or did it get resolved before merge? | 11:13 |
| StevenK | cjwatson: It has hit devel as of r12667, and the LP buildbot is currently building that rev -- so we'll find out in about 37 minutes. | 11:15 |
| StevenK | There are currently no test failures, though. | 11:15 |
| cjwatson | the failures look legit, investigating | 11:19 |
| cjwatson | unfortunately I don't appear to be able to run the uploadprocessor tests locally | 11:21 |
| cjwatson | I've pushed what I think is a fix to lp:~cjwatson/launchpad/tar-xz | 11:21 |
| wgrant | cjwatson: Ah, sorry, forgot to reply. I fixed that myself and landed it. | 11:22 |
| wgrant | cjwatson: Why can't you run it locally? | 11:22 |
| cjwatson | setting up all the necessary postgres stuff for full LP test runs impedes my ability to do Ubuntu boot speed work | 11:24 |
| cjwatson | ah, if you fixed it yourself, great | 11:24 |
| cjwatson | wgrant: you might want to check my tar-xz branch all the same - I had apparently forgotten to add the .tar.xz file to a second set of test data that hangs off the first | 11:25 |
| cjwatson | it seemed to pass anyway but it's more correct this way, I think | 11:25 |
| wgrant | cjwatson: Lots of us run LP in a VM. | 11:31 |
| wgrant | Because it is slightly intrusive. | 11:31 |
| wgrant | (Unity and r600g are really not good friends at the moment) | 11:32 |
| === nigelb_ is now known as nigelb | ||
| LPCIBot | Project windmill build #107: STILL FAILING in 1 hr 9 min: https://lpci.wedontsleep.org/job/windmill/107/ | 13:06 |
| james_w | is there a bug for whatever is causing the package importer to fail with a 500 error? I was told it was a timeout error that a fix was available for | 14:26 |
| wgrant | james_w: It's not a timeout. I suspect that it's a bug in the importer... it's OOPSing with a mismatch between the number of reviewers and review types in the request. | 14:38 |
| wgrant | james_w: https://lp-oops.canonical.com/oops.py/?oopsid=OOPS-1910A1001 | 14:39 |
| wgrant | james_w: It looks like change landed in lp:udd three weeks ago, but perhaps it was only deployed a couple of days back? | 14:44 |
| cjwatson | wgrant: I don't work on LP often enough to have spent time setting that kind of thing up, TBH | 14:55 |
| james_w | wgrant, that's quite possible | 16:04 |
| lifeless | moin | 19:20 |
| lifeless | we should upgrade to bzr 2.3 | 20:39 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!