[12:04] arg, LP won't compile [12:04] ar: .libs/allocsa.o: No such file or directory [12:05] mpt: we can override that [12:05] mpt: are you certain its identical? with the latest rocketfuel or current production? [12:05] sabdfl: with rocketfuel [12:06] Well, I tested it on six sample pages [12:06] including the front page, an auto-generated form, a Rosetta translation form, a bug page [12:06] and a Rosetta chart [12:07] SteveA: how? [12:08] mpt: magic headers. we'll have a session with lifeless at UBZ on launchpad cacheing === mpt has no idea how to fix this compilation bug [12:10] mpt: how are you compiling? [12:10] SteveA: First with make run, and when that didn't work, with make clean followed by make [12:10] that's a problem with gettext-tools [12:10] so, cd sourcecode/pygettextpo === poningru [n=poningru@n128-227-48-184.xlate.ufl.edu] has joined #launchpad [12:10] ok [12:10] make in here? [12:11] try that [12:11] same error [12:11] do I have time before the bzr changeover? [12:11] SteveA: same error in gettext-tools-0.14.2 [12:11] okay [12:12] what does 'locate allocsa' give you? [12:13] SteveA: a bunch of files that are all in salgado's home directory [12:13] hang on [12:13] :-) [12:13] and a warning about slocate.db being old [12:13] can you paste me the full error you get from trying to make the gettext stuff [12:13] on chinstrap [12:13] in the pastebin [12:15] SteveA: https://chinstrap.ubuntu.com/~dsilvers/paste/fileyItaNT.html [12:15] mpt: tested, visually? or comparing screenshots? [12:16] sabdfl: visually, Shift+Reloading after every change to make sure that nothing changed, and fixing it if it did [12:16] mpt: ok, land it, please don't surprise me [12:16] mpt: make clean in gettext-tools-0.14.2 and try again [12:18] Merge to rocketfuel@canonical.com/launchpad--devel--0: [r=sabdfl, r=SteveA] This is a major cleanup of template text and headings across Launchpad. Read the first part of the patch log for some simple advice on how to make pages quicker to use. (patch-2724: mpt@canonical.com) [12:19] YES === Kinnison is storming through this review response [12:19] SteveA: hey, that worked, thanks [12:19] Merge to thelove@canonical.com/bazaar-debian--debian--1.4: Release of 1.4.3 (patch-9: Matthieu.Moy@imag.fr) [12:23] mpt: so, a flaw in its makefile === bradb [n=bradb@modemcable033.209-70-69.mc.videotron.ca] has left #launchpad [] === SteveA fixes the excessive cookie-sending === Kinnison sends his reply to stevea while his baz gets on with things [12:39] sabdfl: ok, http://async.com.br:8081/ should work now === mpt had a few bugs to fix from bad merging [12:41] mpt: you dropped a change of mine, to the li spacing in portlets [12:41] it should be more tightly spaced [12:42] http://async.com.br:8081/malone/bugtrackers/mozilla.org [12:42] some weirdness in the details portlet === t1nt1n [n=t1nt1n@gepardi24.adsl.netsonic.fi] has joined #launchpad [12:44] sabdfl: li fixed [12:44] http://async.com.br:8081/products/firefox/+spec/mergewin [12:44] lost the border on the alert message [12:45] that was intentional [12:45] I changed the alerts from bordered orangey to unbordered yellow [12:45] and the errors from red to pink [12:45] and the non-graphic bullets from black to turquoise [12:45] those were the only visual changes, afaik [12:46] black to turquoise is probably fine [12:46] the colours are not great, could you revert that please? [12:46] ok [12:47] ok, I see what's happening with the bugracker [12:49] Kinnison: replied. please merge [12:49] thanks === yi [i=yi@rollright.bmsc.washington.edu] has joined #launchpad [12:49] SteveA: we'll discuss the ##CUSTOMFORMAT## stuff over a beer in Montral [12:50] ok [12:50] sabdfl: http://async.com.br:8081/malone/bugtrackers/mozilla.org fixed [12:51] mpt: DOIT [12:51] ta muchly, sabdfl [12:52] sabdfl: so the plan is to transfer launchpad to bzr tomorrow? [12:53] Kinnison: yes [12:53] though, check with lifeless [12:53] and colors reverted [12:53] sabdfl: cool === Kinnison is just preparing to send off the queue-accepted processor [12:53] fyi, pqm packages are nearly there, will get pybaz packaged today [12:54] then I think I've closed off all my branches ready for bzr [12:54] so I can go from fresh [12:55] no need to chew chinstrap converting my archive :-) [12:55] Kinnison: good man [12:55] so long as I can get this merge in of course === robertj [n=robertj@66-188-77-153.dhcp.athn.ga.charter.com] has joined #launchpad === xenru [n=Miranda@85.192.3.23] has joined #launchpad [01:01] SteveA: Where should that Makefile bug be reported? (I fear I don't know enough to report it usefully) === mpt [n=mpt@200-171-140-32.dsl.telesp.net.br] has joined #launchpad [01:04] mpt: i'll see if i can reproduce it [01:06] mpt: it will be difficult to make a good bug report because we didn't keep a copy of the tree before make clean [01:06] mpt: but, general advice is to use make clean if anything goes wrong [01:08] SteveA: right, I tried that at the top of the tree, and didn't realize that it would do anything different further down [01:08] now, that's a bug [01:08] report it on jamesh [01:09] 'make clean should work in pygettextpo' [01:10] okie dokie === mpt is soooooo glad design-fascism is landed [01:10] it's been chewing up my time [01:13] Right, my queue stuff is on pqm's plate now === rbelem [n=rodrigo@200.246.97.164] has joined #launchpad [01:22] mpt: you didn't revert those colours correctly [01:22] the alert is now pink, and has no border! [01:23] please fix asap. this colour is naff [01:32] Merge to rocketfuel@canonical.com/launchpad--devel--0: [r=stevea] Fixing bug # 2812, loading zcml info in builddmaster and consequently removing the database imports, fixing bug # 1305 by using standards in both buildd cronscripts. (patch-2725: celso.providelo@canonical.com) === mpt gouges out his eyes [01:41] sabdfl, fixed === sfvt_ [n=sfeehan@pool-64-222-103-115.burl.east.verizon.net] has joined #launchpad === stpere [n=stpere@ts1-54.f1232.ts.globetrotter.net] has joined #launchpad === rbelem is now known as rbelem-afk [02:18] mpt: i still have some more work to do on this login issue. but, i think i've worked it all out now. by the time i'm in montreal, i expect to have ready a branch with a fix to the login issues, improved sessioning that sets cookies only when necessary, and a straightforward way to say what cacheing-related headers to set for different kinds of content we're serving up. [02:27] great [02:27] btw, SteveA, I don't think it's necessary to say "you are logged in" on the next page [02:28] at least, not an extra time in addition to the header blurb [02:32] or should I save this feedback for Montreal? :-) [02:42] mpt: http://www.stylegala.com/features/bulletmadness/ [02:46] cute :-) [02:46] our generic bullet should be a bit larger to be comparable to the various icons, I guess [02:47] anyway, 10.45pm and PQM has the stylesheet sanity [02:47] I'm going home [02:48] mpt: we should go over various login / logout interactions at UBZ [02:48] and refine what launchpad does in each case [02:48] ok [02:48] it won't take long, and we can use the notes to make a basic set of use-cases [02:48] which then turns into tests [02:48] and gets implemented [02:49] we need to consider wikis and shipit too [02:49] register a spec for it [02:49] goodnight === mpt [n=mpt@200-171-140-32.dsl.telesp.net.br] has left #launchpad [] === stub [i=stub@sweep.bur.st] has joined #launchpad === rbelem-afk is now known as rbelem [03:33] stub: morning [03:33] Morning [03:33] can i ask you to cherrypick something please? [03:33] Sure [03:37] urgh, baz still in the pqm queue [03:37] more urgh, bzr still not checked out a fresh tree [03:37] even *more* urgh, publisher using 2g of ram on staging again === Kinnison growls [03:40] Kinnison: We had similar bloat with a Rosetta data migration script. It was doing 'for foo in Foo.select()', which would cause the entire table to be loaded into SQLObject instances and stay there no matter how much you committed. Solution was to use raw SQL to select the ids and create the objects one at a time. [03:40] Or something like that [03:41] Using a fresh connection per chunk to force the cache to be cleared [03:43] gosh, this poll UI is horrible [03:43] stub: meh? [03:44] If you iterate over the results of a select, all those results get sucked into a cache and stay there until the connection is closed. If instead you use psycopg to determine the list of items you want to iterate over, you can then iterate over that list of ids, creating a fresh connection each time. [03:44] Then you get no bloat. [03:45] More overhead in opening connections, but less overhead in thrashing [03:46] stub: can i have your approval for ALTER TABLE PollOption RENAME COLUMN shortname TO title; [03:46] and your permission to thwack anybody who gets another bit of crap like that past you [03:46] there's no shortname anywhere else in the system! [03:46] and this should be a big clue: [03:46] @property [03:46] def title(self): [03:46] return self.shortname [03:46] ? [03:48] If you know you won't need to make it programmatic in the future, sure. [03:48] You got a patch that can go in or do you want a fresh number? [03:49] fresh number please :-/ [03:49] and this is part of what i'd like cherry picked [03:49] and i'm really hoping that mpt never touched the poll stuff, horrible as it is, in his fascism patch [03:51] 25-47-0.sql [03:52] Do we have polls running now? Or should this wait until the Sat/Sun update? [03:53] we do, and i'm trying to allow people to vote [03:53] hey sabdfl [03:53] hey fabbione [03:53] still awake? [03:53] these bugs were reported nearly two weeks ago when the poll started [03:53] fabbione: yup [03:53] montreal time, nearly :-) [03:53] sabdfl: hehe [03:53] i just woke up :/ [03:53] cya in a few hours :) [03:58] fabbione: safe travels [03:58] sabdfl: thanks [04:01] sabdfl: see you in 10 mins to drop off the key? === jbailey [n=jbailey@testhaus.cns.utoronto.ca] has joined #launchpad === fabbione [n=fabbione@port49.ds1-van.adsl.cybercity.dk] has left #launchpad ["Leaving"] [04:03] SteveA: perfect [04:03] SteveA: beer? [04:04] cold and refreshing? === SteveA --> over and out === sfvt_ [n=sfeehan@pool-64-222-103-115.burl.east.verizon.net] has joined #launchpad === minghua [n=minghua@danube.mems.rice.edu] has joined #launchpad [04:13] Hi, does the merge account feature in launchpad work? [04:13] I always get a "RequestExpired" error === Kinnison decides he can't sit around waiting === Kinnison heads for bed [04:19] minghua: Normally it works :-( [04:20] stub: okay thanks, I think I'll try later [04:20] and if still not, I'll come again :-) [04:28] ta. Unfortunately I've just found a bug that causes the information I need to diagnose what is happening in your case to be lost :-( [04:31] minghua: Ahh.... just checking the commit logs. Someone has fixed your bug. I'll roll out that fix in a few hours. [04:31] Glad to hear that :-) [04:31] not that I have anything important in either account... [04:32] I just didn't realize that launchpad auto-imported my bugzilla or rosetta account [04:32] and I happen to want to use a different email for launchpad [04:34] Yup. It is very common which is why it is important to fix. [05:15] stub: mark.shuttleworth@canonical.com/launchpad--pre-ubz-specs--0--patch-10 [05:16] passes tests locally, but i don't know if there's something its likely to conflict with on production, or on current rocketfuel [05:16] sabdfl: Just that patch, or that branch up to that patch? [05:16] just that patch [05:16] when you roll out a new production, is that a tag, or a merge-into-old-production? [05:21] No conflicts is a good start [05:22] I merge it onto the production branch and then do a 'baz update' on the production system. For a full rollout I do a full build-config to get an entirely fresh tree. [05:30] ok, just merged from rocketfuel, no conflicts, will run tests [05:31] I'm already rolling it out [05:41] thanks muchly === sankar [n=sankar@202.144.95.245] has joined #launchpad [05:42] stub: separately: ProgrammingError: ERROR: relation "distributionbounty_id_seq" does not exist SELECT NEXTVAL('DistributionBounty_id_seq') [05:42] on production [05:42] any ideas? [05:42] there is a test for bounty creation, though its not a bounty on a distro [05:42] You don't have perms on the distributionbounty table? === rbelem is now known as rbelem-zzz [05:44] sabdfl: It is distrobounty, not distributionbounty [05:44] i've no idea why it's looking for distribution bounty then :-) [05:46] Because lib/canonical/launchpad/distributionbounty.py thinks the table should be called distributionbounty? [05:47] ah. fairy nuff [05:47] and so to bed [05:47] night [05:47] sabdfl: Your poll patch is live [05:48] minghua: Your merge should work now [05:48] https://launchpad.net/people/ubuntu-dev/+poll/tb-nomination-mjg59-2005/+vote-simple [05:48] doh [05:49] stub: indeed it is, thanks for the fix! [05:50] stub: any ideas? +portlet-options seems well registered [05:52] On that context? And it has permissions? [05:53] Is the portlet required btw? I can comment it out easily enough to get the page working (assuming it isn't critical functionality) [05:53] stub: its not required, no [05:53] can you check the zcml please? [05:54] zcml/poll.zcml [05:54] Not in there [05:54] Must have been added in a previous patch that hasn't been rolled out. [05:54] no, i'm really sure i added that myself [05:55] On that patch? [05:55] patch-10? [05:55] i thought so, yes [05:55] can i easily inspect patch-9 [05:55] ? [05:56] Hmm, I get a "page not found" when log out after merging, is that worth reporting? [05:56] minghua: Yes please. Ideally with the URL you where on when you selected 'logout' [05:57] oh, bollocks [05:57] stub, just roll out that branch [05:57] sorry [05:57] errr... up to -10 [05:57] ok [05:57] my bad [05:58] stub: I don't have the url anymore, it has a lot of random numbers in it [05:59] minghua: Don't worry then. If you can just describe what you did or where you where before clicking logout that will be enough [05:59] it's something like launchpad.net/token/#$!#!$!/+logout [05:59] I suspect this was from the 'your account has been merged' page? [05:59] Makes sense [05:59] stub: sorry about that. i'm very confident in the branch, though, and tests all pass [06:00] sabdfl: Its your nickle ;) [06:00] not -11, though, that has latest rf, and lord only knows what's in there :-) [06:01] yes, I clicked the link in the email sent to "account-to-be-merged", then it asks for "main-account"'s password, then I got logged in as "main-acount", and when I click "log out" on right-up corner I got the error [06:02] an ordinary log out works fine now [06:02] so I suppose it's a corner case [06:02] Yup. One we should catch. === lamont-away is now known as lamont [06:10] stub: should i stay up to check it? [06:10] I can get it up in 20 mins, or 10 mins if I'm rude and don't give the users a warning of a restart [06:12] stub: well, if it's b0rked its no worse than the current bits, so i'm going to crash. shooting for montreal time here, not beijing time [06:12] ok ;) [06:12] night [06:12] so tally ho and let's see if that worked [06:32] stub: nearly there? am still up [06:32] sabdfl: Merging is giving me the shits :-/ [06:32] stub: oh. conflicts? [06:32] Currently sucking down Kiko's branch for some stupid reason === stub works out how to properly use replay --reverse [06:54] This could take some time :-/ === stub goes for a swim === Burgundavia [n=corey@S0106000000cc07fc.gv.shawcable.net] has joined #launchpad === bhuvan [n=ubuntu@b14.gw.maa.collab.net] has joined #launchpad === lbm [n=lbm@cpe.atm4-0-1301006.0x50a0824e.vgnxx6.customer.tele.dk] has joined #launchpad === Seveas [n=seveas@seveas.demon.nl] has joined #launchpad === robitaille [n=robitail@d154-5-117-228.bchsia.telus.net] has joined #launchpad === jordi [n=jordi@115.Red-213-96-69.staticIP.rima-tde.net] has joined #launchpad [09:16] morning jordi [09:18] hello [09:18] stupid blackouts [09:18] all night with no access to mail [09:18] ouch [09:18] going to be at UBZ? [09:21] ajmitch: yup [09:21] SOON [09:21] great === ajmitch should get there saturday morning [09:23] me on the 1st === jordi [n=jordi@115.Red-213-96-69.staticIP.rima-tde.net] has joined #launchpad === jordi [n=jordi@115.Red-213-96-69.staticIP.rima-tde.net] has joined #launchpad === GoRoDeK [n=gorodek@p5083DF0E.dip.t-dialin.net] has joined #launchpad === Biggi [n=biggidb@209.8.233.14] has joined #launchpad [09:56] Hello :) === Virtuall[BZA] [i=virtuall@who.is.virtuall.info] has joined #launchpad === Virtuall[BZA] [i=virtuall@who.is.virtuall.info] has joined #launchpad [10:16] Morning launchpadders :) [10:16] hello sivan [10:17] hey jordi , 'sup? [10:17] sleepy [10:17] jordi: been up late? [10:17] nope, early rise [10:18] jordi: Bill Gates is visitng Israel for the first time ;) [10:18] that's great new :p [10:18] hmm, the "sorting" option in the spec tracker seems broken to me. === Keybuk [n=scott@syndicate.netsplit.com] has joined #launchpad [10:22] jordi: hilarious isn't it? [10:23] Keybuk: planning to put your pybaz package in debian or dapper? [10:23] ajmitch: not debian, I may upload it to dapper [10:23] depends whether it's obsolete by then or not ;) === t1nt1n [n=t1nt1n@gepardi24.adsl.netsonic.fi] has joined #launchpad [10:24] Keybuk: jblack asked me to do pybaz & pqm packages, I don't know if he'd seen your one [10:24] possibly not [10:24] it's needed for imports from baz to bzr :) [10:25] sabdfl: oh nice, improved UI for the spec tracker [10:25] Mithrandir: what are you trying to sort by? === ajmitch likes to see things in debian as well, but that's just me [10:26] yeah, but I don't like to maintain things in Debian [10:26] I can look after it there if you want [10:26] I prefer to focus on Ubuntu for our packages, and let another maintainer take those and modify them for Debian if they like [10:27] sivang: priority. [10:28] ajmitch: sure, go for it [10:28] the source at the same place [10:28] grabbed it earlier [10:28] I also, perhaps strangely, doesn't tend to package software I'm upstream for [10:28] morning [10:29] jbailey did the bzrk packages, fabbione the live-f1, etc. [10:34] Mithrandir: I seem to get nothing if I try to sort by prioriry..weird [10:35] sivang: it consumes some CPU time, then does nothing. [10:35] sivang: apparently, it tries to sort client-side, I think. [10:37] something has changed on the specs page so it consumes large amounts of CPU just to scroll it. :-( [10:37] lifeless: alive? [10:53] also, shouldn't "order by priority" order specs in high - medium - low - wishlist and not high - low - medium - wishlist ? [10:59] right, another totally fresh install [10:59] let's see if "make check" works ... what's the betting? === fabbione [n=fabbione@217.205.109.249] has joined #launchpad [11:21] Mithrandir: Probably worth a usability bug? [11:28] stub: ping? === zyga [n=zyga@2-mi2-1.acn.waw.pl] has joined #launchpad === WaterSevenUb [n=WaterSev@azevedo.astro.up.pt] has joined #launchpad [11:47] sivang: hm, I was fooled. Apparently, there are no medium-priority specs any more [11:50] & according to launchpad, noone is attending ubz yet [12:10] is pqm stopped or something? [12:13] sivang: oops, that stuffs just a mockup, wasn't meant to land just yet [12:13] looks pretty, doesn't do jack [12:14] sabdfl: how goes your attempt to rotate to montreal time? [12:15] sabdfl: yeah, I noticed all thos phony #'s for the hyper links :) [12:15] Kinnison: pretty good. "early" start today at 4:30am but managed to work "late" last night :-) [12:15] sabdfl: you're already in Montreal ? [12:16] sivang: no, but i'm already on montreal time === Kinnison managed to work until "10:30pm" as it were === Kinnison got up at 6am montreal time === Kinnison probably won't rotate any further until he gets there [12:16] otherwise I'll lose the entire UK morning [12:16] which would suck [12:16] and speaking of suck, what's up with PQM? [12:17] good idea, need to try to switch my timezone as well, will have only the flight for doing so... === Kinnison 's branch, which was submitted > 11h ago, still hasn't been merged [12:18] Also, cm.py still hasn't managed to check out launchpad for me === Kinnison restarts it === Keybuk is having major problems with cm [12:19] it intermittently decides it's not going to deal with bzr branches [12:19] so it'll trundle through the list, and then throw a spanner half way down [12:19] and refuse to work on that directory, so you have to start again [12:19] it's worse than that [12:19] it sits on a futex [12:19] and does nothing [12:19] for 11 hours [12:19] so much for having a shiny fresh checkout this morning [12:24] lifeless: ^? [12:26] sabdfl: isn't he on a plane? [12:27] stub: what is the magic foo to rename a key, or index, or foreign key constraint? [12:27] pqm was spinning on a baz commit. I kicked is as per lifeless' instructions [12:29] cm.py can do it if you have a recent enough build of bzr.integration. It takes 20 minutes building a full tree on asuka. I documented an rsync recipe because I really didn't want to wait the 6 or seven hours I estimate it would take to build it on my laptop. [12:30] sabdfl: drop and recreate for constraints [12:30] sabdfl: And I'd suggest doing the same for indexes [12:30] and the primary key? [12:30] i'm trying to s/distrobounty/distributionbounty/g [12:31] stub: does cm.py update then work? [12:31] geez, i was lazy once, and it bit me on the ass [12:31] Keybuk: update does not work. If you look closely you will find that sftp urls currently only work for build [12:32] sabdfl: ALTER TABLE foo_id_seq RENAME TO foo2_id_seq [12:32] stub: i did that [12:32] that's the table [12:32] sabdfl: ALTER TABLE foo ALTER COLUMN id SET DEFAULT nextval('foo2_id_seq') [12:32] sabdfl: ALTER TABLE foo RENAME TO foo2 [12:33] does it have to be in that order? [12:33] sabdfl: probably not [12:33] ok, cool [12:33] that's the seq, what about the pkey? [12:33] You might also need: ALTER TABLE foo DROP CONSTRAINT foo_pkey; [12:34] ALTER TABLE foo ADD CONSTRAINT foo2_pkey PRIMARY KEY (id) [12:36] sabdfl: Or you can just rename the class and leave the table the way it is ;) [12:37] stub: my inner mpt will not allow that [12:37] That conjures up.... disturbing.... imagery [12:41] ALTER TABLE distrobounty RENAME TO DistributionBounty; [12:41] ALTER TABLE distrobounty_id_seq RENAME TO distributionbounty_id_seq; [12:41] ALTER TABLE distributionbounty ALTER COLUMN id SET DEFAULT nextval('distributionbounty_id_seq'); [12:41] ALTER TABLE distributionbounty DROP constraint distrobounty_pkey; [12:41] ALTER TABLE distributionbounty ADD CONSTRAINT distributionbounty_pkey [12:41] PRIMARY KEY (id); [12:43] i'm nearly done with it [12:44] ALTER TABLE distributionbounty ADD CONSTRAINT distributionbounty_bounty_key [12:44] UNIQUE (bounty, distribution); [12:44] ALTER TABLE distributionbounty DROP CONSTRAINT distrobounty_bounty_key; [12:44] will privmsg for approval and patch num === cprov [n=cprov@200-171-140-32.dsl.telesp.net.br] has joined #launchpad [12:49] morning guys [12:49] stub: https://chinstrap.ubuntu.com/~dsilvers/paste/filemBGCtK.html [12:54] sabdfl: You have adistrobounty_distribution_key on your branch? [12:55] not... anymore? [12:55] You are renaming an index that isn't on my branch here. [12:55] oh [12:55] odd. thanks [12:55] sorry [12:56] test "make" in second window had failed [12:57] sabdfl: https://chinstrap.ubuntu.com/~dsilvers/paste/filexy73uR.html [12:58] stub: changes? [12:58] number of patch and that key? === mpt [n=mpt@200-171-140-32.dsl.telesp.net.br] has joined #launchpad [12:59] few minor tweaks. Most significant was reversing the column order in distributionbounty_distribution_bounty_uniq [12:59] patch number is 25-48-0 [12:59] Goooooooooood morning === salgado [n=salgado@200-171-140-32.dsl.telesp.net.br] has joined #launchpad [01:00] guuuurd morning mpt [01:00] hey salgado, diff in your inbox, landed last night, some basic poll cleanups [01:00] salgado: I managed to fix the slowness of that query on the front page btw. It now uses indexes that have been defined. [01:01] sabdfl, just saw it. will reply shortly [01:01] thanks muchly [01:01] stub: ah, which query was slow? [01:02] sabdfl: topPeople [01:02] stub, I saw the mail in the arch-commits list. thanks for that [01:02] one of mine :-/ [01:02] sabdfl: ORDER BY foo DESC, foo2 won't use an index on (foo, foo2), causing the plan to be real slow. [01:02] sabdfl: PostgreSQL limitation really. [01:03] stub: so you added an index on foo alone? [01:04] stub, the cherry-pick of that patch to unbreak people merge haven't gone yet, right? [01:05] sabdfl: there already was one on just karma, but it still caused slowness because of the other table being joined. We are now ordering that query on (karma DESC, id DESC). ORDER BY karma DESC would have been good enough in reality but we need it stable for the test suite. [01:06] Is PQM stuck? [01:07] mpt: it was. It shouldn't be any more. [01:08] ok [01:08] and we're still on baz right now === spacey [n=spacey@flits101-191.flits.rug.nl] has joined #launchpad === niemeyer [n=niemeyer@200-140-206-245.ctame7015.dsl.brasiltelecom.net.br] has joined #launchpad === matsubara [n=matsubar@200-171-140-32.dsl.telesp.net.br] has joined #launchpad [01:14] good morning! === ddaa [n=ddaa@200-140-206-245.ctame7015.dsl.brasiltelecom.net.br] has joined #launchpad [01:18] morning matsubara, ddaa [01:22] sabdfl, I can't see the poll-portlet-options.pt in the patch you sent === ddaa [n=ddaa@200-140-206-245.ctame7015.dsl.brasiltelecom.net.br] has joined #launchpad [01:35] Merge to rocketfuel@canonical.com/launchpad--devel--0: Queue-Accepted processor and some upload tweaks to fit it. r=stevea (patch-2726: daniel.silverstone@canonical.com) [01:37] salgado: sorry, it was in the previous commit of the branch [01:37] that nailed me last night too :_) [01:38] stub: could you cherrypick another patch for me, please? === Nafallo_away is now known as Nafallo [01:42] sabdfl, my only concern is that title is not required=True in the interface, and so people won't see it as "(Required)" in the form [01:47] salgado: good catch, could you fix that please? [01:47] stub: mark.shuttleworth@canonical.com/launchpad--pre-ubz-specs--0--patch-12 [01:48] sabdfl, sure [01:50] sabdfl: Arn't you supposed to be on a plane or something? === bhuvan [n=ubuntu@b14.gw.maa.collab.net] has left #launchpad [] [01:58] sabdfl: code updated. Restart will happen in 10 mins. [02:08] stub: thanks. should fix that accidental mockup on the specs pages [02:15] cheers all... till montreal === sabdfl [n=mark@pdpc/supporter/silver/sabdfl] has left #launchpad [] === berend_ [n=berend@chasin.xs4all.nl] has joined #launchpad [02:29] stub, can https://launchpad.net/errors/showEntry.html?id=1130328581.220.89194050491 be a db patch that wasn't rolled out? [02:30] paste please. that is expired (or on the other app server - I have only a 50% chance of being on the same server as you) === salgado pastes [02:31] stub, https://chinstrap.ubuntu.com/~dsilvers/paste/fileecFXfZ.html [02:31] No, that was a bug. [02:32] Mark is on it [02:32]