[01:54] <LPCIBot> Yippie, build fixed!
[01:54] <LPCIBot> Project db-devel build (331): FIXED in 6 hr 22 min: https://hudson.wedontsleep.org/job/db-devel/331/
[01:54] <LPCIBot> Launchpad Patch Queue Manager: [rs=buildbot-poller] automatic merge from stable. Revisions: 12284
[01:54] <LPCIBot> included.
[02:02] <lifeless> [02:02] <lifeless>     Hard / Soft  Page ID
[02:02] <lifeless>      182 /  299  BugTask:+index
[02:02] <lifeless>       13 /   12  Archive:+copy-packages
[02:02] <lifeless>       12 /    3  Cve:+index
[02:02] <lifeless>       10 /   11  Branch:+index
[02:02] <lifeless>        8 /    0  BinaryPackageBuild:+retry
[02:02] <lifeless>        7 /   27  DistroSeriesLanguage:+index
[02:02] <lifeless>        7 /    8  Person:+uploaded-packages
[02:14] <StevenK> Why is the top 10 only 7?
[02:17] <wgrant> Indeed, 2-4 are omitted.
[02:17] <wgrant> Bad lifeless.
[02:34] <lifeless> that would be freenode fail
[02:34] <lifeless> their new software throttles far too aggressively
[19:24] <thumper> Monday morning, and all quiet
[19:25] <lifeless> heh
[19:25] <lifeless> can fix that
[19:26] <lifeless> thumper: btw maxb reopened your stuck builds fix
[19:26] <thumper> yeah
[19:26] <thumper> saw that
[19:35] <lifeless> hmm
[19:35] <lifeless> in linking series to branch
[19:36] <lifeless> would it make sense to offer a likely list? e.g. code imports + branches called 'trunk', 'MAIN', 'HEAD' etc
[19:43] <thumper> lifeless: file a bug :)
[19:44] <lifeless> ok
[19:56] <thumper> are the windmill tests disabled?
[19:56] <lifeless> I'm not sure
[20:18] <jelmer> g'morning nz
[20:57] <lifeless> woo
[20:57] <lifeless> no new bugs
[20:57] <lifeless> no confirmed bugs
[20:58] <thumper> hi jelmer
[21:01] <wallyworld> morning
[21:02] <thumper> wallyworld: morning
[21:02] <thumper> wallyworld: thanks for taking the CHR slot
[21:02] <wallyworld> thumper: np
[21:06] <lifeless> and woo every undecided importance bug is incomplete.
[21:08] <mwhudson> ah, this is why i have so much email, perhaps
[21:08] <mwhudson> not that i get launchpad bug mail any more
[21:11] <lifeless> james_w: bug 645640
[21:12] <james_w> yes?
[21:12] <lifeless> james_w: you commented that its blocked, but not by what
[21:13] <lifeless> ah bah
[21:13] <lifeless> wrong bug
[21:13] <lifeless> hang a sec while I try to find the right one again
[21:13] <james_w> well, why is that one incomplete?
[21:14] <lifeless> it was incomplete pending a reply, which you have given
[21:15] <lifeless> james_w: though I do have another question for you on that bug :)
[21:18] <lifeless> james_w: bug 395200
[21:46] <lifeless> poolie: call?
[22:18] <wgrant> Anyone up for reviewing https://code.launchpad.net/~wgrant/launchpad/bug-710360-gina-wheezy/+merge/47942?
[22:19] <lifeless> wgrant: ugh
[22:19] <wgrant> Yes.
[22:19] <lifeless> wgrant: are you a reviewer yet?
[22:19] <wgrant> No.
[22:22] <wgrant> I need a mentor.
[22:24] <lifeless> ok, I'll mentor you
[22:27] <wgrant> lifeless: Sure?
[22:28] <lifeless> yes, I think I can handle it
[22:30] <wgrant> Thanks!
[22:33] <wallyworld> thumper: you free yet?
[22:33] <thumper> wallyworld: yep
[22:33] <thumper> sorry
[22:34] <thumper> mumble?
[22:34] <wallyworld> ok
[22:34] <lifeless> wgrant: can you let bac know, get yourself on the roster etc etc
[22:38] <thumper> StevenK: ping
[22:38] <thumper> StevenK: mumble ping
[22:38] <StevenK> thumper: Hai
[22:40] <StevenK> thumper: I can
[22:41] <StevenK> thumper: You think?
[22:46] <StevenK> thumper: I need a bit more time to clean up some SQL
[22:46] <StevenK> thumper: Yes
[22:46] <StevenK> Same thing
[22:46] <StevenK> It's all IPerson.merge
[22:47] <wgrant> Speaking of which, can I object to the delete-recipes-on-merge thing? :)
[22:47] <StevenK> wgrant: thumper just did
[22:48] <wgrant> Yay!
[22:49] <StevenK> thumper: So, I don't think the queue-recipes will take very long
[22:49] <StevenK> thumper: Then I'll rip team-merge apart
[22:49] <StevenK> thumper: branch merging is all done with SQL
[22:50] <StevenK> thumper: def _mergeBranches(
[22:55] <thumper> wallyworld: https://launchpad.net/oops-tools
[23:00] <thumper> wallyworld: http://pastebin.ubuntu.com/560402/
[23:02] <thumper> lifeless, mwhudson: didn't someone organise to have the doctests rendered as ReST and available somewhere on a site?
[23:03] <mwhudson> thumper: BjornT_ was working on that
[23:03] <lifeless> thumper: benji presented a plan
[23:03] <mwhudson> thumper: ages ago though
[23:03] <lifeless> thumper: in july
[23:03] <thumper> so not yet then...
[23:03] <lifeless> not yet
[23:04] <mwhudson> searching my mail archive turns up http://people.canonical.com/~bjorn/lp-architecture/
[23:05] <mwhudson> but i don't know if that ever got past proof-of-concept
[23:05] <lifeless> it was a redo
[23:05] <lifeless> new docs
[23:05] <lifeless> new subtree
[23:05] <lifeless> existing stuff untouched
[23:05] <mwhudson> ah right
[23:05] <lifeless> I decided it wasn't worth pursuing in that form
[23:08] <lifeless> wow RootObject:+daily-builds is sick
[23:08] <thumper> lifeless: how sick?
[23:08] <lifeless> https://devpad.canonical.com/~lpqateam/ppr/lpnet/latest-daily-timeout-candidates.html
[23:09] <lifeless> never renders in < 9 seconds
[23:09] <thumper> heh
[23:10] <thumper> 273 queries won't help
[23:10] <thumper> should aim for < 20
[23:10] <lifeless> yup
[23:12] <lifeless> I was looking for pages whose 99% completing fell between 14 and 15 seconds
[23:12] <lifeless> to see the impact of dropping the timeout by a second
[23:12] <lifeless> only two
[23:13] <lifeless> that, and PillarNameSet:EntryResource:search
[23:13] <lifeless> both < 50 hits a day
[23:13] <thumper> lifeless: probably a day or so to fix that one
[23:17] <thumper> StevenK: the morning standups just aren't the same if you can't talk
[23:17] <thumper> StevenK: plz fix :)
[23:18] <StevenK> Here I was thinking you'd say they're better if I can't talk
[23:26] <wgrant> lifeless: You know that armel PPAs are coming RSN, right?
[23:27] <mwhudson> fsov rsn
[23:27] <wgrant> I believe that's included in the definition of RSN.
[23:27] <jelmer> wgrant: I thought we already had armel PPAs?
[23:28] <mwhudson> jelmer: well sort of, but they're not virtualized
[23:28] <wgrant> jelmer: We have restricted fake virtualized builders.
[23:28] <wgrant> That are not virtualized.
[23:28] <jelmer> right, so we have armel PPAs :-)
[23:44] <StevenK> lifeless: Does http://pastebin.ubuntu.com/560425/ look sane to you? I don't think Storm is bracketting the two date_created conditions correctly
[23:46] <lifeless> StevenK: why do you have the two comparisons with date created ?
[23:47] <StevenK> lifeless: Because if there is a build that's been created within the last 24 hours, we don't want to schedule another
[23:47] <lifeless> that only requires a <
[23:48] <lifeless> not < is equivalent to >=
[23:49] <StevenK> Er, won't that return builds that have been scheduled in the last 24 hours?
[23:49] <lifeless> StevenK: I think your math is broken :)
[23:50] <lifeless> StevenK: date created is a point in time; we are interested when the build was scheduled before now-23h50m
[23:50] <lifeless> StevenK: if we had an interval, we would query on interval > 23h50
[23:51] <lifeless> StevenK: if we have a position, we query on things before that position
[23:52] <StevenK> lifeless: Keep in mind a recipe can have more than BuildFarmJob
[23:52] <StevenK> More than one
[23:52] <lifeless> ah yes
[23:52] <lifeless> I really dislike this data model
[23:53] <StevenK> So I'd like to make sure if there is one BFJ, it was created more than one day ago, and if there are more than one, that they all were created more than one day ago
[23:54] <StevenK> lifeless: Patches welcome
[23:54] <StevenK> lifeless: But keep in mind that BFJs are used by more than just recipes
[23:55] <lifeless> sure
[23:55] <lifeless> the basic problem is that you want to work on stuff that is 'current' but the schema is an archival schema
[23:56] <lifeless> better to hav a current schema and an archive schema, if you want archiving.
[23:58] <wgrant> lifeless: What does current mean?
[23:58] <lifeless> wgrant: live, active
[23:58] <wgrant> In this case we are looking for records that might have built a day ago.
[23:58] <wgrant> Are they archived?
[23:59] <lifeless> wgrant: in a different model you wouldn't be looking for anything in the archive schema
[23:59] <lifeless> wgrant: so that question is noddy
[23:59] <wgrant> Oh?
[23:59] <wgrant> How would you model it?
[23:59] <lifeless> StevenK: so, we want SPR with either (no builds) or (no builds in the last 24 hours) right ?