[12:09] <bradb_> Keybuk, jbailey: dudes?
[12:09] <Keybuk> we're in the chairs, come! :p
[12:09] <bradb_> oh, ok
[12:22] <bradb_> salgado: we fixed that problem with "bugs I reported" showing fixed bugs, right?
[12:23] <uws> bradb_: Thanks for fixing the  +bugs -> +bugs-all  instead of  +bugs -> +bugs-open  issue
[12:35] <salgado> bradb_, yes, it's fixed on this branch I'm working on right now
[01:04] <alessio> alessio Launchpad does not currently support validation of sign-only GPG keys. If you add an encryption subkey (using gpg --edit-key) and upload your key again, you should be able to import the key.
[01:04] <alessio> alessio bu i have done a subkey
[01:04] <alessio> alessio and i have resend he key
[01:04] <alessio> alessio a subkey of this type  (6) RSA (encrypt only)
[01:04] <alessio> can anyone help me?
[03:41] <bradb_> stub: I want to try optimizing the privacy query. Where can I get a dump of staging or prod to try some stuff out?
[03:50] <bradb_> Hey, that's what an empty bug search should do, perhaps.
[03:50] <kiko> ahoy
[03:50] <bradb_> i.e. suggest that maybe you want to _File a Bug_
[03:51] <kiko> well
[03:51] <bradb_> a cheap guided bug form
[03:51] <kiko> hmm
[03:55] <jordi> so, kiko
[03:55] <jordi> where were you at 6:30 man
[03:56] <kiko> buying cocaine
[04:00] <jamesh> jordi: he probably went without you when you didn't turn up at 4:15
[04:01] <jordi> kiko: got any left?
[04:05] <stub> kiko: Run gina just against breezy?
[04:06] <stub> bradb_: If you can give me any suspect SQL queries, I'll have a look at it. In many cases I have been able to fix the issue by creating specific indexes or reordering the query slightly.
[04:06] <Kinnison> I made a luvley generic system we could use for that if only we had a gajillion CPUs
[04:10] <Kinnison> kiko, dude, gina tests fail on my laptop
[04:10] <Kinnison> can you come and help me debug them
[04:13] <kiko> Kinnison, yeah. what did you change in her?
[04:14] <Kinnison> kiko: not touched her
[04:15] <Kinnison> kiko: I've been fiddling with distrorelease though
[04:16] <kiko> weird.
[04:16] <kiko> ok
[04:16] <kiko> what's the error?
[04:16] <Kinnison> aha, I think you're calling distroreleaseset.new
[04:17] <kiko> yeah, look at the first error
[04:17] <Kinnison> s'hard when they fly by fast
[04:17] <kiko> Kinnison, | less
[04:19] <kiko> tttttted
[04:20] <bradb_> stub: mailed. this speed issue is fairly critical.
[04:25] <Kinnison> stub: can I get a db patch reviewed please?
[04:25] <stub> bradb_: That query runs in 0.2ms. I already recall having optimized it. Either there are other dud queries on that page, or (as I suspect) way too many queries are being executed causing cumulative time. Last time I looked at it, there were hundreds of DB queries being executed.
[04:25] <stub> Kinnison: paste please
[04:25] <Kinnison> ALTER TABLE DistroRelease DROP COLUMN Components;
[04:25] <Kinnison> ALTER TABLE DistroRelease DROP COLUMN Sections;
[04:25] <Kinnison> -- END
[04:25] <bradb_> stub: did you change BugTask.assignee = ... to MOTU's id?
[04:25] <stub> bradb_: Batching will be the big win
[04:25] <stub> bradb_: I'll try that
[04:26] <stub> bradb_: That takes 73ms.
[04:26] <stub> bradb_: Not a problem
[04:26] <Kinnison> stub: ^^
[04:27] <stub> Kinnison: If we drop those columns, do we need the tables they reference?
[04:27] <kiko> bradb_, look at your postgresql logs
[04:27] <Kinnison> they reference SCHEMA
[04:27] <kiko> for a reload
[04:28] <stub> Kinnison: Ok. Approved. patch-25-54-0.sql
[04:29] <bradb_> stub: What kind of profiling data get you can get back from a request to a given URL logged in as a given user?
[04:29] <bradb_> I'd like to be shown something that gives an idea of exactly where time is being spent
[04:29] <Kinnison> stub: thanks dude
[04:31] <stub> bradb_: Don't know I'm afraid. We can extract logs of queries and their durations, but that is only the DB side (and a pita to do on production, but we throught of a way to make it easier that will be implemented soon)
[04:38] <stub> bradb_: I think that if you are displaying 100 bugs, it is issuing 100 seperate db queries to display the assignees name.
[04:38] <kiko> stub, bradb_: if that is the case, we should probably create a view for it.
[04:38] <stub> bradb_: Which could be done in a single query, but I don't know how easy to refactor the python to do it.
[04:39] <stub> Or just issue 'SELECT displayname, surname, givenname from person where id in ( [comma seperated list of assignee ids]  )'
[04:39] <kiko> bradb_, a simple view with a single extra column can work wonders for you. it's a bit of database class overhead though.
[04:39] <kiko> it did solve serious problems in soyuz though.
[04:40] <kiko> (one year ago)
[04:41] <zyga> carlos: ping
[04:41] <zyga> carlos: in #u-desktop if you could
[04:43] <spiv> sub   4096g/8CF9CA35 2005-11-05 [expires: 2007-11-05] 
[04:46] <sivang> lifeless: do you think you will have time to do the twisted framework BOF today? (just trying to find out if not, and use that time for something else ;-) )
[05:16] <lifeless> sivang: probly not, 
[06:12] <Kinnison> kiko: publishing run on drescher finished
[06:12] <Kinnison> kiko: I'm almost ready to try another run, do you mind?
[06:14] <kiko> Kinnison, not at all -- do you need to run it again though?
[06:14] <kiko> and why, if you do?
[06:25] <SteveA> kiko: ping
[06:27] <kiko> what?
[06:27] <kiko> SteveA, tell me everyting
[06:27] <kiko> and everything
[06:30] <Kinnison> kiko: because I'm fixing bugs as I go
[06:31] <kiko> oh
[06:31] <kiko> sure
[06:31] <kiko> ok
[06:37] <Kinnison> mdz: Once this run is done it'd be nice if you can have a look at the archive
[06:37] <Kinnison> mdz: do you have a login on drescher?
[06:37] <mdz> Kinnison: I will find out if I do
[06:37] <mdz> Kinnison: no, I don't
[06:39] <Kinnison> and irritatingly we don't seem to export the archive over http
[06:39] <Kinnison> Do you want to poke elmo or shall I?
[06:39] <SteveA> hi kiko. i 'm up on reception with jane, with phone reception in case claire calls.
[06:39] <fabbione> hey guys
[06:39] <SteveA> i'm doing ddaa's code review up here
[06:40] <kiko> SteveA, oh, ok.
[06:40] <fabbione> sorry if i don't remember, but who is in charge of teams and people?
[06:40] <kiko> fabbione, it's salgado
[06:40] <Kinnison> kiko: almost time to run apt-ftparchive :-)
[06:40] <fabbione> kiko: ok
[06:40] <fabbione> salgado: ping?
[06:40] <Kinnison> kiko: assuming it runs :-)
[06:40] <salgado> fabbione, pong
[06:41] <fabbione> salgado: yo. are you busy?
[06:42] <salgado> fabbione, I'm finishing some changes I started yesterday. have something for me?
[06:44] <fabbione> salgado: i need to unroll a loop
[06:44] <fabbione> and understand how to assign pkgs to a team
[06:45] <salgado> fabbione, where are you now?
[06:45] <kiko> fabbione, because you want bugs to be filed on them?
[06:45] <kiko> if so, it's not so trivial because the maintainer is inferred from the package maintainer field
[06:49] <fabbione> sabdfl: i am one of the small rooms hidden behind the bar
[06:49] <fabbione> ops
[06:49] <fabbione> ^^ salgado
[06:49] <fabbione> kiko: well there are several minor changes i would like to see there to manually associate pkgs to maintainers
[06:49] <kiko> yeah
[06:49] <fabbione> kiko: but there is still a loop that needs to be unrolled
[06:49] <kiko> that needs fixing definitely
[06:49] <fabbione> for ex:
[06:49] <fabbione> group foo can upload to main
[06:49] <fabbione> group bar manages only a strict subset of pkgs in main
[06:50] <fabbione> some people in group bar do not have full main upload privileges
[06:50] <fabbione> now
[06:50] <Kinnison> fabbione: Not currently supported
[06:50] <fabbione> in order for group bar to upload to main
[06:50] <fabbione> group bar needs to be part of foo
[06:50] <fabbione> (read foo as ubuntu-core-devel)
[06:51] <fabbione> so how can we make this to work?
[06:51] <Kinnison> Currently we can't
[06:51] <Kinnison> we've spoken about having more granular upload privs
[06:51] <fabbione> Kinnison: ok
[06:51] <Kinnison> we don't currently have them
[06:51] <fabbione> is there a spec or plan to do it?
[06:51] <fabbione> or is it all handwaving
[06:51] <fabbione> ?
[06:51] <Kinnison> check out https://wiki.launchpad.canonical.com/UploadPrivileges
[06:51] <fabbione> Kinnison: thanks
[06:52] <fabbione> Kinnison: make sense :)
[06:53] <Kinnison> fabbione: cool
[06:54] <fabbione> what about the manual link between pkgs and maintainers (people/team)?
[06:54] <Kinnison> Anyone on the review team want a small review?
[06:54] <kiko> not done either
[06:55] <fabbione> kiko: same question.. is there a spec/plan or is it still handwaving?
[06:56] <fabbione> Kinnison: go ahead and send it here
[06:56] <kiko> fabbione, that is missing a spec, I believe.
[06:56] <Kinnison> fabbione: erm, I meant the launchpad code-reviews team :-)
[06:56] <fabbione> kiko: i assume you are going to work on it :P
[06:56] <fabbione> Kinnison: ehehe ok :)
[06:56] <Kinnison> fabbione: feel free to do the review if you want
[06:56] <fabbione> kiko: (specially if you want to wake up tomorrow ;))
[06:56] <kiko> Kinnison, I can review
[06:57] <kiko> fabbione, I could, but probably npw
[06:57] <kiko> not
[06:57] <Kinnison> kiko: Cool, you want to come over and do it here, or do you want a diff
[06:57] <fabbione> Kinnison: nah.. i don't have enough background to do it..
[06:57] <Kinnison> kiko: it'll take a while before jamesh's scripts catch up to it
[06:57] <kiko> Kinnison, I'll walk over
[06:58] <Kinnison> kiko: coolio
[06:59] <Kinnison> kiko: I'll yell when I have the diff ready
[06:59] <jamesh> Kinnison: it runs once an hour right now
[07:00] <Kinnison> jamesh: oooh
[07:00] <Kinnison> jamesh: cool
[07:00] <Kinnison> jamesh: it's that quick?
[07:00] <Kinnison> jamesh: on the hour?
[07:01] <stub> SteveA: ping
[07:01] <stub> SteveA: Guy looking for a laptop
[07:01] <jamesh> Kinnison: there isn't that many branches on the page, which contributes to the speed ...
[07:03] <Kinnison> jamesh: so when does it run?
[07:05] <jamesh> Kinnison: the run date is at the top of the page
[07:06] <jamesh> it is part way through a run right now
[07:07] <Kinnison> oh well
[07:07] <Kinnison> so I lose
[07:08] <sivang> 17:34 < zyga> I've updated my /usr/share/applications
[07:08] <sivang> 17:34 < zyga> I'll restart to check if the startup is notacibly slower
[07:08] <sivang> 17:34 < zyga> brb
[07:08] <sivang> oops
[07:08] <sivang> sorry
[07:08] <zyga> sivang: ?
[07:08] <zyga> np
[07:09] <sivang> my touchpad seem to get crazy
[07:15] <SteveA> SteveA: right now?
[07:16] <SteveA> stub: right now?
[07:17] <SteveA> stub: i'm in muguet if anyone wants to talk with me
[07:31] <stub> SteveA: https://chinstrap.ubuntu.com/~dsilvers/paste/fileTaEgiU.html
[07:31] <stub> Doit bitch
[07:33] <elmo> mdz/kiko: done
[07:34] <kiko> thanks elmo rocking as usual
[08:03] <mdz> elmo: zsh on drescher would be lovely
[08:11] <janimo> can external SVN projects be imported in launchpad only if the yhave coressponding packages in ubuntu?
[08:12] <kiko> darn. the answer was no.
[08:13] <kiko> janimo, the answer is no. you just need to register the product.
[08:13] <kiko> and talk to jblack or lifeless 
[08:13] <janimo> kiko,  thanks.
[08:15] <janimo> so I talk to them before/after/instead of filling out the import forms for the product?(xfce alreday regsitered just not tracked)
[08:15] <kiko> janimo, you can do it aftrwards
[08:18] <janimo> any ETA on the switch to bzr?
[08:22] <kiko> Kinnison, ping?
[08:22] <kiko> janimo, it is done
[08:22] <kiko> can somebody get me Kinnison?
[08:41] <Kinnison> no
[08:49] <kiko> now I need stub
[08:50] <kiko> janimo, but not for imports, sorry -- so you'll get baz for now, and bzr afterwards
[09:07] <janimo> kiko,  any idea when bzr will be here for imports too?
[09:13] <bradb_> kiko: dude, i just thought of something.
[09:13] <bradb_> why do we even need the "Request fix:" links?
[09:14] <kiko> bradb_, hmmm. why wouldn't we?
[09:14] <bradb_> the fact that I've added release targeting and null bugtask fu seems to allow their disappearance entirely. i have serious doubts that *anyone* would notice their disappearance :)
[09:14] <bradb_> the only feedback i've gotten about them thus far is "what are these for?"
[09:15] <kiko> bradb_, do you understand how much pain you are inviting by changing that part of the page?
[09:16] <bradb_> kiko: basically you're saying you don't think the sab will buy into it?
[09:16] <bradb_> kiko: can you give an example of a non-contrived use case for those links?
[09:16] <SteveA> bradb_: fix other things first
[09:17] <kiko> bradb_, I'm saying that area is an area which is controversial. I'd stay away from there
[09:17] <bradb_> kiko: right
[09:18] <kiko> stub!
[09:18] <stub> kiko: still here
[09:18] <kiko> how are you doing?
[09:18] <kiko> stub, I'll need a gina run soon
[09:19] <stub> kiko: ok
[09:19] <kiko> stub, we missed the backports pockets.
[09:19] <Mez> ...?
[09:21] <stub> kiko: You have new code, or should I just run the existing code on staging?
[09:21] <kiko> stub, I will have new code -- I need to add it to a dbschema.
[09:21] <kiko> it does mean waiting for PQM
[09:22] <stub> kiko: Can you update the staging config too in your commit?
[09:23] <kiko> stub, hmmm. yes, I think I can
[09:23] <Mez> is this the new soyuz stuff being put into place then?
[09:24] <kiko> Mez, in testing, but yes
[09:24] <kiko> oh, that's right Mez -- you're the backports dude
[09:24] <kiko> so I forgot your pocket
[09:24] <kiko> adding it :)
[09:28] <elmo> mdz: done
[09:29] <Mez> but *shrusg*
[09:34] <Mez> https://staging.ubuntu.com/+builds/+build/134165
[09:36] <kiko> Mez, is that a system error?
[09:41] <Mez> yes
[09:51] <Mez> hmm
[09:51] <Mez> the packages are a lil borked
[09:51] <Mez> https://staging.ubuntu.com/distros/ubuntu/breezy/+package/k3b-mp3
[09:51] <Mez> k3b-mp3
[09:51] <Mez> click on i386
[09:51] <Mez> https://staging.ubuntu.com/distros/ubuntu/breezy/i386/k3b-mp3/0.12.2-0ubuntu2
[09:51] <Mez> and it says it's  k3blibs-dev
[09:51] <mdz> elmo: you are my hero
[09:54] <Mez> in fact - they all show as k3blibs-dev
[09:54] <Mez> and I guess in other packages they show as the last package there
[10:29] <Kinnison> is launchpad's extra slowness a known-issue right now?
[10:29] <Kinnison> Or is it my laptop being shit?
[10:33] <Kinnison> bug 3256, has it been updated?
[10:33] <Ubugtu> Error: I cannot access this bug
[10:33] <Kinnison> apparently not
[10:33] <Kinnison> bug 3256, has it been updated now?
[10:33] <Ubugtu> Malone bug #3256: distrorelease needs component/section cleaning up Fix req. for: launchpad (upstream), Severity: Normal, Assigned to: Daniel Silverstone, Status: Fixed http://launchpad.net/malone/bugs/3256
[10:33] <Kinnison> huzzah
[10:33] <Kinnison> took long enough
[10:34] <stub> SteveA: https://chinstrap.ubuntu.com/~dsilvers/paste/filed0pgBI.html
[10:46] <bradb_> stub: Can we do a new rollout if/when my patch lands? (currently #1 in pqm's queue) It will hopefully fix the +assignedbugs problem.
[10:46] <stub> bradb_: ok, although I'd like to wait until I can land mine too. Are people here waiting to see it?
[10:47] <stub> Of course, that involves someone poking SteveA until he looks at that paste
[10:53] <carlos> jordi, ping!
[11:12] <kiko> ddaa, can you put off running baz-import until tomorrow night? PQM is really really slow atm
[11:12] <kiko> and I have some critical fixes to land for the archive side of things
[11:12] <kiko> ddaa, are you running for all your branches, and is it close to ending?
[11:13] <ddaa> yes, yes, no idea
[11:13] <ddaa> I think I should just nice it
[11:13] <kiko> if you could
[11:14] <SteveA> nice won't help
[11:14] <SteveA> it is IO bound
[11:14] <spiv> ddaa: nice sadly doesn't help with io contention.
[11:14] <SteveA> not cpu bound
[11:15] <kiko> ionice?
[11:15] <ddaa> bah... I just suspended it
[11:15] <ddaa> when can I start it again?
[11:17] <kiko> ddaa, tomorrow evening?
[11:17] <kiko> pleeeeze
[11:21] <Keybuk> meh @ topic ?
[11:21] <kiko> hmmm
[11:21] <salgado> bradb_, did that branch of yours that was on pqm a few minutes ago got merged?
[11:21] <bradb_> salgado: NOPE
[11:22] <kiko> failure
[11:22] <bradb_> salgado: It's resubmitted
[11:23] <salgado> bradb_, I don't understand why you wrote this fix. you saw that I already have it on my branch. kiko is reviewing it
[11:24] <bradb_> salgado: ? I told you in the room a few hours ago that I was working on it. If I would have saw that you added batching to +assignedbugs, rest assured I wouldn't have added it. :)
[11:25] <salgado> bradb_, I changed the whole +assignedbugs to use the same base view class and macros that are used in the bug listings of products/distro/distroreleases
[11:26] <salgado> so, yes, they have batching
[11:26] <uws>  "batching"  == cutting a list in pieces/subpages ?
[11:26] <salgado> I thouhgt you were changing those macros and not the +assignedbugs
[11:26] <salgado> uws, yes
[11:41] <bradb_> salgado: this was the reason i couldn't continue working with you to land the targetnamecache stuff. sorry for the confusion.
[11:50] <salgado> bradb_, no worries. I've seen your diff already, and it looks like it won't be too much trouble to solve the conflicts
[11:51] <bradb_> ok, that's good to hear :)