=== JanC [n=janc@lugwv/member/JanC] has joined #launchpad === jblack [i=jblack@static-209-158-45-74.scr.east.verizon.net] has joined #launchpad [12:40] lifeless: both things done now [12:40] elmo: thanks! [12:40] oh, but not the port 8000 forwarding. blah. === elmo reopens the ticket [12:42] heh [12:42] if you open port 8000 from chinstrap to balleny [12:42] then folk can look at it by hand until we cut over [12:44] oh, right [12:44] am I ok to do that now? [12:45] do which? (Want to be clear) [12:45] re-direct https://pqm.ubuntu.com/ to balleny [12:45] no [12:46] until balleny is live that would be, uhm, harmful. [12:46] oh, right. in that case, I'll close the ticket, can you reopen or open a new one, when I should do the switch [12:46] we need to switch the http://pqm.ubuntu.com address and pqm@pqm.ubuntu.com at the same time [12:46] right [12:47] as soon as I'm confident with the pqm on balleny, I'll ask that we do both [12:47] cool [12:47] ideally at a time we're both around for a bit afterwards [12:47] elmo: Hey, I've lost power not once, but twice today. Feel like doing a quicky zone transfer? [12:47] jblack: transfer of what? [12:48] sourcecontrol.net. I'm still running the authoritive serversa. [12:48] jblack: gimmie a zone file? [12:48] or do you just want me to secondary? [12:48] Secondary works. [12:48] I figure in a couple months we won't be using that for work anymore, and I can get it back anyways. [12:49] or not, as I've got revisioncontrol.net :) [12:49] what is the hostname and ip of the dns server you have in mind? [12:51] jblack: ns.ubuntu.com 82.211.81.173 [12:51] I'm setup to secondary, let me know when an AXFR will work [12:52] Should be trying to send [12:53] ok, synced; you should be good to add me [12:53] Nov 29 23:52:48 esperanza named[515] : zone sourcecontrol.net/IN: transferred serial 200509030 [12:53] Great. [12:54] And you'll update for a tertiary server at the registrar? [12:54] oh, do we control that? *giggle* sorry. btw, let's take this to #canonical or privmsg, it's not really LP related [12:54] sure === a|so [n=a_s@hn-47-52.brookes.ac.uk] has joined #launchpad [01:32] hi people === 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 [04:21] anybody knows how I can validate my gpg key at launchpad? [04:23] ulinskie: have you uploaded it to the keyserver? [04:24] there is an error in my system [04:24] you will need to provide some more information about the problem if you want some help. [04:25] wait it says success sending to `subkeys.pgp.net' (status=200) [04:25] i will check again at launchpad [04:25] ulinskie: you may need to wait a little while for the key to propagate === lamont [n=lamont@mix.mmjgroup.com] has joined #launchpad [04:27] I have done it thrice... , actually they sent me an email already thrice... saying that I need for follow the instructions to conclude the process [04:27] but all I see are codes [04:28] ulinskie: try this: gpg --keyserver keyserver.ubuntu.com --send $KEYID [04:29] jamesh: its read only [04:29] jamesh: wont allow that [04:30] lifeless: will it allow updates of existing keys? [04:30] lifeless: it doesn't seem to return an error [04:30] I think fabbione suggested that approach once [04:33] interesting [04:33] last I heard it was and did [04:33] ajmitch_: its meant to pull from the wide wide net automatically [04:34] ulinskie: anyway, if you've uploaded to the key, wait a few hours and try again === robitaille [n=robitail@ubuntu/member/robitaille] has joined #launchpad === XVTIURI [n=darkside@226-111.adsl.caucasus.net] has joined #launchpad [05:48] Alinux ti gde? [05:50] aris vinme aq? [06:13] lifeless: keyserver.u.c is not readonly [06:13] you can send key to it [06:13] :) [06:13] but not via http afaik [06:14] you need use --send-keys [06:18] fabbione: ah [06:19] fabbione@gordian:~$ gpg --keyserver keyserver.ubuntu.com --send-keys 63549F8E [06:19] gpg: sending key 63549F8E to hkp server keyserver.ubuntu.com [06:19] fabbione@gordian:~$ gpg --keyserver 192.168.1.1 --send-keys 63549F8E [06:19] gpg: sending key 63549F8E to hkp server 192.168.1.1 [06:19] for example [06:19] (192.168.1.1 is keyserver.fabbione.net) [07:02] ok [07:02] merges should work properly now [07:02] 4 hours to run check [07:04] lifeless: I'll give it a go then [07:06] Did you just nuke the pqm queue, or has my request gotten stuck somewhere? [07:09] neither [07:09] pqm has been disabled while I fixed things [07:14] did you get an error ? [07:16] No - just saw my request go nowhere ;) [07:36] could you resubmit it ? [07:57] stub: ^^ [07:57] lifeless: Just sent (with more fixes) [07:57] k [07:57] lets see what happens [07:58] Delivered to pqm [08:00] But can't see anything on http://pqm.ubuntu.com [08:00] it caches results [08:00] you wont see it for a minute [08:00] also procmail has not delivered it [08:00] (tail the log - ~/arch/queue/pqm/pqm.log [08:02] It was delivered to fiordland over three minutes ago [08:02] star-merge sftp://chinstrap/home/warthogs/archives/stub/launchpad/trivial/ sftp://chinstrap.ubuntu.com/home/warthogs/archives/rocketfuel/launchpad/devel [08:02] ? [08:02] That would be the one [08:03] procmail binned iot [08:03] it went to the mbox not pqm [08:03] I *have* to figure out why that happens [08:04] ok, I've zapped the mbox [08:04] try again [08:04] Need to enable debugging on procmail to see why it is using the fallback [08:04] Reset [08:04] Resent [08:04] mm, yes [08:04] how do to that ? === lbm [n=lbm@cpe.atm4-0-1301006.0x50a0824e.vgnxx6.customer.tele.dk] has joined #launchpad [08:06] LOGFILE=/home/pqm/procmail.log [08:06] at the top of .procmailrc could help [08:06] Also 'VERBOSE=yes' and LOGABSTRACT=yes [08:07] erm... LOGABSTRACT=all [08:07] ok [08:08] You want me to try making the changes? [08:08] send it in cowboy [08:08] sent [08:08] I don't know if procmail does twiddly expansion [08:09] pretty sure it does [08:10] could be wrong :) [08:11] I'll change it and resent - looks like it ended up in mbox again and no log [08:11] ok [08:11] Oh - I see you already changed [08:12] So looks like the cwd might have changed? [08:13] Nope - the arch-pqm directory is gone [08:13] oh, my bad [08:14] right that hsould fix it [08:15] Resent [08:15] There it is [08:15] yay [08:17] lifeless: is the rocketfuel-build/launchpad checkout being rebuilt since you fixed the launchpad branch? [08:18] [] 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:19] stub: ok, let me look at that === zyga [n=zyga@2-mi2-1.acn.waw.pl] has joined #launchpad [08:22] firstly [08:22] it must be 'chinstrap.ubuntu.com' [08:22] not 'chinstrap' [08:22] in your request [08:23] garh [08:23] stop that === lifeless takes away stubs refresh button [08:24] :-P [08:27] ok [08:27] the // url thing has landed [08:27] and is fuxked [08:27] -> #bzr [08:28] [] 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:29] stub: try sftp://chinstrap.ubuntu.com//home/warthogs/archives/stub/launchpad/trivial/ maybe? [08:29] I'll wait and see what happens in #bzr first [08:30] Ooh... 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] Malone bug #4818: SQLObject executing spurious COUNT(*) using slices In: launchpad (upstream), Severity: Normal, Assigned to: Andrew Bennetts, Status: New http://launchpad.net/bugs/4818 [08:34] jamesh: that does not work [08:34] jamesh: at the moment. === carlos [n=carlos@54.Red-83-53-61.dynamicIP.rima-tde.net] has joined #launchpad [08:34] morning [08:35] morning [08:35] ok [08:36] stub: should work now [09:10] Resent [09:28] looking better [09:44] morning [09:46] Morning [09:52] I get this output from 'make check': [09:52] https://chinstrap.ubuntu.com/~dsilvers/paste/fileX1f6lj.html [09:52] is there anything wrong in my code? [09:59] carlos: don't you read the launchpad mailing list? ;) both cprov and i reported the same problem === gml_ [i=gml@dyn-83-156-7-44.ppp.tiscali.fr] has joined #launchpad [10:01] BjornT, I'm not talking about the double free [10:01] BjornT, I'm talking about the: Exception psycopg.OperationalError: 'FATAL: database "launchpad_ftest" does not exist\n' in > ignored [10:01] or is it the same? [10:04] carlos: 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] BjornT, which test is that? do you know it? [10:05] hmm I suppose it's in your email to launchpad inside the big debugging log... [10:05] carlos: testSetOwnerTrust in test_gpghandler.py [10:06] BjornT, an I suppose the way to disable it is just move it outside the launchpad tree, right? [10:07] carlos: that's one way. another is to run python test.py "!test_gpghandler" [10:07] hmm I prefer your suggestion ;-) [10:07] BjornT, thanks === carlos adds it to the FAQ [10:22] BjornT, it does not work here... [10:22] BjornT, it ignores all tests [10:24] carlos: really? try: python test.py "\!test_gpghandler" [10:24] BjornT, I did it already [10:25] without the '\' bash complains about '!' [10:25] and with the \!... the tests are not executed [10:26] carlos: oh... then, use tcsh instead? ;) [10:27] BjornT: carlos try single quotes === carlos ignores BjornT and uses a real shell... [10:28] BjornT: took a bit more of a look at the problem, but didn't find a solution [10:28] jamesh, thanks, it works now === jordi [n=jordi@115.Red-213-96-69.staticIP.rima-tde.net] has joined #launchpad [10:31] jamesh: 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:32] BjornT: I'm going to try it out on my laptop next (x86) [10:32] BjornT: I tried running the tests under valgrind without success [10:32] ok [10:33] BjornT: the answer might just be that pyme sucks because it uses swig ... === jamesh has a hard time trusting memory management of swig extensions [10:41] hello [10:41] wow, that was a bad blackout [10:41] jordi: too much coffee ? [10:41] never! [10:42] dunno, the server wouldn't work until this morning [10:42] jordi, hi, are you subscribed to ubuntu-translators mailing list? [10:42] not sure [10:44] I see your reply now [10:44] jordi, I added you to the CC [10:44] because I was not sure you were subscribed [10:44] it seems I'm not [10:44] oh damn [10:44] I think you should join that list.... [10:44] I'm getting buried under email :/ [10:45] jordi, just like kiko!!! [10:45] ;-) [10:45] I dunno how he manages. :) [10:46] SteveA: the merge problem is fixed [10:46] and pqm/bzr updated to prevent it happening again [10:59] lifeless: cool. is there a short explanation of what happened? [11:03] yes, there was a bug in merge, which meant it did not copy all needed data. this shows itself potentially much later. === sbec [n=sbec@eureka.av7.net] has joined #launchpad [11:12] hello [11:13] I register on launchpad yesterday night but never receive mail ...? [11:17] sbec: that's interesting. i can try sending you some email, to see if it works. [11:18] sbec: /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:19] Uh, I try again and it works, dono where went the first email ... maybe in the dark internet :-) [11:19] maybe you or your ISP has a "greylisting" service. that can cause problems sometimes. === carlos workraves [11:22] SteveA: no, i'm my own isp :) [11:23] Nevertheless, thank you. === WaterSevenUb [n=WaterSev@azevedo.astro.up.pt] has joined #launchpad === koke [n=koke@ubuntu/member/koke] has joined #launchpad [11:49] Bye. === 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 [12:17] good morning! [12:17] hi matsubara === salgado_ [n=salgado@200-171-140-32.dsl.telesp.net.br] has joined #launchpad [12:20] carlos, 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. === 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 [12:22] hey Kinnison do you have a reply for the e-mail kiko cc'ed you about the 1132 bug? [12:23] WaterSevenUb, the bugs are filed in the right place, it's just I'm a bit behind with my user support tasks [12:24] WaterSevenUb, I hope I will look into all bug reports before the end of this week [12:25] lifeless, How is possible that, from time to time, a 'bzr push' needs to sync weaves that were already synced? [12:25] carlos, k. Hang on the great job:) [12:26] ;-) === kiko [n=kiko@200-171-140-32.dsl.telesp.net.br] has joined #launchpad [12:38] good morning hackers [12:38] hey SteveA [12:38] kiko, morning [12:38] hey carlos how's it going [12:39] fine, thanks [12:39] tell me how the uploads are going? [12:39] hmm I did my first bzr merge request and I think I fucked it.... [12:39] ;-) === GoRoDeK [n=gorodek@p5083DC98.dip.t-dialin.net] has joined #launchpad [12:39] lifeless, could you remove my request so I sent it again with the 'sftp://' string added? [12:40] kiko, waiting for Steve's review [12:40] kiko, In the mean time I'm working on user support [12:42] carlos, what about my favorite feature, POMsgSet? :) [12:42] +View === BjornT -> lunch [12:43] kiko, 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 it [12:44] I thought that some work had been done on that already? [12:44] I think yes, you should start on it and put up whatever you have for review before you leave [12:46] kiko, 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:47] triage is good, but you could help jordi get started on helping you out there [12:47] that way you two better complement yourselves [12:48] carlos: don't answer mail if you think they are in my roof. I am working on them [12:48] kiko, sometimes there are technical details that jordi does not know because he's not a launchpad developer [12:48] that's true [12:48] but yes, I suppose Jordi could help there [12:48] that's fine though [12:48] jordi can call you in on those ones [12:48] kiko: besides, I have no rights to modify a single bug detail [12:49] jordi, do you have all mails from ubuntu-translators? [12:49] no [12:49] I just subscribed [12:49] but they are in the archive, are they? [12:49] jordi, ok, I will handle the old ones [12:49] jordi, yes [12:49] jordi, ok, if you handle the old ones too... [12:50] what kind of messages do we need to track? [12:50] damn. I use way too much time replying to stuff === zyga [n=zyga@2-mi2-1.acn.waw.pl] has left #launchpad ["Leaving"] [12:52] jordi, This is the next mail that should be answered: http://lists.ubuntu.com/archives/ubuntu-translators/2005-September/000280.html [12:52] jordi, since that one, I didn't reply to any email [12:53] jordi, look at the threads because sometimes, other users answered already [12:53] jordi, you need to reply only the ones that are without an answer [12:53] jordi, ok? [12:53] ok === jordi sighs. [12:54] jordi, there are only 44 emails [12:54] jordi, and some of them are already answered [12:55] so don't worry, that mailing list is low traffic (but with a ton of spam) [12:55] ok [12:56] "me pido no ser el administradoooor" :) [12:57] jordi, ;-) [12:58] don't worry, you will not be the admin of that mailing list [12:58] at least not now... but perhaps in the future.... :-D === jordi can be heard from Brazil cursing and whining. [01:00] kiko, ok, so back to code... [01:01] kiko, should I work first on https://launchpad.net/products/rosetta/+spec/translation-review ? is set as high priority by mark [01:02] kiko: speaking of, https://launchpad.net/products/rosetta/+spec/distro-and-product-translation-visibility ? [01:02] hmm, no, pomsgsetview will help to implement that spec [01:02] kiko, so I'm going to work on pomsgsetview [01:02] carlos: what needs to be done to get MulticastTranslations approved? [01:02] I would love to see that one [01:03] jordi, mark wants that we implement translation-review first [01:03] nod [01:03] and after having it implemented, look again to MulticastTranslations [01:03] Heh. [01:03] jamesh, around? [01:04] The Rosetta product "Doesn't use Rosetta". :) [01:04] jordi, and never will do as Rosetta is not really a product but a part of launchpad... :-) [01:05] jordi, perhaps we should set that flag to prevent funny comments.... === dholbach [n=daniel@ubuntu/member/dholbach] has joined #launchpad [01:06] hellas [01:06] could it be that launchpad mails today need some more time to get processed or sent out? [01:09] stub, ^^^^ ? [01:09] carlos: yeah :) [01:12] Launchpad mails are running normally as far as I can tell. Works for me. [01:13] hm [01:14] thanks for the info === ddaa [n=ddaa@nor75-18-82-241-238-155.fbx.proxad.net] has joined #launchpad [01:16] funny bug.... [01:16] you cannot add a new spec with the assignee, drafter and approver field set [01:16] because you get timeouts [01:17] if you create it with those fields empty, the spec is created.. === carlos files a bug [01:19] carlos: review sent [01:19] it isn't much [01:19] SteveA, nice ;-) [01:19] there is one serious problem, but which has a simple fix, but needs a test [01:19] thanks [01:19] ok [01:20] hey SteveA, would you like to do another review? ;) [01:22] salgado: ok [01:23] SteveA, it's the implementation of ShipItReports. it's already in pending-review, but the diffs are not showing up there [01:23] SteveA, should I mail you the diff? [01:24] ok [01:35] carlos: cool [01:35] there's like 4 mails that need reply [01:40] dholbach: do you use greylisting? [01:41] no [01:41] the mails took an hour to reach me [01:41] i mean it's fine with me... i don't *rely* on them that much - just as a heads up [01:42] last 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:43] so, the mail would be delayed on the outgoing mail server at the DC [01:43] i don't yet have access to mail logs, so i can't look into it further. [01:43] i see [01:43] i could ask the hoster, but i'm pretty sure they don't use greylisting [01:44] Marius' mailhops program might be useful [01:44] it lists where a message spent its time [01:44] you could put the full mail you received, inc headers, into RT and ask the admins to look into it [01:47] jordi, ;-) [01:47] We already know about the issue of lists.ubuntu.com being terribly slow. Hopefully that will be resolved today with a hardware upgrade. [01:48] SteveA, could you explain to me where do you think the bug is? [01:48] SteveA, https://chinstrap.ubuntu.com/~dsilvers/paste/filehrxNJz.html [01:48] I don't see it [01:48] lifeless: it would be nice if you could loosen the perms on your home dir on chinstrap a bit [01:48] so other people can access e.g. ~robertc/public_html [01:49] carlos: missing = sign [01:49] lifeless: I do not really see the point of preventing other users from reading your home dir on chinstrap... [01:49] SteveA, oh, right! [01:50] system doc test, perhaps? [01:50] SteveA, It's a bug and I suppose we don't have a tests [01:50] SteveA, yes [02:04] stub, still around? [02:04] Znarl: ah ok === mpt [n=mpt@200-171-140-32.dsl.telesp.net.br] has joined #launchpad [02:06] salgado: yes [02:08] stub, 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] I can help. What is the problem? [02:09] salgado: review sent [02:10] that 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't [02:10] SteveA, dude, this was fast. thank you. :) [02:11] salgado: Which query was this? I don't recall a left outer join === carlos -> lunch [02:12] IIRC, you needed to change [02:12] SELECT [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') TO [02:12] SELECT [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] UNION [02:12] SELECT [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] stub, hmmm. that's true. the query that times out doesn't have the left outer join as I see in the code [02:13] Maybe with a SELECT DISTINCT wrapper around it in case there are dupes [02:14] SELECT DISTINCT * FROM ( [02:14] SELECT [list of columns] from Person, EmailAddress [02:14] WHERE Person.id = EmailAddress.person AND teamowner IS NULL AND merged IS NULL [02:14] AND (lower(email) LIKE 'kiko%%' [02:14] UNION [02:14] SELECT [list of columns] from person, emailaddress [02:14] where person.id = emailaddress.person and teamowner is null and merged is null [02:14] and fti @@ ftq('kiko') [02:14] ) [02:14] stub <3 kiko [02:14] No tongue this time! [02:15] jordi, I'm still blocked by lifeless fixing bzr for me, my branches are all fscked [02:15] dammit, /me was looking at the wrong place [02:16] stub, okay, this one I can fix easily. but the one I was looking at is very similar to this, but more complex [02:16] kiko: aww === salgado pastes it [02:16] jordi, maybe it will unblock tomorrow [02:16] cool [02:18] stub, https://chinstrap.ubuntu.com/~dsilvers/paste/filePzDqFe.html [02:19] this 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't === niemeyer [n=niemeyer@200-171-140-32.dsl.telesp.net.br] has joined #launchpad [02:23] salgado: That query is broken - missing a where statement. [02:24] stub, my fault, I copied it from the code and forgot to copy the WHERE [02:24] stub, https://chinstrap.ubuntu.com/~dsilvers/paste/filenRRf2I.html [02:25] salgado: ok. 4 seconds - needs work. [02:29] stub, is the UNION (like I'll do for the other) supposed to make this one faster too? [02:30] Yes. https://chinstrap.ubuntu.com/~dsilvers/paste/filelRgS6E.html (from 4 seconds down to 20 micro seconds) [02:31] actually - I think that can be simplified a bit further. [02:31] dude, you're a star === jbailey [n=jbailey@modemcable139.249-203-24.mc.videotron.ca] has joined #launchpad [02:32] https://chinstrap.ubuntu.com/~dsilvers/paste/fileLfk0Cc.html [02:32] salgado: ^^ I think that has all the same logic [02:33] Merge 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] Hmm... no. I think the first one is better. It matches teams [02:34] Cor, dilys is back on the game [02:34] stub, yes, that's right. it has to match teams [02:36] salgado: With the DISTINCT - https://chinstrap.ubuntu.com/~dsilvers/paste/fileK4SYCf.html [02:36] salgado, that fix is probably not the right one. [02:36] (it might not hurt though) [02:37] salgado: erm.... https://chinstrap.ubuntu.com/~dsilvers/paste/fileZwXMXw.html [02:37] kiko: The query he pasted is taking 4 seconds on production, so it needs fixing anyway [02:37] stub, I guess he was talking about my merge [02:37] stub, I was talking about his latest merge [02:37] right [02:37] kiko, yes, I think you're right === GoRoDeK [n=gorodek@p5083D223.dip.t-dialin.net] has joined #launchpad === jbailey [n=jbailey@modemcable139.249-203-24.mc.videotron.ca] has joined #launchpad [02:43] stub, 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 like [02:44] salgado: 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:45] It isn't quite as efficient, but the wastage is in milliseconds and we can live happily with that [02:45] stub, no, that's a raw query that is composed using multiple parts, and the composition changes in three different classes [02:46] anyway, now I think I can do it using sqlobject and SelectResults.union() [02:46]