/srv/irclogs.ubuntu.com/2005/12/05/#launchpad.txt

=== JanC [n=janc@lugwv/member/JanC] has joined #launchpad
=== jblack [i=jblack@static-209-158-45-74.scr.east.verizon.net] has joined #launchpad
elmolifeless: both things done now12:40
lifelesselmo: thanks!12:40
elmooh, but not the port 8000 forwarding.  blah.12:40
=== elmo reopens the ticket
lifelessheh12:42
lifelessif you open port 8000 from chinstrap to balleny12:42
lifelessthen folk can look at it by hand until we cut over12:42
elmooh, right12:44
elmoam I ok to do that now?12:44
lifelessdo which? (Want to be clear)12:45
elmore-direct https://pqm.ubuntu.com/ to balleny12:45
lifelessno12:45
lifelessuntil balleny is live that would be, uhm, harmful.12:46
elmooh, right.  in that case, I'll close the ticket, can you reopen or open a new one, when I should do the switch12:46
lifelesswe need to switch the http://pqm.ubuntu.com address and pqm@pqm.ubuntu.com at the same time12:46
elmoright12:46
lifelessas soon as I'm confident with the pqm on balleny, I'll ask that we do both 12:47
elmocool12:47
lifelessideally at a time we're both around for a bit afterwards12:47
jblackelmo: Hey, I've lost power not once, but twice today. Feel like doing a quicky zone transfer? 12:47
elmojblack: transfer of what?12:47
jblacksourcecontrol.net. I'm still running the authoritive serversa.12:48
elmojblack: gimmie a zone file?12:48
elmoor do you just want me to secondary?12:48
jblackSecondary works.12:48
jblackI figure in a couple months we won't be using that for work anymore, and I can get it back anyways.12:48
jblackor not, as I've got revisioncontrol.net :)12:49
jblackwhat is the hostname and ip of the dns server you have in mind? 12:49
elmojblack: ns.ubuntu.com 82.211.81.17312:51
elmoI'm setup to secondary, let me know when an AXFR will work12:51
jblack Should be trying to send12:52
elmook, synced; you should be good to add me12:53
elmoNov 29 23:52:48 esperanza named[515] : zone sourcecontrol.net/IN: transferred serial 20050903012:53
jblackGreat.12:53
jblackAnd you'll update for a tertiary server at the registrar?12:54
elmooh, do we control that?  *giggle* sorry.  btw, let's take this to #canonical or privmsg, it's not really LP related12:54
jblacksure12:54
=== a|so [n=a_s@hn-47-52.brookes.ac.uk] has joined #launchpad
a|sohi people01:32
=== stub [i=stub@sweep.bur.st] has joined #launchpad
=== poningru [n=poningru@n128-227-55-1.xlate.ufl.edu] has joined #launchpad
=== stub [i=stub@sweep.bur.st] has joined #launchpad
=== Alinux [n=Ubuntu@d81-211-245-200.cust.tele2.it] has joined #launchpad
=== ulinskie [n=yolynne@202.57.88.34] has joined #launchpad
=== jinty [n=jinty@205.134.224.215] has joined #launchpad
ulinskieanybody knows how I can validate my gpg key at launchpad?04:21
jameshulinskie: have you uploaded it to the keyserver?04:23
ulinskiethere is an error in my system04:24
jameshyou will need to provide some more information about the problem if you want some help.04:24
ulinskiewait it says success sending to `subkeys.pgp.net' (status=200)04:25
ulinskiei will check again at launchpad04:25
jameshulinskie: you may need to wait a little while for the key to propagate04:25
=== lamont [n=lamont@mix.mmjgroup.com] has joined #launchpad
ulinskieI have done it thrice... , actually they sent me an email already thrice... saying that I need for follow the instructions to conclude the process04:27
ulinskiebut all I see are codes04:27
jameshulinskie: try this: gpg --keyserver keyserver.ubuntu.com --send $KEYID04:28
lifelessjamesh: its read only04:29
lifelessjamesh: wont allow that04:29
ajmitch_lifeless: will it allow updates of existing keys?04:30
jameshlifeless: it doesn't seem to return an error04:30
jameshI think fabbione suggested that approach once04:30
lifelessinteresting04:33
lifelesslast I heard it was and did04:33
lifelessajmitch_: its meant to pull from the wide wide net automatically04:33
jameshulinskie: anyway, if you've uploaded to the key, wait a few hours and try again04:34
=== robitaille [n=robitail@ubuntu/member/robitaille] has joined #launchpad
=== XVTIURI [n=darkside@226-111.adsl.caucasus.net] has joined #launchpad
XVTIURIAlinux ti gde?05:48
XVTIURIaris vinme aq?05:50
fabbionelifeless: keyserver.u.c is not readonly06:13
fabbioneyou can send key to it06:13
XVTIURI:)06:13
fabbionebut not via http afaik06:13
fabbioneyou need use --send-keys06:14
lifelessfabbione: ah06:18
fabbionefabbione@gordian:~$ gpg --keyserver keyserver.ubuntu.com --send-keys 63549F8E06:19
fabbionegpg: sending key 63549F8E to hkp server keyserver.ubuntu.com06:19
fabbionefabbione@gordian:~$ gpg --keyserver 192.168.1.1 --send-keys 63549F8E06:19
fabbionegpg: sending key 63549F8E to hkp server 192.168.1.106:19
fabbionefor example06:19
fabbione(192.168.1.1 is keyserver.fabbione.net)06:19
lifelessok07:02
lifelessmerges should work properly now07:02
lifeless4 hours to run check07:02
jameshlifeless: I'll give it a go then07:04
stubDid you just nuke the pqm queue, or has my request gotten stuck somewhere?07:06
lifelessneither07:09
lifelesspqm has been disabled while I fixed things07:09
lifelessdid you get an error ?07:14
stubNo - just saw my request go nowhere ;)07:16
lifelesscould you resubmit it ?07:36
lifelessstub: ^^07:57
stublifeless: Just sent (with more fixes)07:57
lifelessk07:57
lifelesslets see what happens07:57
stubDelivered to pqm07:58
stubBut can't see anything on http://pqm.ubuntu.com08:00
lifelessit caches results08:00
lifelessyou wont see it for a minute08:00
lifelessalso procmail has not delivered it08:00
lifeless(tail the log - ~/arch/queue/pqm/pqm.log08:00
stubIt was delivered to fiordland over three minutes ago08:02
lifelessstar-merge sftp://chinstrap/home/warthogs/archives/stub/launchpad/trivial/ sftp://chinstrap.ubuntu.com/home/warthogs/archives/rocketfuel/launchpad/devel08:02
lifeless ?08:02
stubThat would be the one08:02
lifelessprocmail binned iot08:03
lifelessit went to the mbox not pqm08:03
lifelessI *have* to figure out why that happens08:03
lifelessok, I've zapped the mbox08:04
lifelesstry again08:04
stubNeed to enable debugging on procmail to see why it is using the fallback08:04
stubReset08:04
stubResent08:04
lifelessmm, yes08:04
lifelesshow do to that ?08:04
=== lbm [n=lbm@cpe.atm4-0-1301006.0x50a0824e.vgnxx6.customer.tele.dk] has joined #launchpad
stubLOGFILE=/home/pqm/procmail.log08:06
stubat the top of .procmailrc could help08:06
stubAlso 'VERBOSE=yes' and LOGABSTRACT=yes08:06
stuberm... LOGABSTRACT=all08:07
lifelessok08:07
stubYou want me to try making the changes?08:08
lifelesssend it in cowboy08:08
stubsent08:08
stubI don't know if procmail does twiddly expansion08:08
lifelesspretty sure it does08:09
lifelesscould be wrong :)08:10
stubI'll change it and resent - looks like it ended up in mbox again and no log08:11
lifelessok08:11
stubOh - I see you already changed08:11
stubSo looks like the cwd might have changed?08:12
stubNope - the arch-pqm directory is gone08:13
lifelessoh, my bad08:13
lifelessright that hsould fix it08:14
stubResent08:15
stubThere it is08:15
lifelessyay08:15
jameshlifeless: is the rocketfuel-build/launchpad checkout being rebuilt since you fixed the launchpad branch?08:17
stub[]  Command failed! All lines of log output: ["PQM Cannot merge between different VCSsystems. 'sftp://chinstrap/home/warthogs/archives/stub/launchpad/trivial/'(pqm.Baz1_1Handler) and '/home/pqm/archives/rocketfuel/launchpad/devel'(pqm.Bazaar2Handler) are different."] 08:18
lifelessstub: ok, let me look at that08:19
=== zyga [n=zyga@2-mi2-1.acn.waw.pl] has joined #launchpad
lifelessfirstly08:22
lifelessit must be 'chinstrap.ubuntu.com'08:22
lifelessnot 'chinstrap'08:22
lifelessin your request08:22
lifelessgarh08:23
lifelessstop that08:23
=== lifeless takes away stubs refresh button
stub:-P08:24
lifelessok08:27
lifelessthe // url thing has landed 08:27
lifelessand is fuxked08:27
lifeless-> #bzr08:27
stub[]  Command failed! All lines of log output: ["PQM Cannot merge between different VCSsystems. 'sftp://chinstrap.ubuntu.com/home/warthogs/archives/stub/launchpad/trivial/'(pqm.Baz1_1Handler) and '/home/pqm/archives/rocketfuel/launchpad/devel'(pqm.Bazaar2Handler) are different."]  08:28
jameshstub: try sftp://chinstrap.ubuntu.com//home/warthogs/archives/stub/launchpad/trivial/ maybe?08:29
stubI'll wait and see what happens in #bzr first08:29
stubOoh... swim time. back in 30mins. Feel free to resubmit my request for testing (bzr-submit-merge '[trivial]  Add indexes to speed up librarian garbage collection and work around bug 4818 in topPeople')08:30
UbugtuMalone bug #4818: SQLObject executing spurious COUNT(*) using slices In: launchpad (upstream), Severity: Normal, Assigned to: Andrew Bennetts, Status: New http://launchpad.net/bugs/481808:30
lifelessjamesh: that does not work08:34
lifelessjamesh: at the moment.08:34
=== carlos [n=carlos@54.Red-83-53-61.dynamicIP.rima-tde.net] has joined #launchpad
carlosmorning08:34
sivangmorning08:35
lifelessok08:35
lifelessstub: should work now08:36
stubResent09:10
lifelesslooking better09:28
SteveAmorning09:44
stubMorning09:46
carlosI get this output from 'make check':09:52
carloshttps://chinstrap.ubuntu.com/~dsilvers/paste/fileX1f6lj.html09:52
carlosis there anything wrong in my code?09:52
BjornTcarlos: don't you read the launchpad mailing list? ;) both cprov and i reported the same problem09:59
=== gml_ [i=gml@dyn-83-156-7-44.ppp.tiscali.fr] has joined #launchpad
carlosBjornT, I'm not talking about the double free10:01
carlosBjornT, I'm talking about the: Exception psycopg.OperationalError: 'FATAL:  database "launchpad_ftest" does not exist\n' in <bound method Transaction.__del__ of <sqlobject.dbconnection.Transaction object at 0xb351886c>> ignored10:01
carlosor is it the same?10:01
BjornTcarlos: oh. i get that as well, doesn't seem to cause any problems, though. (the glibc error seems to stop the test suite in the middle, though, so you might want to skip the test causing that)10:04
carlosBjornT, which test is that? do you know it?10:04
carloshmm I suppose it's in your email to launchpad inside the big debugging log...10:05
BjornTcarlos: testSetOwnerTrust in test_gpghandler.py10:05
carlosBjornT, an I suppose the way to disable it is just move it outside the launchpad tree, right?10:06
BjornTcarlos: that's one way. another is to run python test.py "!test_gpghandler"10:07
carloshmm I prefer your suggestion ;-)10:07
carlosBjornT, thanks10:07
=== carlos adds it to the FAQ
carlosBjornT, it does not work here...10:22
carlosBjornT, it ignores all tests10:22
BjornTcarlos: really? try: python test.py "\!test_gpghandler"10:24
carlosBjornT, I did it already10:24
carloswithout the '\' bash complains about '!'10:25
carlosand with the \!... the tests are not executed10:25
BjornTcarlos: oh... then, use tcsh instead? ;)10:26
jameshBjornT: carlos try single quotes10:27
=== carlos ignores BjornT and uses a real shell...
jameshBjornT: took a bit more of a look at the problem, but didn't find a solution10:28
carlosjamesh, thanks, it works now10:28
=== jordi [n=jordi@115.Red-213-96-69.staticIP.rima-tde.net] has joined #launchpad
BjornTjamesh: too bad, seems like more and more people are getting that error. would it help if you had access to a machine where it's reproducible?10:31
jameshBjornT: I'm going to try it out on my laptop next (x86)10:32
jameshBjornT: I tried running the tests under valgrind without success10:32
BjornTok10:32
jameshBjornT: the answer might just be that pyme sucks because it uses swig ...10:33
=== jamesh has a hard time trusting memory management of swig extensions
jordihello10:41
jordiwow, that was a bad blackout10:41
SteveAjordi: too much coffee ?10:41
jordinever!10:41
jordidunno, the server wouldn't work until this morning10:42
carlosjordi, hi, are you subscribed to ubuntu-translators mailing list?10:42
jordinot sure10:42
jordiI see your reply now10:44
carlosjordi, I added you to the CC10:44
carlosbecause I was not sure you were subscribed10:44
jordiit seems I'm not10:44
jordioh damn10:44
carlosI think you should join that list....10:44
jordiI'm getting buried under email :/10:44
carlosjordi, just like kiko!!!10:45
carlos;-)10:45
jordiI dunno how he manages. :)10:45
lifelessSteveA: the merge problem is fixed10:46
lifelessand pqm/bzr updated to prevent it happening again10:46
SteveAlifeless: cool.  is there a short explanation of what happened?10:59
lifelessyes, there was a bug in merge, which meant it did not copy all needed data. this shows itself potentially much later.11:03
=== sbec [n=sbec@eureka.av7.net] has joined #launchpad
sbechello11:12
sbecI register on launchpad yesterday night but never receive mail ...?11:13
SteveAsbec: that's interesting.  i can try sending you some email, to see if it works.11:17
SteveAsbec: /msg me your email address, and i'll send you some test email.  then we can see where the problem is likely to be.11:18
sbecUh, I try again and it works, dono where went the first email ... maybe in the dark internet :-)11:19
SteveAmaybe you or your ISP has a "greylisting" service.  that can cause problems sometimes.11:19
=== carlos workraves
sbecSteveA: no, i'm my own isp :)11:22
sbecNevertheless, thank you.11:23
=== WaterSevenUb [n=WaterSev@azevedo.astro.up.pt] has joined #launchpad
=== koke [n=koke@ubuntu/member/koke] has joined #launchpad
sbecBye.11:49
=== sbec [n=sbec@eureka.av7.net] has left #launchpad []
=== Keybuk [n=scott@descent.netsplit.com] has joined #launchpad
=== salgado [n=salgado@201-1-135-249.dsl.telesp.net.br] has joined #launchpad
=== matsubara [n=matsubar@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
=== beyond [n=beyond@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
matsubaragood morning!12:17
Kinnisonhi matsubara 12:17
=== salgado_ [n=salgado@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
WaterSevenUbcarlos, thx for your reply in #rosetta-u. Old problems (probably filed in the wrong place) were never assigned so I'm wondering if the suggestions for improvements are correctly filed. U can check https://launchpad.net/people/astronomy/+reportedbugs just to see if this is the right place to do it. Thx again.12:20
=== camilotelles [n=Camilo@20132194128.user.veloxzone.com.br] has joined #launchpad
=== zygis [n=zygis@clt-84-32-129-122.dtiltas.lt] has joined #launchpad
=== sivang is now known as sivang_away
matsubarahey Kinnison do you have a reply for the e-mail kiko cc'ed you about the 1132 bug?12:22
carlosWaterSevenUb, the bugs are filed in the right place, it's just I'm a bit behind with my user support tasks12:23
carlosWaterSevenUb, I hope I will look into all bug reports before the end of this week12:24
carloslifeless, How is possible that, from time to time, a 'bzr push' needs to sync weaves that were already synced?12:25
WaterSevenUbcarlos, k. Hang on the great job:)12:25
carlos;-)12:26
=== kiko [n=kiko@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
kikogood morning hackers12:38
kikohey SteveA 12:38
carloskiko, morning12:38
kikohey carlos how's it going12:38
carlosfine, thanks12:39
kikotell me how the uploads are going?12:39
carloshmm I did my first bzr merge request and I think I fucked it....12:39
carlos;-)12:39
=== GoRoDeK [n=gorodek@p5083DC98.dip.t-dialin.net] has joined #launchpad
carloslifeless, could you remove my request so I sent it again with the 'sftp://' string added?12:39
carloskiko, waiting for Steve's review12:40
carloskiko, In the mean time I'm working on user support12:40
kikocarlos, what about my favorite feature, POMsgSet? :)12:42
kiko+View12:42
=== BjornT -> lunch
carloskiko, I will be on holidays next week so I don't think I should start a new feature at this point. If you think I should, just tell me and I will do it12:43
kikoI thought that some work had been done on that already?12:44
kikoI think yes, you should start on it and put up whatever you have for review before you leave12:44
carloskiko, Is not that I'm losing my time now... I'm answering pending email from users and doing bug triage, but your wishes are orders to me ;-)12:46
kikotriage is good, but you could help jordi get started on helping you out there12:47
kikothat way you two better complement yourselves12:47
jordicarlos: don't answer mail if you think they are in my roof. I am working on them12:48
carloskiko, sometimes there are technical details that jordi does not know because he's not a launchpad developer12:48
jordithat's true12:48
carlosbut yes, I suppose Jordi could help there 12:48
kikothat's fine though12:48
kikojordi can call you in on those ones12:48
jordikiko: besides, I have no rights to modify a single bug detail12:48
carlosjordi, do you have all mails from ubuntu-translators?12:49
jordino12:49
jordiI just subscribed12:49
jordibut they are in the archive, are they?12:49
carlosjordi, ok, I will handle the old ones 12:49
carlosjordi, yes12:49
carlosjordi, ok, if you handle the old ones too... 12:49
jordiwhat kind of messages do we need to track?12:50
jordidamn. I use way too much time replying to stuff12:50
=== zyga [n=zyga@2-mi2-1.acn.waw.pl] has left #launchpad ["Leaving"]
carlosjordi, This is the next mail that should be answered: http://lists.ubuntu.com/archives/ubuntu-translators/2005-September/000280.html 12:52
carlosjordi, since that one, I didn't reply to any email12:52
carlosjordi, look at the threads because sometimes, other users answered already12:53
carlosjordi, you need to reply only the ones that are without an answer12:53
carlosjordi, ok?12:53
jordiok12:53
=== jordi sighs.
carlosjordi, there are only 44 emails12:54
carlosjordi, and some of them are already answered12:54
carlosso don't worry, that mailing list is low traffic (but with a ton of spam)12:55
jordiok12:55
jordi"me pido no ser el administradoooor" :)12:56
carlosjordi, ;-)12:57
carlosdon't worry, you will not be the admin of that mailing list12:58
carlosat least not now... but perhaps in the future.... :-D12:58
=== jordi can be heard from Brazil cursing and whining.
carloskiko, ok, so back to code...01:00
carloskiko, should I work first on https://launchpad.net/products/rosetta/+spec/translation-review ? is set as high priority by mark01:01
jordikiko: speaking of, https://launchpad.net/products/rosetta/+spec/distro-and-product-translation-visibility ?01:02
carloshmm, no, pomsgsetview will help to implement that spec01:02
carloskiko, so I'm going to work on pomsgsetview01:02
jordicarlos: what needs to be done to get MulticastTranslations approved?01:02
jordiI would love to see that one01:02
carlosjordi, mark wants that we implement translation-review first01:03
jordinod01:03
carlosand after having it implemented, look again to MulticastTranslations01:03
jordiHeh.01:03
salgadojamesh, around?01:03
jordiThe Rosetta product "Doesn't use Rosetta". :)01:04
carlosjordi, and never will do as Rosetta is not really a product but a part of launchpad... :-)01:04
carlosjordi, perhaps we should set that flag to prevent funny comments....01:05
=== dholbach [n=daniel@ubuntu/member/dholbach] has joined #launchpad
dholbachhellas01:06
dholbachcould it be that launchpad mails today need some more time to get processed or sent out?01:06
carlosstub, ^^^^ ?01:09
jordicarlos: yeah :)01:09
stubLaunchpad mails are running normally as far as I can tell. Works for me.01:12
dholbachhm01:13
dholbachthanks for the info01:14
=== ddaa [n=ddaa@nor75-18-82-241-238-155.fbx.proxad.net] has joined #launchpad
carlosfunny bug....01:16
carlosyou cannot add a new spec with the assignee, drafter and approver field set01:16
carlosbecause you get timeouts01:16
carlosif you create it with those fields empty, the spec is created..01:17
=== carlos files a bug
SteveAcarlos: review sent01:19
SteveAit isn't much01:19
carlosSteveA, nice ;-)01:19
SteveAthere is one serious problem, but which has a simple fix, but needs a test01:19
carlosthanks01:19
carlosok01:19
salgadohey SteveA, would you like to do another review? ;)01:20
SteveAsalgado: ok01:22
salgadoSteveA, it's the implementation of ShipItReports. it's already in pending-review, but the diffs are not showing up there01:23
salgadoSteveA, should I mail you the diff?01:23
SteveAok01:24
jordicarlos: cool01:35
jordithere's like 4 mails that need reply01:35
SteveAdholbach: do you use greylisting?01:40
dholbachno01:41
dholbachthe mails took an hour to reach me01:41
dholbachi mean it's fine with me... i don't *rely* on them that much - just as a heads up01:41
SteveAlast time this kind of thing was reported, elmo looked into the mail logs, and discovered that the target MX was rejecting mail on the first send, as part of its greylisting stuff.01:42
SteveAso, the mail would be delayed on the outgoing mail server at the DC01:43
SteveAi don't yet have access to mail logs, so i can't look into it further.01:43
dholbachi see01:43
dholbachi could ask the hoster, but i'm pretty sure they don't use greylisting01:43
dafMarius' mailhops program might be useful01:44
dafit lists where a message spent its time01:44
SteveAyou could put the full mail you received, inc headers, into RT and ask the admins to look into it01:44
carlosjordi, ;-)01:47
ZnarlWe already know about the issue of lists.ubuntu.com being terribly slow.  Hopefully that will be resolved today with a hardware upgrade.01:47
carlosSteveA, could you explain to me where do you think the bug is?01:48
carlosSteveA, https://chinstrap.ubuntu.com/~dsilvers/paste/filehrxNJz.html01:48
carlosI don't see it01:48
ddaalifeless: it would be nice if you could loosen the perms on your home dir on chinstrap a bit01:48
ddaaso other people can access e.g. ~robertc/public_html01:48
SteveAcarlos: missing = sign01:49
ddaalifeless: I do not really see the point of preventing other users from reading your home dir on chinstrap...01:49
carlosSteveA, oh, right!01:49
SteveAsystem doc test, perhaps?01:50
carlosSteveA, It's a bug and I suppose we don't have a tests 01:50
carlosSteveA, yes01:50
salgadostub, still around?02:04
dholbachZnarl: ah ok02:04
=== mpt [n=mpt@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
stubsalgado: yes02:06
salgadostub, I'm having some problems to rewrite that query I sent to you yesterday (the one from the person vocabs). are you going to leave soon or do you have some time to help me on that?02:08
stubI can help. What is the problem?02:08
SteveAsalgado: review sent02:09
salgadothat query uses a left outer join on the email address table, because we want to query all valid persons or teams, and while a valid person must have a preferred email, a valid team doesn't02:10
salgadoSteveA, dude, this was fast. thank you. :)02:10
stubsalgado: Which query was this? I don't recall a left outer join02:11
=== carlos -> lunch
stubIIRC, you needed to change02:12
stubSELECT [list of columns]  from Person, EmailAddress WHERE Person.id = EmailAddress.person AND teamowner IS NULL AND merged IS NULL AND (lower(email) LIKE 'kiko%%') OR fti @@ ftq('kiko') TO02:12
stubSELECT [list of columns]  from Person, EmailAddress WHERE Person.id = EmailAddress.person AND teamowner IS NULL AND merged IS NULL AND (lower(email) LIKE 'kiko%%'02:12
stubUNION02:12
stubSELECT [list of columns]  from person, emailaddress where person.id = emailaddress.person and teamowner is null and merged is null and fti @@ ftq('kiko')02:12
salgadostub, hmmm. that's true. the query that times out doesn't have the left outer join as I see in the code02:12
stubMaybe with a SELECT DISTINCT wrapper around it in case there are dupes02:13
stubSELECT DISTINCT * FROM (02:14
stubSELECT [list of columns]  from Person, EmailAddress02:14
stubWHERE Person.id = EmailAddress.person AND teamowner IS NULL AND merged IS NULL02:14
stubAND (lower(email) LIKE 'kiko%%'02:14
stubUNION02:14
stubSELECT [list of columns]  from person, emailaddress02:14
stubwhere person.id = emailaddress.person and teamowner is null and merged is null02:14
stuband fti @@ ftq('kiko')02:14
stub)02:14
kikostub <3 kiko02:14
stubNo tongue this time!02:14
kikojordi, I'm still blocked by lifeless fixing bzr for me, my branches are all fscked02:15
salgadodammit, /me was looking at the wrong place02:15
salgadostub, okay, this one I can fix easily. but the one I was looking at is very similar to this, but more complex02:16
jordikiko: aww02:16
=== salgado pastes it
kikojordi, maybe it will unblock tomorrow02:16
jordicool02:16
salgadostub, https://chinstrap.ubuntu.com/~dsilvers/paste/filePzDqFe.html02:18
salgadothis query uses a left outer join on the email address table, because we want to query all valid persons or teams, and while a valid person must have a preferred email, a valid team doesn't02:19
=== niemeyer [n=niemeyer@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
stubsalgado: That query is broken - missing a where statement.02:23
salgadostub, my fault, I copied it from the code and forgot to copy the WHERE02:24
salgadostub, https://chinstrap.ubuntu.com/~dsilvers/paste/filenRRf2I.html02:24
stubsalgado: ok. 4 seconds - needs work.02:25
salgadostub, is the UNION (like I'll do for the other) supposed to make this one faster too?02:29
stubYes. https://chinstrap.ubuntu.com/~dsilvers/paste/filelRgS6E.html (from 4 seconds down to 20 micro seconds)02:30
stubactually - I think that can be simplified a bit further.02:31
salgadodude, you're a star02:31
=== jbailey [n=jbailey@modemcable139.249-203-24.mc.videotron.ca] has joined #launchpad
stubhttps://chinstrap.ubuntu.com/~dsilvers/paste/fileLfk0Cc.html02:32
stubsalgado: ^^ I think that has all the same logic02:32
dilysMerge to devel/launchpad: [trivial]  Clean up the http_proxy env var before running tests, as we don't want the requests we make to localhost to be proxied (2869: Guilherme Salgado)02:33
stubHmm... no. I think the first one is better. It matches teams02:33
KinnisonCor, dilys is back on the game02:34
salgadostub, yes, that's right. it has to match teams02:34
stubsalgado: With the DISTINCT - https://chinstrap.ubuntu.com/~dsilvers/paste/fileK4SYCf.html02:36
kikosalgado, that fix is probably not the right one.02:36
kiko(it might not hurt though)02:36
stubsalgado: erm.... https://chinstrap.ubuntu.com/~dsilvers/paste/fileZwXMXw.html02:37
stubkiko: The query he pasted is taking 4 seconds on production, so it needs fixing anyway02:37
salgadostub, I guess he was talking about my merge02:37
kikostub, I was talking about his latest merge02:37
kikoright02:37
salgadokiko, yes, I think you're right02:37
=== GoRoDeK [n=gorodek@p5083D223.dip.t-dialin.net] has joined #launchpad
=== jbailey [n=jbailey@modemcable139.249-203-24.mc.videotron.ca] has joined #launchpad
salgadostub, thanks dude. although it's going to be a lot of work to get this fixed, at least now I know how the queries must look like02:43
stubsalgado: If this is SQLObject, you can always cheat and make the fast query a subquery used by the Foo.select() method. Have a look at my person.topPeople() fix that should have landed earlier.02:44
stubIt isn't quite as efficient, but the wastage is in milliseconds and we can live happily with that02:45
salgadostub, no, that's a raw query that is composed using multiple parts, and the composition changes in three different classes02:45
salgadoanyway, now I think I can do it using sqlobject and SelectResults.union()02:46
stubI see02:46
salgadoif I manage to do that I guess I won't have too much work02:46
stubMore fireworks!02:46
stubKings birthday isn't until monday either02:47
=== cprov [n=cprov@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
cprovhey hackers02:56
=== jordi [n=jordi@115.Red-213-96-69.staticIP.rima-tde.net] has joined #launchpad
mptnew-branch seems to be hung. If I kill it, how screwed will I be?03:03
mpt(hung on fetching a revision)03:03
stubnew-branch?03:07
=== bradb [n=bradb@modemcable033.209-70-69.mc.videotron.ca] has joined #launchpad
mptoh, I spoke too soon, it's continued now03:08
mptbradb!03:08
bradbhey mpt 03:09
bradb["PQM Cannot merge between different VCSsystems. 'sftp://chinstrap.ubuntu.com/home/warthogs/archives/bradb/launchpad/malone-smallfixes/'(pqm.Baz1_1Handler) and '/home/pqm/archives/rocketfuel/launchpad/devel'(pqm.Bazaar2Handler) are different."] 03:09
mptbradb, you watch Homestar Runner much?03:10
bradbmpt: Can't say that I do.03:10
mpthmm, ok03:11
mptanyway03:11
mptbradb, kiko tells me that you've been using a lot of "or"s lately03:11
kiko3 per sentence, or else!03:12
=== bradb avoids the bait
=== SteveA [n=steve@195.182.78.95] has joined #launchpad
kikowelcome back SteveA 03:17
=== ddaa tells bradb about De Morgan theorem.
mptbradb, can you fix it?03:20
mptIf the footer isn't going to provide usefully specific information, including it at all is slowing people down03:21
ddaaI'm thinking a probably simple fix would be sending a notification when a user gets subscribed.03:21
ddaa"David Allouche has subscribed Frobo Team to this bug. As part of this team, you will receive notifications blah blah"03:22
ddaa"David Allouche has subscribed Brad Bollenbach to this bug. You will receive blah blah"03:22
bradbmpt: If people are happy for me to spend the 1-2 days on it being specific, I'd love to, yeah. If people want me to remove it entirely, I don't really care that much. It was only put there as the "5c solution" as kiko would say, for people who really had no idea at all about why they were getting a bug notification (as some DD's had complained)03:22
ddaa"David Allouche has assigned this bug to Brad Bollenbach, you will receive blah blah"03:23
kikobradb, the DDs had complained because we were spamming them :)03:23
bradbddaa: You mean, you'd want more bugspam than you get already?03:31
ddaaMh... that's a good point :)03:31
ddaaI was just pointing out that fixing the "I received bugspam and I do not know why" problem can be fixed by sending in more bugspam :)03:32
ddaaIt's a bit like fixing "foo is too slow" by adding a progress indicator.03:32
mptbradb, who's "people"?03:32
mptIf you make it a 5c solution now, people will learn to ignore it, so yes, I'd rather it was removed until it's done properly03:33
bradbmpt: elmo, most recently.03:34
bradbISTR a few other people at UBZ asking about it, but that was probably related to the Maintainership table03:34
kikoit was.03:34
bradbIt can still happen by way of team membership though that people get surprised with bug reports (which is what happened in elmo's case, for example)03:35
mptbradb, I meant the "people are happy for me to" and "people want me to" people :-)03:35
bradbmpt: Oops, I might have phrased that as though there was more than one person who makes decisions like that (or, alternatively, who doesn't but then I ultimately feel the wrath later on.)03:37
bradbIn any case, I'm already removing it, so it should be merged within the next 24-48 hours.03:38
mptthanks bradb03:40
bradbnp03:40
=== carlos [n=carlos@164.Red-83-53-59.dynamicIP.rima-tde.net] has joined #launchpad
=== kjcole [n=kjcole@pchb1f.gallaudet.edu] has joined #launchpad
mdkempt, i had a malone question for you too, if you have time03:55
mptsure03:55
mdkempt, do you think it would be a good idea to implement a method of quoting a previous comment when commenting via the malone gui?03:55
mdkeit is something I miss03:56
mdkekiko said to ask you03:56
mptI think Bugzilla has demonstrated quite well that that would be a bad idea03:57
mdkei use it all the time on bugzilla :(03:58
=== bradb suggested the "Reply" thing in bug 3797
UbugtuMalone bug #3797: Bug mails should be more descriptive In: malone (upstream), Severity: Normal, Assigned to: Nobody, Status: NeedInfo http://launchpad.net/bugs/379703:58
bradbIt could be one of those small things that help makes bugmail much more useful03:58
=== matsubara is now known as matsubara-lunch
mdkempt, i think loads of people use quoting in bugzilla03:59
mptmdke, because people get lazy about it, don't snip, and the comment ends up four times as long as it would have been otherwise03:59
bradbBecause at least the person making a comment has a chance to include context, so I don't have click and scan.03:59
mptmdke, that loads of people use it is precisely the problem03:59
mdkehmm03:59
mptbug reports end up getting much longer, which slows everybody down03:59
mdkeyes i see that03:59
bradbmpt: They don't have to.03:59
mdkeso people who want to give context to their bugs need to use email?04:00
bradbmpt: The quoted text can be collapsed by default, of course.04:00
mdkethere is plenty of good quoting on the ubuntu bugzilla, mdz uses it a lot, for example04:00
mptmdke, no, they need to quote manually, just like they do on Metafilter and Slashdot and just like they used to do on Bugzilla.04:00
mptwhich is a good thing, because it practically guarantees that only the relevant stuff (if anything) will be quoted.04:01
mdkehmm04:01
mptAnd if you're replying to the immediately previous comment, you usually don't need to quote at all.04:01
mdkenot true, people will then get email with no context04:01
mdkebut in any event, I hate solutions which are dictated by bad practice04:01
mptYes, this is one of the unfortunate things about having an e-mail interface to a bug tracker04:01
mdkeis there no solution which would encourage users to quote properly?04:02
bradbmpt: What is your beef with quoting that hasn't yet been addressed?04:02
=== jbailey [n=jbailey@modemcable139.249-203-24.mc.videotron.ca] has joined #launchpad
=== mdke goes and stands in bradb's corner
mptbradb, there's a current bug report that in an e-mailed comment with only one quoted section, the quoted section should be stripped04:03
bradbMy beef with *not* quoting is that, in practice, reading portlet UI comments in email just makes me angry.04:03
mpt"portlet UI comments"?04:03
bradbmpt: Stripped wouldn't seem to make much sense to me, but collapsed by default would.04:03
bradbgmail style, IIRC04:03
mptPortlets make me angry too, but what does that have to do with quoting? :-)04:04
bradbmpt: aka the web UI04:04
mdkebradb, collapsed by default in the finished post or in the writing dialogue?04:04
bradbmdke: in the finished post04:05
mdkethat would be good04:05
mdkegmail does both i think, which sucks a bit04:05
mpta Reply function, by simulating threading, also encourages discussions to go off-topic.04:07
mpt(As again demonstrated by Slashdot and Usenet vs. Metafilter.)04:07
mptSometimes going off-topic is a fine thing (as in Usenet), but not in a bug tracker IMO.04:08
bradbmpt: There are ways to address that, i.e. obsolete comments, or closing comments, for example.04:08
bradbs/i.e./e.g./04:08
=== WaterSevenUb [n=WaterSev@azevedo.astro.up.pt] has joined #launchpad
=== jbailey [n=jbailey@modemcable139.249-203-24.mc.videotron.ca] has joined #launchpad
mptbradb, sure, I'd be a lot happier about Reply if KeepingBugsConcise was implemented04:09
mptAlready I'm seeing some Launchpad bug reports with ten or fifteen comments and thinking "aaaaargh"04:10
bradbIME, that's minor compared to all the useless, contextless bugmail commentary I get.04:11
mptI've already spent most of my spare time over four years reading bug reports, that's too much for one lifetime04:11
mptso, I guess comments optimized for the Web suck for e-mail, and vice versa04:12
bradbmpt: Not necessarily. As I say, reading contextless comments in the portlet UI is a PITA IME too.04:13
mptthe context is 30 pixels upward, what's PITA about that?04:14
=== einheit_ [n=steve@195.182.78.95] has joined #launchpad
bradbmpt: The context could be anyone of the previous comments, in practice.04:14
=== Ubugtu [n=bugbot@ubuntu/member/seveas] has joined #launchpad
=== carlos [n=carlos@234.Red-83-41-29.dynamicIP.rima-tde.net] has joined #launchpad
=== BjornT [n=bjorn@84.32.140.183] has joined #launchpad
mptIf that's likely, that's a problem, since you're all talking about the same bug04:16
=== jbailey [n=jbailey@modemcable139.249-203-24.mc.videotron.ca] has joined #launchpad
=== dand [n=dand@86.105.65.80] has joined #launchpad
SteveAmpt: hello04:25
mpthi SteveA 04:25
SteveAmpt: we should arrange to talk using some voip magic about UI stuff04:29
mptok, what do I need to install (and why isn't it built in to Gaim)?04:30
sivang_awaySteveA: linphone is cool for that. I wish Kinnison would have gotten his mic already so I could talk to him :)04:30
sivang_awaybut for the firewall challanged, skype might be better04:30
kiko-fudmpt, skype :)04:41
carlosSteveA, ping04:43
=== matsubara-lunch is now known as matsubara
mptoh, but skype's not in the official repositories ...04:44
=== mpt flutters his Free-Software-loving eyelashes
=== SteveA_ [n=steve@213.226.190.253] has joined #launchpad
mptnm, I have Skype on my Mac04:44
elmoskype's license doesn't allow it to be in any repositoriy04:44
elmoand besides, who are you trying to fool, OS X boy?04:44
kikodon't tell anyone where I found it then04:44
SteveA_mpt: hello04:44
SteveA_mpt: routing problems from lithuania04:44
elmokiko: warez on the internet, I'm shocked, no really04:45
=== mp1 [n=mpt@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
carlosSteveA_, about "def getSubsetFromRealSourcePackageName(distrorelease, sourcepackagename)"04:45
kikoelmo, I'm shocked at your suggestion I'd be a consumer of war3z04:45
=== mp1 waves to elmo
kikogo osx go04:45
SteveA_voip is not going to work for me, until the telekom.lt routing problems are solved04:45
SteveA_i'm connecting using gprs now04:46
=== molsen [n=martin@0x573053cf.vjnxx3.adsl-dhcp.tele.dk] has joined #launchpad
kikofark04:46
kikoSteveA_, just call the office to talk to matt04:46
SteveA_why do i want to talk with matt?04:46
mptabout UI stuff?04:46
SteveA_oh, that matt04:46
SteveA_hello matt pt04:46
stub:-D04:46
SteveA_i've only known you as mpt or matthew04:46
=== lamont [n=lamont@mib.fc.hp.com] has joined #launchpad
carlosSteveA_, There are two kinds of SourcePackage, the one from where a .pot file comes and the one where we want to put it. The 'Real' one is for me the one from where the .pot file comes, the other is a 'fake' one04:47
SteveA_carlos: this makes my head hurt04:47
carlosSteveA_, any suggestion?04:48
SteveA_what do you mean "where a .pot file comes from" ?04:48
SteveA_is that a "magic source package" ?04:48
SteveA_mpt: i'll phone in a few minutes04:48
carlosSteveA_, no, that method is related to Ubuntu's automatic import04:49
carlosSteveA_, so it means the .deb source package where the related .pot file was extracted from04:49
SteveA_so, this is an "importer source package" ?04:49
molsenCould someone please add wmii (http://www.wmii.de/) to the buglist at launchpad.net?04:49
carlosSteveA_, yeah I suppose we could call it that way04:49
carlosSteveA_, getSubsetFromImporterSourcePackageName?04:50
SteveA_it is confusing to call our standard database code the RealWhatever stuff04:50
SteveA_or the FakeWhatever04:50
SteveA_the standard database code is the Whatever04:50
SteveA_and anything else needs qualification04:50
SteveA_this operation has two arguments: distrorelease and sourcepackagename04:51
SteveA_what kind of sourcepackagename is it?04:51
kikoSteveA_, shouldn't SourcePackage be in components/ btw?04:51
SteveA_kiko: the simple answer is, no.04:51
kikobecause...?04:52
SteveA_the simple rationale is "mark said so"04:52
SteveA_i can discuss it in detail.  i don't want to do so on irc.04:52
kikosure.04:53
SteveA_aha... looks like the network is back.04:53
SteveA_i'll disconnect and try with the real internet04:53
carlosSteveA_, this method is exactly the same as the getSubset() one but instead of checking IPOTemplate.sourcepackagename, checks IPOTemplate.from_sourcepackagename04:53
SteveA_carlos: if from_sourcepackagename is the one that the importer uses, make sure 'importer' appears in the name04:54
SteveA_otherwise this is going to get REALLY confusing04:54
SteveA_-NickServ- You cannot GHOST yourself.04:55
SteveA_how irritating.04:55
=== SteveA [n=steve@195.182.78.95] has joined #launchpad
carlosSteveA, welcome back04:57
SteveAthanks04:57
SteveAmpt: want to try some voip?04:58
mptSteveA, sure04:59
sivang_awayhehe, OS X boy =)05:00
=== jinty [n=jinty@205.134.224.215] has joined #launchpad
=== lbm [n=lbm@x1-6-00-13-10-7a-d1-e4.k233.webspeed.dk] has joined #launchpad
=== heyko_ [n=heyko@tor/session/x-b2e9543c83c3a55f] has joined #launchpad
=== CrazyTB [i=denilson@200.217.179.23] has joined #launchpad
=== CrazyTB [i=denilson@200.217.179.23] has left #launchpad []
=== mdke_ [n=matt@81-178-180-199.dsl.pipex.com] has joined #launchpad
=== niemeyer wonders why test.py looks like a shell script..
=== mdke_ [n=matt@81-178-180-199.dsl.pipex.com] has joined #launchpad
=== mdke_ is now known as mdke
niemeyerNext gobby has search & replace!! Good start for a text editor :-)05:54
bradbWhat about undo?05:55
kiko-phoneheh05:56
niemeyerbradb: Doesn't mention it.. :(05:57
mptI know, let's rewrite gedit for the purpose of adding one feature05:58
=== bradb & # lunch
=== sivang_away is now known as sivang
sivangmpt: why not adding shared network editing to gedit ;-)06:10
sivangit already supports plugin 06:11
sivang(s)06:11
jordiand it's little more than using libobby :)06:12
carlosKinnison, ping06:15
sivangjordi: ah, there's a lib for the shared network editing functionality? cool!06:16
sivangbradb: is this under works or something? https://launchpad.net/people/sivan/+filebug06:21
Kinnisoncarlos: yo06:21
carlosKinnison, I got my branched reviewed and ready to merge06:21
sivang(I clicked it after going the bug context direction , after logging in, and go "no page")06:21
carlosKinnison, could you take a look to https://launchpad.net/products/launchpad/+bug/5227 ?06:21
UbugtuError: I cannot access this bug06:21
carlosKinnison, also, I don't see anything in our code that calls IDistroReleaseQueueCustom.publish_ROSETTA_TRANSLATIONS06:22
carlosKinnison, will you take care of that?06:22
Kinnisoncarlos: DistroReleaseQueueCustom constructs an attribute to call06:23
Kinnisoncarlos: check it out06:23
carlosoh06:24
carlosright06:24
carlosI did a grep O:-)06:24
mptsivang, apparently at the time the gobby developers started, gedit's plug-in architecture wasn't mature enough06:24
mptor something06:24
mptand now they're a runaway train06:24
carlosKinnison, I'm running the final tests and will request a merge as soon as they finish.06:25
Kinnisoncarlos: rock on, ta06:25
carlosKinnison, are we running Gina on staging?06:26
carlosI want to test this new feature with real data (or something close to real data)06:26
Kinnisoncarlos: gina I believe was run on staging, yes06:26
carlosKinnison, 'was'... so to get IDistroReleaseQueueCustom.publish_ROSETTA_TRANSLATIONS called, I need a new execution...06:27
salgadompt, have you seen bug 4772?06:27
UbugtuMalone bug #4772: Allow advanced searching in FOAF (and elsewhere) In: malone (upstream), Severity: Normal, Assigned to: Guilherme Salgado, Status: Accepted https://launchpad.net/bugs/477206:27
Kinnisoncarlos: gina doesn't make queue entries06:27
Kinnisoncarlos: the uploader tests are what will call publish_ROSETTA_TRANSLATIONS06:27
Kinnisoncarlos: and only if the uploads contain translation tarballs06:27
carlosKinnison, ok, then the question is... are we running that atm?06:28
KinnisonWe;re doing uploader tests on dogfood currently, talk with cprov and niemeyer about them06:28
carlosok, so I need my code tested there...06:28
carloscprov, niemeyer ping06:28
carlosKinnison, thanks06:28
cprovcarlos: pong06:28
carloscprov, have you read my conversation with Kinnison ?06:29
=== cprov reading .. was afk
=== heyko [n=heyko@tor/session/x-287e2309ffb2637c] has joined #launchpad
=== carlos [n=carlos@121.Red-83-50-63.dynamicIP.rima-tde.net] has joined #launchpad
=== lbm [n=lbm@80.167.5.54] has joined #launchpad
bradbsivang: re: +filebug from person page: bug 444207:08
UbugtuMalone bug #4442: https://launchpad.net/people/xeon/+filebug -- File not found In: malone (upstream), Severity: Normal, Assigned to: Guilherme Salgado, Status: Accepted https://launchpad.net/bugs/444207:08
=== kiko [n=kiko@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
=== gneuman [n=gneuman@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
=== beyond [n=beyond@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
=== mpt_ [n=mpt@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
=== salgado [n=salgado@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
sivangbradb: ah ok :)07:21
=== mgalvin [n=mgalvin@host-66-202-95-170.spr.choiceone.net] has joined #launchpad
=== BjornT [n=bjorn@84.32.140.183] has joined #launchpad
=== matsubara [n=matsubar@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
=== niemeyer [n=niemeyer@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
=== cprov [n=cprov@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
cprovcarlos: link was down ... we have uploader tests almost done07:40
kikowth is wrong with this internet 07:40
cprovcarlos: I'm not sure about the publish_ROSETTA_TRANSLATIONS  things that you mentioned, but I can offer you the results of the uploader tests in DF07:41
=== sivang is now known as sivan_away
mpt"It is highly advisable to ensure that your system has the security pocket enabled"07:49
SteveAonly someone who needs total stability, and is not connected to any network ever, would want not to do so07:54
mpt--> "It is a good idea to have security updates turned on"07:55
SteveAturn this off only if you know enough to disregard this notice.07:55
=== ajmitch_ [n=ajmitch@port164-107.ubs.maxnet.co.nz] has joined #launchpad
mptok, who knows about publishing07:59
mptcprov!07:59
mptcprov, "This source package is not published in The Breezy Badger Release"08:00
mptWhat happens if I start reporting bugs on it anyway?08:00
kikompt, yes?08:00
mptor translating it anyway?08:00
kikonothing bad will happen08:00
mptand then it's published later?08:00
kikoit's not a big deal08:00
kikotranslation may be a problem08:01
mpthttps://launchpad.net/distros/ubuntu/breezy/+sources/casper08:02
mpthttps://launchpad.net/distros/ubuntu/breezy/+source/casper/+translations08:02
=== GoRoDeK [n=gorodek@p5083FC2E.dip.t-dialin.net] has joined #launchpad
mdkehas anyone got time to tell me something of the origins of bazaar?08:27
mdkei am curious as to the reasons behind its development08:27
mptmdke, http://en.wikipedia.org/wiki/Bazaar_(software)08:28
mdkempt, that page doesn't address my specific question, which is why a fork was required, rather than developing the original implementation of the gnu/arch protocol08:29
mptno, but the message it links to from Robert Collins does pretty well I think08:30
mdkeyeah i was just on that now :)08:30
mdkethat is good enough, thanks08:30
mdkempt, so is it correct to describe it as a "fork"08:33
mptI don't know enough about the internals08:34
mptask lifeless or jblack 08:35
Seveasmdke, #bzr :)08:35
mdkethat's ok, I really have the answer from the WP entry08:35
=== ajmitch_2 [n=ajmitch@port163-97.ubs.maxnet.co.nz] has joined #launchpad
salgadohey guys, is there anybody here with read access to production or staging db?09:02
ddaaI have limited access to production09:07
ddaahow can I help you?09:07
salgadoddaa, would you run https://chinstrap.ubuntu.com/~dsilvers/paste/fileFsMMcl.html there for me?09:10
salgadoddaa, and tell me how long it takes09:10
=== ddaa looks at the paste
ddaathat looks reasonable innocuous... I'll run it09:12
ddaaincluding pqsl spawning time, it takes about 115ms wallclock09:16
ddaaand yields a relation with 2 columns and 115 rows09:16
ddaasalgado: anything else I can do for you?09:17
salgadoddaa, is that the 'Total runtime' that analyze gives?09:19
ddaayes, the "real" value given by the "time" bash builtin.09:20
salgadoddaa, hmmm. did you leave the "explain analyze" line at the beginning or you removed it?09:21
ddaahu, I removed it09:21
ddaadidn't knew about it, so I did not want to take risks09:22
salgadothat's what gives the time the query took (together with some other stuff), so if you could run it with that line I'd be glad09:22
salgadohttp://www.postgresql.org/docs/7.4/interactive/sql-explain.html09:23
ddaaI see.09:23
ddaasince it was lowercase, I assumed it was not SQL :)09:24
salgadoheh09:24
salgadoit's lowercase because I added it in the paste form09:24
ddaascary09:24
salgadobut indeed, it looks like that's not part of the thing I wanted you to run09:25
=== ajmitch_2 is now known as ajmitch_
ddaaIt takes between 20 and 60 ms.09:25
ddaamost of the time, about 30ms09:25
mptWhy does launchpad/ include an empty "launchpad/" subdirectory?09:26
salgadowow, this seems pretty good. 09:26
salgadoddaa, would you run another one for me? (https://chinstrap.ubuntu.com/~dsilvers/paste/filenRRf2I.html) :)09:26
salgadothat's the last one, I swear09:26
ddaampt: there's no empty launchpad subdir in my launchpad09:27
mptok, BEHLETED09:27
ddaasalgado: that other one takes 5 or 6 SECONDS!09:29
salgadoheh09:29
salgadothanks ddaa!09:30
ddaayou're welcome09:30
=== GoRoDeK [n=gorodek@p5083F602.dip.t-dialin.net] has joined #launchpad
=== salgado hopes that once he finishes this optimization, we'll see less timeouts in launchpad
=== sivan_away is now known as sivang
carloscprov, ping09:37
cprovcarlos: pong 09:37
carloscprov, what I need is to do some extra testing09:37
carlosso the Rosetta method is tested with real data09:38
cprovcarlos: does your test need uploads in place ? 09:38
carloscprov, what do you understand by 'in place'?09:38
cprovcarlos: already imported in the LPDB09:39
cprovcarlos: or your translations goes with the uploads09:39
carloscprov, no, I need a new build that at the end will execute a Rosetta method to import translations09:39
carloscprov, with the uploads09:40
cprovcarlos: sorry my lack of ideas, but "end"of what ? which process are you interesting ?09:42
carloscprov, I need that we build a new debian source package09:42
carloswith translations09:42
carlosthat way, our buildd "builds" the source package and imports the translations09:43
cprovcarlos: right, if I understand, you are interesting in the slave-scanner entry-point (when we collect the build results from slaves)09:43
salgadohey guys, where do I choose the topics I want to receive in the launchpad-error-reports mailing list?09:43
carloscprov, right09:43
cprovcarlos: but at this point we have binaries, not sources ... correct your previous sentence09:44
=== josh____ [n=josh@a213-84-252-29.adsl.xs4all.nl] has joined #launchpad
carloscprov, I don't know the exact details09:45
carloscprov, I only know that the buildd generates the tar.gz, the .deb and I suppose that another .tar.gz with translations09:46
carlos(the first tar.gz is the source tarball)09:46
cprovcarlos: no problem09:46
carlossalgado, "Change productseries add and edit pages to autogenerated forms"09:49
carlosfuck...09:49
carlossalgado, dude you hate me, right?09:49
cprovcarlos:  no, build generates .deb only, no sources (already in DB) and not translations (atm) 09:49
carloscprov, anyway, I only know I need a full build ;-)09:50
salgadocarlos, eh?09:50
carlossalgado, my last work touched many things there09:51
carlosso I guess I will have a big conflict to solve....09:51
salgadoouch09:51
=== carlos hopes is easy to fix...
cprovcarlos: what for ? if you explain the process you have in mind maybe I can help you. anyway, if you just know you need a "full built distrorelease" I can help you soon09:52
carlossalgado, and you were lucky that the merge request failed or you the problem would be your ;-)09:52
salgadocarlos, not really. that's from matsubara. I'm only merging for him09:53
cprovcarlos: if you are brave you can try something in DF, foodix/breezyfood, it's built, but missing binaries 09:53
carlos;-)09:53
=== mdke_ [n=matt@81-178-147-239.dsl.pipex.com] has joined #launchpad
Seveassalgado, cprov, SteveA told me yesterday that you have k-lining problems, would an IRC bouncer or a screen with irssi help?09:53
carloscprov, I need that DistroReleaseQueueCustom.publish() is called09:54
=== mdke_ is now known as mdke
salgadocarlos, but anyway, he didn't change too many things.09:54
carloscprov, I don't know the path to that method09:54
carlosafter that.. all things are under my control09:54
carloscprov, Kinnison prepare that API for me09:55
carlossalgado, the view class...09:55
cprovcarlos: I'm sorry, but neither me 09:55
carlosanyway, I hope it's easy09:55
salgadoSeveas, we were using a link with dinamic IP here and they were k-lining us because there were too many people using09:55
salgadoSeveas, but now we're routing IRC traffic through the other (static IP) link we have. no the only problem we have is the high latency of this link09:56
Seveassalgado, SteveA told me that. The problem is that the IP block from your provider is far too large to whitelist09:56
Seveasaha09:56
salgadoSeveas, but anyway, thanks for offering. I'll ping you if we have any other problems. :)09:57
Seveasyw, even though I didn't really do anything ;)09:57
cprovcarlos: found your points in the code10:01
carloscprov, so, would be possible to test my code tomorrow ?10:02
carloshmmm, is pqm stalled?10:03
cprovcarlos: not really, what does your code do ?10:03
Seveassalgado, is thsi static ip already whitelisted at freenode?10:03
carloscprov, gets the tarball with translations from the buildd and imports them into Rosetta10:03
salgadoSeveas, I think so because we've never been k-lined with it10:03
Seveas:)10:03
salgadoactually it might have been whitelisted during the sprint we had here10:04
salgadowe were k-lined in the first days of the sprint10:04
ddaabug #524910:10
ddaaSeveas: can you do me a favor?10:10
UbugtuError: Could not parse data returned by Malone: Connection to Malone bugzilla failed: timed out10:10
Seveasddaa, possibly10:10
ddaacan you put a Ubugtu for the bazaar product in #bzr?10:11
ddaaplease10:11
Seveasalready there :)10:11
ddaathanks, I missed it because it's timing out ATM :)10:12
Seveas:)10:12
Seveashmm10:12
mptbzr: ERROR: Local branch is not a new version of remote branch.10:13
Seveasjay for 25% package loss10:13
jordiSteveA: ping10:14
=== Nafallo_away is now known as Nafallo
ddaampt: you've tried to push10:16
bradbmpt: do the upsteam cp -a *before* the one on yur local machine10:16
bradbs/yur/your/10:17
mptddaa, correct10:17
mptbradb, what cp -a?10:17
ddaampt: if you _really_ want to do that, then "push --overwrite"10:17
mptWell, I've made some changes that aren't on chinstrap, so I don't know why I wouldn't want to push10:17
bradbmpt: a way of copying a dir easily10:17
bradbcp -a somedir somenewdir10:17
mptbradb, not "what's cp -a?", "what cp -a" :-)10:18
mptWhen do you normally do that?10:18
bradboh10:18
bradbmpt: when i create a new branch10:18
ddaampt: you get this error when you prime the branch on chinstrap by doing cp from the rocketfuel branch10:18
ddaawhen rocketfuel has had new revision since your forked your local branch10:18
mptThis is a branch I've made successful pqm merges from before10:18
mptso it's not new10:18
bradbmpt: when you create a new branch, you should first create it on chinstrap, and then locally.10:19
bradbmy workflow for branch creation is:10:19
ddaampt: well, that probably means that your local branch was not branched off that branch on chinstrap, but from rocketfuel directly.10:19
mptthat seems right10:19
ddaaSince the history of the target branch is not a prefix of the history of the local branch, push says that you may be wrong.10:19
=== josh____ [n=josh@a213-84-252-29.adsl.xs4all.nl] has left #launchpad []
bradb1. chinstrap $ cp -a $whatever/rocketfuel-built/launchpad $myarchive/the-new-branch10:20
ddaabradb: hu...10:20
bradb2. mymachine $ cp -a launchpad-upstream the-new-branch10:20
ddaayou probably want to cp off rocketfuel/launchpad/devel10:20
mptbradb, that can't be right, that would make bzr unusable offline10:20
ddaaso you do not copy all the subtrees as well...10:20
ddaampt: that's an optimisation10:20
bradbmpt: How does it make it usable offline?10:21
bradber, unusable even10:21
ddaaa way to prevent rsycing the whole branch across on the initial push10:21
mptbradb, by making it impossible for you to create a new branch10:21
mptddaa, lifeless wrote me a "pull-rocketfuel" script that updates my local copy of rocketfuel, and normally I branch off that10:21
ddaaanyway, push --overwrite removes the finger guard10:21
bradbmpt: Not "impossible", you'd just need to incorporate what ddaa suggests into your workflow10:22
ddaaanyway10:22
ddaaguys, you should be using microbranches now10:22
ddaanot long lived devel branches10:22
ddaathey make ugly bzrk output ;)10:22
bradbI indeed shouldn't be copying from rocketfuel-built though anymore, doh :)10:22
=== Nafallo is now known as Nafallo_away
carloslifeless, could you take a look to PQM (if you are awake...)10:25
bradbcarlos: i think it's "working". my changes landed not too long ago, but they took several hours to get out of the #1 spot.10:26
carlosbradb, first entry has been there for 3 hours...10:27
bradbcarlos: in the queue, not in the #1 spot10:27
carlosbut I will wait ...10:27
carloshmmm10:27
carlosgood point ;-)10:27
lifelesscarlos: I am10:28
ddaalifeless: importd2bzr is pending-review10:29
ddaanow blocked on you10:29
lifelessddaa: what else is in the air that you can work on ?10:29
ddaadon't worry many thing10:29
lifelessI realise that *that* particular pipeline is now blocked, but its not the only one... good10:29
carloslifeless, I think I was too fast, seems like pqm is working as bradb pointed already but thanks10:29
ddaarollout bzrsync cronjob, but it's blocked on account creation10:30
ddaamake branch title and summary optional10:30
ddaathat's what I'll be working on10:30
lifelesscarlos: it is working10:31
ddaalifeless: not screaming at you (yet), just letting you know, so you can nudge the urgency of that item on your todo queue.10:31
lifelessyah10:31
carloslifeless, btw, I got this: https://chinstrap.ubuntu.com/~dsilvers/paste/fileRDIGYg.html10:31
lifelessnow rocketfuel is unfucked, things can move again10:31
carloslifeless, I suppose it's because I had 'launchpad/devel/' instead of 'launchpad/devel', right?10:32
carloslifeless, ok, thanks for checking it10:32
lifelesssftp://chinstrap.ubuntu.com/home/warthogs/archives/rocketfuel/launchpad/devel/10:33
lifelessyour target ^10:33
lifelesssftp://chinstrap.ubuntu.com/home/warthogs/archives/rocketfuel/launchpad/devel10:33
lifelesspqms target ^10:33
lifelessyes, the trailing slash matters to pqm10:34
carlosok, I supposed that's the problem10:36
carloslifeless, thanks10:36
=== mpt [n=mpt@201-27-71-186.dsl.telesp.net.br] has joined #launchpad
=== sivang is now known as sivang-zzz
=== jinty [n=jinty@205.134.224.215] has joined #launchpad
dholbachgood night launchpadders :)11:49

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