/srv/irclogs.ubuntu.com/2005/11/10/#launchpad.txt

bradb_Keybuk, jbailey: dudes?12:09
Keybukwe're in the chairs, come! :p12:09
bradb_oh, ok12:09
=== 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
bradb_salgado: we fixed that problem with "bugs I reported" showing fixed bugs, right?12:22
uwsbradb_: Thanks for fixing the  +bugs -> +bugs-all  instead of  +bugs -> +bugs-open  issue12:23
=== 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
salgadobradb_, yes, it's fixed on this branch I'm working on right now12:35
=== 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
alessioalessio 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
alessioalessio bu i have done a subkey01:04
alessioalessio and i have resend he key01:04
alessioalessio a subkey of this type  (6) RSA (encrypt only)01:04
alessiocan anyone help me?01:04
=== 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
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:41
=== bradb_ adds batching meanwhile
=== matsubara-lunch is now known as matsubara
=== kiko [n=kiko@66.103.220.210] has joined #launchpad
bradb_Hey, that's what an empty bug search should do, perhaps.03:50
kikoahoy03:50
bradb_i.e. suggest that maybe you want to _File a Bug_03:50
kikowell03:51
bradb_a cheap guided bug form03:51
kikohmm03:51
jordiso, kiko03:55
jordiwhere were you at 6:30 man03:55
kikobuying cocaine03:56
jameshjordi: he probably went without you when you didn't turn up at 4:1504:00
=== sabdfl [n=mark@pdpc/supporter/silver/sabdfl] has joined #launchpad
jordikiko: got any left?04:01
stubkiko: Run gina just against breezy?04:05
stubbradb_: 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 pouts
KinnisonI made a luvley generic system we could use for that if only we had a gajillion CPUs04:06
=== stub runs gina on staging against breezy
Kinnisonkiko, dude, gina tests fail on my laptop04:10
Kinnisoncan you come and help me debug them04:10
=== Kinnison wants to have a clean branch to merge
kikoKinnison, yeah. what did you change in her?04:13
=== salgado [n=salgado@66.103.220.225] has joined #launchpad
Kinnisonkiko: not touched her04:14
Kinnisonkiko: I've been fiddling with distrorelease though04:15
kikoweird.04:16
kikook04:16
kikowhat's the error?04:16
Kinnisonaha, I think you're calling distroreleaseset.new04:16
=== Keybuk [n=scott@209.104.102.193] has joined #launchpad
kikoyeah, look at the first error04:17
Kinnisons'hard when they fly by fast04:17
kikoKinnison, | less04:17
=== Kinnison teeeed 'em
kikotttttted04:19
bradb_stub: mailed. this speed issue is fairly critical.04:20
Kinnisonstub: can I get a db patch reviewed please?04:25
stubbradb_: 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
stubKinnison: paste please04:25
KinnisonALTER TABLE DistroRelease DROP COLUMN Components;04:25
KinnisonALTER TABLE DistroRelease DROP COLUMN Sections;04:25
Kinnison-- END04:25
bradb_stub: did you change BugTask.assignee = ... to MOTU's id?04:25
stubbradb_: Batching will be the big win04:25
stubbradb_: I'll try that04:25
stubbradb_: That takes 73ms.04:26
stubbradb_: Not a problem04:26
Kinnisonstub: ^^04:26
stubKinnison: If we drop those columns, do we need the tables they reference?04:27
kikobradb_, look at your postgresql logs04:27
Kinnisonthey reference SCHEMA04:27
kikofor a reload04:27
stubKinnison: Ok. Approved. patch-25-54-0.sql04:28
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 spent04:29
Kinnisonstub: thanks dude04:29
=== WaterSevenUb [n=WaterSev@195-23-220-220.net.novis.pt] has joined #launchpad
stubbradb_: 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:31
=== bradb_ wonders if it's the security checking code
=== Nafallo_away is now known as Nafallo
stubbradb_: I think that if you are displaying 100 bugs, it is issuing 100 seperate db queries to display the assignees name.04:38
kikostub, bradb_: if that is the case, we should probably create a view for it.04:38
stubbradb_: Which could be done in a single query, but I don't know how easy to refactor the python to do it.04:38
stubOr just issue 'SELECT displayname, surname, givenname from person where id in ( [comma seperated list of assignee ids]  )'04:39
kikobradb_, a simple view with a single extra column can work wonders for you. it's a bit of database class overhead though.04:39
kikoit did solve serious problems in soyuz though.04:39
kiko(one year ago)04:40
zygacarlos: ping04:41
zygacarlos: in #u-desktop if you could04:41
spivsub   4096g/8CF9CA35 2005-11-05 [expires: 2007-11-05] 04:43
=== spiv wonders how that got pasted.
sivanglifeless: 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 ;-) )04:46
=== mdz [n=mdz@66.103.220.206] has joined #launchpad
=== ddaa [n=ddaa@209.104.102.193] has joined #launchpad
lifelesssivang: probly not, 05:16
=== 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
Kinnisonkiko: publishing run on drescher finished06:12
Kinnisonkiko: I'm almost ready to try another run, do you mind?06:12
kikoKinnison, not at all -- do you need to run it again though?06:14
kikoand why, if you do?06:14
=== pkunk [n=pkunk@a84-231-27-185.elisa-laajakaista.fi] has joined #launchpad
=== koke [n=koke@209.104.102.193] has joined #launchpad
SteveAkiko: ping06:25
kikowhat?06:27
kikoSteveA, tell me everyting06:27
kikoand everything06:27
Kinnisonkiko: because I'm fixing bugs as I go06:30
kikooh06:31
kikosure06:31
=== Kinnison is re-running it to add Origin/Bugs headers and the Task headers
kikook06:31
Kinnisonmdz: Once this run is done it'd be nice if you can have a look at the archive06:37
Kinnisonmdz: do you have a login on drescher?06:37
mdzKinnison: I will find out if I do06:37
mdzKinnison: no, I don't06:37
=== zyga [n=zyga@2-mi2-1.acn.waw.pl] has joined #launchpad
Kinnisonand irritatingly we don't seem to export the archive over http06:39
KinnisonDo you want to poke elmo or shall I?06:39
SteveAhi kiko. i 'm up on reception with jane, with phone reception in case claire calls.06:39
fabbionehey guys06:39
SteveAi'm doing ddaa's code review up here06:39
kikoSteveA, oh, ok.06:40
fabbionesorry if i don't remember, but who is in charge of teams and people?06:40
kikofabbione, it's salgado06:40
Kinnisonkiko: almost time to run apt-ftparchive :-)06:40
fabbionekiko: ok06:40
fabbionesalgado: ping?06:40
Kinnisonkiko: assuming it runs :-)06:40
salgadofabbione, pong06:40
fabbionesalgado: yo. are you busy?06:41
salgadofabbione, I'm finishing some changes I started yesterday. have something for me?06:42
fabbionesalgado: i need to unroll a loop06:44
fabbioneand understand how to assign pkgs to a team06:44
salgadofabbione, where are you now?06:45
kikofabbione, because you want bugs to be filed on them?06:45
kikoif so, it's not so trivial because the maintainer is inferred from the package maintainer field06:45
fabbionesabdfl: i am one of the small rooms hidden behind the bar06:49
fabbioneops06:49
fabbione^^ salgado06:49
fabbionekiko: well there are several minor changes i would like to see there to manually associate pkgs to maintainers06:49
kikoyeah06:49
fabbionekiko: but there is still a loop that needs to be unrolled06:49
kikothat needs fixing definitely06:49
fabbionefor ex:06:49
fabbionegroup foo can upload to main06:49
fabbionegroup bar manages only a strict subset of pkgs in main06:49
fabbionesome people in group bar do not have full main upload privileges06:50
fabbionenow06:50
Kinnisonfabbione: Not currently supported06:50
fabbionein order for group bar to upload to main06:50
fabbionegroup bar needs to be part of foo06:50
fabbione(read foo as ubuntu-core-devel)06:50
fabbioneso how can we make this to work?06:51
KinnisonCurrently we can't06:51
Kinnisonwe've spoken about having more granular upload privs06:51
fabbioneKinnison: ok06:51
Kinnisonwe don't currently have them06:51
fabbioneis there a spec or plan to do it?06:51
fabbioneor is it all handwaving06:51
fabbione?06:51
Kinnisoncheck out https://wiki.launchpad.canonical.com/UploadPrivileges06:51
fabbioneKinnison: thanks06:51
fabbioneKinnison: make sense :)06:52
Kinnisonfabbione: cool06:53
fabbionewhat about the manual link between pkgs and maintainers (people/team)?06:54
KinnisonAnyone on the review team want a small review?06:54
kikonot done either06:54
=== ddaa [n=ddaa@209.104.102.193] has joined #launchpad
fabbionekiko: same question.. is there a spec/plan or is it still handwaving?06:55
fabbioneKinnison: go ahead and send it here06:56
kikofabbione, that is missing a spec, I believe.06:56
Kinnisonfabbione: erm, I meant the launchpad code-reviews team :-)06:56
fabbionekiko: i assume you are going to work on it :P06:56
fabbioneKinnison: ehehe ok :)06:56
Kinnisonfabbione: feel free to do the review if you want06:56
fabbionekiko: (specially if you want to wake up tomorrow ;))06:56
kikoKinnison, I can review06:56
kikofabbione, I could, but probably npw06:57
kikonot06:57
Kinnisonkiko: Cool, you want to come over and do it here, or do you want a diff06:57
fabbioneKinnison: nah.. i don't have enough background to do it..06:57
Kinnisonkiko: it'll take a while before jamesh's scripts catch up to it06:57
kikoKinnison, I'll walk over06:57
Kinnisonkiko: coolio06:58
=== Kinnison preps a diff
Kinnisonkiko: I'll yell when I have the diff ready06:59
jameshKinnison: it runs once an hour right now06:59
Kinnisonjamesh: oooh07:00
Kinnisonjamesh: cool07:00
Kinnisonjamesh: it's that quick?07:00
Kinnisonjamesh: on the hour?07:00
stubSteveA: ping07:01
stubSteveA: Guy looking for a laptop07:01
jameshKinnison: there isn't that many branches on the page, which contributes to the speed ...07:01
Kinnisonjamesh: so when does it run?07:03
jameshKinnison: the run date is at the top of the page07:05
jameshit is part way through a run right now07:06
Kinnisonoh well07:07
Kinnisonso I lose07:07
sivang17:34 < zyga> I've updated my /usr/share/applications07:08
sivang17:34 < zyga> I'll restart to check if the startup is notacibly slower07:08
sivang17:34 < zyga> brb07:08
sivangoops07:08
sivangsorry07:08
zygasivang: ?07:08
zyganp07:08
sivangmy touchpad seem to get crazy07:09
SteveASteveA: right now?07:15
SteveAstub: right now?07:16
SteveAstub: i'm in muguet if anyone wants to talk with me07:17
stubSteveA: https://chinstrap.ubuntu.com/~dsilvers/paste/fileTaEgiU.html07:31
stubDoit bitch07:31
=== stub goes to lunch
=== GoRoDeK [n=gorodek@p5083E874.dip.t-dialin.net] has joined #launchpad
elmomdz/kiko: done07:33
=== WaterSevenUb [n=WaterSev@195-23-220-156.net.novis.pt] has joined #launchpad
kikothanks elmo rocking as usual07:34
=== smurfix [n=smurf@debian/developer/smurf] has joined #launchpad
mdzelmo: zsh on drescher would be lovely08:03
=== janimo [n=jani@Home03207.cluj.astral.ro] has joined #launchpad
janimocan external SVN projects be imported in launchpad only if the yhave coressponding packages in ubuntu?08:11
kikodarn. the answer was no.08:12
=== janimo [n=jani@Home03207.cluj.astral.ro] has joined #launchpad
kikojanimo, the answer is no. you just need to register the product.08:13
kikoand talk to jblack or lifeless 08:13
janimokiko,  thanks.08:13
janimoso I talk to them before/after/instead of filling out the import forms for the product?(xfce alreday regsitered just not tracked)08:15
kikojanimo, you can do it aftrwards08:15
=== ..[topic/#launchpad:kiko] : kiko_328
janimoany ETA on the switch to bzr?08:18
kikoKinnison, ping?08:22
kikojanimo, it is done08:22
kikocan somebody get me Kinnison?08:22
=== 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
Kinnisonno08:41
kikonow I need stub08:49
kikojanimo, but not for imports, sorry -- so you'll get baz for now, and bzr afterwards08:50
=== 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
janimokiko,  any idea when bzr will be here for imports too?09:07
bradb_kiko: dude, i just thought of something.09:13
bradb_why do we even need the "Request fix:" links?09:13
kikobradb_, 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:14
kikobradb_, do you understand how much pain you are inviting by changing that part of the page?09:15
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
SteveAbradb_: fix other things first09:16
kikobradb_, I'm saying that area is an area which is controversial. I'd stay away from there09:17
bradb_kiko: right09:17
=== stub [i=stub@sweep.bur.st] has joined #launchpad
kikostub!09:18
stubkiko: still here09:18
kikohow are you doing?09:18
kikostub, I'll need a gina run soon09:18
stubkiko: ok09:19
kikostub, we missed the backports pockets.09:19
Mez...?09:19
stubkiko: You have new code, or should I just run the existing code on staging?09:21
kikostub, I will have new code -- I need to add it to a dbschema.09:21
kikoit does mean waiting for PQM09:21
stubkiko: Can you update the staging config too in your commit?09:22
kikostub, hmmm. yes, I think I can09:23
Mezis this the new soyuz stuff being put into place then?09:23
kikoMez, in testing, but yes09:24
kikooh, that's right Mez -- you're the backports dude09:24
kikoso I forgot your pocket09:24
kikoadding it :)09:24
elmomdz: done09:28
=== Mez has no idea what you mean about my poket
Mezbut *shrusg*09:29
Mezhttps://staging.ubuntu.com/+builds/+build/13416509:34
=== TinMan [n=Lotus@rrcs-24-97-24-139.nys.biz.rr.com] has joined #launchpad
kikoMez, is that a system error?09:36
Mezyes09:41
=== 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
Mezhmm09:51
Mezthe packages are a lil borked09:51
Mezhttps://staging.ubuntu.com/distros/ubuntu/breezy/+package/k3b-mp309:51
Mezk3b-mp309:51
Mezclick on i38609:51
Mezhttps://staging.ubuntu.com/distros/ubuntu/breezy/i386/k3b-mp3/0.12.2-0ubuntu209:51
Mezand it says it's  k3blibs-dev09:51
mdzelmo: you are my hero09:51
Mezin fact - they all show as k3blibs-dev09:54
Mezand I guess in other packages they show as the last package there09:54
=== lamont [n=lamont@66.103.220.244] has joined #launchpad
Kinnisonis launchpad's extra slowness a known-issue right now?10:29
KinnisonOr is it my laptop being shit?10:29
Kinnisonbug 3256, has it been updated?10:33
UbugtuError: I cannot access this bug10:33
Kinnisonapparently not10:33
Kinnisonbug 3256, has it been updated now?10:33
UbugtuMalone 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/325610:33
Kinnisonhuzzah10:33
Kinnisontook long enough10:33
=== Kinnison spanks launchpad
stubSteveA: https://chinstrap.ubuntu.com/~dsilvers/paste/filed0pgBI.html10:34
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
stubbradb_: ok, although I'd like to wait until I can land mine too. Are people here waiting to see it?10:46
stubOf course, that involves someone poking SteveA until he looks at that paste10:47
=== zyga [n=zyga@2-mi2-1.acn.waw.pl] has joined #launchpad
=== zyga [n=zyga@2-mi2-1.acn.waw.pl] has joined #launchpad
carlosjordi, ping!10:53
kikoddaa, can you put off running baz-import until tomorrow night? PQM is really really slow atm11:12
kikoand I have some critical fixes to land for the archive side of things11:12
kikoddaa, are you running for all your branches, and is it close to ending?11:12
ddaayes, yes, no idea11:13
ddaaI think I should just nice it11:13
kikoif you could11:13
SteveAnice won't help11:14
SteveAit is IO bound11:14
spivddaa: nice sadly doesn't help with io contention.11:14
SteveAnot cpu bound11:14
kikoionice?11:15
ddaabah... I just suspended it11:15
ddaawhen can I start it again?11:15
kikoddaa, tomorrow evening?11:17
kikopleeeeze11:17
Keybukmeh @ topic ?11:21
kikohmmm11:21
salgadobradb_, did that branch of yours that was on pqm a few minutes ago got merged?11:21
=== ..[topic/#launchpad:kiko] : it's saturday
bradb_salgado: NOPE11:21
kikofailure11:22
=== bradb_ dies
bradb_salgado: It's resubmitted11:22
salgadobradb_, I don't understand why you wrote this fix. you saw that I already have it on my branch. kiko is reviewing it11:23
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:24
salgadobradb_, I changed the whole +assignedbugs to use the same base view class and macros that are used in the bug listings of products/distro/distroreleases11:25
salgadoso, yes, they have batching11:26
uws "batching"  == cutting a list in pieces/subpages ?11:26
salgadoI thouhgt you were changing those macros and not the +assignedbugs11:26
salgadouws, yes11:26
bradb_salgado: this was the reason i couldn't continue working with you to land the targetnamecache stuff. sorry for the confusion.11:41
salgadobradb_, no worries. I've seen your diff already, and it looks like it won't be too much trouble to solve the conflicts11:50
bradb_ok, that's good to hear :)11:51

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!