=== andrewski_ [n=andrew@pool-141-158-41-67.phil.east.verizon.net] has joined #launchpad [12:18] what does it mean to "sign" a code of conduct? is that like saying that you've read it? because i know very little about OpenPGP and such, but i'm not sure if signing it is a measure of good faith or somesuch. [12:21] andrewski_: it means you read it and agree to abide by it, then you can downlod it, clearsign it with gpg, and paste the output into that window [12:21] Kamping_Kaiser: ah, ok. so i need to download it first to sign it, eh? could that be made a bit clearer on the site? [12:22] andrewski_: http://ubuntu.pastebin.com/541507 [12:22] yeh. i commented yesterday [12:22] Kamping_Kaiser: ah, ok. :) cheers. [12:23] :) [12:23] should i set up gpg first? do i need to "personalize" it? [12:23] you need a gpg key [12:23] if you have that, you can sign it [12:23] oh [12:23] ah, ok. i think i have one on my desktop... lemme fire up ssh. :) [12:23] you need to have your key registed with launchpad IIRC [12:24] ok, i see that page too. [12:28] Kamping_Kaiser: any idea which key i'm supposed to send with 'gpg --send-key'? [12:29] hm? wichever you want to use in future work with launchpad/other ubuntu stuff [12:30] ok, so pubring.gpg is fine? [12:30] (like i said, i know little about gpg. :) [12:30] andrewski_: i know little as well :) i had to get help setting this up myself :$, and i cant remember [12:31] yeah, it doesn't like pubring.gpg. i'll check the wiki for something. how do i go about making a suggestion for launchpad stuff? [12:32] i commented here. [12:33] just a minute, I'll try find the gpg page [12:33] sounds good to me. [12:34] https://wiki.ubuntu.com/GnuPrivacyGuardHowto - look at point 5.1 as well :) [12:36] Kamping_Kaiser: thank you much; you got to it faster than i. :) i must be off, but i'll stick around to see if anyone backtracks to read our comments. tsch! [12:38] ok mate :) === lfittl [n=lfittl@83-65-244-232.dynamic.xdsl-line.inode.at] has joined #launchpad === mpt_ [n=mpt@219-89-149-187.jetstart.xtra.co.nz] has joined #launchpad [01:15] lifeless: I saw you just sent a mail about branch status feedback [01:16] lifeless: here I just sent an update to the "runnig baz2bzr periodically" task, giving a lot of detail to implement the daily error reporting for buildbot. [01:24] ddaa: Did you see my mail about the buildbot tests? [01:24] spiv: yes, and I wondered... [01:25] spiv: did you make all the changed you mentioned? [01:25] ddaa: Yes, whY? [01:26] it does not read very obviously [01:26] "the CVS version with the SignalMixin is probably straightforward to backport, if we want it (although I'm not convinced that that's the best way either...)." [01:26] I made sure to run "make check" in sourcecode/buildbot before reporting my results :) [01:26] Oh, right. [01:26] No, I didn't try that. [01:26] "Here's a diff, against rocketfuel" [01:27] "Yeah, I think that test is totally irrelevant to us, so skip it." [01:27] Sorry, I sent a diff of what fixes it now (partly by skipping broken tests). [01:27] So I wondered what was stopping you from sending the changes to rocketfuel. [01:27] And also suggested ways to unbreak some tests. [01:28] I wanted to run it by you, seeing as you've been working in this area. [01:28] spiv: I am currently beyond suggestions about anything not involving drugs, sex, and the importd->bzr transition :) [01:28] I'm happy to send the merge request right now if it all makes sense to you :) === sabdfl [n=mark@ubuntu/member/pdpc.silver.sabdfl] has joined #launchpad [01:28] Ok :) [01:28] hey all [01:29] just got a timeout on /products/gnomebaker/ which was very surprising [01:29] spiv: please do whatever you think is right to let me merge my pending cscvs changes [01:29] is something going on with LP performance? [01:31] Not that I know of, there was a rollout yesterday though. [01:31] What's the OOPS id? [01:32] sabdfl: I received your mail about the pybaz packaging problem [01:32] sabdfl: you realize the problem is that pybaz and python-baz are just two packages for the same bit of software, don't you? [01:32] spiv: lost the OOPS ID when I reloaded, but it just happened a minute ago [01:33] ddaa: in that case, should they not Provide: the same thing? Because installing config-manager pulls in one, and something else pulls in the other. [01:33] sabdfl: Ok, I'll see if I can find it. [01:34] sabdfl: obviously, the fact they package the same thing shows that the two packagers did not communicate... [01:36] besides, it looks like only pybaz is on dapper... [01:37] ddaa: i'm running dapper [01:37] sabdfl: OOPS-39A13 [01:37] thanks spiv. anything seem out of the ordinary? [01:38] All fine until a SELECT COUNT(*) with a subselect. [01:38] (on BugTask, Bug, subselect on Bug, BugSubscription, TeamParticipation) [01:39] I wonder if the offending SELECT COUNT(*) will go away next rollout with jamesh's __len__ fix. [01:40] But the page usually is very fast, so I guess there must have been some contention. I'll get stub's opinion when he wakes up. [01:43] just got another timeout [01:43] OOPS-39D23 [01:43] this time on a rosetta page [01:43] we need to make eliminating these timeouts amajor goal of ours [01:43] I'd bet it's browser/bugtask.py:1028 [01:43] tasklist = self.context.searchTasks(params) [01:43] return tasklist[:quantity] === Mez [n=Mez@ubuntu/member/mez] has joined #launchpad [01:45] that's run twice by the bugtarget-portlet-latestbugs.pt [01:45] but spiv is right, this page is usually very fast, so it's probably a contention with something else that's really slow [02:11] Merge to devel/launchpad/: [r=kiko] extend fmt:text-to-html to turn OOPS codes into links for developers (bug #30645) (r3097: Dafydd Harries) [02:13] hey sabdfl [02:14] how's the tour? [02:14] hiya Kinnison, happy your baby is in production? [02:14] dude you have no idea how high I've been flying [02:14] tours going well, not much sleep but otherwise wonderful reception and lots of work [02:14] I think I've given C1 a run for its money === niemeyer [n=niemeyer@200-103-135-181.ctame7006.dsl.brasiltelecom.net.br] has joined #launchpad [02:14] wondered what the hell that was outside the window === Kinnison grins === Kinnison is just finishing the "how to ensure drescher is happy during production rollouts" document for stuart [02:15] we did a completely smooth rollout today together [02:15] so I'm turning my notes from the process into a document for him [02:20] v cool [02:20] once we get cron.daily's equivalent back down to once per 30 minutes we will have full equivalence to dak, AIUI [02:20] Pretty much [02:20] and we're down to an average 20 minute run [02:21] James and I seriously improved the dominator's performance on Saturday === jsgotangco [n=jsg@210.4.38.43] has joined #launchpad [02:34] you beat the dominator into submission. i like it. === sabdfl [n=mark@ubuntu/member/pdpc.silver.sabdfl] has left #launchpad [] === stub [n=stub@gb.ja.97.164.revip.asianet.co.th] has joined #launchpad === Kinnison heads to bed [02:57] stub: I've sent you a doc [02:58] Or at least I thought I had [02:58] it has bounced [02:58] grah [02:58] But I'm fine! [02:58] email? [02:58] what's your @canonical.com address? [02:59] stuart.bishop@canonical.com [03:00] sent [03:00] and now I sleep [03:00] ciau [03:03] Night === makaveli [n=nnn@c-69-139-7-167.hsd1.pa.comcast.net] has joined #launchpad === makaveli [n=nnn@c-69-139-7-167.hsd1.pa.comcast.net] has left #launchpad [] === stub [n=stub@gb.ja.97.164.revip.asianet.co.th] has joined #launchpad [03:29] stub: sabdfl got OOPS-39A13, but usually that page renders quite quickly. I guess it was just contention on the tables in the query? [03:30] I guess [03:31] Not the prettiest of queries [03:33] stub: Was the librarian upgraded in yesterday's rollout? [03:33] spiv: Yes [03:34] Ok, so it now has the database name checking in it. [03:34] So it's a matter of upgrading all the clients :) [03:37] Hmm... it should enforce that. [03:38] At the moment, it's optional, depending on the client sending the relevant header. [03:38] All the time critical stuff is using the new code - anything else that blows up is a backend system that can afford some downtime [03:38] I should make it log a warning everytime a client doesn't send that header. [03:38] Heh. [03:39] Logging warnings is only useful if someone is watching the logs :) [03:41] Well, the theory would be that we could look back at the logs to figure out if there's any unupgraded clients left. [03:42] stub: But here's a 10-second, untested patch to enforce it: https://chinstrap.ubuntu.com/~dsilvers/paste/fileOMXlxG.html [03:45] spiv: exponential degradataion on the warnings :) [03:45] spiv: or for cuteness, have a web page on the librarian showing the old clients seen in the last day [03:46] lifeless: ...or, someone could grep the log files that are rsynced to chinstrap already. [03:46] spiv: I did mention cute didn't I ? [03:46] Even if it is the boring way :) [04:04] We don't want old clients. Bad enough tracking down bugs in uptodate clients. Just refuse to talk to them. === Ubugtu [n=bugbot@ubuntu/member/seveas] has joined #launchpad [04:58] lifeless: Can you install config manager into ~pqm/bin on balleny? (or tell me where to find it) === makaveli [n=nnn@c-69-139-7-167.hsd1.pa.comcast.net] has joined #launchpad [05:49] stub: "bzr branch http://www.robertcollins.net/config-manager/trunk/" [06:00] stub: would you be able to delete bugwatch id 353? It should have remotebug='-42' and bug=5723 [06:11] jamesh, how often are the Oops reports going to be sent? [06:12] mpt_: I had the script disabled while I was fixing it up to do a short summary to the list + long summary on the web [06:13] mpt_: I should have that going again today [06:13] great [06:26] jamesh: Deleted [06:26] stub: thanks [06:44] What's up with staging? [06:44] I get Bad Gateway errors for staging.ubuntu.com and staging.launchpad.net [06:46] the staging config might need updating [06:47] both bradb and daf added some required config keys that don't seem to be in configs/staging/launchpad.conf [06:47] (or production[12] ) [07:08] Merge to devel/launchpad/: [r=jamesh] Export GPG fingerprints in person/$name/+rdf, to make it easier for people to e.g. create GPG keyrings for a team. (r3098: Andrew Bennetts) === koke [n=koke@ubuntu/member/koke] has joined #launchpad [08:10] stub: ~/source/ has it all [08:10] lifeless: ta [08:10] (I've just been using ~pqm/bin) [08:15] hello [08:18] yo [08:19] stub: do you recall what the conflicts were in merging jamesh's __len__ stuff? [08:20] SteveA: Nope. I was busy trying to rollout at the time :) [08:22] SteveA: I'll be doing some cherry picks once a patch of mine lands and will check it out then === tambaqui [n=patricia@200-208-49-85-mns.cpe.vivax.com.br] has joined #launchpad === carlos [n=carlos@84.76.255.40] has joined #launchpad [08:31] morning [08:41] Merge to devel/launchpad/: [trivial] Make some config sections not required to ease maintenance (r3099: Stuart Bishop) [08:52] stub: for pqm I use that too [08:58] spiv: OOPS-39A13 is a __nonzero__, not a __len__, but jamesh's patch converts __nonzero__ to use a select-limit query rather than a count(). [09:02] howdy all [09:02] hi sivan [09:07] SteveA: I don't think the fix to make __nonzero__ not do a count might have missed the rollout [09:08] SteveA: my original __nonzero__() implementation was erroneously doing a count still [09:08] jamesh: yes, i think they both missed the rollout [09:08] jamesh: stub said he will look at getting the rest cherrypicked later [09:09] is __nonzero__ invoked on 'if foo:' ? [09:09] lifeless: yes [09:10] iirc, it will invoke __nonzero__ then __len__ then check if it is not None [09:13] Seveas: hello [09:21] SteveA: hi. do you have a minute to discuss a fix to bug 3796? [09:21] malone bug 3796 in malone "Duplicated bugs still show up as New in a list of bugs (also affects the Latest bugs portlet)" [Normal,Confirmed] http://launchpad.net/bugs/3796 [09:27] BjornT: yes, after a workrave [09:27] ok [09:30] BjornT: I filed https://launchpad.net/products/malone/+bug/30307 a little while ago. Does it sound like a good idea for searching? [09:30] malone bug 30307 in malone "omit_dupes and searching" [Normal,Unconfirmed] [09:32] BjornT: for bug 3796, i agree with you [09:32] malone bug 3796 in malone "Duplicated bugs still show up as New in a list of bugs (also affects the Latest bugs portlet)" [Normal,Confirmed] http://launchpad.net/bugs/3796 [09:33] BjornT: perhaps have self.status and self.display_status [09:33] where the latter is a computed property [09:38] SteveA: yes, that seems like a good idea. we were thinking of having self.status a property. that would avoid having to change all the call-sites, on the other hand it's more complicated. === doko [n=doko@217.205.109.249] has joined #launchpad [09:42] BjornT: we should keep the direct-to-database properties separately named from the computed ones [09:43] you can change all the callsites in an hour or two of work. many people can lose many hours debugging problems from a more complex system over the course of months. [09:43] jamesh: yeah, matching searches on dupes sounds like a good idea. [09:44] SteveA: true === fabbione [i=fabbione@gordian.fabbione.net] has joined #launchpad [09:50] lifeless: Where can I find the environment setup for using cm.py out of ~pqm/source ? Nothing seems setup in a sane path that I can find, and invoking cm.py directly from ~/source/config-manager can't find pybaz libraries for a start === stub gives up and rolls out untested cherry picks again [10:16] Morning === dous [n=dous@efreet.edu.ms] has joined #launchpad [10:19] SteveA, bon giorno [10:25] SteveA, I've gotta run, if it's important /msg or e-mail works too :) === Lorenzod [n=lorenzod@63.218.103.162] has joined #launchpad [10:30] jamesh: does the "Launchpad Errors" mail get sent before the report has been generated? the link in the mail is a 404 [10:31] BjornT: I had an error in the script. See the second email [10:32] jamesh: yeah, i saw that now [10:32] BjornT: should be reliable now, giving a short summary with the full HTMLised report linked [10:32] yep === irvin [n=irvin@ubuntu/member/irvin] has joined #launchpad === merriam [n=merriam@84.12.81.236] has joined #launchpad [10:41] morning folkies [10:56] Seveas: okay === doko [n=doko@217.205.109.249] has joined #launchpad === carlos [n=carlos@84-123-7-4.onocable.ono.com] has joined #launchpad [11:00] jamesh: it looks very good [11:00] jamesh: i'd like you to make a couple of changes [11:00] hard timeouts are far more important to fix than soft timeouts [11:01] yeah. [11:01] I'll split them out [11:01] also, i'd like to see soft timeouts arranged not in order of how many occurred [11:01] but instead in order of length of request [11:01] (if that is possible) [11:02] i don't know if that is how the soft timeout system works [11:03] also, at the top of the html, a table of contents, with #anchor links to the various sections [11:04] and perhaps a summary would be nice, like 88 timeouts, 25 soft timeouts, 87 programming errors, 1 attribute error, 4 value errors [11:04] it'd also be goot to work out some regexps that could be used to help group the SQL errors [11:05] we should aim to have no non-404 non-timeout errors. it is more useful to have non-404 and non-timeout errors ordered by the error type [11:05] than by frequency [11:05] (or number occurred, rather) [11:06] currently there is a regexp to replace the memory location used in many object's repr() with INSTANCE-ID, which helps with grouping similar OOPS reports [11:07] that doesn't really help for the ones where an SQL statement is included in the exception value [11:07] mpt_: please take a look at jamesh's summary report sometime, and create a stylesheet for it [11:10] stub: if you made a wee script that you can stick revision ids in, and get revision ids + logmessage out of, then your emails about what revisions got into production could be more informative without much extra effort. [11:12] re [11:12] hi Seveas [11:12] hi [11:13] i have a feature to request for Ubugtu. it isn't very useful for anyone (including you), except launchpad developers [11:13] the feature is for Ubugtu to listen for OOPS-oopscode [11:13] and show a URL to jamesh's oops-viewing cgi URL for that oops code [11:13] that [11:13] 's doable [11:14] what's the CGI url? [11:14] Seveas: make OOPS-[A-Z\d] + => https://chinstrap.ubuntu.com/~jamesh/oops.cgi/$OOPSID [11:14] SteveA, sure [11:15] lifeless: hi, could you take a look to PQM? my request is taking too long to be processed (more than 1 hour) and when I sent it, the queue was empty [11:16] jamesh: as the oops report is rather large, what do you think about splitting it into 4 or so pages? === stgraber [i=steph@xeon.stargate-server.com] has joined #launchpad [11:16] - hard timeouts [11:16] - soft timeouts [11:16] - 404s [11:16] - errors [11:16] with an index page pointing to each with a summary [11:17] SteveA: I suppose so. The alternative would be to remove some of the information [11:17] jamesh, that url needs authentication [11:17] i think the level of information is good [11:17] Seveas: yes. [11:18] Seveas: i was thinking just to display the URL, for ease of launchpad developers clicking on it from their irc client [11:18] ok === jamesh just uses a keyword bookmark [11:18] you're always ahead of the curve :-) [11:19] @reload Bugtracker [11:19] SteveA: is it useful to have the OOPS numbers categorised by URL, or do you think it would be as useful to just list them all together for the particular error? [11:19] Error: I tried to send you an empty message. [11:19] hmm [11:20] jamesh: displaying the URLs helps me understand what the OOPSes are about. [11:20] if the URLs are displayed, then the OOPSes may as well be categorized with them [11:21] SteveA: I wasn't suggesting removing the URLs, just changing it to display the URLs, then the OOPSs [11:21] OOPS-21312AD [11:21] https://chinstrap.ubuntu.com/~jamesh/oops.cgi/21312AD [11:21] almost all have just one URL, so i don't think the change is important either way right now [11:21] okay [11:22] SteveA, ok this way? [11:22] OOPS-39A13 [11:22] https://chinstrap.ubuntu.com/~jamesh/oops.cgi/39A13 [11:22] perfect! [11:22] thanks Seveas! [11:22] np [11:23] jamesh: the text that says "0% from search bots, 100% referred from local sites" is needed only for 404s in my opinion === WaterSevenUb [n=WaterSev@azevedo.astro.up.pt] has joined #launchpad === salgado [n=salgado@200-171-140-32.dsl.telesp.net.br] has joined #launchpad === cprov [n=cprov@200-171-140-32.dsl.telesp.net.br] has joined #launchpad [11:29] morning, hackers [11:30] good morning [11:30] salgado: there's a few shipit errors in jamesh's error report. some interesting not found errors, and some other application errors [11:31] https://chinstrap.ubuntu.com/~jamesh/oops.cgi/OOPS-38A65 <-- AttributeError [11:31] https://chinstrap.ubuntu.com/~jamesh/oops.cgi/38A65 [11:32] OOPS-38B59 <-- interesting NotFound error [11:32] https://chinstrap.ubuntu.com/~jamesh/oops.cgi/38B59 [11:33] jamesh: do you have shipit.ubuntu.com listed as a local site? [11:35] cprov, hello, you wanted to talk about Soyuz? [11:36] actually... mpt could put the css in his home on chinstrap, and jamesh's scripts could refer to it there in the html [11:36] mpt_: it was yesterday, wasn't it ? === ..[topic/#launchpad:SteveA] : launchpad.net | developer meeting: Thur 9 Feb, 1200UTC (wiki:MeetingAgenda) | launchpad-users@lists.canonical.com (wiki:MailingLists) | Channel logs: http://tinyurl.com/72w39 [11:36] mpt_: I'm happy with you decision (wait +build clean up land then discuss the content issues) [11:37] cprov: I think that getting the permission stuff sorted and the functionality sorted in the builds pages is more important than making them prettier [11:37] cprov: don't you? [11:38] cprov, my cleanup is done and waiting for (re-)review. That shouldn't be blocking us talking about anything else. [11:39] You can try the branch if you want. [11:40] Kinnison: uhm, personally I think the permission are ok, View is public, edit + cancel + mode are Edit and admin is Admin. What am I missing ? [11:40] cprov: erm, we need to get the launchpad-buildd-admins celebrity done and made able to do the admin work [11:40] cprov: otherwise we can't hand over to adam and lamont === Kinnison perhaps didn't communicate this well last week [11:41] Kinnison: right, good point. I almost forget this [11:41] :-) [11:41] adam and lamont won't :-) [11:44] mpt_: It's hard ... we have a lot of bugs but I can define myself those who needs UI efforts, the simplest thing to do is some triage on soyuz bug recently added, would you do it for me ? [11:47] cprov: we can ask daf and matsubara to focus on soyuz bug triage for a while [11:47] SteveA: good idea, I'll ask them, thx === SteveA wonders if daf is around yet === seb128 [n=seb128@ubuntu/member/seb128] has joined #launchpad [11:48] launchpad keep Oopsing today, is that known? [11:48] ie: OOPS-39A244 [11:48] https://chinstrap.ubuntu.com/~jamesh/oops.cgi/39A244 [11:49] seb128: thanks. probably a regression in the rollout. i'll look into it [11:49] seb128: did you *just now* get that oops? [11:49] Kinnison: bug 3580, is the begin of buildd celebrity [11:49] malone bug 3580 in launchpad-buildd "Missed Launchpad Celebrity for Auto Build System" [Major,Unconfirmed] http://launchpad.net/bugs/3580 [11:49] if so, i'll need to wait a short while until it is visible on chinstrap [11:50] cprov: right [11:50] yep [11:51] cprov: I've added a note to that about the team in production [11:51] seb128: okay, i see it now. this OOPS is to do with contention with people concurrently updating a bug. [11:51] stub is working on a solution to that issue in general, which will be ready soon [11:51] I get timeout error too, like OOPS-39B202 [11:51] Kinnison: right [11:51] https://chinstrap.ubuntu.com/~jamesh/oops.cgi/39B202 [11:51] eh? [11:52] stub: are you not working on retries? [11:52] Oh - serialization exceptions. es [11:52] y [11:52] exactly [11:53] i didn't know the right name for it :-) [11:54] salgado: the person vocabulary search stuff -- how is that going? i think that's what OOPS-39B202 is about [11:54] https://chinstrap.ubuntu.com/~jamesh/oops.cgi/39B202 [11:56] stub: carlos would like pqm live again [11:56] stub: are you finished ? [11:56] SteveA, yes, that's the vocab timing out. it was probably caused by contention. [11:56] Oops. Yup. [11:56] SteveA, I tried it two times here. the first it timed out and the second it run pretty fast [11:56] lifeless: reenabled [11:56] timeout OOPS-39B214 ... [11:56] https://chinstrap.ubuntu.com/~jamesh/oops.cgi/39B214 [11:57] salgado: timeout problems with contention are an issue. we can't automatically retry these, because it will take 1 minute to get a response [11:58] salgado: you have been working on a 2-stage query for this, right? [11:58] serialization issues should not be confused with locks being held open by other processes. serialization issues are expected to happen and we need to cope. locks being help open by other processes are bugs that need to be dealt with individually === matsubara [n=matsubar@200-171-140-32.dsl.telesp.net.br] has joined #launchpad === SteveA waits until rsync processes seb128's most recent OOPS [12:00] good morning! [12:00] lifeless: oh, is it down? didn't know :-P [12:00] stub: do you know if elmo changed the rsync of OOPS reports and other logs to be more selective about what it processes? [12:00] SteveA, no, what I did was to make all vocabs not fetch all the results at once, but instead fetch only the results of the batch they're displaying [12:00] SteveA: No idea. === jinty [n=jinty@196-28-47-56.jhb.netdial.co.za] has joined #launchpad [12:00] carlos: stub disabled it during prod rollout testing [12:01] carlos: and forgot to undisable [12:01] salgado: okay. did you discuss with people an approach of making two queries, one direct and one broader? [12:02] salgado: OOPS-39B214 would benefit from exactly this approach [12:02] https://chinstrap.ubuntu.com/~jamesh/oops.cgi/39B214 [12:02] SteveA, something like bug 2045? [12:02] https://launchpad.net/products/launchpad/+bug/2045 [12:03] because in this case, the long query was a search for a person matching 'iwj' [12:03] this could be matched instantly on person.name === Mez [n=Mez@ubuntu/member/mez] has joined #launchpad [12:05] morning matsubara :) === carlos_ [n=carlos@84.76.255.40] has joined #launchpad [12:05] salgado: bug 2045 is part of it, yes === thisfred [n=thisfred@a80-127-80-154.adsl.xs4all.nl] has joined #launchpad [12:08] salgado: when we're entering names into a form, i think a launchpad-name or launchpad-email-address search would be sufficient. [12:09] I definitely agree [12:09] what do we need to do to make this change? [12:09] this would remove a whole bunch of timeouts for the distro team [12:10] well, I told you I was waiting for some input on that bug [12:10] nobody ever commented on it [12:10] if that happens again, add it to the weekly meeting agenda [12:10] for that reason I haven't checked what's needed to make that change. [12:11] I don't see OOPS-39B214 benefitting from doing more queries. The slow query was just a select on the person and validpersonorteamcache tables (with an unnecessary join with the emailaddress table) [12:11] https://chinstrap.ubuntu.com/~jamesh/oops.cgi/39B214 [12:11] if you have some time to discuss this now, it'd be great [12:11] stub, maybe you can discuss it with salgado? [12:12] seeing as you already commented on the bug before [12:12] and you proposed exactly "Would it make sense for the search() method to only search on exact matches for email address?" [12:14] Merge to devel/launchpad/: [r=spiv] Allow admins, rosetta experts and product owners to edit translations if using CLOSED/STRUCTURED mode. (r3100: Carlos Perell Marn) [12:14] dilys: thanks ;-) [12:28] salgado: For some reason, ILIKE is no longer hitting the index. Changing the query to do """ lower(email) LIKE 'iwj' || '%' """ again hits the indexes and runs fast (50ms) [12:28] ouch [12:29] salgado: Want me to shove that through with a [trivial] ? I have a branch free [12:30] stub, that'd be great [12:31] stub, do you think it's worth leaving a comment there saying that we shouldn't use ILIKE because it might not hit the index? === dous is now known as suodla === lbm [n=lbm@x1-6-00-13-10-7a-d1-e4.k233.webspeed.dk] has joined #launchpad [12:31] salgado: Sure. [12:37] daf, around? [12:38] the link to the oops page from https://launchpad.net/products/launchpad/+bug/30807 is broken [12:38] malone bug 30807 in launchpad "Links to a oops" [Normal,Unconfirmed] [12:38] matsubara: hi [12:38] matsubara: i just had a phone call with daf about the process we will use to take OOPS reports from jamesh's report and users' reports, and process these into bugs with a particular milestone. [12:39] daf is going to write this up today, and talk with you about it, a bit later [12:39] salgado: yeah, I just noticed [12:39] SteveA: ok, we scheduled a meeting every day around 16:00 utc [12:39] stub: my code assumes that the configuration value ends with a slash [12:39] two of the most important QA tasks at the moment are to respond initial bug reports in some way, and to keep on top of oopses [12:40] daf: eh? [12:40] SteveA: also cprov asked me to take special attention to soyuz bugs [12:40] stub: the configuration value oops_root_url [12:41] Oh - ok. I'll fix that now. [12:41] it's a bug, but changing the config will work around it [12:41] matsubara: yes. seeing as we've just rolled out soyuz, you and daf should pay particular attention to soyuz bugs, so that cprov and others have good information about what needs fixing. === irvin [n=irvin@ubuntu/member/irvin] has joined #launchpad [12:42] carlos, have you seen bug 3176? we just got two duplicates of it [12:42] malone bug 3176 in launchpad "Error when trying to save AbiWord pt-BR translations" [Normal,Confirmed] http://launchpad.net/bugs/3176 [12:42] daf: I generally use urllib.join [12:42] SteveA: I'll put up a wiki page outlining what we discussed [12:42] erm... urllib.urljoin [12:42] daf: thanks [12:42] SteveA: all right. [12:43] stub: ok, I'll do a [trivial] merge with that, assuming the tests still pass [12:43] daf: ideally, this needs an additional test [12:43] salgado: WTF... [12:43] salgado: thanks, I will take a look. btw, the OPPS link you gave is broken [12:44] SteveA: oh, good point [12:44] carlos, no, I didn't give any link [12:44] oh, is it a new malone feature? [12:44] carlos, it's the code that turns the oops code into a link that is broken [12:44] then I guess it's broken... [12:44] yeah [12:44] carlos: yes. will be fixed in a few minutes [12:44] yes, it was cherry picked today [12:45] SteveA: did you see https://launchpad.net/products/launchpad/+bug/30746? [12:45] malone bug 30746 in launchpad "LaunchBag.developer is not updated when ftest login() is called" [Normal,Unconfirmed] [12:45] carlos: with a config change to work around the problem [12:45] daf: no, i didn't. [12:45] i guess it should do [12:45] ok [12:45] we should use events more for logging in etc. but i'll look into that later. [12:45] any reasonable fix will do for now [12:46] well, I worked around it, it's an infrastructure thing [12:47] jamesh: did you get my mail this morning ? [12:47] Merge to devel/launchpad/: [trivial] improve oops analysis script to generate html too (r3101: James Henstridge) [12:47] salgado: that problem is already fixed at rocketfuel [12:48] ahhh, cool [12:48] salgado: I rewrote that class and the new version seems like fixed it as a side effect [12:48] salgado: thanks anyway, I'm going to note that on that bug report === SteveA --> lunch and exercise [12:49] salgado: which bugs are the duplicated ones that you told me? [12:50] carlos, don't remember, but I've marked them as dupes [12:51] hmm I don't see that information on the bug report you gave me.. [12:51]