[12:08] s/3 or 4/10 or 11 === mdke wonders if the majority of open ubuntu bugs are duplicates which have been fixed [12:12] We shall try to tell you soon. [12:12] sfllaw, mm? [12:12] Well, for some definition of soon. [12:12] and what definition of we? [12:13] mdke: Hi. I'm the new guy. [12:13] hello, are you on malone? [12:14] https://launchpad.net/people/sfllaw [12:14] ah, I thought you meant you were working on launchpad === baconbacon [n=bacon@modemcable020.207-130-66.mc.videotron.ca] has joined #launchpad [12:15] lifeless, noted that [12:15] Oh no. We're going to be doing this the old fashioned way. === sfllaw sighs. [12:15] kiko's last comment on bug #3796 tends to suggest that duplicates aren't included in most bug lists, not sure though [12:15] Malone bug 3796 in malone "Duplicated bugs still show up as New in a list of bugs (also affects the Latest bugs portlet)" [Normal,Confirmed] http://launchpad.net/bugs/3796 [12:15] eu? [12:15] lifeless, would you like to review that branch or shall I fix this and resubmit it for review? [12:15] mdke, they aren't -- in any [by default] that I know of [12:16] kiko, oh, I just don't understand geek-speak then [12:16] so all those 10k ubuntu bugs are probably lots of dups? [12:16] I was agreeing with you! [12:16] oh damn [12:16] salgado: I've emailed you :) [12:16] heh [12:16] kiko, I got excited there for a moment [12:17] as I said -- they aren't [displayed by default] [12:17] salgado: I'd say, fix it, and the duplicate code, then resubmit it [12:17] I fixed the last bug I knew there, which was in the recent bugs portlet [12:17] k [12:17] so there are 10k real bugs, that is crazy [12:19] lifeless, great. thank you === salgado => home === Lorenzod [n=lorenzod@63.218.103.162] has joined #launchpad === Lorenzod [n=lorenzod@63.218.103.162] has joined #launchpad === sabdfl [n=mark@ubuntu/member/pdpc.silver.sabdfl] has joined #launchpad [01:00] 10k but for many apps [01:00] ...about 16k apps iirc [01:00] its < 1 per app === WaterSevenUb [n=WaterSev@195-23-238-238.nr.ip.pt] has joined #launchpad === mpt__ [n=mpt@222-154-112-147.jetstream.xtra.co.nz] has joined #launchpad === tambaqui [n=tambaqui@200-183-98-222-mns.cpe.vivax.com.br] has joined #launchpad === mpt__ [n=mpt@222-154-112-147.jetstream.xtra.co.nz] has joined #launchpad === cprov [n=cprov@201-43-145-181.dsl.telesp.net.br] has joined #launchpad === mpt [n=mpt@219-89-132-63.jetstart.xtra.co.nz] has joined #launchpad === stub [n=stub@ppp-58.8.1.90.revip2.asianet.co.th] has joined #launchpad === stub [n=stub@ppp-58.8.1.90.revip2.asianet.co.th] has joined #launchpad === PenguinOfDoom [n=PenguinO@spleen.xzrq.net] has joined #launchpad [04:15] How do I increase the severity of a bug? [04:15] oh, it's per-distribution [04:15] grumble === mpt_ [n=mpt@222-154-181-148.jetstream.xtra.co.nz] has joined #launchpad === PenguinOfDoom [n=PenguinO@spleen.xzrq.net] has left #launchpad [] === LeeJunFan [n=junfan@adsl-69-210-207-5.dsl.klmzmi.ameritech.net] has joined #launchpad === mpt__ [n=mpt@219-89-151-229.jetstart.xtra.co.nz] has joined #launchpad === auth00_ [n=auth@fiji.grd.sgsnet.se] has joined #launchpad === mpt_ [n=mpt@219-89-138-28.jetstart.xtra.co.nz] has joined #launchpad === poningru [n=poningru@ip68-226-0-76.ga.at.cox.net] has joined #launchpad === nictuku [n=yves@ubuntu/member/nictuku] has joined #launchpad [05:05] "Your subscription to this team has been deactivated. You can't join this team. " what does this mean? I was banned from the group? === stub [n=stub@ppp-58.8.1.90.revip2.asianet.co.th] has joined #launchpad === mpt__ [n=mpt@219-89-156-29.jetstart.xtra.co.nz] has joined #launchpad === mpt_ [n=mpt@219-89-156-29.jetstart.xtra.co.nz] has joined #launchpad === _drak0__ [n=rob@user-10cmeb8.cable.mindspring.com] has joined #launchpad === _drak0__ [n=rob@user-10cmeb8.cable.mindspring.com] has left #launchpad [] === carlos [n=carlos@105.Red-81-34-77.dynamicIP.rima-tde.net] has joined #launchpad [08:39] morning === tambaqui [n=tambaqui@200-183-98-222-mns.cpe.vivax.com.br] has left #launchpad [] [08:47] morning all [08:51] stub: hi, around? [08:51] carlos: yes [08:51] I'm having problems with the code updates you do on mawson in the afternoon, or at least I think that's the problem... [08:52] I breaks the language pack exports [08:52] s/I/It/ [08:52] I don't do code updates on mawson. Do you mean asuka? [08:52] http://mawson.ubuntu.com/~carlos/rosetta-dapper-2006-04-24.log [08:52] sorry, asuka, yes [08:52] I have lock problems [08:53] I can't stop that without disabling the afternoon code updates. They were really only needed for the sprint, so I don't have a problem with that. [08:53] stub: would the problem be: [08:53] for (id,) in cur.fetchall(): [08:53] yield POTemplate.get(id) [08:54] would it be fixed if I create a list first? and stop using the cursor? [08:54] Not really - locks you open remain that way until you commit or rollback. [08:54] hmmm, no, the break is when doing the query.... [08:55] yeah, and another process is doing the lock [08:55] stub: well, disabling the code update would fix it now, but when we move this script into production... [08:55] You are competing with a script that removes and rebuilds the permissions on all the tables - no way you can avoid locking. This is why we shutdown the production launchpad for database updates. [08:55] it would be worse [08:55] ok [08:56] so you think it would not be an issue on production? [08:56] carlos: can you reschedule teh exports to not conflict ? [08:57] I did it already [08:57] Let me see how long it takes now and try to find a better time to execute it.... [08:57] stub: when does the morning update finish? [08:58] the one with the database mirror included [08:58] carlos: If it triggered by the database updates, then this won't be an issue on production [08:58] ok [08:59] my export script takes around 3 hours [09:01] and I would need as close as possible to the db mirror to be able to test it earlier instead of one day after doing changes on production (like new .pot/.po imports) [09:01] stub: I'm executing it at 12:30 (mawson time) [09:01] You shouldn't get too close, as the finish time isn't that fixed === stub waits for his trash mailbox to load [09:02] yeah, that's why I moved it later, but seems like I moved too late and the afternoon update broke it again [09:02] Start at approx 8:30 and finish approx 12:00 server time [09:03] I'll disable the midday update [09:03] that means I should delay it a bit more or the afternoon update should be done later (3 hours after the morning update is a bit early, isn't it?) [09:04] It was requested at that time for the sprint. [09:04] Like I said - it is pretty pointless now that the sprint is over [09:04] stub: I think lifeless prefer that we leave it there instead of removing it [09:04] lifeless: ? [09:05] I don't care [09:05] I think steve might [09:06] and its night to have staging really close to prod [09:06] plus the po exports really should not be broken every time we sprint [09:06] -> should solve it permanently [09:06] it is just a code update - doesn't make any difference to data freshness [09:06] I'm talking code! [09:07] po exports shouldn't be running on staging. [09:07] sorry, I meant 'close to HEAD' [09:07] language packs are .. mo exports not po, sorry. [09:08] I meant language packs though [09:09] lifeless: well, the po export should move to production servers before next sprint [09:11] we are runing them on staging because that give me much more flexibility, but I hadn't to change any code recently related to them, or at least I hadn't to change any code that would not wait for the usual review and rocketfuel merge procedure, atm we are running there rocketfuel code directly [09:17] so why not run on production now ? [09:18] he is chicken ;) [09:19] squawk squawk squawk === stub goes for a swim [09:23] :-P [09:23] lifeless: if I get a full run today, and works as expected, I will start planning its movement to production === doko_ [n=doko@dslb-088-073-100-191.pools.arcor-ip.net] has joined #launchpad === BjornT [n=bjorn@213.226.190.253] has joined #launchpad [10:04] stub, are you able to cherrypick r1815? === ddaa [n=ddaa@nor75-18-82-241-238-155.fbx.proxad.net] has joined #launchpad [10:18] lifeless: hi, we had a weird behaviour with bzr, I'm not sure if it's related but it happened with the revision number change, the r3488 that is know now as r1814 (I think that was the last commit with the old revision numbers) [10:18] lifeless: I added a new file on that revision and merged it into rocketfuel [10:18] but rocketfuel doesn't have that file [10:19] carlos, lifeless said that the revision numbers will all fix themselves once he finds that bug [10:19] and my mirror has it so I'm sure I didn't forget its addition [10:20] mpt_: do you mean that the missing files is a known bug? [10:20] mpt_: or just that the revision number will be fixed? [10:20] in that case, is not just the revision number, but data lose... === raphink [n=raphink@ubuntu/member/raphink] has joined #launchpad [10:25] carlos: the revno thing should not affect the merge logic, I think. [10:26] carlos, I don't know anything about any missing files [10:26] whether a branch has new stuff compared to another one is based on the revid of the tip [10:27] carlos: what is your branch with the problem? === raphink [n=raphink@ubuntu/member/raphink] has joined #launchpad === SteveA [n=steve@195.182.78.95] has joined #launchpad [10:35] hi [10:37] ddaa: chinstrap:/home/warthogs/archives/carlos/launchpad/bug-2529 [10:37] SteveA: hi [10:40] hmmm [10:40] ddaa: seems like it's there now... [10:40] mpt_: Probably. I was going to do a production update today and bring it in then. [10:41] great [10:41] mpt_: aren't you on holiday? :-) [10:42] SteveA, yes, but I said I'd be on IRC some of the day === jinty [n=jinty@84.Red-83-55-199.dynamicIP.rima-tde.net] has joined #launchpad [10:43] carlos: well, if you say the file is in rocketfuel now, no need for me to investigate. [10:45] ddaa: right, thank you [10:46] stub: the migration script for the cherry pick you did for me is now on rocketfuel, could you execute it now? [10:47] carlos: Do you know what revision it landed in? [10:48] stub: well, I know the revision where it should be, and is the same you cherry picked... [10:48] I didn't ask for any other merge since then [10:49] r3488 or r1811 with the new numeration [10:49] Do you have a rough idea on how long it will take to run? [10:50] stub: no, but I don't think it would take more than one hour, it depends on the number of POFiles we have in our database [10:51] I think it would do the job in 15-20 minutes [10:51] but that's only a guess [10:51] if you want [10:51] I could time it on staging [10:51] no - rough is fine. [10:55] ok [11:00] Looks like rolling out head is the thing to do - almost everything landed since friday are desirable cherrypicks [11:13] Launchpad will be going down in just over 45 minutes at 10:00 UTC for its regular code update. Estimated downtime is 15 minutes. [11:44] carlos, pitti: I don't see any translations on rookery from the last OOo build? [11:44] doko: hm, maybe you still had NO_PKG_MANGLE defined? [11:44] pitti: no, and that wouldn't explain that carlos had something imported [11:45] Launchpad will be going down in 15 minutes at 10:00 UTC for its regular code update. Estimated downtime is 15 minutes. [11:45] doko: I don't control rookery tarballs, I cannot do anything there... === tortho [n=tortho@6.84-49-112.nextgentel.com] has joined #launchpad === WaterSevenUb [n=WaterSev@195-23-238-173.nr.ip.pt] has joined #launchpad [12:05] mpt_: ping [12:05] BjornT, pong [12:06] mpt_: do you have any suggestions how to make it possible to unsubscribe a team, without adding another menu item? [12:07] BjornT, the current UI structure kind of requires another menu item === koke [n=koke@ubuntu/member/koke] has joined #launchpad [12:08] hmmm, unless ... [12:08] ... unless "Subscribe" becomes "Subscribe/Unsubscribe" if a team you are a member of is subscribed to the bug [12:09] and then the resulting "Subscribe/Unsubscribe" page has radiobuttons for the things you want to do [12:09] (*) Subscribe me [12:09] ( ) Unsubscribe Team I'm a Member Of A [12:09] ( ) Unsubscribe Team I'm a Member Of B [12:09] That would be a gross hack, but it would avoid adding a menu item [12:10] Ideally, this would be done by the people/teams that you had permission to modify in the list of subscribers having checkboxes [12:11] To unsubscribe yourself or a team you're a member of, uncheck the relevant box [12:12] well [12:12] there are a number of states [12:12] yeah, i'll go for the "Subscribe/Unsubscribe" solution for now. it's quite easy to do, and the menu won't get any longer than it already is. [12:12] - not subscribed [12:12] - subscribed as me [12:12] - subscribed as team / teams [12:12] - subscribed as me and team / teams [12:12] the menu item can say [12:12] hey SteveA [12:13] - unsubscribe [12:13] - unsubscribe my team [12:13] - unsubscribe me and my team [12:13] in the (hopefully) rare case you want to unsubscribe a team, but not yourself, we can either offer a UI, or you unsubscribe it all, and resubscribe yourself [12:13] Three menu items? [12:13] no [12:14] well, yes [12:14] but only one ever visible at one [12:14] once [12:14] SteveA: so, if the menu item says 'unsubscribe my team', how do i subscribe myself? [12:14] is Launchpad eligible for SOC? [12:15] SteveA, that would be two extra page loads for the rare case, and the same number of page loads for every other case [12:16] BjornT: it would say "unsubscribe me and my team" [12:17] so, what is the advantage of doing it that way? [12:17] ah... [12:17] (*) Subscribe me [12:17] so, that wasn't a type [12:17] typo [12:17] (how ironic i typo the word typo) [12:17] SteveA: i don't quite understand. if one of my team is subscribed, but i'm not, what will it say? [12:17] i was confused by one radio button being "subscribe me" and the rest being "unsubscribe team" [12:18] mixing "subscribe" and "unsubscribe" in the same control is confusing [12:18] Yes, it is [12:18] We already have such evilness for unmarking duplicates [12:18] but the alternative is to add another menu item [12:18] or to add more page loads [12:19] my overall point, confusion aside, is that we can make the menu item give more of a clue as to what it is offering [12:19] by making it more context-specific [12:24] well, it's hard to get much information into the item and still have it short enough to fit into the menu box. === SteveA thinks of icons [12:25] a person going into a waste-disposal device, vs a group of people going into the same waste disposal device ;-) === SteveA got a degree from the school of inappropriate icons [12:25] carlos? [12:25] mpt_: magic dhtml extra menu items... [12:25] jordi: hi [12:26] Soylent Green Subscriptions === mpt__ [n=mpt@219-89-140-108.jetstart.xtra.co.nz] has joined #launchpad === BjornT -> lunch === mpt [n=mpt@219-89-150-174.jetstart.xtra.co.nz] has joined #launchpad === SteveA --> lunch === Keybuk [n=scott@quest.netsplit.com] has joined #launchpad [01:35] uh, help [01:35] sync-source is bailing out most of the time saying things like: [01:35] E: bsdgames_2.17.orig.tar.gz (from bsdgames) returns multiple IDs ([(1332643,), (1494584,)] ) for orig.tar.gz. Help? === SnkBite [n=SnkBite@212.25.63.82] has joined #launchpad [01:46] Keybuk: that shouldn't happen, that means there are multiple different orig.tar.gz's with different content, that's stunningly bad [01:46] Keybuk: and it's not a sync-source problem [01:46] the content is the same in both Ubuntu and Debian, if that's what you mean ? [01:46] no, I mean in soyuz [01:47] Kinnison says that the uploader may be just making duplicate aliases for the same actual .orig.tar.gzs [01:47] it's doing this for pretty much every package I'm trying [01:47] sync-source already deals with that [01:47] it has an explicit "is the sha1 and size the same? if so, ignore it" check [01:47] so who has to be beaten up to get this fixed? [01:48] elmo: yargh, okay I need to looksee [01:48] keybuk: well, probably not me, but I need to run to a meeting anyway === Kinnison needs to grab some lunch, then I'll take a good look at the db [01:49] Kinnison: thanks *hug* === bradb [n=bradb@modemcable092.66-130-66.mc.videotron.ca] has joined #launchpad === cprov [n=cprov@200-171-140-32.dsl.telesp.net.br] has joined #launchpad [02:02] morning guys [02:02] bradb, pong === matsubara [n=matsubar@200-171-140-32.dsl.telesp.net.br] has joined #launchpad [02:06] good morning! [02:09] mpt: Was going to ask you to have a look at the UI for the fix for bug 977. (It's in rf.) [02:09] Malone bug 977 in malone "Commenting on bug should optionally subscribe you" [Major,Fix committed] http://launchpad.net/bugs/977 [02:10] That would require me to go off IRC to get rocketfuel [02:10] Have a demo/screenshot? [02:10] or shall I just look at it tomorrow? [02:14] mpt: Tomorrow'd be fine. [02:14] It's nothing life changing. [02:15] ok === salgado [n=salgado@200-171-140-32.dsl.telesp.net.br] has joined #launchpad [02:26] matsubara: good catch [02:26] I mean bug 41164 [02:26] ddaa: ? [02:26] Malone bug 41164 in launchpad "IPerson.getBranch() should return only one result" [Critical,Confirmed] http://launchpad.net/bugs/41164 [02:26] critical db constraint missing [02:26] lifeless, around? [02:26] ddaa: thanks to the oops report :) [02:27] no idea how that ended up this way, I cannot believe I just _forgot_ to add that constraint [02:28] ddaa: can you fix it? [02:29] Should be trivial to fix. [02:29] well, that also means that some form do not do proper input validation [02:29] but that's MUCH less of a problem === mpt_ [n=mpt@219-89-142-164.jetstart.xtra.co.nz] has joined #launchpad === mpt_ [n=mpt@219-89-142-164.jetstart.xtra.co.nz] has left #launchpad ["http://mpt.net.nz/"] [02:42] ok, that's kinda interesting [02:42] my sync queue just got moved to failed, not accepted [02:43] no errors, just lots of [02:43] 12:41:44 WARNING Exception during processing made it out of the main loop. [02:43] -> http://librarian.launchpad.net/2339224/lEYjJjYCKy0XmqVqfzZaazPPLYK.txt (No To: header) === mpt_ [n=mpt@219-89-142-164.jetstart.xtra.co.nz] has joined #launchpad === mpt [n=mpt@219-89-142-164.jetstart.xtra.co.nz] has joined #launchpad [02:47] Keybuk, I think there's a bug reported for that [02:47] yep, bug 40958 === carsten [n=carsten@wikipedia/carsten] has joined #launchpad [02:48] Ubugtu, you slacker! [02:48] Malone bug 40958 in qprocd "all sync attempts fail" [Normal,Confirmed] http://launchpad.net/bugs/40958 [02:48] *sigh* === BjornT [n=bjorn@clt-84-32-240-183.dtiltas.lt] has joined #launchpad [03:11] cprov, is that codepath not tested? [03:11] hey BjornT === carlos -> lunch [03:11] see you later [03:12] hey carlos [03:12] kiko: barely only, I think we never reached this subtle situation [03:12] kiko: hey dude! [03:12] did you give matsubara a hand trying to figure out that crasher in rosetta? [03:12] hi kiko [03:12] cprov, really? isn't it that all syncs are busted? [03:12] kiko: which crash? [03:12] carlos, the TypeError? [03:12] kiko: yes he did. [03:12] the only rosetta crasher open that I know of [03:12] ah cool [03:12] kiko: I talked with matsubara last week [03:12] kiko: yes, I think so [03:13] matsubara: but did you manage to reproduce it? [03:13] cprov, so what I'm saying is that we are not functional-testing the sync process [03:13] carlos: unfortunately, no [03:13] kiko: just investigate that zakame issue [03:13] carlos, well, notice that there are /two/ string 13s in the form [03:13] matsubara: let's talk when I'm back from lunch about it, ok? [03:13] carlos, how could that be possible? [03:13] anyway k [03:13] carlos: ok. [03:13] kiko: no idea ;-) [03:13] carlos, seems to be user-dependent too [03:14] kiko: I don't even know how is possible that we get a python list dump there.... [03:14] i.e. BjornT sees two string 13s but matsubara and I only see one. [03:14] carlos, it happens when there are two fields with the same form name. [03:14] that's how you get the python list [03:14] kiko: I'd say so, it's not properly tested, as you can see [03:14] kiko: oh, that's good [03:14] yeah [03:15] I mean if you found a way to reproduce it [03:15] carlos, we'll need to find out what codepath causes two string 13s to be displayed [03:15] kiko: I need to leave now, I will take a deeper look when I'm back [03:15] thanks for the extra info [03:15] kiko: right [03:15] kiko: it's string 14. The garbage I told you in string 13 is the html that should be rendered as the second 14 textarea [03:15] sorry [03:15] string 13 [03:15] string 14 [03:16] I guess it depends more on your locale preferences or IP address [03:16] matsubara, that "garbage" is actually entered by the translator, I suspect [03:16] carlos, exactly what I think [03:16] ok [03:16] see you later! [03:16] kiko: do you think so? I run a diff between the html generated by opera and by firefox and there's no difference [03:17] matsubara, I am /sure/ there is a difference [03:17] matsubara, and, for the 10th time, this is /not/ browser-dependent [03:18] it most likely depends on the user's calculates languages [03:18] I understood that and I'm not saying it's browser dependent. [03:18] but you said "opera" versus "firefox" above! === niemeyer [n=niemeyer@200.103.151.176] has joined #launchpad [03:23] mh... apparently, the db constraint just got forgotten... [03:23] how embarassing === stub [n=stub@ppp-58.8.1.90.revip2.asianet.co.th] has joined #launchpad [03:25] stub! [03:25] ddaa! [03:25] heya guys [03:25] can you make a itsy bitsy littly db patch like, right now, with a cherrypick? === kiko looks at ddaa [03:26] I'll try phrasing what I want in sql if you want. [03:26] sql or english [03:26] in english [03:26] drop all Branch with duplicate (owner, product, name), keep the one with smallest id [03:27] add unique branch constraint on (owner, product, name) [03:28] ok [03:28] note that product may be NULL, dunno how that can affect unique matching [03:29] the delete should delete just 2 rows [03:30] ddaa, that constraint needs a code check, I assume? [03:30] kiko: code check? [03:30] well, something to avoid OOPSing when it happens [03:30] well, the form that allowed violating the unspoken constraint definitely needs fixing [03:30] and other forms too [03:31] but that's a low priority [03:31] if it generates an OOPS it is high priority [03:31] you don't need to do it yourself though [03:31] I mean lower than fixing the db constraint. [03:31] just make sure it gets done [03:31] since the constraint violation cause _everything else_ to blow up [03:32] you mean not having the constraint I guess [03:32] yeah [03:33] it's a "violation" in that a lot of things rely on that constraint, in the code (selectOneBy) and in the design. [03:33] indeed [03:33] mh... [03:35] stub: please run the following query and mail me the output before running the delete in production: select branch.id, branch.owner, person.name as owner_name, branch.product, product.name as product_name, branch.name from (select owner, product, name from branch group by owner, product, name having count(*) > 1) as dup_branch join branch using (owner, product, name) join person on branch.owner = person.id join product on branch.produ [03:35] it may require some cleanup on the supermirror filesystems [03:35] ddaa: pastebin please - that got cuttoff. [03:36] https://chinstrap.ubuntu.com/~dsilvers/paste/filejTBhBh.html [03:37] basically, I just want to know which branches got deleted, because the branch mirroring stuff does not care about that constraint === radix [n=radix@dsl092-068-248.bos1.dsl.speakeasy.net] has joined #launchpad === lamont [n=lamont@mib.fc.hp.com] has joined #launchpad === fabbione [i=fabbione@gordian.fabbione.net] has joined #launchpad === lifeless [n=robertc@dsl-43.1.240.220.rns01-kent-syd.dsl.comindico.com.au] has joined #launchpad === Ubugtu [n=bugbot@ubuntu/member/seveas] has joined #launchpad === zorglub [n=zorglub@194.146.226.84] has joined #launchpad [03:38] ddaa: https://chinstrap.ubuntu.com/~dsilvers/paste/fileay8ntH.html [03:38] stub: you have already applied the constraint? [03:39] ddaa: Not yet [03:39] ('ddaa', NULL, 'fred') and ('ddaa', NULL, 'fred') should conflict I assume? [03:40] yes [03:40] NULL product == pseudo product with name '+junk' [03:46] ddaa: Done [03:47] thank you, I'm looking forward to see it landing in RF === ddaa is sick, going for a nap === sabdfl [n=mark@ubuntu/member/pdpc.silver.sabdfl] has left #launchpad [] === Ubugtu [n=bugbot@ubuntu/member/seveas] has joined #launchpad [03:52] stub, we're only rolling out head-ish next week, right? === stub [n=stub@ppp-58.8.1.90.revip2.asianet.co.th] has joined #launchpad [03:54] kiko: Almost everything that had landed since last week was either requested for cherry pick, or was a good candidate for a cherry pick. So yes - one off. [03:54] stub, wonderful. next tuesday, then? === stub [n=stub@ppp-58.8.1.90.revip2.asianet.co.th] has joined #launchpad === beyond [n=beyond@200-171-140-32.dsl.telesp.net.br] has joined #launchpad [04:03] SteveA: Any chance of some code review love today? === bradb is in desparate need [04:04] bradb, what's up? [04:04] Code review blockage [04:04] that was obvious; more specifically? [04:04] also, a decision on binary package name, as per my email [04:05] I thought we had agreed to just put it in the description. I don't care about data migration, it's your call. [04:05] kiko: Yeah, it's already in the description, just the data migration issue. But if you don't care, then I say we just blow it away. We'll offend two or three people, and life will go on. [04:07] "Have you ever killed anybody? Me? No. But I hurt someone's feelings once." [04:07] heh === bradb lands it then === jkakar [n=jkakar@204.174.36.228] has joined #launchpad [04:21] kiko: hehe [04:21] what movie is that from sivang? [04:25] bradb: you know i'd love to give your code some lovin' [04:27] stub: is it possible to create temporary tables inside a transaction when connected as user 'ro' ? [04:31] actually, that question goes to anyone who might know [04:33] SteveA: ! [04:34] tough love [04:34] booty call [04:35] the bradb code review booty call [04:35] i like it [04:35] heh [04:36] ddaa: why is the docs stuff in my review queue? [04:36] Kinnison: Dunno ;-) [04:37] stub: hhe [04:37] stub: it seems it is permissible === Kinnison continues doing scary sql research as ro [04:37] just with much shorter queries now [04:38] jamesh: nice improvements to the pending reviews page! [04:40] if I have a table with three columns in it, namely aliasid, filename and sha1, how can I select all the rows which have a unique (filename,sha1) tuple? === sits [n=sits@cpc3-cwma2-0-0-cust739.swan.cable.ntl.com] has joined #launchpad [04:43] bradb: i'm looking at bug 36866 now, in preparation for the code review [04:43] Malone bug 36866 in malone "Searching for bugs after selecting a certain status from the Right-Hand-Menu resets the search" [Major,In progress] http://launchpad.net/bugs/36866 [04:43] bradb: one thing about bug reports like this: always edit the description to include an actual URL to start the process from [04:43] that way, looking at the problematic workflow is much easier for someone looking at the bug [04:43] matsubara: please note the above too [04:45] SteveA: updated :) [04:48] SteveA: ok === lbm [n=lbm@82.192.169.174] has joined #launchpad [05:00] Kinnison, select distinct on (filename, sha1) [05:00] Kinnison, you can use that in a subselect if necessary [05:01] and order by to choose which row you want [05:01] kiko: yah, someone gave me that in another channel just now, thanks dude === Kinnison never knew of the ON(blah) bit of select distinct [05:01] if you need some help using it let me know as I rewrote some code to use it recently [05:01] thanks, I think I've got the answer I needed, but I may be back for more hints [05:02] carlos, ping? === lakin [n=lakin@S01060013101832ce.cg.shawcable.net] has joined #launchpad === ddaa crawls out of his nap [05:10] SteveA: not sure why doc-bazaar is in your queue, after you replied to to lifeless' question during your vacation, I made some changes to the README, quicked it back to needs-review, then it went dormant. Only this week was I asked to get it moving again, so I said I already did... [05:11] at some point in the meantime, I guess it was moved out of spiv's queue (who is in vacation if I am correct) === Ubugtu [n=bugbot@ubuntu/member/seveas] has joined #launchpad === radix [n=radix@dsl092-068-248.bos1.dsl.speakeasy.net] has joined #launchpad === lamont [n=lamont@mib.fc.hp.com] has joined #launchpad === fabbione [i=fabbione@gordian.fabbione.net] has joined #launchpad === lifeless [n=robertc@dsl-43.1.240.220.rns01-kent-syd.dsl.comindico.com.au] has joined #launchpad === zorglub [n=zorglub@194.146.226.84] has joined #launchpad [05:12] SteveA: I guess your review is requested to confirm that the level of build documentation (good) and cross-referencing (none so far) is satisfying. [05:13] ddaa: That constraint is causing branch-pages.txt to fail (possibly others too) [05:13] duh? [05:13] ??? [05:13] no way _adding_ this constrain would cause anything to fail [05:14] except some forms with insufficient validation [05:14] https://chinstrap.ubuntu.com/~dsilvers/paste/fileYAYBeQ.html for the constraint that needs to land in rocketfuel.... [05:15] stub: yes [05:15]