[00:04] wgrant: You're not done with mawson? [00:05] StevenK: I would have been if it hadn't crashed. [00:05] Nearly done. [00:05] But I still need the buildd. [00:05] StevenK: hi [00:05] wgrant: Is perfectly fine, tell me when you're done. [00:05] lifeless: mumble? [00:06] lifeless: Or would you prefer something else? [00:06] mumble is still fail on my link [00:06] Get a better one? :-) [00:06] 2012 [00:07] lifeless: Skype or pots? [00:07] skype [00:07] Bleh, that requires commitment [00:08] I don't think you're craazy [00:09] Bad puns will be punishable at the Epic [00:10] i.e. never [00:10] :> [00:12] lifeless: On Skype and ready [00:13] StevenK: skype id [00:38] wgrant: Are we there yet? [00:39] StevenK: Just finished about a minute ago. [00:39] It's all yours. [00:44] thumper: ping [00:56] wgrant: Didn't you say you'd fix the en_AU locale on mawson? [01:15] wgrant: https://code.dogfood.launchpad.net/~stevenk/+recipes :-D [01:20] StevenK: No. I was going to look at overriding LANG. [01:20] Indeed, my .profile has: [01:20] export LANG=C [01:20] export LC_ALL=C [01:20] And there are no more warnings. [01:20] StevenK: Also, let me know when you're done with DF. [01:20] I want to stab the publisher in the face. [01:21] (that may be taken to mean optimising publishFileLists, or maybe not) [01:21] wgrant: I'm done once I clean up, but I wanted you to see the evil I created. [01:23] what should I do today? [01:23] StevenK: What was the evil? [01:23] wgrant: https://code.dogfood.launchpad.net/~stevenk/+recipes [01:23] Besides what looks like a bug in findStaleDailyBuilds, or a manual request. [01:23] wgrant: Look at the source branch [01:23] wgrant: It was a manual request. [01:24] Ah. [01:24] you're trying to kill our builders! [01:24] Haha [01:24] What're you testing? [01:24] I was QA'ing my findStaleDailyBuilds() change [01:24] I needed a branch ... [01:25] Ah [01:25] wgrant: Recipe deleted, you should be good [01:26] Thanks. [01:27] &away [01:27] Project devel build (412): STILL FAILING in 6 hr 10 min: https://hudson.wedontsleep.org/job/devel/412/ [01:27] Launchpad Patch Queue Manager: [r=leonardr][ui=none][bug=707103] UI for searching for bugs with or [01:27] without linked Blueprints. [01:39] wallyworld: whazzup? [01:39] thumper: mumble? [01:39] aye [02:02] poolie: With the oauth thing... you did s/contrib.oauth/oauth/, right? [02:04] wgrant: hey [02:04] in oops 1855H1087 [02:04] for th elong query; can you suggest a likely value for archive? [02:05] and the two status values [02:06] That query suggests it was a copy archive. [02:06] It's going to be difficult to reproduce entirely now. [02:06] I'm looking for one that will be on qas [02:07] Ah, yes, it was the copy archive. [02:07] There's nothing like it on qas. [02:07] Possible on staging, though. [02:07] Let me see. [02:07] not even lucid itself? [02:07] No. [02:07] This relies on there being lots of pending builds. [02:07] We could create one on qas, though. [02:08] Sure, how much do you want asuka to cry blood? [02:09] The first status is 0 (there were probably 25000 or so matching BFJs), the second is 6 (probably only about 30). [02:09] StevenK: it would hardly notice [02:09] staging's snapshot is from just the right time. [02:09] lifeless: Because it already is? [02:09] But the pending builds have been nuked. [02:12] hmmm, I wonder if https://help.launchpad.net/Code/Imports can be made snappier [02:13] Snappier? [02:13] easier for users of bzr to follow successfully [02:14] so how do we go about creating one of these archives on [qa]staging? [02:15] lifeless: We need to turn off the build farm, then run populate-archive.py. [02:15] Or we could possibly leave the build farm on and the archive disabled. [02:16] wallyworld: are you all good? [02:16] wallyworld: we have a laptop emergency [02:16] wallyworld: and need to get Rachel a new one [02:17] wgrant: https://qastaging.launchpad.net/builders is full of lies [02:17] "scripts/populate-archive.py -v --distribution=ubuntu --suite=natty -a i386,amd64 --to-user=lifeless --to-archive=bye-bye-asuka --reason='i hate alive servers'" should do it. [02:18] will that try to build things straight away? [02:18] lifeless: Looks like qastaging has no buildd-manager. [02:18] lifeless: Of course it is. We don't delete builders on qas [02:18] So you can safely run it there. [02:18] thats correct [02:18] spm: hi [02:18] I think he's lunching [02:19] spm: 6 lines before I said hi, kthxburn [02:19] On that note, so am I [02:19] StevenK: I'm sure he is [02:19] spm, lifeless: It may need to be "-a i386 -a amd64" instead of "-a i386,amd64". One will work, one will not, I forget which. [02:20] wallyworld: too late, off to hardly normal [02:36] wgrant: where is your openid fix [02:36] lifeless: In buildbot. [02:36] It was testfixed away last night. [02:36] thumper: sorry, was eating [02:36] So it is still a few hours away from qasbounce. [02:37] wgrant: kk [03:11] wgrant: so scripts/populate-archive.py -v --distribution=ubuntu --suite=natty -a i386 -a amd64 --to-user=lifeless --to-archive=bye-bye-asuka --reason='wgrant hates alive servers' <== on LPCONFIG=QAS on asuka? [03:11] spm: I see what you did there. [03:11] But yes, that should work. [03:11] sneaky aren't I [03:12] technically it's *you*, not I, as the command would have it. So I had to correct the 'person' sense. <== BIG ISSUES [03:12] Indeed. [03:12] spm: thanks [03:14] ho ho.FATAL: Ident authentication failed for user "lucille" <== fixin' [03:15] I think that is the sole remaining reference to lucille. [03:15] It is tempting to quickly remove that. [03:15] Death to lucille [03:15] Ah, no, the demon lives on in poppy's ident. [03:15] Sigh, it's moving. Kill it. [03:16] haha [03:17] StevenK: What should I call the new user? archivepublisher? [03:17] but yes. names that match functions, if only loosely, do help us. pls to fix. :-) [03:17] wgrant: sigh. lucilleball of course. for shame. [03:17] Needs more "l"s. [03:17] llllllllllll ? [03:17] loball [03:17] wgrant: I'm tempted to suggest 'lolwut' [03:17] lollball? [03:18] Just due to the queries that lucille currently runs [03:18] StevenK: mawson can handle the SPPH indices OK. [03:18] But not both it and BPPH, it seems. [03:19] Once hot, the source override queries are all sub-second... But the moment you run a binary override query, they exceed a minute. [03:19] Yay, mawson. [03:19] The BPPH indices suck? [03:19] proposition: the queries suck [03:19] They're all just a bit big. [03:19] the number of rows being considered is too high [03:20] SELECT SourcePackageName.name, Component.name, Section.name FROM SourcePackagePublishingHistory JOIN Component ON Component.id = SourcePackagePublishingHistory.component JOIN Section ON Section.id = SourcePackagePublishingHistory.section JOIN SourcePackageRelease ON SourcePackageRelease.id = SourcePackagePublishingHistory.sourcepackagerelease JOIN SourcePackageName ON SourcePackageName.id = SourcePackageRelease.sourcepackagename WHERE ... [03:20] or they are too widely spread out [03:20] ... SourcePackagePublishingHistory.archive = 1 AND SourcePackagePublishingHistory.distroseries = 103 AND SourcePackagePublishingHistory.pocket = 0 AND SourcePackagePublishingHistory.status = 2 ORDER BY SourcePackagePublishingHistory.id DESC LIMIT 10000 OFFSET 0; [03:20] Component and Section are small. SPN isn't bad. [03:20] moving to an actual model of suite would help. [03:20] A little, yes. [03:20] No, it wouldn't [03:20] It would make adding a new suite for Ubuntu a lot harder [03:21] by which you mean easier and more controlled [03:21] No, by which I mean creation of new tables and duplicated data\ [03:21] I unfortunately have to agree with lifeless here. [03:21] And I normally disagree with his Soyuz model arguments :P [03:22] wgrant: Who are you, and what have you done with the real wgrant? [03:23] I unfortunately have to agree with lifeless here. <== my world. It has ended. [03:23] Haha [03:24] I had 3 cornerstones. Death, Taxes and lifeless/wgrant not agreeing. This is now over. /me hols forearm theatrically and dramatically to forehead [03:25] * lifeless applies stablegun [03:25] *staple* [03:25] something that shoots stables would be awesome, scary, and worrying. [03:25] meh. I play a pally. I can still faceroll and out dps [03:26] Yet far more effective than a mere staplegun; [03:26] spm: I need to get that stuff off you [03:26] also fix my gems etc, I struggle to do 5k dps [03:26] [as ret] [03:26] DEPART, WoW SCUM! [03:26] Haha [03:27] wgrant: join us, be one of us. [03:27] lifeless: Pfft. My DK is currently doing 9k and I button mash [03:27] its a dk. [03:27] bastards. [03:27] wgrant: for the record - what are you doing that needed that DB access change? "add to pg_ident: lucille for qastaging access for wgrant doing soyuz builders <...>" ? [03:28] lifeless: Hell, I did 7k as *prot* in H SFK last night [03:28] spm: we're making a copy archive to test performance of some soyuz q's. [03:28] StevenK: prot dk ? again... [03:28] lifeless: Prot pally, dks tanking tree is 'blood' [03:28] lifeless: ta [03:29] StevenK: I roll between 5 and 9 in prot, depending on encounters. [03:29] Due to classes, we had no reliable CC for the entire instance [03:29] Although Holy Wrath is awesome again [03:32] lifeless: Back to work time things. wgrant has tagged my bugs qa-bad, and with the rollback. What will the qatagger do when the new branch hits stable? [03:32] * lifeless started work at 6am [03:32] whats this work time you speak of? [03:32] StevenK: Your thing is OK to deploy since the rollback./ [03:33] Just tag the bug qa-ok as normal once this thing is QA'd. [03:33] lifeless: Sorry, s/time/type/ [03:33] wgrant: And leave the rollback tag? [03:33] StevenK: the rollback comes from the commit, not the bug [03:33] StevenK: it will all Just Work [03:34] Leave bad-commit-39423423, though. [03:41] wgrant: Are you using mawson? [03:41] StevenK: No. [03:42] Pondering how best to create test accounts to QA my branch [03:42] Oh? [03:42] Ah, the merge one? [03:42] Yes [03:42] No need for test accounts. [03:42] Just find an account with recipes and subsume it. [03:42] nom nom nom [03:43] Don't I need to be logged in as that person? [03:43] You merge them into you. [03:43] It will send an email to the mergee with a logintoken. [03:43] You have DB access. [03:44] or [03:44] Or use adminpeoplemerge [03:44] use the staging mailbox to read the email [03:44] Or that. [03:44] But that's slow. [03:44] And non-TLs aren't meant to have access, IIRC. [03:50] $ bzr push [03:50] Using saved push location: lp:~wgrant/launchpad/the-death-of-lucille [03:50] bzr: ERROR: No such file: '/~wgrant/launchpad/the-death-of-lucille/.hg/requires' [03:50] Pardon? [03:51] \o/ [03:51] Ah, new bzr-hg this morning. [03:51] jelmer: ^ [03:57] lifeless: I don't know the archive ID, but "SELECT id FROM archive WHERE owner=2 AND name='bye-bye-asuka'" should tell you. [03:57] Also, damn, that's a nice UID. [03:57] wgrant: the boss wanted 1. [04:14] StevenK: https://code.launchpad.net/~wgrant/launchpad/the-death-of-lucille/+merge/48424 [04:16] wgrant: +1'd with a comment [04:24] wgrant: I have to say, I don't quite like the idea of merging random people into my account on DF [04:24] Be the big dog. [04:24] StevenK: :( [04:25] StevenK: Remove email addresses and OpenIDs from some other account, reassign your cookie or OpenID to that user, then merge people into that. [04:25] * StevenK blinks [04:26] Or is +adminpersonmerge effective here too? [04:26] I think it might be. [04:28] * StevenK tries to work out if a person is a team using only the DB [04:29] thumper: can you find that working example we discussed? i can see in firebug the post is happening but it's not getting to the back end code. [04:30] Ah, teamowner. Sneaky [04:32] wallyworld: Are you avoiding the natural disasters again this time? [04:32] huwshimi: yeah, i'm about 600km south of the action [04:32] haven't seen the news today yet so don't know how much bad shit has happened === stub1 is now known as stub [04:33] wallyworld: You avoided the floods too right? [04:33] yep - just :-) [04:33] bloody hot today though - and very humid :-( [04:34] This is why we don't live in Queensland :) [04:34] Also cyclones. [04:34] And floods. [04:34] But yeah. [04:35] Currently 35degC in my room [04:35] Feels muggy as hell, too [04:36] wgrant: So, feel like helping? A suitable candidate is merging 'liferea' into 'midori' [04:37] wgrant: There are other reasons too :P [04:37] StevenK: ~midori hath no recipes. [04:37] Oh. [04:37] It does on dogfood. [04:37] wgrant: https://code.dogfood.launchpad.net/~midori/+recipe/development ? [04:38] And identically named branches [04:38] doit [04:39] wgrant: So, I should mark liferea's 3 PPAs as DELETED? [04:40] StevenK: I'd say so. [04:40] lifeless: Any idea on QAing that last thing? [04:41] It's advanced subscriptions stuff. [04:41] But I'm not sure if it's in the UI. [04:41] wgrant: join the alpha team [04:41] I enabled it globally on DF. [04:41] Still couldn't see the UI anywhere. [04:41] ok [04:41] uhm [04:41] sec [04:41] Maybe I should grep around. [04:43] Ah, the new UI is there if you bypass AJAX. [04:43] spm: so that merge is in the pqm queue in slot 4 [04:43] spm: but the merge to db-devel is in slot 0 [04:44] spm: its liable that staging will blow up as a result. [04:44] wgrant: Done, what next? :-) [04:53] StevenK: Did the merge work? [04:53] wgrant: I'm still trying to work out *how* to do the merge [04:53] lifeless: Could you mentor https://code.launchpad.net/~wgrant/launchpad/the-death-of-lucille/+merge/48424? [04:53] StevenK: /people/+adminteammerge [04:54] wgrant: Can you show me how to reproduce bug #392079? [04:54] <_mup_> Bug #392079: "Recent revisions" header on branch page jumps around due to "clear: both" < https://launchpad.net/bugs/392079 > [04:55] lifeless: no worries. staging blowing up is nothing abnormal :-) [04:56] Oh damn it [04:56] I am a muppet [04:56] huwshimi: I think that's fixed. [04:56] there's now just a clear: left; [04:57] Can I unmerge a team? :-) [04:57] wgrant: Want to close that bug then? [04:57] huwshimi: Doing so. [04:57] StevenK: Hah. What did you do? [04:57] wgrant: Thanks mate :) [04:57] wgrant: Forgot to merge in my branch *first* [04:57] Heh. [04:58] So, bugger [05:00] lifeless: that's why I branched from and proposed to db-devel :) [05:00] great minds [05:02] Grrr [05:02] nightly.sh still sucks. [05:02] And it doesn't log :( [05:08] Now lets see if this is just good timing, or if this position cuts out the wireless interference from next door. [05:09] 0.5% packet loss down from 25-50% [05:10] nice [05:22] Hard / Soft Page ID [05:22] 862 / 8918 Archive:+index [05:22] spm: did that copy archive creation complete? [05:22] Yes. [05:22] yup [05:23] how hard would it be to add an expander to the subscriber portlets [05:23] just the 'subscribers' and 'also notified' buts [05:24] wgrant: How do you want nightly.sh improved? We should certainly twiddle all the jobs to use --log-file=DEBUG:/srv/wherever/foo.log and only emit errors. [05:25] stub: it sucks because it doesn't finish within 24 hours, and you can't tell what's going on unless you're subscribed to launchpad-error-reports. [05:25] Which I am, as of about a minute ago. [05:25] launchpad-error-reports only sees logs at the end, so that sucks too. [05:26] But it at least confirms that update-pkgcache is still running when the next thing starts. [05:27] So it needs to echo "Running foo `date`" >> /srv/whatever/nightly.log so we can see wtf it is running, and --log-file added to the command line so we get detailed logs of what is running, syncing the new logs regularly, and commenting out crap running far too long (bugs opened, separate cronjob installed) [05:27] Ah, there's the full log. [05:27] Yup. [05:27] Curtis removed a couple of things during the thunderdome. [05:28] Another UI branch to be reviewed when someone has the chance: https://code.launchpad.net/~huwshimi/launchpad/remove-icon-alt-528367/+merge/48430 [05:29] spm: Could you confirm when scriptactivity says update-pkgcache.py last finished? It seems to call itself update-cache. [05:30] wgrant: loganberry:update-cache with all the other nightly.sh's [05:30] would someone kindly review https://code.edge.launchpad.net/~mbp/launchpad/701545-oauth/+merge/48431 [05:30] it should be very easy [05:31] spm: When did it finish? It's the one time that isn't logged by nightly.sh. [05:31] I want to know how far over we are running. [05:32] ahh. you should be able to infer that from when the email was actually sent [05:32] but one sec [05:32] Fair point. [05:32] Oh wow. [05:33] 7 hours. [05:33] but a fix as to "I'm finished date/time" would be nice. [05:33] Er, no, that's wrong. [05:33] The time on the email seems to be the time the cron job started :( [05:34] And pipermail won't give me the headers. [05:34] * wgrant finds the mbox. [05:34] wgrant: so its archive 20929 [05:34] You don't have permission to access /mailman/private/launchpad-error-reports/Week-of-Mon-20110131.mbox on this server. [05:34] wgrant: what are the enums we expect ? [05:34] lifeless: The first status is 0, the second 6. [05:34] wgrant: https://pastebin.canonical.com/42777/ 15 hours [05:35] spm: ... ouch. [05:35] thanks. [05:35] wgrant: what creates the buildfarmjobs ? [05:35] * spm won't mention the name of "nightly".sh ;-) [05:36] lifeless: populate-archive.py should. [05:36] launchpad_qastaging=> select count(*) from packagebuild where archive=20929; [05:36] count [05:36] ------- [05:36] 0 [05:36] (1 row) [05:36] Uh. [05:36] Could you enable the archive? [05:36] I can't see it unless it's enabled. [05:36] url [05:37] https://qastaging.launchpad.net/ubuntu/+archive/bye-bye-asuka/+edit [05:37] Oh. [05:37] timeout [05:37] Goddammit. [05:37] OOPS-1860QS14 [05:37] gottendamerung? [05:37] I bet qastaging is old enough that it doesn't have any natty chroots. [05:38] Hm, no, it does. [05:38] upports_virtualized [05:38] False [05:38] Fail. [05:38] We have a half-initialised natty on qas. [05:39] spm: Could you rerun populate-archive.py with a new archive name, and maverick instead of natty? [05:39] sure [05:40] hereeeeees-asuka, underway [05:40] with apologies to Here's Johnny. [05:47] * huwshimi is away [05:49] * henninge is here [05:50] Hi! [05:50] Anybody feel like doing a review for me? ;-) [05:51] Hmm. [05:51] I wonder if I can just delete all DistributionSourcePackageCache and DistroSeriesPackageCaches for PPAs and copy archives. [05:51] Nothing uses them except the package count calculation. [05:51] Which is easily implementable in other ways. [05:53] And avoids a million inserts a night. [06:00] henninge, i'll happily look [06:00] poolie: thanks, it's https://code.edge.launchpad.net/~henninge/launchpad/devel-710591-sharing-info-groundwork-0/+merge/48416 [06:02] i infer you're using Idea - is it good? [06:04] to me it looks clear and well explained and not obviously wrong [06:04] of course i'm not familiar with that code === stub1 is now known as stub [06:08] poolie: You lie. [06:08] poolie: You proposed the branch to the wrong place. [06:09] lp:~mbp/bzr/trunk [06:09] :/ [06:09] that'd be it [06:09] Scared me for a minute, since I thought I'd fixed that bug two weeks ago. [06:09] Indeed I had. [06:09] i did check for that but must have glazed over the url [06:09] Heh [06:10] in https://bugs.launchpad.net/launchpad/+bug/707808 [06:10] <_mup_> Bug #707808: Unmerged revisions list does not exclude merged revisions < https://launchpad.net/bugs/707808 > [06:12] stub: You suggest that the script should log stuff directly to a file, but is there a reason to do that over just redirecting its output in crontab? [06:12] That's what all the rest do. [06:15] spm: Is qasbounce automatically updating now? [06:16] i just tried make check in a branch off lp trunk and got [06:16] wgrant: should be [06:16] a failure in testPPAPublisherOverrides ... connection_raw_execute ... not enough arguments for format string [06:17] spm: Yay, thanks. [06:17] wgrant: qastaging-logs/qastaging-update.log <== should be on carob for qaasbounce [06:17] poolie: That should have been fixed in r12305 [06:17] poolie: Broke in r12302 [06:18] spm: So it is. [06:19] thanks [06:31] wgrant: losa long term goal, previously agreed strategy etc [06:32] lifeless: ECONTEXT [06:32] wgrant: output logging / redirect for scripts [06:33] Ah, right. [06:33]