[12:09] Keybuk, jbailey: dudes? [12:09] we're in the chairs, come! :p [12:09] oh, ok === bradb_ is currently assigned to watching jdub's laptop. We'll come over shortly. === koke [n=koke@66.103.220.192] has joined #launchpad === zyga [n=zyga@2-mi2-1.acn.waw.pl] has joined #launchpad [12:22] salgado: we fixed that problem with "bugs I reported" showing fixed bugs, right? [12:23] bradb_: Thanks for fixing the +bugs -> +bugs-all instead of +bugs -> +bugs-open issue === smurfix_ [n=smurf@debian/developer/smurf] has joined #launchpad === corey_ [n=corey@209.104.102.193] has joined #launchpad === carlos_ [n=carlos@209.104.102.193] has joined #launchpad === __keybuk [n=scott@209.104.102.193] has joined #launchpad === mez_ [n=Mez@209.104.102.193] has joined #launchpad === einheit_ [n=steve@209.104.102.193] has joined #launchpad [12:35] bradb_, yes, it's fixed on this branch I'm working on right now === smurfix_ is now known as smurf === koke [n=koke@209.104.102.193] has joined #launchpad === Keybuk [n=scott@209.104.102.193] has joined #launchpad === corey_ is now known as Burgundavia === fabbione [i=fabbione@66.103.220.245] has left #launchpad ["Leaving"] === camilotelles [n=Camilo@20132194128.user.veloxzone.com.br] has joined #launchpad === bradb_ [n=bradb@209.104.102.193] has joined #launchpad === jamesh [n=james@209.104.102.193] has joined #launchpad === Mez [n=Mez@66.103.220.192] has joined #launchpad === spiv_ [n=andrew@209.104.102.193] has joined #launchpad === smurfix_ [n=smurf@debian/developer/smurf] has joined #launchpad === smurfix_ is now known as smurf === einheit_ [n=steve@209.104.102.193] has joined #launchpad === cprov [i=9ecd60c3@66.103.220.196] has joined #launchpad === vasi [n=vasi@modemcable032.248-37-24.mc.videotron.ca] has joined #launchpad === vasi [n=vasi@modemcable032.248-37-24.mc.videotron.ca] has joined #launchpad === TinMan [n=Lotus@cpe-66-65-244-241.nycap.res.rr.com] has joined #launchpad === lamont [n=lamont@66.103.220.193] has joined #launchpad === Mez [n=Mez@66.103.220.192] has joined #launchpad === zyga [n=zyga@2-mi2-1.acn.waw.pl] has joined #launchpad === Mez [n=Mez@66.103.220.192] has joined #launchpad === heyko_ [n=heyko@tor/session/x-00859d9771cff3f6] has joined #launchpad === zygis [n=zygis@clt-84-32-129-122.dtiltas.lt] has joined #launchpad === dewd [n=dewd@201.29.123.206] has joined #launchpad === matsubara [n=matsubar@200-161-81-84.dsl.telesp.net.br] has joined #launchpad === alessio [n=alessio@host219-10.pool8249.interbusiness.it] has joined #launchpad [01:04] 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 bu i have done a subkey [01:04] alessio and i have resend he key [01:04] alessio a subkey of this type (6) RSA (encrypt only) [01:04] can anyone help me? === ajmitch [n=ajmitch@port161-157.ubs.maxnet.co.nz] has joined #launchpad === lbm [n=lbm@x1-6-00-13-10-7a-d1-e4.k233.webspeed.dk] has joined #launchpad === Seveas [n=seveas@ubuntu/member/seveas] has joined #launchpad === stub [i=stub@sweep.bur.st] has joined #launchpad === lamont [n=lamont@66.103.220.244] has joined #launchpad === camilotelles [n=Camilo@20132194128.user.veloxzone.com.br] has joined #launchpad === Keybuk [n=scott@66.103.220.201] has joined #launchpad === cprov [i=a87f6d11@66.103.220.196] has joined #launchpad === fabbione [i=fabbione@66.103.220.245] has joined #launchpad === matsubara is now known as matsubara-lunch === smurfix_ [n=smurf@debian/developer/smurf] has joined #launchpad === smurfix_ is now known as smurf === BjornT [n=bjorn@209.104.102.193] has joined #launchpad === carlos [n=carlos@66.103.220.223] has joined #launchpad === __keybuk [n=scott@209.104.102.193] has joined #launchpad === einheit_ [n=steve@209.104.102.193] has joined #launchpad === jamesh [n=james@66.103.220.242] has joined #launchpad === bradb_ [n=bradb@66.103.220.229] has joined #launchpad === BjornT_ [n=bjorn@66.103.220.247] has joined #launchpad === einheit_2 [n=steve@66.103.220.155] has joined #launchpad === stub [i=stub@sweep.bur.st] has joined #launchpad [03:41] stub: I want to try optimizing the privacy query. Where can I get a dump of staging or prod to try some stuff out? === bradb_ adds batching meanwhile === matsubara-lunch is now known as matsubara === kiko [n=kiko@66.103.220.210] has joined #launchpad [03:50] Hey, that's what an empty bug search should do, perhaps. [03:50] ahoy [03:50] i.e. suggest that maybe you want to _File a Bug_ [03:51] well [03:51] a cheap guided bug form [03:51] hmm [03:55] so, kiko [03:55] where were you at 6:30 man [03:56] buying cocaine [04:00] jordi: he probably went without you when you didn't turn up at 4:15 === sabdfl [n=mark@pdpc/supporter/silver/sabdfl] has joined #launchpad [04:01] kiko: got any left? [04:05] kiko: Run gina just against breezy? [04:06] 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. === Kinnison pouts [04:06] I made a luvley generic system we could use for that if only we had a gajillion CPUs === stub runs gina on staging against breezy [04:10] kiko, dude, gina tests fail on my laptop [04:10] can you come and help me debug them === Kinnison wants to have a clean branch to merge [04:13] Kinnison, yeah. what did you change in her? === salgado [n=salgado@66.103.220.225] has joined #launchpad [04:14] kiko: not touched her [04:15] kiko: I've been fiddling with distrorelease though [04:16] weird. [04:16] ok [04:16] what's the error? [04:16] aha, I think you're calling distroreleaseset.new === Keybuk [n=scott@209.104.102.193] has joined #launchpad [04:17] yeah, look at the first error [04:17] s'hard when they fly by fast [04:17] Kinnison, | less === Kinnison teeeed 'em [04:19] tttttted [04:20] stub: mailed. this speed issue is fairly critical. [04:25] stub: can I get a db patch reviewed please? [04:25] 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] Kinnison: paste please [04:25] ALTER TABLE DistroRelease DROP COLUMN Components; [04:25] ALTER TABLE DistroRelease DROP COLUMN Sections; [04:25] -- END [04:25] stub: did you change BugTask.assignee = ... to MOTU's id? [04:25] bradb_: Batching will be the big win [04:25] bradb_: I'll try that [04:26] bradb_: That takes 73ms. [04:26] bradb_: Not a problem [04:26] stub: ^^ [04:27] Kinnison: If we drop those columns, do we need the tables they reference? [04:27] bradb_, look at your postgresql logs [04:27] they reference SCHEMA [04:27] for a reload [04:28] Kinnison: Ok. Approved. patch-25-54-0.sql [04:29] 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] I'd like to be shown something that gives an idea of exactly where time is being spent [04:29] stub: thanks dude === WaterSevenUb [n=WaterSev@195-23-220-220.net.novis.pt] has joined #launchpad [04:31] 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) === bradb_ wonders if it's the security checking code === Nafallo_away is now known as Nafallo [04:38] bradb_: I think that if you are displaying 100 bugs, it is issuing 100 seperate db queries to display the assignees name. [04:38] stub, bradb_: if that is the case, we should probably create a view for it. [04:38] 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] Or just issue 'SELECT displayname, surname, givenname from person where id in ( [comma seperated list of assignee ids] )' [04:39] 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] it did solve serious problems in soyuz though. [04:40] (one year ago) [04:41] carlos: ping [04:41] carlos: in #u-desktop if you could [04:43] sub 4096g/8CF9CA35 2005-11-05 [expires: 2007-11-05] === spiv wonders how that got pasted. [04:46] 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 ;-) ) === mdz [n=mdz@66.103.220.206] has joined #launchpad === ddaa [n=ddaa@209.104.102.193] has joined #launchpad [05:16] sivang: probly not, === Nafallo is now known as Nafallo_away === WaterSevenUb [n=WaterSev@195-23-220-220.net.novis.pt] has joined #launchpad === poningru [n=poningru@n128-227-34-119.xlate.ufl.edu] has joined #launchpad === koke [n=koke@209.104.102.193] has joined #launchpad [06:12] kiko: publishing run on drescher finished [06:12] kiko: I'm almost ready to try another run, do you mind? [06:14] Kinnison, not at all -- do you need to run it again though? [06:14] and why, if you do? === pkunk [n=pkunk@a84-231-27-185.elisa-laajakaista.fi] has joined #launchpad === koke [n=koke@209.104.102.193] has joined #launchpad [06:25] kiko: ping [06:27] what? [06:27] SteveA, tell me everyting [06:27] and everything [06:30] kiko: because I'm fixing bugs as I go [06:31] oh [06:31] sure === Kinnison is re-running it to add Origin/Bugs headers and the Task headers [06:31] ok [06:37] mdz: Once this run is done it'd be nice if you can have a look at the archive [06:37] mdz: do you have a login on drescher? [06:37] Kinnison: I will find out if I do [06:37] Kinnison: no, I don't === zyga [n=zyga@2-mi2-1.acn.waw.pl] has joined #launchpad [06:39] and irritatingly we don't seem to export the archive over http [06:39] Do you want to poke elmo or shall I? [06:39] hi kiko. i 'm up on reception with jane, with phone reception in case claire calls. [06:39] hey guys [06:39] i'm doing ddaa's code review up here [06:40] SteveA, oh, ok. [06:40] sorry if i don't remember, but who is in charge of teams and people? [06:40] fabbione, it's salgado [06:40] kiko: almost time to run apt-ftparchive :-) [06:40] kiko: ok [06:40] salgado: ping? [06:40] kiko: assuming it runs :-) [06:40] fabbione, pong [06:41] salgado: yo. are you busy? [06:42] fabbione, I'm finishing some changes I started yesterday. have something for me? [06:44] salgado: i need to unroll a loop [06:44] and understand how to assign pkgs to a team [06:45] fabbione, where are you now? [06:45] fabbione, because you want bugs to be filed on them? [06:45] if so, it's not so trivial because the maintainer is inferred from the package maintainer field [06:49] sabdfl: i am one of the small rooms hidden behind the bar [06:49] ops [06:49] ^^ salgado [06:49] kiko: well there are several minor changes i would like to see there to manually associate pkgs to maintainers [06:49] yeah [06:49] kiko: but there is still a loop that needs to be unrolled [06:49] that needs fixing definitely [06:49] for ex: [06:49] group foo can upload to main [06:49] group bar manages only a strict subset of pkgs in main [06:50] some people in group bar do not have full main upload privileges [06:50] now [06:50] fabbione: Not currently supported [06:50] in order for group bar to upload to main [06:50] group bar needs to be part of foo [06:50] (read foo as ubuntu-core-devel) [06:51] so how can we make this to work? [06:51] Currently we can't [06:51] we've spoken about having more granular upload privs [06:51] Kinnison: ok [06:51] we don't currently have them [06:51] is there a spec or plan to do it? [06:51] or is it all handwaving [06:51] ? [06:51] check out https://wiki.launchpad.canonical.com/UploadPrivileges [06:51] Kinnison: thanks [06:52] Kinnison: make sense :) [06:53] fabbione: cool [06:54] what about the manual link between pkgs and maintainers (people/team)? [06:54] Anyone on the review team want a small review? [06:54] not done either === ddaa [n=ddaa@209.104.102.193] has joined #launchpad [06:55] kiko: same question.. is there a spec/plan or is it still handwaving? [06:56] Kinnison: go ahead and send it here [06:56] fabbione, that is missing a spec, I believe. [06:56] fabbione: erm, I meant the launchpad code-reviews team :-) [06:56] kiko: i assume you are going to work on it :P [06:56] Kinnison: ehehe ok :) [06:56] fabbione: feel free to do the review if you want [06:56] kiko: (specially if you want to wake up tomorrow ;)) [06:56] Kinnison, I can review [06:57] fabbione, I could, but probably npw [06:57] not [06:57] kiko: Cool, you want to come over and do it here, or do you want a diff [06:57] Kinnison: nah.. i don't have enough background to do it.. [06:57] kiko: it'll take a while before jamesh's scripts catch up to it [06:57] Kinnison, I'll walk over [06:58] kiko: coolio === Kinnison preps a diff [06:59] kiko: I'll yell when I have the diff ready [06:59] Kinnison: it runs once an hour right now [07:00] jamesh: oooh [07:00] jamesh: cool [07:00] jamesh: it's that quick? [07:00] jamesh: on the hour? [07:01] SteveA: ping [07:01] SteveA: Guy looking for a laptop [07:01] Kinnison: there isn't that many branches on the page, which contributes to the speed ... [07:03] jamesh: so when does it run? [07:05] Kinnison: the run date is at the top of the page [07:06] it is part way through a run right now [07:07] oh well [07:07] so I lose [07:08] 17:34 < zyga> I've updated my /usr/share/applications [07:08] 17:34 < zyga> I'll restart to check if the startup is notacibly slower [07:08] 17:34 < zyga> brb [07:08] oops [07:08] sorry [07:08] sivang: ? [07:08] np [07:09] my touchpad seem to get crazy [07:15] SteveA: right now? [07:16] stub: right now? [07:17] stub: i'm in muguet if anyone wants to talk with me [07:31] SteveA: https://chinstrap.ubuntu.com/~dsilvers/paste/fileTaEgiU.html [07:31] Doit bitch === stub goes to lunch === GoRoDeK [n=gorodek@p5083E874.dip.t-dialin.net] has joined #launchpad [07:33] mdz/kiko: done === WaterSevenUb [n=WaterSev@195-23-220-156.net.novis.pt] has joined #launchpad [07:34] thanks elmo rocking as usual === smurfix [n=smurf@debian/developer/smurf] has joined #launchpad [08:03] elmo: zsh on drescher would be lovely === janimo [n=jani@Home03207.cluj.astral.ro] has joined #launchpad [08:11] can external SVN projects be imported in launchpad only if the yhave coressponding packages in ubuntu? [08:12] darn. the answer was no. === janimo [n=jani@Home03207.cluj.astral.ro] has joined #launchpad [08:13] janimo, the answer is no. you just need to register the product. [08:13] and talk to jblack or lifeless [08:13] kiko, thanks. [08:15] 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] janimo, you can do it aftrwards === ..[topic/#launchpad:kiko] : kiko_328 [08:18] any ETA on the switch to bzr? [08:22] Kinnison, ping? [08:22] janimo, it is done [08:22] can somebody get me Kinnison? === cprov [i=45439eb3@66.103.220.196] has joined #launchpad === carlos [n=carlos@66.103.220.223] has joined #launchpad === BjornT [n=bjorn@66.103.220.247] has joined #launchpad [08:41] no [08:49] now I need stub [08:50] janimo, but not for imports, sorry -- so you'll get baz for now, and bzr afterwards === berend [n=berend@chasin.xs4all.nl] has joined #launchpad === jamesh [n=james@66.103.220.242] has joined #launchpad === smurfix is now known as smurf === ddaa [n=ddaa@209.104.102.193] has joined #launchpad [09:07] kiko, any idea when bzr will be here for imports too? [09:13] kiko: dude, i just thought of something. [09:13] why do we even need the "Request fix:" links? [09:14] bradb_, hmmm. why wouldn't we? [09:14] 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] the only feedback i've gotten about them thus far is "what are these for?" [09:15] bradb_, do you understand how much pain you are inviting by changing that part of the page? [09:16] kiko: basically you're saying you don't think the sab will buy into it? [09:16] kiko: can you give an example of a non-contrived use case for those links? [09:16] bradb_: fix other things first [09:17] bradb_, I'm saying that area is an area which is controversial. I'd stay away from there [09:17] kiko: right === stub [i=stub@sweep.bur.st] has joined #launchpad [09:18] stub! [09:18] kiko: still here [09:18] how are you doing? [09:18] stub, I'll need a gina run soon [09:19] kiko: ok [09:19] stub, we missed the backports pockets. [09:19] ...? [09:21] kiko: You have new code, or should I just run the existing code on staging? [09:21] stub, I will have new code -- I need to add it to a dbschema. [09:21] it does mean waiting for PQM [09:22] kiko: Can you update the staging config too in your commit? [09:23] stub, hmmm. yes, I think I can [09:23] is this the new soyuz stuff being put into place then? [09:24] Mez, in testing, but yes [09:24] oh, that's right Mez -- you're the backports dude [09:24] so I forgot your pocket [09:24] adding it :) [09:28] mdz: done === Mez has no idea what you mean about my poket [09:29] but *shrusg* [09:34] https://staging.ubuntu.com/+builds/+build/134165 === TinMan [n=Lotus@rrcs-24-97-24-139.nys.biz.rr.com] has joined #launchpad [09:36] Mez, is that a system error? [09:41] yes === BjornT_ [n=bjorn@209.104.102.193] has joined #launchpad === Seveas [n=seveas@ubuntu/member/seveas] has joined #launchpad === koke [n=koke@209.104.102.193] has joined #launchpad [09:51] hmm [09:51] the packages are a lil borked [09:51] https://staging.ubuntu.com/distros/ubuntu/breezy/+package/k3b-mp3 [09:51] k3b-mp3 [09:51] click on i386 [09:51] https://staging.ubuntu.com/distros/ubuntu/breezy/i386/k3b-mp3/0.12.2-0ubuntu2 [09:51] and it says it's k3blibs-dev [09:51] elmo: you are my hero [09:54] in fact - they all show as k3blibs-dev [09:54] and I guess in other packages they show as the last package there === lamont [n=lamont@66.103.220.244] has joined #launchpad [10:29] is launchpad's extra slowness a known-issue right now? [10:29] Or is it my laptop being shit? [10:33] bug 3256, has it been updated? [10:33] Error: I cannot access this bug [10:33] apparently not [10:33] bug 3256, has it been updated now? [10:33] 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] huzzah [10:33] took long enough === Kinnison spanks launchpad [10:34] SteveA: https://chinstrap.ubuntu.com/~dsilvers/paste/filed0pgBI.html [10:46] 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] bradb_: ok, although I'd like to wait until I can land mine too. Are people here waiting to see it? [10:47] Of course, that involves someone poking SteveA until he looks at that paste === zyga [n=zyga@2-mi2-1.acn.waw.pl] has joined #launchpad === zyga [n=zyga@2-mi2-1.acn.waw.pl] has joined #launchpad [10:53] jordi, ping! [11:12] ddaa, can you put off running baz-import until tomorrow night? PQM is really really slow atm [11:12] and I have some critical fixes to land for the archive side of things [11:12] ddaa, are you running for all your branches, and is it close to ending? [11:13] yes, yes, no idea [11:13] I think I should just nice it [11:13] if you could [11:14] nice won't help [11:14] it is IO bound [11:14] ddaa: nice sadly doesn't help with io contention. [11:14] not cpu bound [11:15] ionice? [11:15] bah... I just suspended it [11:15] when can I start it again? [11:17] ddaa, tomorrow evening? [11:17] pleeeeze [11:21] meh @ topic ? [11:21] hmmm [11:21] bradb_, did that branch of yours that was on pqm a few minutes ago got merged? === ..[topic/#launchpad:kiko] : it's saturday [11:21] salgado: NOPE [11:22] failure === bradb_ dies [11:22] salgado: It's resubmitted [11:23] 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] 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] 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] so, yes, they have batching [11:26] "batching" == cutting a list in pieces/subpages ? [11:26] I thouhgt you were changing those macros and not the +assignedbugs [11:26] uws, yes [11:41] salgado: this was the reason i couldn't continue working with you to land the targetnamecache stuff. sorry for the confusion. [11:50] 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] ok, that's good to hear :)