[00:34] wallyworld: bug 1342, whoa :) [00:34] <_mup_> Bug #1342: Can't delete spurious "Affects" lines (bugtasks) from bug reports < https://launchpad.net/bugs/1342 > [00:34] poolie: are you happy or sad? [00:34] happy and impressed [00:35] happy yes, there's nothing to be impressed about [00:35] i would like if you qa http://launchpad.net/bugs/861979 some time so my oops fix can have a go at production [00:35] <_mup_> Bug #861979: utf-8 encode diffs attached to outgoing email < https://launchpad.net/bugs/861979 > [00:35] poolie: doing it now but it's being difficult [00:35] because not enough of that stuff works easily on qas? [00:35] branch scan job oopsed [00:35] poolie: We can't deploy until Monday at least. [01:02] wallyworld: hey [01:03] wallyworld: whats the implementation strategy you guys are planning for bug 1342 ? [01:03] lifeless: hello [01:03] <_mup_> Bug #1342: Can't delete spurious "Affects" lines (bugtasks) from bug reports < https://launchpad.net/bugs/1342 > [01:03] lifeless: Magic [01:03] StevenK: sadly, I'm too jaded to consider that a great answer ;) [01:03] lifeless: log activity and delete unless it is the last task on a bug [01:04] do it via api initially [01:04] That isn't what lifeless meant. [01:04] And blocked via flag [01:04] yes [01:04] Personally, I'm picturing IBugTask.remove() [01:05] probably wants to be on Bug, but I'll let you guys figure that out [01:05] i haven't looked yet. doing qa and other administrivia [01:05] wallyworld: things to watch out for - conjoined masters will make 'last task on a bug' hard to determine [01:05] hmmm [01:06] Conjoinness rises its ugly head to bite us in the ass again [01:06] dumb question - what exactly is a conjoined master? [01:06] wallyworld: will notifications be sent to the context the task is removed from ? [01:06] lifeless: i expect so [01:06] wallyworld: your team can help you on the conjoined master thing :) - I mention it because its not obvious until you're in the trenches. [01:06] wallyworld: BugTask for Ubuntu, and then it's nominated for natty [01:07] * wallyworld needs to buy some gum boots [01:07] wallyworld: I think they should; as there isn't a LEP, I'm using this forum here to toss some constraints your way :) [01:07] StevenK: uhm, no. :) thats not a conjoined master [01:07] Oh [01:07] lifeless: I don't like it on IBug -- I prefer the idea of grabbing IBug.tasks, grabbing the one you want and calling .remove() or .delete() on it [01:08] StevenK: wallyworld: when you create a task for a *pillar directly* one task is made. If you also create a task for that pillars *development focus*, then those two tasks are shown as one in the Web UI, and are together a 'conjoined master' [01:08] StevenK: sometimes that will delete two tasks. [01:08] Why would it delete two tasks? [01:08] StevenK: so while you like the idea, I think it will be harder to code and harder to get right, if you put it on BugTask. Just saying. [01:08] wgrant: again, conjoined masters. [01:08] We don't have to continue treating them as conjoined for deletion. [01:08] wgrant: I will wait for a second while you headdesk. [01:09] wgrant: we have to show the difference in the UI then... [01:09] Delete one of the two, and it is magically not conjoined any more. [01:09] Magical! [01:09] wgrant: unless you delete the non-series task. [01:09] And? [01:09] There's no longer a conjoined slave. [01:09] No problem. [01:09] its not a valid state to have a series task with no non-series master [01:10] Isn't it? [01:10] I thought you argued a couple of months ago that it was. [01:10] When I was attempting to restrict it during my retargeting work. [01:10] I'm pretty sure we permit it now. [01:11] does the BugTaskSearch code have explicit code for dealing with conjoined masters? [01:11] Even if we want to forbid it, it's not directly related to conjoinment. [01:11] *Any* series task is affected. [01:11] Conjoinment is unspecial. [01:11] I argued that we have such states already, and that the conjoined thing messy, and that we shouldn't make it worse by breaking existing things [01:11] wgrant: thats true [01:11] wgrant: So let me phrase this differently: delete shouldn't let users create a state that they cannot already create. [01:12] Certainly. [01:12] Its my understanding that you cannot create a series task w/o a non-series same-pillar task, today. [01:12] (via web UI) [01:13] anyhow, long story short: beware the jabberwocky; send notifications to the folk the task was removed from; log enough that someone can undo brain damage; think about who can delete (the person who added it, the owner of the context, who else?) carefully. Have fun! [01:13] if the two tasks are shown as one in the web ui, if someone changes the assignee etc, which task gets updated? [01:14] wallyworld: both [01:14] lifeless: https://bugs.qastaging.launchpad.net/ubuntu/+bug/1234 [01:14] <_mup_> Bug #1234: Gina is an unmaintainable mess of command line options, environment variables and shell scripts < https://launchpad.net/bugs/1234 > [01:14] why do we need two task then? [01:15] wallyworld: the idea is that when a task nominated for the development focus is closed, its closed for the project as a whole too (in the absence of older series tasks) [01:15] wallyworld: the current implementation is just that, an implementation. [01:15] wallyworld: I would like to get rid of non-series tasks [01:15] lifeless: As for permissions, we agreed that bug supervisor + task creator is probably sensible. [01:16] wgrant: I'd suggest owner of the original task context, but that way lies madness [01:16] lifeless: Never let me hear you use the phrase "original task" again :) === StevenK changed the topic of #launchpad-dev to: https://dev.launchpad.net/ | On call reviewer: - | Critical bugs: 269 [01:22] sinzui: ping [01:27] feeling better? [01:37] me? mostly. [01:37] lifeless: You are a BAD MAN [01:37] BAD! [01:38] Been crook a few days. Yesterday it had mutated into a head cold but that seems to have cleared up now. [01:41] stub: ugh. Glad you're better :) [01:41] Just in time to be flooded tomorrow :-) [01:41] StevenK: getting things done in a tolerable fashion isn't bad. Cody can do that work unless it actually has holes in it. [01:42] lifeless: I don't think it's tolarable, I think it's a terrble hack [01:42] IPerson is already too fricken big [01:42] And advocating a celebrity? [01:42] StevenK: what are the consequences of it that make it intolerable ? [01:42] We want LESS celebrites, not more. [01:43] lifeless: That we are stuck maintaining it [01:43] until someone creates a launchpad-itself model object that such policy objects can link to, we need celebs [01:43] Cody or Tim drive it by and say "Excellent, the LP security model is out of our way, thanks" and we're stuck with the baby [01:43] There is also the issue of non-virt builders. [01:43] So, I object. [01:44] Ideally this would only grant them access to their own little world of fake-virt armel. [01:44] StevenK: you're rather they web scraped ? [01:44] lifeless: Web scraping is always better, because it's not an interface that we have to support. [01:44] wgrant: I'm not sure how to do that without deeper plumbing work; I was aiming to limit the scope of the permissions rather than rework [01:44] :) [01:45] lifeless: I'd rather we give them a restricted account with the privs they want, rather than other madness [01:45] But no one listens to me anyway, so meh [01:45] StevenK: this gives them a restricted account with the privs they want [01:45] StevenK: *I* listen to you - do you have a proposal on how that would work, and how does it compare in dev + maintenance effort to the other proposals ? [01:46] I wonder how close the secure panda cluster is. [01:46] stub: bug indices at 98% bloat :) [01:46] That would make this easier. [01:46] awesome [01:46] time to try pg_reorg? :) [01:46] oh, it's an index [01:46] I'll shutup now [01:47] elmo: :) [01:47] elmo: aieeeeeeeeeee [01:47] haha [01:47] https://code.launchpad.net/~stub/launchpad/replication/+merge/78914 has landed, but the scanner hasn't flagged it as merged. [01:47] hahaha [01:47] lifeless just googled pg_reorg [01:47] stub: db-devel vs devel [01:48] pg_reorg is for wimps. [01:48] I just did, that's *insane* [01:48] Oh, it landed on devel. [01:48] wgrant: nah... [01:48] Nevermind me then, something's just screwed. [01:48] Ah. [01:48] Will it have been logged somewhere? I'm not fussed but not sure if it should be raised somewhere. [01:48] https://code.launchpad.net/~stub/launchpad/replication [01:48] Ancient branch. [01:48] The scan probably timed out. [01:49] pg_reorg is that thing you use when you write to your database too much for vacuum to work right? [01:49] Because our branch scanner is fast and awesome and reliable and perfect. [01:49] (and want to die in a fire) [01:49] All my branches are ancient ;) [01:49] stub: Well, crucially, this one is missing 18 months of revisions. [01:49] Hah [01:50] Ahh [01:50] And the old scan is based on db-devel [01:50] The new one is probably devel. [01:50] So it has to rewrite tonnes. [01:50] I just crapped on https://code.launchpad.net/~allenap/launchpad/oneiric-librarian-bug-871596/+merge/79175 . Anyone disagree that this is a Storm bug and better to address there? [01:51] stub: Agreed. [01:51] That seems to pretty clearly be a DisconnectionError. [01:51] +1 [01:53] lifeless: Oh, I noticed this yesterday: [01:53] steven@liquified:~/launchpad/lp-branches/devel% head -n 1 LICENSE [01:53] Launchpad is Copyright 2004-2009 Canonical Ltd. [01:53] yes, copyright overheads are a PITA [01:53] lifeless: Should I JFDI the fix? [01:54] yeah [01:54] cron it for the 1/1/* [01:54] On my desktop? Not likely :-P [03:05] "But Robert tells us that the problematic team membership records are harder to clean up than regular old requests." [03:05] Clearly, both jtv and I are missing something. [03:07] ECONTEXT [03:09] wallyworld: \o/ at ajax batching [03:10] lifeless: seems to work well. if we get sorting solved, we can add it to the bug and blueprints tables on the milestones page [03:10] there's already a half done branch for that [03:11] whats the sorting issue? [03:11] when sortable.js is used for client side sorting, it doesn;t make sense if only a batch of results is rendered [03:11] well, thats what we do today right ? [03:12] the sorting doesn;t break, but it only sorts the current batch [03:12] how does avoiding page-loads make it worse? [03:12] yes but today for those tables there's no batching [03:12] oh, I see. [03:12] so the sort works on the entire results set [03:12] yes [03:12] so we need to catch the table header click and send a new query to the back end [03:12] can I make two suggestions [03:13] sure [03:13] rather than replacing the batch, consider - at least as an option - *appending* to it. [03:13] (and scroll down to the new bits) [03:14] lifeless: otp just a sec [03:14] I suspect, much of the time, that that would be closer to what users want [03:14] wallyworld: np [03:18] -> picking up lynne [03:19] lifeless: will ping you later [03:56] wgrant: Hai [03:56] *yawn* Morning [03:57] StevenK: Hello. [03:57] wgrant: I have a test, but I want to see that it creates an OOPS. [03:57] getLastOopsReport? [03:58] Or self.oopses perhaps. [03:58] Depending on how you do it. [04:02] Traceback (most recent call last):\nMixedVisibilityError\n [04:02] I am disappoint. [04:03] So I guess I need to inject a traceback into my raising() call [04:12] StevenK: no, if you do thats a bug somewhere else [04:12] StevenK: is it in a subprocess? [04:12] StevenK: if not, self.oopses is the thing to use. [04:13] lifeless: self.oopses looks good, but I want the full traceback [04:14] StevenK: it should be there [04:14] StevenK: if its not, something is mangling it [04:14] StevenK: report['tb_text'] should have it [04:15] 'tb_text': 'Traceback (most recent call last):\nMixedVisibilityError\n' [04:15] StevenK: as I said, something is mangling it [04:15] getUtility(IErrorReportingUtility).raising( [04:15] (MixedVisibilityError, MixedVisibilityError(), None), [04:15] request) [04:16] That's how I'm raising it, perhaps that is wrong [04:16] uhm, lets start over. What are you trying to do ? [04:16] lifeless: https://code.launchpad.net/~stevenk/launchpad/soft-oops-on-private-team-disclosure/+merge/79066 [04:16] there are no soft oopses [04:16] There are no *informational* OOPSes. [04:16] There can certainly be soft ones. [04:18] this has the potential to cause thousands of oopses [04:18] are you sure you want to do it ? [04:18] (for instance, an api collection with 75 members in it will be trimmed by lazr, and that one web API call will generate 75 oopses) [04:18] oh, and I see that you won't log from the API, which is good on one hand, but means you won't see it on the other [04:18] . [04:18] bloody ISP [04:18] lifeless: So, we want to turn this on for an hour or so and then see what happened [04:19] This is not a feature flag to leave enabled for too long [04:19] And it is purely for data gathering [04:19] So we can nail down the prime suspects, as it were [04:19] ok [04:19] so you actually need an *exception*: [04:19] try: [04:19] raise MixedVisibilityError('some text here') [04:19] I don't want to stop it [04:20] except MixedVisibilityError: [04:20] I just want to log it [04:20] ...raising() [04:20] StevenK: have faith that I understand your use case :) [04:21] try raise except results in 'tb_text': 'Traceback (most recent call last):\nMixedVisibilityError\n' [04:23] paste the updated code ? [04:23] lifeless: http://pastebin.ubuntu.com/707156/ [04:24] StevenK: nono, don't make the tuple by hand [04:24] sys.exc_info() [04:27] lifeless: Which tuple, sorry? [04:27] Oh, just toss sys.exc_info() rather than (MixedVi ... [04:27] http://paste.ubuntu.com/707159/ [04:28] Can someone who knows code imports help with this question? https://answers.launchpad.net/launchpad/+question/174071 [04:28] lifeless: Modulo the left bracket, I just did that myself, so great minds [04:29] StevenK: that should work better for you [04:29] 'tb_text': 'Traceback (most recent call last):\n Module lp.app.browser.tales, line 1327, in _report\n raise MixedVisibilityError()\nMixedVisibilityError\n' [04:30] Although I'm calling into the formatting API myself, so that should be okay. [04:31] lifeless: Thanks for the help. [04:31] StevenK: anytime [04:32] I was expecting more frames, but I shouldn't in this case. [04:41] * wgrant yearns for IArchiveCollection and IPublicationCollection === wgrant changed the topic of #launchpad-dev to: https://dev.launchpad.net/ | On call reviewer: - | Critical bugs: 267 [04:45] lifeless: batching - you want to append the next batch to the current batch? to create a table with twice as many rows (and a scroll bar)? doesn't sound quite right to me [04:46] Why not? [04:46] That's how most modern batchers work. [04:46] Start scrolling down, it automatically loads the next bit and extends the page. [04:48] that would be a significant rewrite of the current batcher though [04:48] well, the js etc [04:49] i was just wanting to do something backwards compatible and in line with the current implementation [04:49] at least for now [04:50] WIth launchpad's move to SOA, this might be an interesting read, if you folks haven't read it already - https://plus.google.com/112678702228711889851/posts/eVeouesvaVX [04:50] Yeah, that's been circulating around a bit. A rather impressive work. [04:51] Indeed [05:02] lifeless: Hai, Mr. OCR. [05:03] stub: has the branch transitively_private not null patch been applied to prod? [05:13] wgrant, wallyworld: Do either of you want to review my logging branch? [05:13] StevenK: i'll have a look [05:17] wallyworld: The NOT NULL patch is next in the DB queue. [05:17] wallyworld: Will probably be deployed on Monday, unless oneiric breaks stuff. [05:17] ok [05:17] just curious [05:18] The last few windows have been used for oneiric-critical cocoplum deployments, unfortunately. [05:18] StevenK: the method _report() - could it have a better name, like _report_visibility_leak() or something [05:19] wallyworld: I like the _ since it is internal, and I doubt it will remain there for long [05:19] StevenK: it's not the _, but the name [05:19] report [05:19] vs report_visibility_leak [05:19] Yes, alright [05:19] sorry [05:20] :%s/\(_report\)/\1_visibility_leak/ [05:20] Fixed [05:21] StevenK: i also think the test should ensure the ooops content is related to the mixed visbility error raised [05:21] at the moment, there's nothing to test that the oops is informational or is related to the error we are raising [05:21] it could be any oops [05:22] and we wouldn't know [05:22] self.assertTrue( [05:22] 'MixedVisibilityError' in self.oops[0]['tb_text']) [05:22] Rather than what is there, okay? [05:22] i think that works. is there a way to tell that it's a soft oops? [05:23] That the call returns u'', which I already test. [05:23] ah ok, since a hard oops would not return a result [05:23] it would just error out [05:23] Exactly. [05:24] cool. thanks for making the changes. r=me [05:30] wallyworld: its a desired feature, even though it is different to the non-js batch [05:30] wallyworld: non-js batch being the same as js-batch isn't a goal in and of itself :) [05:30] wallyworld: if you don't have time, thats fine. Consider though that the bugtask comment js batch works this way ;) [05:30] lifeless: sure. i'm just doing a bit at a time - small chunks of improvement [05:31] it was just a coding spike rather than a proper part of disclosure [05:31] ah cool [05:31] I think its great. [05:32] just tossing out nice to haves ;) [05:32] for what it is it works. backwrads compatible with non-js etc [05:32] i agree with the nice to haves [05:33] lifeless: while i have you - i wanted to put the deleteBugTask() on IBugTaskSet. it makes sense to me that the xyzSet interfaces be used to manage the lifecycle of the items they create etc [05:33] Any method on a Set that isn't set-based is a bug. [05:33] deleteBugTasks(), perhaps. [05:33] opinions are mixed about the *Set interfaces/instances [05:34] they are misnamed for much of what they do [05:34] wallyworld: Also, that doesn't work too well for the API. [05:34] As the Sets can't really be exported sensibly. [05:34] agreed. that was the issue i was going to aks about [05:34] This is most inconvenient. [05:34] putting it on there would be fine by me; I agree that it should take an interable of tasks, as future proofing. The API side of it is interesting though, as (IIRC) we haven't exposed the Sets on the PAI [05:34] we export IBranchSet [05:34] but it needs a url and default collectio method [05:35] We can't use a Set here. === almaisan-away is now known as al-maisan [05:35] As we need permission checking. [05:35] we pass in the user as part of the request [05:35] wgrant: that seems like a non-sequitur [05:35] deleteBugTask(bugtask, deleted_by) [05:35] lifeless: Until it's not awkward as hell, it's very relevant. [05:36] wgrant: its not awkward as hell ... [05:36] You have to manually work out the security stuff. [05:36] and we use call_with(who_deleted=REQUEST_USER) [05:36] Sure, we can get the user in there. [05:36] do you mean 'you'd have to check the security by probing rather than security adapters' ? [05:36] that seems to be the pattern used everywhere else [05:36] But then you have to manually determine and invoke security adapters. === al-maisan is now known as almaisan-away [05:38] i like the idea of a separate manager type interface to control the lifecycle of objects [05:39] it fits more with a service based design where domain objects encapsulate state and services manage the workflow etc [05:39] * StevenK attempts to stop his eyes glazing over [05:40] so we need to stick the deleteBugTask() method somewhere other than on IBugTask itself or even IBug [05:40] StevenK: you know you love this stuff [05:40] wallyworld: the current pattern in LP, for good or ill, is destroySelf() [05:40] Love to see it burn, sure. [05:40] yuk! [05:40] wallyworld: I would introduce BugTaskSet.delete(sequence_of_tasks) [05:40] IBugTask.destroySelf() [05:40] Then BugTask.destroySelf calls that. [05:40] nooooooo [05:41] domain objects do not call services [05:41] In our current architecture they do. [05:41] wallyworld: we don't have a domain/service split today [05:41] domain objects should just encapulate state and nothing more [05:41] Yes, it is bloody awful. [05:41] But this is Launchpad. [05:41] lifeless: yes, but do we want to propogate bad edesign? [05:41] We have no choice here. [05:41] wallyworld: introducing one incrementally is fine, but I would like to have some confidence we won't get lots of stubby attempts that don't flow together [05:42] sure [05:42] The current API and security design mandates that the method be on the object. [05:42] so given we have an addTask method on IBug, i could put a deleteTask method there too [05:42] and then it can update the heat etc [05:42] wgrant: Did you see the new design github deployed? It reminds me of old Launchpad :P [05:42] I don't think destroySelf is 'bad design' - its the logical consequence of the design of the zope stack. [05:42] just like addTask does [05:42] wallyworld: -the entire stack- [05:42] nigelb: Indeed, with the tabs along the top. [05:43] lifeless: destroySelf is ok, but that should not be exposed via the service layer [05:44] wallyworld: What service layer? [05:44] The API, I guess [05:44] wgrant: i'm generising [05:44] LP has no layers. [05:44] wallyworld: consider the interactions between ORM-objects-are-content-objects, security adapters and highly delegate-to-content-object design [05:44] wallyworld: if you grok that, and still want to add a service layer as part of this work, you have my blessing. [05:45] wallyworld: few folk do grok all those interactions though :( [because its bloody vicious] [05:45] lifeless: i'd like to move to a different design which separates out content from behaviour from workflow modelling from business process modeliing from orm etc [05:45] but that's in an idea lworld [05:46] i realise we have something different [05:46] largely dictated by the design of the zope stack i guess [05:46] lifeless: wgrant: so you happy if i add a deleteBugTask method to IBug? [05:47] and if so,i would raise an exception if a bug task were passed in that didn;t belong to the bug? [05:47] wallyworld: I don't think it should be on the bug. === jtv is now known as jtv-eat [05:47] addTask is there because it's adding a task to the bug. [05:47] but the bug needs to be involved because it needs to update bug heat [05:47] I think it should be on the task [05:47] Fucking bug heat. [05:48] Kill it. [05:48] so if it is on the bug task, i would need to update bugg heat still [05:48] and call back to the parent bug [05:48] sigh [05:48] Well, ideally the *Set method would do that. [05:48] In a batch fashion. [05:49] yes, but to expose the IBugSet method - it needs a url and a default collection method [05:49] and there isn;t one at the moment [05:49] Sure, which is why you put a trivial method on BugTask to delegate to it. [05:49] Matching the rest of LP's deletable objects. [05:49] ok, but i will have to have a shower afterwards. that is just sooooo wrong [05:49] i was thinking the other day about bug 678090 - i'd like to see how many people are actually affected by bugs, across dupes [05:50] <_mup_> Bug #678090: Affected people from duplicates aren't included in the master bug's affected count < https://launchpad.net/bugs/678090 > [05:50] stub, or someone, could you comment on my db performance question on the bug [05:50] basically, is counting them at run time going to be fast enough, or should we maintain a count? [05:50] wgrant: StevenK: to do it on bugtask seems the best option, but it just gets the layering *completely* wrong :-( [05:50] wallyworld: It's as good as it can get now. [05:51] wallyworld: Until we end up with a sensible architecture. [05:51] "lol" [05:51] Which may happen in 10 years when we're out of criticals :) [05:51] yeah :-( [05:51] But don't worry, there's nothing wrong :) [05:52] wgrant: i have to run away and pick up the kid from school. i doubt we'll see any qastaging email today :-( [05:52] How do I find which things are exposed over the API and wwhich arent? [05:52] nigelb: search through http://launchpad.net/+apidoc ? [05:53] nigelb: they are annotated and also listed in the webservice.py modules [05:53] poolie: Well, I was asking from the point of looking at the code and figuring out [05:53] that's if you want to see in the code [05:53] * wallyworld runs away [05:53] aha [05:53] nigelb: They are declared in the relevant interfaces [05:54] Ah, anything declared in the interface is available over the API? [05:54] No, it needs to decorated [05:55] nigelb: Taking lib/lp/bugs/interfaces/bug.py, getVisibleLinkedBranches is exported since it is has a @export_read_operation() decorator [05:55] 18:50 < lifeless> wallyworld: I want what you want, I just see more things in the way :) [05:55] funnily enough, I was looking at that exact file. [05:55] and [05:56] 18:49 < wgrant> Matching the rest of LP's deletable objects. [05:56] nigelb: latest_patch_uploaded is exported, but latest_patch is not [05:56] before my connection crapped out. [05:56] I see an ISP change in my future [05:56] Haha [05:56] I suggest a country change first [05:56] StevenK: layer 2 blip [05:56] Or a continent [05:56] nigelb: I've the choice of two right now, just need to drive over the mountains :) [05:57] heh [05:58] Haha [05:58] nigelb: Clear as mud? [05:58] StevenK: clearer than before at least [05:58] Haha [05:59] nigelb: So exporting things that haven't been can be easy if the interface they are in has had some groundwork laid -- but it can be complicated too [06:00] StevenK: Ok, so the reason I asked is searchTasks is available over the API, but I don't see BugTaskSearchParams anywhere [06:00] poolie: There will be little difference between filtering duplicates like we currently do and counting them. It may well be much faster even, as we may be able to avoid joining the bug table in some cases. [06:01] stub: bug.private [06:01] lifeless: Which is starting to be overhauled in any case. [06:02] stub: yes, but we still need to know, don't we ? [06:02] lifeless: It will move to task I think, as your bug could be targetted at pillars with different policies? Anyway... [06:02] so at the moment it does [06:03] select affected_user_count from bug where bug.id = %d [06:03] stub: We're actually very strongly leaning to removing cross-pillar private bugs. [06:03] we could change that to [06:03] stub: Once we beat OEM and ISD into submission. [06:04] Hm. [06:04] poolie: The query for 'users affected by this bug' will be slower and more complex if you count duplicates, but it will still be fast. [06:04] select count(user) from bugaffectsuser where bugaffectsuser.bug = %d or bugaffectsuser.bug in (select id from bug where duplicateof = %d) [06:04] We need a rabbitmq logging transport. [06:04] or something like that [06:05] that's more or less what bug.affected_user_count_with_dupes does [06:05] wgrant: I thought of that but was worried about clogging rabbit with debug2 spam. [06:05] stub: Yeah, it would need testing. [06:05] wgrant: this is for realtime logging? [06:05] lifeless: Yes. [06:06] wgrant: the ISP project should cover that [06:06] wgrant: I'd rather not overlap for a bit at leasrt [06:06] Yes, but they're nearly as slow at feature development as we are. [06:06] ISP? [06:06] wgrant: Would involve hooking into the existing log_options crud, adding an option to control the level of messages to send to messaging, and a log handler installed that sends to rabbit. Not terribly much work once rabbit is operational. [06:06] nigelb: information systems projects [06:06] stub: Yep, fits in very well with the existing script logging infrastructure. [06:07] lifeless: ah [06:07] StevenK: you wanted a review? [06:07] speaking of which, I could use a couple [06:07] lifeless: You're like an hour late. [06:08] StevenK: so you don't ? [06:08] oops-tools test time down to 4.7 seconds + db setup of maybe 7 [06:08] \i/ [06:08] lifeless: No, wallyworld has done it for me, but thanks [06:13] stub: so you're still pretty sure that will be safe? [06:14] poolie: we bring up the dupes already [06:14] poolie: Yer. [06:14] poolie: I suggest not changing that query [06:14] poolie: instead, sum up the affecting counts from the dupes (that we already retrieve) [06:14] ok [06:15] good idea [06:15] that's not precisely accurate in the case one person is affected by multiple bugs [06:15] but, perhaps that's not important [06:15] I think for dupes that it doesn't matter :) [06:16] tags +pedantic [06:16] ok that seems pretty safe then [06:16] how about for sorting by affected-users across dupes? [06:17] what do you mean ? [06:18] part of the related bug is that getting a list of bugs sorted by number of affected users probably should sort by total affected users across bugs [06:18] ah [06:18] if you want to know which bugs cause the most pain [06:18] perhaps we should stop offering that sort [06:18] ! [06:18] because bug heat is intended to provide a unified value representing pain, interest etc [06:19] but it fades over time, right? [06:19] though apparently not really? [06:19] right [06:20] and for affected users, wouldn't something that 1000 people marked affecting me in 2005 be less interesting than one where they marked it that way yesterday? [06:20] i don't know what the fall off is [06:20] [Note: I'm not endorsing that decay is useful, just taking it as an axiom for the discussion] [06:20] it seems reasonable to want to know about either of them [06:21] poolie: IIRC 1% a day or something [06:21] poolie: everything in the UI has a cost; I'm questioning the value of the affected-user-sort [06:21] so [06:21] given we have something intended to be more than it [06:21] i think it's a good question [06:22] i guess i dislike that both heat and affectance have this "you don't need to know that" attitude [06:22] and heat has some bugs, due to eg security bugs (many marked in error) getting a big boost [06:22] but, perhaps they can just be fixed [06:23] and it'll be a reasonable default [06:23] rhetorical question: if you fix both affected and heat to be perfect, would we need both anymore ? [06:23] [modulo the 'stop bug noise' aspect of affected] [06:23] affected users count towards heat [06:23] another good question [06:23] i know [06:24] i think they mesh without overlapping much [06:24] if bug heat worked well i don't think i'd care much about sorting by #affected [06:24] anyhow, I bet that a self join onto duplicates will trigger table scans in Ubuntu bug searches unpleasantly often. [06:24] but i do want to know the number of affected people [06:24] thats a WAG, needs testing to be sure. [06:24] poolie: I totally support showing the # affected sanely ;) [06:25] conversely, i think the heat metrics on an arbitrary scale have little or no value, cause confusion, and ought to be removed or deemphasized - ie make it only an ordering [06:25] eg the (fairly hot :) bug about heat being per-bug vs per task [06:27] what do you think? [06:27] I think heat is an ambitious project that we've underdelivered on [06:27] it has many significant operational issues as well as the UI related ones you refer to [06:28] folk like deryck are keen to fix it, but the current approach is tweaking; [06:28] I think it needs ground up re-evaluation, to fix both the UI and operation issues [06:28] (e.g. it causes search timeouts) [06:30] well, i am kinda tweaking here [06:30] a rethink could be good [06:32] but, perhaps is not necessary to just make dupes work better [06:32] sure; we were talking about the affected sort, which is a bit orthogonal to dupes [06:33] s//affectsmetoo [06:33] i mistyped [06:33] mis-thought [07:13] Hi lifeless, thanks for your feedback on the weird storm behaviour, I was a little bit surprised to see such a crazy thing but you're right, it really seems like I should fix this in storm (as opposed to a quick fix in the batchnavigator). === jtv-eat is now known as jtv [07:34] rvba: you may want to fix batchnav too, as google won't be making up those urls itself - we're emitting them somewhere [07:35] rvba: you can use googles link: search to find the pages containing the bad url and look at whats happening there [07:35] Why won't it be? [07:35] lifeless: not sure about that, I've heard that google tried to fiddle with query parameters to crawl the web. [07:35] wgrant: because its a spider, not an AI [07:35] lifeless: Erm... [07:35] rvba: ah.. well, its worth checking that we're not emitting them [07:35] rvba: on the 'better safe than sorry' side [07:35] lifeless: Right. [07:37] grah. ISP DIE DIE DIE DIE [07:38] .... [07:38] . [07:38] . [07:38] I wonder if setting my MSL to 5 seconds would help things or wreck em [07:55] Howdy [07:55] Hello mrevell! [07:59] hallo rvba === rvba changed the topic of #launchpad-dev to: https://dev.launchpad.net/ | On call reviewer: rvba* (allenap) | Critical bugs: 267 [08:06] stub: Thanks for the review. I don't mind the crapping-on :) I wasn't sure of the fix, but I wanted to show you something that might illustrate the problem. I'm going to relocate now, back in ~20m. === almaisan-away is now known as al-maisan [08:17] allenap: So the fix should be pretty simple - just need to add to is_disconnection_error() in databases/postgres.py. Tests might be harder to engineer, although for all I know perhaps the existing test suite fails under Oneiric. [08:17] allenap: Assuming you want to work on it rather than hand ball it a Storm dev (me or jamesh would be most likely to grab this one) [08:34] o/ mrevell [08:35] hey poolie, not so loud, I'm hiding from the 50ft marshmallows. [08:35] I need a guinea pig [08:35] s/ft/tonne [08:36] :) who _are_ you going to call, mrevell? :) [08:36] how wide must a ft long marshmallow be to weight a tonne ? [08:36] Heh. Hmm, who's the most Dan Ackroydy member of the team. [08:36] Huw? [08:37] you gonna call... [08:37] that was terrible poolie [08:37] hah [08:37] :) [08:37] actually he does also look vaguely like him [08:38] * lifeless puts out the call for guinea pigs [08:39] lifeless, Id the experience you have planned for these guinea pigs too scary to describe in your sales pitch? [08:39] Feck, "Is" [08:40] yes, of course [08:40] :) [08:40] mrevell: I want someone to quickly once-over the oops-tools release branch I've prepared [08:41] mrevell: its mind numbing looking for any production data references I've missed *that matter* [08:41] * bigjools wonders who Robert Collings is [08:42] probably the dude whose mail I keep getting [08:42] from hotels, gyms, their daughters wow account [parental control bit woo] and more [08:42] the sheer number of services that *don't* do a probe to check they got the mail address right is astonishing [08:43] lifeless: well he attended the TL call last night [08:43] bigjools: ah, no idea then. [08:43] anyhow [08:44] someone, please pull bzr+ssh://devpad.canonical.com/code/robertc/python-oops-tools and check I didn't miss anything big [08:44] kthanks release [08:47] That's very FHS. [08:48] FHS? [08:48] Filesystem Hierarchy Standard [08:48] Hrm, maybe I don't wanna know. [08:49] Ok, urbrandictionary'ing it wasn't a great idea. [08:53] FHS mandates things like binaries in /bin or /usr/bin, things that the machine serves go under /srv, /usr/local is for locally installed stuff, etc, etc [08:53] Ah [08:55] wgrant: you didn't know about /code ? [08:56] so that was amazing time consuming; I think for qatagger I'll rewrite [08:56] lifeless: I didn't. [08:57] The FHS didn't specify /code last I read it. [08:58] it doesn't [08:58] what do you want people to look for? [08:58] poolie: stuff we wouldn't be happy pasting in this channel [08:59] machine name references, internal config details, that sort of thing [08:59] grep -ir f.ck . [08:59] heh [09:00] there are some I've deliberately kept, because we depend on them for some of the aggregation (but those are obvious when reading the code) - and already known via lp source I strongly suspect :) [09:00] lifeless: well, the buildout.cfg has canonical.com as example data [09:00] if anyone else runs this we might be annoyed by backscatter [09:00] or they might be embarrassed by it [09:00] poolie: thanks - thats one I missed, and exactly what I was hoping for [09:00] this has been brain numbing :) [09:01] thanks :) [09:01] there is no obvious licence on it [09:02] and the readme's "for more information" is a private url [09:02] also the "real world example" url [09:03] no licence? where are you looking [09:03] ah, I haven't overhauled README. [09:03] shall do. [09:03] oh, the top-level readme [09:03] there is one in the python module [09:04] some of it is agpl and some is lgpl? [09:04] should be all AGPL [09:04] (which can be valid, but may not be intentional) [09:04] presumably I missed a header [09:05] src/oopstool/README.txt [09:05] thanks [09:05] oh no [09:05] it has doctests [09:05] better fix that ;) [09:06] its a child of its time [09:06] I have purged many [09:07] however my goal is a release not code overhaul [09:07] I suspect folk interested will poke at it after its out there [09:08] i know, i was just joking [09:09] in models.py there is some code flagged as lp-specific [09:10] embedding some policy about lp custom exceptions [09:10] probably fairly harmless to leave it as an example in the first relase thoug [09:11] that's all i can find [09:11] that's great to get this released! [09:12] what does this do? [09:12] oops tools? [09:12] poolie: yeah, thats the code I was referring to that needs to stay [09:12] poolie: theres no extension points for this yet [09:13] poolie: we need to make these data driven or something [09:13] nigelb: you may never have seen this but occasionally launchpad times out [09:13] :P [09:13] those things are gathered into a database and there's a tool that does some summaries and reporting [09:13] which we're apparently now going to release \o/ [09:13] poolie: heh, I did guess right :) [09:24] stub: Storm does string matching in is_disconnection_error. Do you think I should stick with that, or should I use pgcode like in my Launchpad branch? [09:26] allenap: It does string matching because we were not getting error codes before for these exceptions. I think error code matching is better as we don't need to worry about localization issues. Perhaps we can do this for the other disconnections too under Oneiric and leave the string matching for backwards compatibility with older psycopg2/libpq releases? [09:26] jtv, fair enough [09:26] poolie: "just following orders" :) [09:28] stub: Okay, I'll try to use pgcode if it exists, and I'll leave the fallback to string matching in place too. Thanks. [09:34] Anyone here who can help with a failing code import? https://answers.launchpad.net/launchpad/+question/174071 [09:41] jtv: jelmer is the best to ask about that [09:42] Thanks bigjools [09:47] can anyone explain this test failure? https://pastebin.canonical.com/54298/ [09:48] allenap: ^^ [09:48] poolie's issue looks like yours. [09:50] i do have some lines like this in the postgres log [09:50] [2011-10-13 20:45:26 EST] mbp@launchpad_ftest_template_17866 FATAL: database "launchpad_ftest_template_17866" does not exist [09:53] jelmer_, is this something you can help with? https://answers.launchpad.net/launchpad/+question/174071 [09:53] poolie: I get those log lines too [09:53] * allenap looks [09:53] Yup, that's the one allenap's working on. [09:53] poolie: oneiric> [09:53] ? [09:54] poolie: bug 871596 [09:54] <_mup_> Bug #871596: Not handling administrative shutdown under Oneiric < https://launchpad.net/bugs/871596 > [09:54] allenap: you might want to announce you're fixing that on the dev list, we'll get loads of questions about it today [09:54] hooray for chroots [09:58] poolie: no other feedback ? [09:58] poolie: e.g. 'you need a copy of the GPL in there :P' (one I just noticed) [09:59] mbp pointed me this way. What's the up-to-date method for getting a LP install working, such that I can test a proposed patch to Malone [09:59] sladen: are you on oneric? [10:00] lifeless: that's all i can find [10:00] o/ paul [10:00] you can either sacrifice your apache to LP or you can run it in a container [10:00] dev.launchpad.net/Running [10:00] /Running/LXC if you want more isolation [10:00] https://dev.launchpad.net/Getting <-- there's that, is it current? [10:00] https://dev.launchpad.net/Running/LXC [10:01] those two [10:01] Right, that works too, if you want to sacrifice your system postgres and apache to LP. [10:01] personally i use Schroots [10:01] sladen: it is current, but like I said. Sacrifice involved :) [10:02] Running/LXC is my recommendation [10:06] jtv, thanks for taking care of that en_GB removal request [10:06] ok, bzr+ssh://devpad.canonical.com/code/robertc/python-oops-tools should be in shape now [10:06] poolie: care to eyeball again ? [10:06] danilos: np. Just realized though that we'll need to delete the POFile as well. :( [10:08] lifeless: sorry i have to go out, maybe tomorrow [10:08] well, maybe just the diff, ok [10:08] its a push--overwrite, but you can use heads and diff the two [10:08] someone read https://code.launchpad.net/~mbp/launchpad/612171-diff-generation-spam/+merge/79244 for me? [10:10] no diff yet, but I've added commentary based on your cover letter [10:10] I'm v tired so lets talk about it tomorrow [10:10] thanks [10:10] how ironic if the diff fails [10:11] np [10:13] lifeless: looks pretty good [10:13] not sure if you ticked off every item i mentioned (that you want to fix) [10:18] ok night all [10:19] night poolie [10:24] poolie: I updated both README's, added LICENSE, and fixed buildout.cfg, deleted the isd and u1 index templates and made the LP one be called index (its a bit ugly that thats in-tree, but ... meh) [10:27] and bleh png files to nuke too [10:27] done === al-maisan is now known as almaisan-away [10:29] wgrant: care to add some paranoia to this process? [10:31] lifeless: Is the devpad branch up to date? [10:31] Looks like it. [10:31] As I must pull --overwrite [10:33] lifeless: Don't want to s/lp-oops.canonical.dev/oops-tools.dev/ or so? [10:34] sure, can do that [10:35] The remaining sample OOPSes are non-sensitive? [10:35] * wgrant checks. [10:36] Ah, you must have mangled them. [10:40] hatchet and slashet [10:40] pushed that sed up [10:41] Getting distribution for 'wadllib'. [10:41] error: Couldn't find a setup script in /usr/lib/python2.7/dist-packages [10:41] An error occured when trying to install wadllib 1.2.0.Look above this message for any errors thatwere output by easy_install. [10:41] :( [10:42] details :P - bootstraps on lucid with the lazr sourcedeps branch [10:42] (oneiric) [10:42] I just ran make [10:42] Which grabs that branch. [10:42] (yay) [10:42] so, I think once we get this out, someone probably wants to run around and cleanup [10:43] I mean I don't want it to be terrible [10:43] Perhaps the system wadllib is killing it. [10:43] but diminishing returns and all [10:43] Anyway, will ignore for now. [10:45] maintainer_email='launchpad-developers@lists.launchpad.net', [10:45] Really? [10:45] license='LGPL v3', [10:45] Lies. [10:46] bah [10:46] the former - etired. the second, grrr [10:46] trove classifiers are where its at [10:46] Yep. [10:47] deleted the license line and fixed the list [10:47] Thanks. [10:47] Checked that the secret key doesn't match prod? [10:48] secret key ? [10:48] * sladen deletes some Top Gear to make way for Launchpad. I hope you're all grateful [10:48] In buildout-templates/src/oopstools/settings.py.in [10:49] stub: I'm struggling to replicate the admin_shutdown thing in a Storm test. Do you know how I can do that? [10:50] changed to 12345 [10:50] and added a note to the README [10:50] Thanks. [10:50] thank &you& [10:51] allenap: python-pgbouncer perhaps ? [10:52] lifeless: So, I think that looks fine otherwise! [10:54] lifeless: Ah, okay, that's already in LP, right? [10:55] allenap: as a dep? yes [10:55] allenap: its how we do the fdt tests [10:56] lifeless: Huh, do the tests pass now? [10:56] I see matsubara's email address in report.txt, but nowhere else in the codebase. [10:57] they were before the latest set of edits [10:57] fixing [11:08] Ran 23 tests in 4.600s [11:08] OK [11:08] Excellent. [11:09] That's nice and quick, too. [11:09] Can you do the same thing to LP? :) [11:09] if I can delete the same amount, sure [11:10] jelmer_, hi, do you think you could QA bug 485932 or share some instructions on how to do it? [11:10] <_mup_> Bug #485932: should stack foreign branch imports < https://launchpad.net/bugs/485932 > === almaisan-away is now known as al-maisan [11:11] allenap: One approach that might work is to open a second connection and 'select pg_terminate_backend(procpid) from pg_stat_activity where datname='$testdbname' and procpid <> pg_backend_pid()' [11:13] allenap: That might work. There is a chance it is a pgbouncer specific thing and we would need to pull in the python-pgbouncer as lifeless suggested. [11:21] stub: I'll give that a go, thanks :) === matsubara-afk is now known as matsubara === beuno is now known as beuno-lunch === dpm_ is now known as dpm === al-maisan is now known as almaisan-away [12:27] * sladen gets to utilities/update-sourcecode [12:28] what does "bzrlib.errors.ConnectionReset: Connection closed: Unexpected end of message. Please check connectivity and permissions, and report a bug if problems persist." mean? === almaisan-away is now known as al-maisan [12:29] http://pastebin.ubuntu.com/707303/ === beuno-lunch is now known as beuno [13:04] Morning, everyone. [13:05] Morning deryck. The mockups for the buglists look cool! Can't wait to see it in action :) [13:05] nigelb, cool. Glad you like it. [13:05] Neither. [13:05] Are they implemented now? [13:05] How about now? === al-maisan is now known as almaisan-away === almaisan-away is now known as al-maisan === jcsackett changed the topic of #launchpad-dev to: https://dev.launchpad.net/ | On call reviewer: rvba* (allenap), jcsackett | Critical bugs: 267 [13:51] Morning jcsackett. [13:51] morning, rvba. [13:54] * jcsackett decides he needs more coffee after looking at the review queue [13:54] hehe [14:03] jcsackett: I'm sorry but I'm stuck with a critical bug I need to work on ... I'll take new reviews; I know the review queue is a little bit daunting. [14:05] no worries, rvba. i'm juggling things today as well -- it happens. :-) [14:06] jcsackett: ;) === al-maisan is now known as almaisan-away [15:01] abentley, mumble time? === matsubara is now known as matsubara-lunch [15:41] sinzui: Hey, you have a few minutes? [15:42] I will in a few minutes :) [15:44] :) === rvba changed the topic of #launchpad-dev to: https://dev.launchpad.net/ | On call reviewer: jcsackett | Critical bugs: 267 === mrevell_ is now known as mrevell [16:05] Hey deryck, do you have time to talk about Steve Magoun's email in the next hour or so? [16:06] mrevell, yeah, I can chat now. [16:06] mrevell, mumble? [16:06] sounds good [16:06] mrevell, meet me in Orange 1 o 1 then. [16:07] It's refusing to let me join [16:25] nigelb, I can talk now [16:25] sinzui: aha, so that bug about description - the database change has landed [16:26] nigelb, the status description we dropped? [16:26] * sinzui tries to remember [16:26] no [16:26] hang on [16:27] the description we created in person [16:27] bug 5283 [16:27] <_mup_> Bug #5283: "Home page" vs. "Description" is misleading < https://launchpad.net/bugs/5283 > [16:27] ah description and home_page [16:28] So, now its land garbo job and the temporarily insert into both columns. [16:28] I'm stuck at garbo job :) [16:29] * sinzui thinks === deryck is now known as deryck[lunch] [16:30] nigelb, I wonder is step 3 (Update the index pages and forms to use the new field (do not show the old fields if the description is not empty)). is better to do next [16:31] sinzui: Ah! That's slightly more easier, and makes sense. [16:31] I won't be writing temporary code at least :) [16:31] Ohwait. [16:31] what about existing content? [16:32] If we update the template to use description OR old fields, we know users are always seeing the right data [16:33] the edit forms should only show the new field. [16:33] Ah. [16:33] That sounds good. [16:33] I'll get to it :) [16:35] nigelb, LaunchapdFormView has a property (default_values?) that is used to populate the form values. We often do not need it, but in this case, we can use it to concatenate the values in the old field in the rare case where an old team/person is edited [16:35] okay :) [16:38] nigelb, initial_values is the property that returns a dict of fieldnames and values [16:38] ok! [17:00] Night all === deryck[lunch] is now known as deryck [17:49] Hey guys, getting OOPS's every time I search for 'zookeeper' on https://bugs.launchpad.net/juju [17:49] OOPS-2112K92 [17:49] other searches do not timeout [17:55] it's a trap [18:10] gary_poster: very nice changes to the YUI XHR fixtures! will make it much easier to use thanks! [18:11] cool, thanks flacoste :-) [18:20] SpamapS: cool [18:37] lifeless, I violently disagree with "must be able to copy and paste in excel" as a requirement and that failing to do so is a regression. [18:38] lifeless, if that becomes a requirement we might as well never change the UI. It's a by product of a design that you can copy in a certain order. [18:38] no one meant for that happen in the original design, I'm sure. [18:45] deryck: they didn't, and note that I didn't keep 'copy and paste' as my proposed requirement - getting the data *into* excel is the thing they need [18:45] deryck: e.g. the csv export [18:45] deryck: oem /currently/ depend on this [18:46] deryck: are you proposing we leave them high and dry for an unknown time period ? [18:46] lifeless, no, of course not. [18:47] lifeless, And I don't think anyone was saying that. in fact, I told mrevell I think we can deliver csv pretty easy when we finish the bulk of the work in 4 weeks, but I'd prefer to see where we're at then. [18:47] deryck: I'm saying that if they cannot meet their use case that they can currently, its a regression [18:47] lifeless, I thought mrevell echoed my "let's wait and see where we're at soon" sentiment. [18:47] deryck: sure; I'm saying that we shouldn't open the flag to OEM until we have CSV [18:47] fair enough. [18:48] lifeless, however, I don't like the word "regression" for this. [18:48] deryck: I'm not trying to say when-or-how, I'm trying to say that releasing this to them without a replacement for their use case will negatively impact them, and that we, in that discuss, were apparently not hearing that clearly enough [18:48] lifeless, well, to be fair, there's a lot in the email thread. ;) [18:48] deryck: which is true, and fine :) [18:49] lifeless, and also to be fair, the fact that they get by today is a happy accident. I certainly don't want to make things worse than now, so we're in agreement. [18:49] lifeless, but I just don't like all this regression talk when we never supported this use case yet. [18:49] the reality is that we do support it, even though we never intended to [18:50] No, we don't support it. We allow it. Those are different things. [18:50] deryck: csv export wouldn't hard, but not trivial either since we are likely to hand the CSV generation to a job as not to timeout when there are lots of bugs (we shouldn't paginate CSV exports) [18:50] deryck: so we have all the infrastructure to implement this, but it's not a simple take the JSON and write it throug csv.DictWriter either [18:51] well, it's that, but needs some wrapping :-) [18:51] flacoste, right, I didn't mean to imply it was that simple. :) Just more attainable at the end of this work than at the beginning. [18:51] deryck: agreed [18:52] and I agree with the difficulty etc; I'm not suggesting we need to change the order we do the work in; but we do need to acknowledge and deal with their needs [18:54] SpamapS: that looks like bug 735966, weird though that only zookeeper search triggers it [18:54] <_mup_> Bug #735966: Product:+bugs timeouts < https://launchpad.net/bugs/735966 > [18:55] lifeless: anything that could explain that Product:+bugs time outs when trying to ftq(zookeeper), but not without it? [18:55] on juju [18:55] posibbly cold pages in the text index [18:56] or pathological layout - we're at 98% bloat as of last night [18:56] I don't think stub has managed to fix it yet [18:57] I can search for lots of other common things [18:57] just not zookeeper [19:01] SpamapS: works for me [19:01] SpamapS: a bit slow - 107 queries/external actions issued in 8.86 seconds [19:01] re-running, [19:01] timeout [19:01] may be db server specific [19:05] flacoste: the main bugtask search is whats timing out [19:05] https://lp-oops.canonical.com/oops.py/?oopsid=OOPS-2112K92#longstatements [19:07] yeah, i saw [19:07] but since it seems to work for SpamAs when he doesn't use zookeeper as a term, i wondered if it wouldn't be only the ftq() clause that slows it down [19:09] flacoste: SpamapS: http://paste.ubuntu.com/707506/ [19:11] lifeless: doesn't that confirm my hypothesis? [19:11] Index Scan using bug_fti on bug (cost=0.00..1830.44 rows=51 width=761) (actual time=45.069..10902.728 rows=71 loops=1) [19:12] yes [19:12] sorry, am juggling a few threads right now [19:12] on my baby-addled brain (yesterday was first immunisation shots) [19:13] lifeless: ouch, yeah shots, that throws a baby sleep-cycle off for a week! [19:14] lifeless: DTP, MMR, and the best immunity.. Diplomatic [19:14] SpamapS: :) [19:17] flacoste: so yes, 10 seconds to get 71 rows [19:17] flacoste: sick index [19:18] we need a new one and a pivot [19:18] this isn't automated yet and is tricky to do live [19:20] deryck: http://people.canonical.com/~abentley/client-side-mustache.png [19:21] deryck: I'd like to chat about how to maintain a common template for server side and client side. [19:22] abentley, ok, may have to wait a bit. I'm currently in 2 other conversations. I'll try to wrap shortly and ping. [19:22] deryck: okay. === almaisan-away is now known as al-maisan === al-maisan is now known as almaisan-away [20:31] flacoste: [20:31] https://launchpad.net/python-oops-tools [20:31] ! [20:31] finally [20:32] flacoste: indeed, long road [20:32] lifeless: thanks for pushing this past the finish line! [20:32] flacoste: we still need to deal with the fallout: isd an u1 custom front pages were removed, branding cut back etc [20:33] flacoste: but I think folk will step up now that we can't cheat ;) [20:34] flacoste: and http://pypi.python.org/pypi/oops-tools [20:34] flacoste: hasn't rendered right, but meh :( [20:35] the hard part is ~ over [20:36] flacoste: so we used a new project to prevent old branches being pushed wrongly; I'm going to deactivate the old project [20:36] flacoste: It has 46 open bugs, I'm thinking to just manually retarget, no sql or anything - safer. [20:36] flacoste: unless you have a different recommendation ... [20:37] lifeless: nah, sounds fine [20:38] (and am leaving closed bugs behind) === almaisan-away is now known as al-maisan === al-maisan is now known as almaisan-away [20:48] when i forget to land a change --no-qa, what should i do to the tags? [20:48] mark it qa-untestable? [20:48] qa-untestable [20:48] cool [21:09] and the old project disabled [21:09] nigelb: lp:python-oops-tools [21:09] lifeless: <3 === jcsackett changed the topic of #launchpad-dev to: https://dev.launchpad.net/ | On call reviewer: - | Critical bugs: 267 [22:02] sinzui: mumble is taking all my cpu and freezing. trying to fix [22:08] sinzui: can you hear us? [22:11] wallyworld_: try deleting ~/.MumbleSocket or something like that [22:11] mwhudson: i reboot fixed it, thanks :-) [22:26] wallyworld_, bug 663923 [22:26] <_mup_> Bug #663923: Cannot view list archive of private team < https://launchpad.net/bugs/663923 > [22:49] * StevenK glares at lifeless. [22:50] StevenK: oh? [22:51] lifeless: Reassigning 52 bug pillars [22:51] StevenK: faster this way [22:52] wait for me to get going on the high review [23:05] Uh oh, I've broken Mumble. [23:05] I shaded it, which Unity took as minimising. [23:06] Using the Mumble notification to bring the window back shows the toolbar. Only. [23:09] Oh look, I fixed it. [23:36] flacoste: I've mailed stub about bug_fti [23:36] flacoste: to execute his evil workaround [23:37] lifeless: thanks!