[00:00] jml: Still around? [00:03] sinzui, thanks for your review. did you see the follow up? https://code.launchpad.net/~leonardr/lazr.restful/more-tests-for-combined-representations/+merge/50202 [00:03] wgrant: yes [00:03] jml: Which version of bzr-pqm do you have installed? [00:04] wgrant: 1.4.0dev [00:04] why? [00:04] I want the exact package version. Because your zeca move added [ui=none], but I removed that two weeks ago. [00:04] 1.4.0~bzr75-0ubuntu1-launchpad1~maverick1 [00:05] (it ended up with two sets of tags: one without [ui=none] from ec2, and another from presumably lp-land) [00:05] oh [00:05] Hmm. That is old. [00:05] 1.4.0~bzr77-0ubuntu1-launchpad1~maverick1 is the latest version. [00:05] You've not upgraded lately? [00:05] also, I appear to have something symlinked in my plugins [00:05] wgrant: just today [00:05] wgrant: maybe when I upgraded to natty I didn't re-enable my sources.list for launchpad? [00:05] That could do it. [00:06] should I use 'natty' or 'maverick' for that PPA? [00:07] natty [00:07] We support that now. [00:07] Although the test suite doesn't entirely work, I don't think. [00:07] not surprised. [00:16] thumper, maybe you want to take the (short) follow-up branch, that's all that's holding back a lazr.restful release [00:37] wgrant: so [00:37] let me look [00:40] wgrant: I'm not entirely happy with the memcache change; it seems ugly to me [00:40] wgrant: perhaps we should talk about it ? [01:03] leonardr: sure, email me with details [01:03] I'm just moving back home from the shared office space [01:27] matsubara-afk: I can't access the oops in https://bugs.launchpad.net/launchpad/+bug/636158 [01:27] <_mup_> Bug #636158: BugTask:+index times out with many bug tasks/nominations (eg. Bug #1) < https://launchpad.net/bugs/636158 > [01:27] matsubara-afk: spm has updated and reenabled the lp-oops db updater [01:31] thumper: you back online? [01:36] woo [01:36] http://webnumbr.com/launchpad-timeout-bugs# [01:56] wallyworld: am now, but checking on something [01:57] thumper: ok. ping me when you are done [01:57] * thumper nods [02:14] lifeless, spm: thanks. looks like update_db is working fine. instructions on how to update are here: https://dev.launchpad.net/Foundations/QA/OopsToolsSetup [02:14] lifeless, not sure why OOPS-1716ED446 is not working though [02:15] wallyworld: now? [02:15] ok [02:16] lifeless, only thing in the apache log is: [Fri Feb 18 01:09:25 2011] [error] [client 122.63.10.108] Premature end of script headers: oopstools.wsgi, referer: https://bugs.launchpad.net/launchpad/+bug/636158 [02:16] matsubara-afk: thanks; also there are uncommitted changes in the tree; we should fix that to be automatically deployable (like lp itself) [02:16] <_mup_> Bug #636158: BugTask:+index times out with many bug tasks/nominations (eg. Bug #1) < https://launchpad.net/bugs/636158 > [02:17] lifeless, I reverted some debugging code I had left there. the other uncommitted things are config changes which shouldn't be in the vcs (e.g. passwords) and some minor stuff that I have bugs open for but didn't get to it yet [02:18] matsubara-afk: so the password can be switched to ident [02:19] matsubara-afk: and other config stuff should either be a separate tree if confidential, or just committed in some fashion [02:19] matsubara-afk: I say should because the benefits to automation are immense [02:21] lifeless, right. I think if we can switch the db password to ident then the rest of it can be committed [02:22] the basic auth stuff is deprecated and I think I can remove that too [02:22] cool [02:25] lifeless: What is particularly ugly about the memcache change? [02:26] It appears the difference in URL between viewing a branch in loggerhead and viewing the branch details in LP is just a subdomain change (https://code.launchpad.net/~huwshimi/launchpad/tag-label-687546 and https://bazaar.launchpad.net/~huwshimi/launchpad/tag-label-687546). I can't find a situation where this is not the case. Can anyone verify this or know how I can go about doing so? [02:26] huwshimi: The branch path is always the same. [02:26] wgrant: Awesome. No chance that this ever differs? [02:27] Obviously the subpaths can be different. [02:27] No. [02:27] But lp-loggerhead should already have a link back to code.launchpad.net... can you reuse that? [02:28] wgrant: It does? [02:31] huwshimi: http://bazaar.launchpad.net/~launchpad-pqm/launchpad/devel/changes, click the branch name in the top left. [02:32] wgrant: Ah right. I missed that as it does not work locally [02:32] wgrant: Thanks for that [02:35] lifeless: With that BugTask:+index query... isn't it basically just SELECT blah blah FROM Message JOIN BugMessage ON BugMessage.message=message.id WHERE BugMessage.bug = %s AND BugMessage.index = 0" [02:35] ? [02:35] The query used there seems hugely excessive. [02:36] wgrant: its using the indexed_messages property [02:37] yes it can be made much better [02:37] Ahh. [02:37] I noticed it was timing out on that a lot on qastaging last night. But couldn't check the OOPSes to see how bad it really was. [02:46] its better than it was [02:46] its not shipping them all over the wire [02:46] the old one was a 10 second query ;) [02:48] Yep. [02:54] should be fixed now, just checking I haven't broken anything [02:56] Excellent. [02:57] What are message parents used for, anyway? [02:57] FIIK [02:57] Heh. [02:57] We model full email threading [02:57] I know. [02:57] we just don't show it anywhere [02:57] And MPs used to use it. [02:57] But not any more. [02:58] It's also used in bugmail, I guess, but not in the UI anywhere AFAIK. [02:58] https://code.launchpad.net/~lifeless/launchpad/bug-721056/+merge/50266 [02:58] thumper: ^ [02:59] (diff generating now) [02:59] lifeless: Drop about 6 seconds off an already 10 second page? [02:59] Seriously? [03:01] yes [03:01] Wow. [03:01] 5.7 specifically [03:04] https://devpad.canonical.com/~lpqateam/qa_reports/deployment-stable.html needs a "Do it" button [03:04] Given that it looks like we are able to manage 1-2 rollouts a day now... [03:11] lifeless: Do you want to discuss my FF branch? [03:11] Ah, you replied. [03:11] That was easier than expected. Thanks. [03:11] I'd previously said it was fine I think [03:11] it got sidetracked and confused [03:12] wgrant: the check for Contains is still weird IMO [03:12] but I haven't read enough of the rest of the file [03:12] lifeless: It is weird, but it's the same weird as the two other tests. [03:12] Consistent weird is better than inconsistent weird. [03:12] wgrant: I think it would be awesome if the "Do it" button would figure out the current losa and physically tap them on the shoulder. [03:13] bonus points for greying out about now in the week [03:13] spm: hi [03:14] lifeless: Your diff for bug-721056 looks odd [03:14] spm: last interrupt, I semi-promise. [03:14] lifeless: You have interface changes, but no model changes. [03:14] StevenK: That's fine. [03:14] StevenK: there are no model changes [03:14] Although I'd reject that MP, I think. [03:15] Exposing an _method? [03:15] Haha [03:15] consenting adults [03:15] And showing a _ in public? Shameful! [03:15] what really wants to happen is to push the description changed check into Bug [03:15] but I want to make the damn thing fast first [03:15] and then make it pretty [03:16] lifeless: Nothing uses indexed_messages any more. [03:16] Apart from one test. [03:16] wgrant: and the API [03:16] Bah. [03:16] Kill it. [03:16] With screw-compatibility-i-want-performance fire. [03:16] do you know how I know the API uses it ? [03:16] Because it times out hundreds of times a day? [03:16] ... we had timeouts on Bug.messages in the first week I was ta [03:17] wgrant: not anymore :) [03:17] Oh, right, I remember that. [03:17] wgrant: it probably will start timing out when we hit 12 second timeouts [03:17] lifeless: I do note you've stopped pasting the top 10 timeouts. [03:17] StevenK: not at all [03:17] I pasted them yesterday [03:18] today the oops processor was off overnight so the stats would be meaningless [03:18] I don't think any got through. [03:18] Right, but how many lines actually made it to the channel? [03:18] StevenK: the first 3, which is what I pasted [03:18] I think Freenode has wised up and disabled paste for you :-P [03:19] possibly [03:19] the flood rules are positively fascist [03:21] The reasoning is clear. Use a pastebin! [03:21] As fascist as you on OOPSes? :P [03:21] Haha. Maybe Freenode *are* LP users ... [03:22] wgrant: not quite; it lets some through after all [03:22] Haha [03:31] wallyworld: Bug #720474 looks very similar to bug #687623. [03:31] <_mup_> Bug #720474: Need "Build now" capability for daily recipe builds < https://launchpad.net/bugs/720474 > [03:31] <_mup_> Bug #687623: No ability to manually trigger a build 'like the daily build system' < https://launchpad.net/bugs/687623 > [03:31] wgrant: so it does [03:31] * wallyworld has a closer look [03:33] I think we need to SourcePackageRecipe:+index'ify all of LP. [03:34] wgrant: what do you mean? [03:34] lifeless: That's a new verb that means "completely AJAXify" [03:34] ah [03:34] that would be nice; we need to decide what to do with commercial/stakeholder ie7 users [03:36] wgrant: i'll mark 720474 as a dup of 687623. the wording is slightly different but the intent appears to be the same [03:36] wallyworld: I'd go the other way, but yes, they have the same intent. [03:36] wgrant: i thought we were supposed to mark the higher # and the dup? [03:36] s/and/as [03:37] wallyworld: Some say that. [03:37] bah [03:37] But the most informative, searchable one should win, IMO. [03:37] damn it [03:37] wgrant: yes, i see that point too. but both will be searchable even if one is a dup, no? [03:37] Hahahah [03:37] No. [03:37] yes [03:37] thumper: what's wrong [03:38] wgrant: the dupe finder searches dupes [03:38] making description optional requires a db patch :( [03:38] as there's a NOT NULL constraint [03:38] bah humbig [03:38] bug [03:38] thumper: patch away!! i'm not RM anymore :-D [03:38] we should do that in the main bug search, once its performance is tolerable [03:38] lifeless: ah, true, for the dupefinder. [03:38] Indeed. [03:39] wallyworld: if the older bug is less useful, you can either make the newer a master, or improve the older ones subject [03:39] if you're not working on a bug, taking the older as master is a good idea because of the slight emphasis on older-first bugfixing within a bucket [03:39] lifeless: the older one has more background info but the newer one is more succinct. i'll update the older one and dup the newer [03:40] sinzui: so, I found a another low hanging fruit for bugtask:index, will reevaluate when that has landed and been deployed [03:41] huwshimi: sinzui and I talked over bugtask:+index today, like you did the day before. I have a raft of bugs I'm going to file once I have some data on the relative performance impact of the various issues [03:41] lifeless: I wanted to hear your thoughts on bugmessage vs bugcomment when you have a spare cycle? [03:41] wallyworld: coolio [03:41] StevenK: hey, so - what in particular [03:41] lifeless: That's great. sinzui did mention it and it sounds like we're thinking along the same lines. [03:42] lifeless: Well at least that there's stuff to be dealt with [03:42] huwshimi: great minds [03:43] lifeless: Feel free to subscribe me to those bugs or something once they're created [03:43] sure [03:43] probably be tuesday before I file them given latency to gather the needed data [03:46] lifeless: In particular the subscribers list is going to get a huge hit once the yellow squad's work gets released [03:46] thats already out of the performance critical path [03:46] That's in a separate request, but it's still not good. [03:47] wgrant: actually [03:47] check BugTaskView [03:47] lifeless: It calculates them anyway? [03:47] yes [03:47] YAY [03:47] so there is stuff that needs addressing [03:47] a lot of detail to cover [03:47] but things like [03:47] - have a deleted bugtask state [03:47] (don't show those) [03:47] - don't show declined nominations [03:48] accordian the activities as well as messages [03:48] schema changes to let messages-to-show be queried from the db rather than done in python [03:59] * wallyworld wonders why stuff wrapped by