/srv/irclogs.ubuntu.com/2011/09/10/#launchpad-dev.txt

wgrantnigelb: Landed.00:04
nigelbwgrant: thanks!00:05
cjwatsonwgrant: could you do one for me in the same situation?00:11
wgrantcjwatson: multiarch-translations?00:11
cjwatsonyep00:12
wgrantcjwatson: It passed ec2?00:12
cjwatsonyep, forwarding you the test mail now00:12
wgrantThanks.00:12
wgrantcjwatson: Landed as r1390900:17
wgrantcjwatson: I guess this is reasonably urgent?00:18
wgrantWe should be able to deploy it Monday/Tuesday.00:18
cjwatsonThanks.  Moderately; if at all possible I would like to switch it on before beta 2.00:18
cjwatsonThat gives us time to switch it off again and/or fix it up if it goes horribly wrong.00:18
wgrantYup.00:19
wgrantI'll see how QA goes this weekend, and might arrange a poppy downtime window for my Monday morning if things go well.00:19
wgrantSince Monday's 1830 slot is occupied by a DB patch.00:19
wgrant0830 slot, that is.00:19
cjwatsonMon/Tue gives us adequate time.00:19
wgrantOK, might just do it Tuesday then.00:20
wgrantThanks.00:20
=== G is now known as Nigel
StevenKRargh, and buildbot is going to fail.03:02
nigelblawl, so there's now Nigel and nigelb in the channel.04:36
nigelbFUN.04:36
jtvpgbouncer fixture is breaking buildbot: https://lpbuildbot.canonical.com/builders/lucid_lp/builds/1353/steps/shell_6/logs/summary04:43
nigelbohai jtv04:52
jtvHi04:52
nigelb*yawn* 4 hours of sleep. Sigh.04:53
abentleywgrant: sort of.  a None response is treated as a failure now.05:01
wallyworld_nsi05:04
nigelbstub: Hey!08:15
nigelbGot a minutes? I need some help with a db patch (the one I talked to you the other day about)08:16
stubnigelb: ok08:18
nigelbI removed the statusexplanation field, but I'm having trouble with this08:20
nigelbtsvectorupdate BEFORE INSERT OR UPDATE ON bugtask FOR EACH ROW EXECUTE PROCEDURE ftiupdate('targetnamecache', 'b', 'statusexplanation', 'c')08:20
nigelbwilliam asked me to talk to you since we don't run fti.py anymore during the fast downtimes08:20
wgrantI suspect we want to fix fti.py to have a mode to just fix the triggres.08:21
wgrantWithout rebuilding columns...08:21
stubnigelb: I see. I'll need to handle the DB patch while I work out the best way to proceed. I think I'll be manually rebuilding that trigger function.08:21
nigelbI already have a patch number and a patch, do you want me to continue or just take over?08:22
=== almaisan-away is now known as al-maisan
* StevenK wills the tests to write out the unknown file he is chasing08:23
stubIf you want to give it a go, I think it will be a "CREATE TRIGGER tsvectorupdate BEFORE INSERT OR UPDATE ON bugtask ..." like you see, except with 'stausexplanation','c' removed from the arguments08:23
=== al-maisan is now known as almaisan-away
nigelbI'll give it a shot.08:23
stubwgrant: I'm just dropping fti.py, as we out grew it long ago. We really need data from multiple sources in a single index etc.08:23
wgrantYeah.08:24
wgrantGood plan.08:24
nigelbhrm, syntax error.08:25
StevenKPaste what you have?08:25
nigelbhttp://pad.ubuntu.com/kCRLMrXkW308:26
nigelbgah08:26
nigelbwait08:26
nigelbexcellent, that didn't work. because the trigger already exists.08:26
stubYay SQL the query language for mortals08:26
wgrantCREATE OR REPLACE TRIGGER?08:26
wgrantDoes that work?08:27
stubyer, DROP TRIGGER first since there is no CREATE OR REPLACE TRIGGER08:27
nigelbheh, ok08:27
* nigelb googles how to drop trigger08:27
wgrantDROP TRIGGER whatever ON sometable08:28
stubI find file:///usr/share/doc/postgresql-doc-8.4/html/sql-commands.html invaluable.08:28
nigelbworked08:29
nigelbDo I add the trigger queries into my patch as well?08:29
* nigelb heads for lunch08:40
stubnigelb: The DROP TRIGGER, CREATE TRIGGER go into your patch, yes. I think you also need to modify fti.py as well, as it will currently undo your changes. So the db patch will affect staging and production which no longer run fti.py, and dev boxes get the rebuild version from fti.py. Which sucks, so Bug #81571708:44
_mup_Bug #815717: Kill fti.py <fastdowntime-later> <Launchpad itself:Triaged> < https://launchpad.net/bugs/815717 >08:44
* StevenK finally figures out where lp.code.model.tests.test_sourcep and lp.soyuz.tests.test_binarypackag are leaking from.09:03
nigelbstub: heh, okay :)09:05
=== almaisan-away is now known as al-maisan
=== al-maisan is now known as almaisan-away
=== almaisan-away is now known as al-maisan
=== al-maisan is now known as almaisan-away
=== almaisan-away is now known as al-maisan
=== al-maisan is now known as almaisan-away
=== almaisan-away is now known as al-maisan
=== al-maisan is now known as almaisan-away
=== almaisan-away is now known as al-maisan
=== al-maisan is now known as almaisan-away
=== almaisan-away is now known as al-maisan
=== al-maisan is now known as almaisan-away

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