kikobradb, yes, stub's working on that AFAIK12:15
bradbok, cool12:15
=== elmo [n=james@83-216-156-21.jamest747.adsl.metronet.co.uk] has joined #launchpad
=== theCore [n=alex@modemcable106.200-70-69.mc.videotron.ca] has joined #launchpad
UbugtuNew bug: #60874 in conglomerate "crashes when trying to play sounds" [Unknown,Unknown]  http://launchpad.net/bugs/6087412:36
kikocprov-afk, ping?12:44
=== panickedtest [n=travis@cdm-75-109-115-91.asbnva.dhcp.suddenlink.net] has joined #launchpad
=== panickedtest [n=travis@cdm-75-109-115-91.asbnva.dhcp.suddenlink.net] has joined #launchpad
=== panickedthumb [n=travis@ubuntu/member/panickedthumb] has joined #launchpad
=== Fujitsu [n=Fujitsu@ubuntu/member/fujitsu] has joined #launchpad
=== quail [n=quail@unaffiliated/quaillinux/x-000001] has joined #launchpad
=== printk [n=jvaughn@unaffiliated/printk] has joined #launchpad
=== jinty [n=jinty@195.Red-83-58-178.dynamicIP.rima-tde.net] has joined #launchpad
UbugtuNew bug: #61183 in launchpad "Search packages has an unhelpful sort order" [Untriaged,Unconfirmed]  http://launchpad.net/bugs/6118301:35
=== mdz [n=mdz@studiocity-motorola-bsr1-70-36-194-85.vnnyca.adelphia.net] has joined #launchpad
mptGooooooooooooooooood afternoon Launchpadders!02:32
=== panickedtest [n=travis@cdm-75-109-115-91.asbnva.dhcp.suddenlink.net] has joined #launchpad
=== AlinuxOS [n=alinux@d83-176-124-173.cust.tele2.it] has joined #launchpad
=== panickedthumb [n=travis@ubuntu/member/panickedthumb] has joined #launchpad
=== quail [n=quail@unaffiliated/quaillinux/x-000001] has joined #launchpad
=== stub [n=stub@ppp-] has joined #launchpad
=== AlinuxOS [n=alinux@d83-176-124-173.cust.tele2.it] has joined #launchpad
=== mpt [n=mpt@203-167-187-52.dsl.clear.net.nz] has joined #launchpad
=== jelmer_ [n=jelmer@] has joined #launchpad
=== jml [n=jml@203-217-8-89.perm.iinet.net.au] has joined #launchpad
=== Fujitsu [n=Fujitsu@ubuntu/member/fujitsu] has joined #launchpad
=== raphink [n=raphink@ubuntu/member/raphink] has joined #launchpad
=== BjornT [n=bjorn@clt-84-32-240-183.dtiltas.lt] has joined #launchpad
=== jelmer_ [n=jelmer@] has joined #launchpad
=== danilos [n=danilo@cable-89-216-150-63.dynamic.sbb.co.yu] has joined #launchpad
=== Burgundavia [n=corey@ubuntu/member/burgundavia] has joined #launchpad
=== malcc [n=malcolm@host86-138-251-144.range86-138.btcentralplus.com] has joined #launchpad
=== carlos_ [n=carlos@138.Red-81-39-35.dynamicIP.rima-tde.net] has joined #launchpad
SteveAhi carlos 09:19
carlosSteveA: hi09:19
=== seb128 [n=seb128@ubuntu/member/seb128] has joined #launchpad
=== ddaa [n=ddaa@nor75-18-82-241-238-155.fbx.proxad.net] has joined #launchpad
SteveAmpt: ping09:38
mptSteveA, pong09:42
SteveAmpt: when can we have a chat?09:43
mptSteveA, now's good09:45
=== BjornT [n=bjorn@clt-84-32-240-183.dtiltas.lt] has joined #launchpad
=== mpt gets annoyed that repositories prevent simultaneous merges
SteveAit would be possible for them to allow that, but it would make the code a lot more complicated09:59
malccFrom my point of view, it'd be an improvement if it just pretended, ie. blocked waiting for the lock rather than giving me an error and making me think10:03
=== Spads [n=spacehob@] has joined #launchpad
ddaamalcc: there was some discussion on the ML about that, likely bzr-0.11 will do "wait on lock"10:04
ddaathere was also discussion on allowing per-knit locking in some cases, but it sounded like it was not going to happen soon. More likely, some smart server could be used instead of inter-process locking10:06
jameshmpt: if you're merging from rocketfuel into one of your branches, you'll find that most of the work for the second merge was already done for the first10:08
jameshmpt: since the new revisions will already be in the repository, it just needs to merge the changes into the working copy10:09
mptjamesh, that would normally be an advantage, but in this case I was merging first from an sftp:// branch and secondly from my local rocketfuel-built copy10:11
mptI guess I should have done them the other way around10:11
jameshmpt: you can do "bzr fetch $FROM $TO" to do the "pull revisions into my repository" without setting up a pending merge in your working tree10:12
jameshe.g. fetch from your rocketfuel-built copy, then merge from sftp10:13
jameshto minimise the number of revs that need to be fetched via sftp10:13
=== fabbione [i=fabbione@gordian.fabbione.net] has joined #launchpad
SteveAjamesh: nice, I didn't know about bzr fetch10:18
mptI remember bzr fetch, because someone (mpool?) asked me what its opposite should be called10:36
mptbzr throw :-)10:36
=== BjornT [n=bjorn@clt-84-32-240-183.dtiltas.lt] has joined #launchpad
SteveAbzr unappeal10:40
=== raphink [n=raphink@ubuntu/member/raphink] has joined #launchpad
=== fabbione [i=fabbione@gordian.fabbione.net] has joined #launchpad
=== jinty [n=jinty@195.Red-83-58-178.dynamicIP.rima-tde.net] has joined #launchpad
SteveAddaa: ping11:14
ddaaSteveA: pong11:16
SteveAddaa: I'd like your advice on a bzr problem11:17
SteveAI have a tree where bzr info gives me info11:17
SteveAand then says11:17
SteveANoSuchRevision: Branch BzrBranch5('file:///srv/launchpad.net/launchpad/') has no revision pqm@pqm.ubuntu.com-20060824115831-cb77ca85929d1ba211:17
SteveAwith a traceback11:17
SteveAbzr revert doesn't fix it11:17
SteveAbzr pull --overwrite doesn't fix it either11:17
SteveAis there something I can do to explicitly pull in this revision?11:18
ddaaSteveA: fetch-ghosts, maybe11:19
SteveAunknown command11:19
ddaaha, it's from bzrtools11:20
=== j4k [n=chatzill@AMontpellier-157-1-19-224.w86-197.abo.wanadoo.fr] has joined #launchpad
ddaaSteveA: what I'd do would be branch into a populated repository11:22
=== j4k [n=chatzill@AMontpellier-157-1-19-224.w86-197.abo.wanadoo.fr] has left #launchpad []
SteveAhow will that help?11:24
daniloscarlos, jordi: anyone doing the Divehi plural forms? ;)11:24
SteveAI just tried to pull --overwrite from a populated repository, assuming I understand "populated repository" right11:25
carlosdanilos: not me11:25
daniloscarlos: ok, I'll handle that11:25
carlosdanilos: neither jordi, he's without network connection in his other job11:25
ddaaSteveA: it pulls revision into a repository11:26
SteveAhow does that help me?11:26
SteveAthe repository has that revision11:26
SteveAhow does that get the revision into the branch I want it in?11:26
ddaaSteveA: I do not understand what is your situation and what you are trying to do, so I can only guess.11:26
SteveAI have a branch.11:27
SteveAI cannot do stuff I want to do with it, because bzr info gives that exception11:27
SteveAthe exception indicates there is a missing revision11:27
SteveAI have the revision in a repository elsewhere11:27
SteveAbut I do not know how to get that revision from the repository into the branch that is missing it11:27
ddaaSteveA: bzr info should never give you that sort of error, so you have another problem as well. And I do not know what it is. I suggest:11:30
ddaacd broken-branch ; bzr branch /path/to/repo/branch-name11:30
ddaaThen repo/branch-name should work. Replace broken-branch by a lightweight checkout or a fresh branch from repo/branch-name11:31
SteveAokay I can do that.  although, it is annoying because this is a launchpad branch11:32
ddaaactually "bzr branch broken-branch /path/to/repo/branch-name"11:32
SteveAand so I have to mess around with the subtrees / symlink things11:32
ddaaSteveA: all the more a reason to use a repository and light checkouts11:32
SteveAI don't know a good way to maintain these things in bzr currently11:33
ddaaWhat you can do to avoid messing with subtrees etc is to replace the .bzr in your broken tree by the one you created when doing a fresh checkout/branch11:33
SteveAthat sounds like flaky magic11:34
SteveAuntil bzr has a supported way of doing this I'll11:34
SteveA - use the most obvious thing11:34
SteveA - consider reorganising the launchpad tree in RF so that it works well within the limitations of bzr as now11:34
ddaaon minute11:34
ddaaneed music to cover the screams of the walking foetuses outside11:35
SteveAI'm sure there's a French punk band called "the walking foetuses"11:35
=== sabdfl [n=sabdfl@ubuntu/member/pdpc.silver.sabdfl] has joined #launchpad
ddaaSteveA: I think you are talking about two issues now and that's confusing me11:37
sabdfllifeless: squid question: is it possible to setup a browser and proxy so that the browser<->proxy connection is always over https even for http URL's?11:38
ddaaThere are several issues here:11:38
SteveAsabdfl: you can do that with apache, or with any proxy11:38
sabdfli find myself stuck behind national firewalls like in china and want to bypass those11:39
ddaa1. you have a branch that causes bzr info to barf. It's highly anomalous, I did not have anything like that in weeks or months. We look for ways to recover your data.11:39
SteveAsabdfl: the proxy setting will be https://your.proxy11:39
SteveAand the proxy itself will be sent queries by the browser like  GET http://the/site/you/want HTTP/1.111:39
sabdfli tried running firefox on my home desktop with X forwarded over SSH to my laptop but that's.... painful11:39
ddaa2. you appears to have issues with dealing with nested trees. I do not understand clearly what is your issue11:39
sabdflok, thanks stevea11:40
SteveAthe tricky thing is, making sure only you can use this https proxy11:40
SteveAas you don't want to be running an open proxy11:40
sabdflSteveA: why not?11:40
ddaa3. I recommend that you use repositories and light checkouts when working with launchpad because it makes things perform much better11:40
SteveAif it is discovered by spammers, they can use it to send spam, for one thing11:41
SteveAddaa: thanks for your comments and assistance.  I'm rebuilding that tree.  There was no important data in it that I can't get from elsewhere.11:41
SteveAddaa: there are various issues with how obvious it is to do stuff with nested trees.  I've seen how confused non-bzr-experts find it, and I include myself in that group.11:42
SteveAddaa: so, don't worry that you don't understand the difficulty.  But do believe me when I say there are difficulties.11:42
SteveAso, I have no current problem.  I've archived the faulty branch and mailed martin about it, so he can examine it later if he wants to.11:43
ddaaSteveA: my pet solution for launchpad is to use my "bzr switch" command, in bzrtools. It works only on light checkouts.11:43
SteveAsabdfl: elmo has set up some kind of VPN thing to talk to the brilliant machine.  so, a VPN is an alternative for you when traveling.11:43
ddaaSo I can change the branch of the launchpad branch w/o having to touch the nested trees.11:44
ddaaIt's fast, cheap in disk space, and reliable.11:44
ddaasabdfl: I see firefox can use a SOCKS proxy. Then you can use ssh to setup such a proxy that tunnels you to e.g. the data center.11:45
=== jml [n=njml@203-217-8-89.perm.iinet.net.au] has joined #launchpad
ddaae.g. "ssh -N -D 5191 remote-host"11:46
sabdflthanks ddaa, will try that too11:47
ddaaSOCKS rocks to gets through hostile firewalls11:48
FujitsuIt really rocks!11:49
=== sabdfl [n=sabdfl@ubuntu/member/pdpc.silver.sabdfl] has left #launchpad []
=== Znarl [n=karl@bb-82-108-14-161.ukonline.co.uk] has joined #launchpad
=== sidarus [n=chatzill@] has joined #launchpad
ddaahey sidarus11:55
sidarushello ddaa :)11:56
ddaabzr branch http://bazaar.launchpad.net/~vcs-imports/oscss/trunk oscss11:56
SteveAwin 911:56
sidaruswe have also a channel on this server : #oscss11:56
sidarusddaa>thank's a lot ;)11:56
ddaaThanks too, there was a config issue in one of the internal services that caused php to try parsing bzr branch data... Fixed now.11:57
sidarusddaa> Ha ok. Merci11:58
=== doko_ [n=doko@dslb-088-073-117-103.pools.arcor-ip.net] has joined #launchpad
=== WebMaven [n=webmaven@] has joined #launchpad
=== jml [n=nnjml@203-217-8-89.perm.iinet.net.au] has joined #launchpad
carlosstub: do you have 5 minutes to talk about Rosetta?12:21
stubcarlos: yes12:21
carlosstub: several people asked us to run the script to copy translations from Dapper to Edgy before Edgy release so they can concentrate on Dapper and get their work reused for free in Edgy12:21
carlosthe copy from Breezy to Dapper took around 25 minutes, and I guess this Dapper -> Edgy copy would take more or less the same amount of time12:22
stubWe can test that12:22
carlosI think it would be really good to have12:23
carlosstub: would be useful if I time it on carbon?12:23
carlosI think it should be quite fast, at least faster than staging, isn't it?12:23
stubyes, although the timing now won't match the timing come edgy release time, will it?12:23
stubIt will be faster on carbon than on staging, yess.12:23
carlosno, timing would be different because new translations will be added12:24
carloswell, I don't think so12:24
carlosbecause the amount of templates will not change12:24
stubAnyway, I think your assumption is right and it won't be a major hassle to have a 40 minute downtime instead of a 10 minute downtime one update.12:25
carlosand the amount of new rows will not be as high as the amount of rows we already have12:25
carlosso, could I announce that we will do that migration?12:25
stubIt will be nice though when no downtime is needed or we have inheritance and no need for such bloated tables :)12:25
carloswithout a fixed date, but just that it will happen before Edgy release12:26
stubcarlos: Sure12:26
carlosstub: yeah, inheritance would rock here12:26
stubWill this mean people are translating obsolete versions though?12:26
carlosno, people will translate Dapper as their main target12:26
carlosand those translations will still be used for the next 4 years12:26
carloswith regular language packs updates12:27
carloswhen we implement multicasttranslations spec this migration will not be required anymore12:27
stubMakes me think translations should not be tied to versions though, and when you are translating 'an application' you actually should be translating several versions all mushed together. But I digress ;)12:27
carlosbecause translators will be able to do the migration while they translate the system12:27
carlosstub: yeah, that would be another way to implement inheritance ;-)12:28
=== fabbione [i=fabbione@gordian.fabbione.net] has joined #launchpad
jameshthe pending-reviews script seems a lot slower to process all branches than it was a few days ago12:28
jameshthe current run has been going for almost 2 hours12:29
=== jml [n=nnnjml@203-217-8-89.perm.iinet.net.au] has joined #launchpad
ddaaI'm going out soon for a doctor appointment.12:50
=== jsgotangco [n=jsg123@ubuntu/member/jsgotangco] has joined #launchpad
malccstub: ping12:52
stubmalcc: pong12:52
malccstub: Hi. I've got a patch I'm developing which, among other things, renames distroreleasequeue to "upload"12:53
stubThat is a bit vague12:53
=== lfittl [n=lfittl@] has joined #launchpad
malccstub: I'm having trouble with the sequence distroreleasequeue_id_seq, it seems tied to the id12:53
stubLots of bits of launchpad have uploads12:53
stubmalcc: have a look at database/scheme/archive/patch-25-48-0.sql, and try to think up a better name for our flat table namespace12:55
malccstub: Thanks, will do12:55
jordidanilo-brb: I was telling about the divehi plurals yesterday12:56
jordiI mailed you during the weekend12:56
stubmalcc: (and yes, it is not a typo that you need to use alter table to rename sequences)12:56
malccstub: I didn't think it was, it suddenly explained why alter sequence was so little help :)12:57
=== gnomefreak [n=gnomefre@ubuntu/member/gnomefreak] has joined #launchpad
=== jml [n=nnnnjml@203-217-8-89.perm.iinet.net.au] has joined #launchpad
=== BjornT [n=bjorn@clt-84-32-240-183.dtiltas.lt] has joined #launchpad
danilosjordi: uhm, then I must have missed that one01:24
=== Seveas [n=seveas@ubuntu/member/seveas] has joined #launchpad
=== carlos -> lunch
=== salgado [n=salgado@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
salgadostub, around?01:58
stubsalgado: yes01:58
=== Spads_ [n=spacehob@] has joined #launchpad
salgadohey stub, have you seen that cherry pick request I placed on LaunchpadProductionStatus?02:00
stubMaybe. I'll have a look.02:01
stubYer - I've seen it. I guess I should push it out :)02:03
lifelessSteveA: next you see sabdfl, the answer is 'no;02:10
lifelessSteveA: because most (all?) browsers dont use https to talk to the proxy02:10
lifelessSteveA: squid built with ssl, and apache built with ssl can definately do it as far as the proxy logic goes, but the browser is currently your weak point.02:10
lifelessSteveA: my recommendation is one of the [excellent]  SSL tunneling VPN things like ssltunnel et al02:11
lifelesswhich tunnel all your traffic through, giving you access to email and so on problem free.02:11
salgadothanks stub!02:16
salgadois there anybody using dogfood?02:16
malccYes, I am02:16
salgadoI guess it will take long?02:17
=== matsubara [n=matsubar@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
malccA while, yes02:17
=== Ubugtu [n=bugbot@ubuntu/bot/ubugtu] has joined #launchpad
cprovstub: do you think indexing the SourcePackageRelease.changelog would be expensive ? (see bug #48735)02:30
UbugtuMalone bug 48735 in soyuz "changelog histories for packages are not viewable/searchable" [Medium,Needs info]  http://launchpad.net/bugs/4873502:31
=== niemeyer [n=niemeyer@] has joined #launchpad
=== matthewrevell [i=synchron@outbound.silenceisdefeat.org] has joined #launchpad
stubsalgado: We have test failures with that cherry pick02:42
stubsalgado: https://devpad.canonical.com/~andrew/paste/filedeulLf.html02:43
=== salgado looks
salgadoah, right02:45
salgadostub, apparently the cherry pick included the tests I added in r4038 but not the changes themselves. is that possible?02:46
stubThat would be odd considering the cherry pick was r405002:48
salgadoindeed, but that line was actually added in r4038.  I just checked the diff for that revision02:49
salgadoI guess this happened because I touched the same file in r405002:50
salgadoand r4038 is a pretty small change, but includes a db patch. :-(02:51
stubtest_shipit.py? There is a conflict on that file. I'll look at that again.02:51
salgadojust removing TestShippingRun should be enough, I think02:52
=== salgado checks
=== sabdfl [n=sabdfl@ubuntu/member/pdpc.silver.sabdfl] has joined #launchpad
LarstiQheya sabdfl 02:53
stubCan't see anything wrong with how I resolved the conflicts... https://devpad.canonical.com/~andrew/paste/fileHi1qEy.html02:54
LarstiQsabdfl: safely back from travel?02:54
sabdflLarstiQ: yup and mostly in home timezones too, now02:54
LarstiQsabdfl: "mostly"? :)02:54
sabdflstill waking up a bit early02:54
LarstiQsabdfl: have you spoken with SteveA about rosetta output copyright yet?02:56
stublifeless: You might want to look at that if salgado is correct and changes made in r4038 have leaked into a cherry pick of r405002:56
sabdflLarstiQ: he said he was working up a proposal02:57
salgadostub, could the problem be that both revisions (4038 and 4050) came from the same branch of mine (shipit-trivialities)?02:58
LarstiQsabdfl: thanks02:59
salgadostub, for now, if you remove the TestShippingRun tests, everything should work just fine.  but I'd like to have a look at the diff of the cherry pick, just to make sure this is the only thing that shouldn't be included in it03:00
=== flacoste [n=francis@modemcable207.210-200-24.mc.videotron.ca] has joined #launchpad
=== seb128 [n=seb128@ubuntu/member/seb128] has joined #launchpad
salgadostub, any luck with that?03:19
stubsalgado: tests are still running03:19
salgadoah, right03:20
=== Nafallo [n=nafallo@ubuntu/member/nafallo] has joined #launchpad
salgadostub, would it be possible for you to merge from my person-creation-rationale into staging and run a script there, or grant me persmission to access staging's db, so that I can do it myself?03:21
=== raphink [n=raphink@ubuntu/member/raphink] has joined #launchpad
=== Seveas [n=seveas@ubuntu/member/seveas] has joined #launchpad
malcckiko: Morning dude. Will you have some time today to look at my review response for the post-sprint fixes?03:30
kikomalcc, sure -- where is it?03:31
malcckiko: Emailed yesterday afternoon, subject "Re: REVIEW: Soyuz smoketest fixes, was Re: Soyuz System Test Progress"03:32
kikomalcc, I didn't get this. was it To: kiko?03:33
malcckiko: Yes. I'll re-send it to you now03:33
stubsalgado: tests run fine, I can cherry pick that03:33
SteveAkiko: call in 2 hrs03:34
kikoSteveA, with mark?03:34
stubsalgado: I'll do staging after the cherry pick03:34
salgadostub, cool. thanks a lot!03:34
SteveAgo kiko 03:37
SteveAactually, that was a mistyped irssi command03:37
SteveAbut you can accept it as encouragement03:37
stubsalgado: cherry picked03:39
SteveAddaa: ping03:39
=== Keybuk [n=scott@quest.netsplit.com] has joined #launchpad
SteveAcarlos, danilos: ping.  want a quick catch-up chat sometime03:49
carlosSteveA: I'm here03:49
SteveAcarlos: can we say, 10 mins, on the hour?03:50
carlosSteveA: danilo and I have a couple of meetings today, would be possible to have it tomorrow?03:50
carlosor if it's really fast, is fine for me...03:50
SteveAI want it, but fast is good03:50
carlosSteveA: the meetings are related to our current tasks and I guess are related to the meeting you want to have with us03:51
SteveAso, is meeting in 10 mins okay?03:51
carlosyes, it works for me03:52
carlosnot sure whether danilo is around03:52
SteveAok, let's see in 1003:52
=== sabdfl [n=sabdfl@ubuntu/member/pdpc.silver.sabdfl] has joined #launchpad
carlosSteveA: #cm ?04:00
SteveAhow about #l-m ?04:01
SteveAI mean, #launchpad-meeting 04:02
ddaaSteveA: pong04:03
ddaaback from the doc04:03
=== bradb [n=bradb@wnpgmb09dc1-71-199.dynamic.mts.net] has joined #launchpad
WebMavenSteveA: Mornin'04:23
flacostekiko: ping04:25
kikoflacoste, pongus04:27
flacosteflacoste: will you have time to take a look at the 4 unresolved issues on the SupportTrackerWorkflowSpec (and they were alo mentioned in some emails you were Cc on)04:28
=== lbm [n=lbm@] has joined #launchpad
flacosteflacoste: they are: a) multiple best answers or not; b) should we migrate old ticketmessage more precisely; c) should we keep TicketReopenings; d) should we generate karmaaction for all the workflow transitions04:29
flacostekiko: ^^04:29
flacostekiko: my standing: a) no, b) more yes, than no, c) no, d) no04:30
=== bradb_ [n=bradb@wnpgmb09dc1-71-199.dynamic.mts.net] has joined #launchpad
kikoflacoste, yeah, I will. just ping me in the afternoon after my phone call04:32
flacostekiko: ok04:32
stubsalgado: I reworked your db patch a bit as the update was taking too long: https://devpad.canonical.com/~andrew/paste/fileFFEFZ1.html04:34
stub(although I don't know if it is really any faster...)04:35
stubsalgado: staging is back up with your branch04:35
salgadostub, cool. I'll fix the patch on my branch04:36
stubsalgado: Do you need me to disable tomorrows update, or do you only need a short time to check it out?04:36
salgadostub, can you run python ./scripts/guess-person-creation-rationale.py04:36
salgadoI just want the output of that script, actually, and maybe check the results on the UI today, so there's no need to disable tomorrow's update04:36
stubRunning now04:37
stubsalgado: Does that script process all people in order of id?04:39
salgadostub, all unvalidated people in no specific order04:40
WebMavenSteveA: ping04:40
stubSo we have no way of telling how long this will take...04:40
malccstub: I need to re-shuffle some dbs on mawson, and a long-running EXPLAIN process is stopping me. Can you come kill it for me?04:41
SteveAWebMaven: kinda busy right now04:41
stubsalgado: If it happens to be processing in id numeric order, which is highly likely given the staging database is rebuilt fresh daily, then this run will take about 17 hours.04:42
WebMavenSteveA: later, then.04:43
stubsalgado: (extrapolating from https://devpad.canonical.com/~andrew/paste/fileISPhj9.html)04:43
stubsalgado: Does this run in a single transaction?04:43
salgadostub, no, one transaction for each person04:43
salgadostub, https://devpad.canonical.com/~andrew/paste/fileuTud5L.html is how I fetch the list of people ids04:44
stubThat could be a cause - should batch them in lots of about 500004:44
salgadostub, it won't print tthese messages for all profiles04:44
salgadoonly for a few of them, I expect04:44
salgadovery few, in fact04:45
stubYes, but looking at that query the ids will be ordered (to do the EXCEPT, both queries will be ordered before being merged I think). So we have so far processed about 6000, and there are over 600,000 rows to do.04:46
stuboh - so only commit per row it prints out. I see.04:46
salgadono, it commits for all rows, but that "Select ... EXCEPT Select ..." won't return 600000 rows, will it?04:47
stubsalgado: No - only 15,000 or so04:48
stubsalgado: Need to test with that batching though - this seems very slow04:53
stubI'm going to need to kill it and re-run it under screen04:53
salgadostub, sure, I'll add the batching quickly04:55
salgadostub, so, since we'll be processing around 15k rows, would it be okay to have a batch of 500?04:56
stubMaybe 50 actually - it depends on how long it takes to process each row04:57
salgadoit shouldn't take too long, I think04:58
malccstub: Ping04:59
stubsalgado: It is still going to take at least 30 mins - seems to be a maximum of 10 per second05:00
stubAnd maybe down to around 1 per second on avg05:02
malccCan anybody help me with the db on mawson? I need to rename launchpad_dogfood (as I often do during SoyuzSystemTest stuff) and another process is using it.05:05
kikomalcc, which process?05:06
kikoor is that the question? :)05:06
malcckiko: postgres  9539  1433 96 Sep18 ?        17:15:51 postgres: launchpad launchpad_dogfood [local]  EXPLAIN05:06
malcckiko: Or at least that's my guess, it looks a likely candidate05:06
stubmalcc: Process 9539 is the source05:07
stubWhich looks like salgado, but I've killed it.05:08
malccstub: Cool, thanks05:08
salgadoyeah, I had one psql session doing an explain there yesterday and I lost the connection at some point.  I guess it was mine05:09
kikodon't kill salgado05:09
salgadokiko, https://staging.launchpad.net/people/mckinstry05:11
salgado(a problem in the sort order is causing the latest uploaded package to be used in the comment, but I've fixed it already)05:11
kikosalgado, very nice. I don't know whether parenthesized text is the right way to deliver this, but that's another matter.05:11
salgadokiko, please comment on the spec. that's what mpt suggested on the spec05:12
kikosalgado, I'm happy the way it is, just that I wasn't sure.05:12
salgadostub, not finished yet?05:24
=== Kuhrscher [n=jannick@] has joined #launchpad
malcckiko: Did you get my forwarding of that email?05:34
kikomalcc, yes, but I'm in a phone call.05:34
malcckiko: Sure, no hurry, just wanted to avoid the case if it went missing of losing another day.05:35
=== frodon_ido [n=patrick@ip-213-49-147-165.dsl.scarlet.be] has joined #launchpad
malccelmo: Ping05:35
kikomalcc, can you ask somebody else to look at it meanwhile?05:36
SteveAkiko: ping05:36
malcckiko: I have to go out in half an hour, if you'll get time later today it'll be quicker to stick with you. If that's not looking likely, sure, I'll look for another reviewer05:36
kikothat's likely, just don't want any waste05:37
malcckiko: Cool, I'll wait then, and if there's nothing tomorrow morning I'll find a euro-timezone reviewer then05:37
jordioh man05:50
jordiare you guys aware of stuff in Tailand05:50
jordipossible coup d05:51
jordioh man05:51
jordiI can-t type with this keyboard05:51
jordicoup d'etat05:51
=== sabdfl [n=sabdfl@ubuntu/member/pdpc.silver.sabdfl] has joined #launchpad
malccelmo: unping06:00
=== kristog [n=ballio@energ63.energ.polimi.it] has joined #launchpad
kristoghello *06:03
kristogi wonder if you know how i can setup a commit-message mailing list for a project06:04
kristogthe project is ~telepathy hosted on bazaar.lp.net06:04
=== stub [n=stub@ppp-] has joined #launchpad
=== mpt [n=mpt@203-167-187-52.dsl.clear.net.nz] has joined #launchpad
carlosmpt: hi, around?06:25
=== marcus_notebook [n=mholthau@dz6330holthaus-e0.fx-hfc.datazug.ch] has joined #launchpad
carlosdanilos: hi?06:27
=== jelmer [n=jelmer@] has joined #launchpad
danilosSteveA, carlos: hey guys, sorry about this, I just crashed (and laid down just to relax for 5 mins), guess I caught a cold or something, can concentrate only in 4h slots :(06:47
carlosdanilos: don't worry06:47
SteveAdanilos: no worries.  carlos and I discussed the things about rosetta we needed to06:47
carlosI think we should leave our meetings for tomorrow06:47
carlosso you are more concentrated06:47
carloswhat do you think?06:47
daniloscarlos: sure, but there is already https://launchpad.canonical.com/ITranslationImporter you can look at06:48
danilosSteveA: ok, can you fill me in with some details?06:48
carlosdanilos: I can send you the log06:49
SteveAgo kiko 06:49
carlosdanilos: ok, I will read it so the meeting will be more productive, thanks06:49
daniloscarlos: ok, thanks06:50
carlosdanilos: sent06:51
SteveAstub: ping06:52
stubSteveA: pong06:52
kikostub, how's th?06:54
stubDark and raining06:54
kikowhat is this news we hear about tanks?06:55
stubThey just took CNN and BBC off the air so you will probably know news before I do06:55
stubJust another coup06:55
stubHeh - interesting quote "I just spoke to a friend on Suk: He said there's a big f**king party going on to celebrate Thaksin's downfall! In his words.. "..time for another line of coke and a blowjob"07:02
=== bradb & # lunch, bbiab
=== Spads [n=spacehob@host-87-74-55-77.bulldogdsl.com] has joined #launchpad
imbrandonping .... um i dont think i should be seeing the accept/reject buttons for the NEW queue am I ? heh 07:22
imbrandonhttps://launchpad.net/distros/ubuntu/edgy/+queue  ^^07:22
elmothey don't do anything07:23
imbrandonok whew, just wanted to make sure it wasent a major problem, i'm smart enough not to test if they worked but someone else might not have07:23
imbrandonheh thanks elmo 07:23
salgadostub, still around?07:25
=== jdong [n=jdong@ubuntu/member/jdong] has joined #launchpad
kikoBjornT... you donna love me :)07:49
BjornTkiko: don't worry, i'm going to review your patch tonight :) just need to get something to eat first.08:00
kikoBjornT, if you take too long I will give you ANOTHER patch!08:00
=== kristog [n=ballio@energ63.energ.polimi.it] has left #launchpad []
=== jdong [n=jdong@ubuntu/member/jdong] has left #launchpad ["Leaving"]
=== flacoste [n=francis@modemcable207.210-200-24.mc.videotron.ca] has joined #launchpad
=== jelmer [n=jelmer@] has joined #launchpad
=== flacoste [n=francis@modemcable207.210-200-24.mc.videotron.ca] has joined #launchpad
=== Kuhrscher [n=jannick@] has joined #launchpad
KuhrscherHi, is it possible that there went something wrong during the import of kdeaccessibility's pot files?08:18
KuhrscherThere is for example a template for kttsd without any strings...08:18
ddaaIf somebody thinks that the "subversion repository" on this page https://launchpad.net/products/python/trunk looks weird, it's normal. I'm running the import from a local copy of the repository so it does not take forever.08:19
Kuhrscher(instead of 462)08:19
stubsalgado: sodium:~stub/person-creation-rationale.txt08:21
salgadothanks a lot, stub!08:23
salgadostub, at some point you killed the script and started it again, right?08:25
stubyes - I needed to rerun it under screen08:31
salgadook. I was wondering why some profiles already had a creation rationale08:31
salgadostub, can you check if the account named sutton-david-merged has a preferred email in production?08:32
carlosKuhrscher: let me check08:32
salgadostub, would you be kind enough to run another script on staging for me? (https://devpad.canonical.com/~andrew/paste/filePU9NaR.html)08:35
=== mholthaus_ [n=mholthau@johnny33.dersbach.ch] has joined #launchpad
stubsalgado: Yes, sutton-david-merged has a preferred email address on production08:43
kikostub, would you approve of the trivial https://sodium.ubuntu.com/~andrew/paste/fileoM0oDN.html08:44
stubkiko: That seems broken. Why is the (1,2,3) quoted?08:47
kikostub, that's the test part..08:47
stubYes, and it seems to be demonstrating broken behavior (?)08:48
kikoso omit the external ""s08:48
stubI would have throught quote(set([1,2,3] ) would return "(1,2,3)", not "'(1,2,3)'"08:48
stubie. not a string08:49
=== flacoste [n=francis@modemcable207.210-200-24.mc.videotron.ca] has joined #launchpad
kikostub, it does08:49
kikomy test was just broken08:50
stubThe tests show it returning a single quoted string08:50
kiko>>> quote(set([1,2,3] ))08:51
kiko'(1, 2, 3)'08:51
kikothat's a make harness run08:51
kikoI just hadn't run the ftests for that file08:51
stubfine then08:51
kikostub, do you have other philosophical issues with the patch?08:51
kikoah, thanks.08:51
carlosKuhrscher: yeah, the .pot file is broken08:54
salgadostub, kiko, I just reported https://launchpad.net/products/launchpad/+bug/61288. any idea how that could have happened?08:54
KuhrscherCarlos: Thanks for checking it08:55
carlosKuhrscher: Jonathan is fixing that issue with other template in kdebase, and he just told me that will fix those ones too08:55
stubsalgado: Your script doesn't actually connect to the db - might need some basic testing08:56
KuhrscherDo we have to upload all translations manually or will they be implemented automatically?08:56
kikosalgado, that kinda sucks, eh?08:56
kikosalgado, how long ago was it created?08:56
stubCould have been a manual update sometime08:56
salgadostub, ah, sorry.  that code is meant to be run in a "make harness" section08:56
stubwhatever that means08:56
KuhrscherCarlos: Do we have to upload all translations manually or will they be implemented automatically?08:57
carlosKuhrscher: for ubuntu, they are updated automatically with every new package upload into Ubuntu's archive08:57
salgadostub, an interactive session. either python -i canonical/database/harness.py or simply "make harness"08:57
salgadostub, that is not actually a script... is just a collection of hacks I used to use when I had access to staging08:58
kikosalgado, why don't you have access to staging any longer?08:58
salgadokiko, matsubara is going to check that for us08:58
KuhrscherCarlos: Yes I know, but this won't be really a package upload right?08:59
salgadokiko, no idea08:59
carlosKuhrscher: yes, it is08:59
KuhrscherGreat :)08:59
KuhrscherCarlos: Thank you08:59
kikosalgado, it is now accessed from devpad. have you tried from there?09:00
salgadoactually, I think I had access to staging only for one or two days09:00
salgadoyeah, it lasted until it was rebuilt09:01
salgadoit wasn't "official" access09:01
salgadokiko, it was created on 2005-06-15, but we can't tell when it was merged09:02
kikosalgado, when was the account where it was merged to created?09:02
matsubara> select name, merged, datecreated from person where name = 'suttondavid';09:03
matsubara    name     | merged |        datecreated09:03
matsubara suttondavid |        | 2005-11-30 07:20:59.93686909:03
matsubara(1 row)09:03
=== lfittl [n=lfittl@85-125-229-117.dynamic.xdsl-line.inode.at] has joined #launchpad
kikoso recently merged09:05
salgadoit could have been merged last week or 10 months ago... we can't tell for sure09:05
kikowell, less than a year ago.09:06
kikosalgado, could it be  race condition, i.e. gina ran at /exactly/ the same time as this dude was created?09:08
salgadoat the time it was merged, you mean?09:09
salgadoI doubt that, because gina wouldn't set a preferred email09:10
=== flacoste [n=francis@modemcable207.210-200-24.mc.videotron.ca] has joined #launchpad
=== flacoste [n=francis@modemcable207.210-200-24.mc.videotron.ca] has joined #launchpad
kikowhat about the guy has a token open for a preferred email09:15
kikothen merges09:15
kikothen approves the token?09:15
kikodo we check for pending tokens?09:15
salgadothe token should have been carried, AFAICS09:16
kikoI guess.09:19
salgadostub, did you manage to run that hackish script on the interactive session?09:22
andrunkoi uploaded my package to launchpad.net (only the debian dir) to http://bazaar.launchpad.net/~telepathy/telepathy-qt/ubuntu, how can i upload the source package to get it to build?09:23
andrunkohi all btw :)09:23
=== Nafallo [n=nafallo@ubuntu/member/nafallo] has joined #launchpad
kikoandrunko, heh, you're a month or so ahead of us. we don't have a custom package-building facility yet09:28
andrunkoso what should i do to get it to build?09:29
kikoandrunko, well, you could talk to a motu at #ubuntu-motu..09:31
kikoandrunko, what are you trying to build?09:31
andrunkokiko: i would like to add telepathy-qt to https://launchpad.net/distros/ubuntu/edgy/+queue09:33
kikoandrunko, talk to a motu. 09:34
stubsalgado: sodium:~stub/invalid-people-with-non-bug-references.txt09:43
flacostekiko-afk: remdinder to reply to the pending unresolved issues on SupportTrackerWorkflowSpec09:45
salgadostub, you rock! thanks a lot again09:46
UbugtuNew bug: #61296 in rosetta "Please remove "no" from picard" [Untriaged,Unconfirmed]  http://launchpad.net/bugs/6129609:50
=== frodon_ido [n=patrick@ip-213-49-147-165.dsl.scarlet.be] has joined #launchpad
kikostub, I have an SQL question for you.. have amoment?09:52
=== Mez [i=Brummi3@ubuntu/member/mez] has joined #launchpad
cprovkiko: ping10:04
kikocprov, pong10:04
kikoahoy there.10:04
cprovkiko: hi, do you think we can apply the partial fix for bug #58144 in soyuz production (see https://sodium.ubuntu.com/~andrew/paste/filePGGlNa.html)10:04
UbugtuMalone bug 58144 in soyuz "Backport is rejected if an older backport is already there" [Critical,Fix committed]  http://launchpad.net/bugs/5814410:04
kikocprov, it's a simple change isn't it?10:05
cprovkiko: the RF 4066 can't be applied entirely ...10:05
cprovkiko: I've isolated the important chunk to nascentupload10:05
cprovkiko: dude, the current codeline is RF3909 based with tons of cherrypicks (17) and a local change ... i.e. a mess ;)10:06
kikowhich local change?10:07
cprovkiko: on of the malcc bug fix, commited in RF but the changeset could not be applied too, let me see the bug number10:07
cprovkiko: bug # 5818710:08
cprovbug #58187 ?! Mr. bot ?10:09
UbugtuMalone bug 58187 in soyuz "uploads to frozen should land in unapproved, not be rejected" [Critical,In progress]  http://launchpad.net/bugs/5818710:09
=== jelmer [n=jelmer@] has joined #launchpad
kikocprov, isn't there yet another bug related to backports? or is that proposed?10:10
cprovkiko: dunno, the other backport related was broken release file or so, fixed during mawson tests, but we may be talking about different things ...10:12
cprovkiko: ahh, sending announceemail to a different mbox when dealling with dapper-backports10:13
cprovkiko: bug #5944310:13
UbugtuMalone bug 59443 in soyuz "Soyuz should send announce messages for backports to different list" [High,Confirmed]  http://launchpad.net/bugs/5944310:13
kikono, I thought there was something else10:14
kikocprov, I am okay with you applying that there, I guess.10:16
cprovkiko: nice, thank you 10:16
=== LeeJunFan [n=junfan@adsl-69-210-207-5.dsl.klmzmi.ameritech.net] has joined #launchpad
Mezhmm - out of curiosity - which mbox will it be sent to ?10:18
kikohmm, can't remember10:18
Mezalso - when a backport gets uploaded - is it possible to set the Changed-by to the backports mailing list - :D so that the backports mailing list gets an email10:19
Mez(atm - iirc, soyuz sends an email to the maintainer, the changed-by, and the person who signed the upload)10:19
cprovMez: announcelist & signer only 10:20
cprovMez: do you think we are going to have one ML per pocket (dapper, dapper-updates, dapper-backports, etc) ?10:21
Mezcprov: well thats weird - because I remember getting mail as a maintainer when Riddell uploaded katapult10:21
cprovMez: only if you have preferredemail set in LP ... that's right10:23
=== Mez is confused
cprovMez: at the end, announcelist + signer (always has preferredemail) + maintainer (if he has preferredemail)10:24
Mezah, kk10:25
=== webben [n=webben3@] has joined #launchpad
webbensiretart, i'd like to try your vim7 build --- if i want the entire shebang, is vim-full all i need?10:27
siretartwebben:   10:35
kikoflacoste, pong10:36
flacostekiko-afk: ping10:36
siretartwebben: err, check which package of vim you have installed and then upgrade the one you have installed10:36
kikoflacoste, what do I need to look at?10:36
flacostekiko-afk: (about the unresolved issues on SUpportTrackerWorkflowSpec)10:36
flacostekiko-afk: you can take a look at https://launchpad.canonical.com/SupportTrackerWorkflowSpec10:37
webbensiretart, ah that was a whole batch of packages; i guess i should replace each of those then, thanks10:37
flacostekiko-afk: in the Unresolved Issues section, you'll find the summary with links to the emails in the archive, you were Cced on those10:37
=== Burgwork [n=corey@ubuntu/member/burgundavia] has joined #launchpad
=== gnomefreak [n=gnomefre@ubuntu/member/gnomefreak] has joined #launchpad
=== Fujitsu [n=Fujitsu@ubuntu/member/fujitsu] has joined #launchpad
=== webben [n=webben3@] has joined #launchpad
=== raphink [n=raphink@ubuntu/member/raphink] has joined #launchpad
=== lfittl [n=lfittl@85-125-229-117.dynamic.xdsl-line.inode.at] has joined #launchpad
=== Fujitsu [n=Fujitsu@ubuntu/member/fujitsu] has joined #launchpad
=== AlinuxOS [n=alinux@d81-211-222-123.cust.tele2.it] has joined #launchpad
kikohey BjornT?11:54
=== bradb [n=bradb@wnpgmb09dc1-71-199.dynamic.mts.net] has joined #launchpad
=== flacoste [n=francis@modemcable207.210-200-24.mc.videotron.ca] has left #launchpad ["Bye"]

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