[01:44] <wgrant> Hmmm.
[01:44] <wgrant> I think someone needs to make dpkg -b stab people unless I_SWEAR_THAT_I_AM_DEBUILD=1 is set.
[01:53] <lifeless> hmm
[01:53] <lifeless> need to make incomplete-* actual statuses.
[02:04] <wgrant> :( 105 timeouts.
[02:04] <wgrant> So close.
[02:04] <wgrant>        36 /   18  Distribution:+bugtarget-portlet-tags-content
[02:04] <wgrant> :/
[02:04] <lifeless> thats pretty good
[02:04] <wgrant> Hmmmm
[02:04] <wgrant> 20 of the timeouts are from edge.
[02:05] <lifeless> yup
[02:05] <lifeless> gotta get that redirect in
[02:06] <wgrant> aaaa, it executes the query twice
[02:06] <wgrant> *That's* not meant to happen.
[02:06] <wgrant> Oh god.
[02:07] <wgrant> It's not checking tags_cloud_data's emptiness in TAL, is it...
[02:07] <wgrant> Yes, yes it is.
[02:07]  * wgrant blargs.
[02:09] <lifeless> wgrant: double query? I did mention that :>
[02:19] <wgrant> lifeless: So, grant an exception to Distribution:EntryResource:searchTasks and drop to 9s on Monday? :D
[02:19] <wgrant> Hmm.
[02:19] <wgrant> Not all the soft timeouts are listed.
[02:20] <wgrant> There's 65 that aren't on the list... I guess it doesn't show if there aren't any hard timeouts :(
[02:25] <wgrant> lifeless: https://code.launchpad.net/~wgrant/launchpad/bug-736002-seriously-this-time/+merge/58016
[02:26] <lifeless> wgrant: are you sure it works?
[02:26] <wgrant> Yes.
[02:26] <lifeless> why does it work?
[02:27] <wgrant> Because it's a dict, not a resultset. So the define evaluates it, and now we have a non-lazy object.
[02:27] <wgrant> And I have a postgres log.
[02:27] <wgrant> Thanks.
[02:27] <lifeless> ah, it wasn't a cached property?
[02:28] <wgrant> No. Could do that, I guess, but it's so easy to avoid..
[02:29] <lifeless> possibly useful belt and bracer
[02:29] <lifeless> given that there is no test
[02:29] <wgrant> It's hard to give a useful test, since it's dominated by variable numbers of other queries :/
[02:29] <lifeless> \i/
[02:36] <wgrant> :(
[02:36] <wgrant> chaenomeles still has no 'logs' rsync module :(
[02:37] <lifeless> tell losa on monday
[02:38] <wgrant> Oh hm.
[02:38] <wgrant> These OOPS counts are wrong :/
[02:38] <wgrant> oops-tools doesn't know about the new wampee prefixes, nor chaenomeles at all.
[02:38] <lifeless> heh
[02:39] <lifeless> bug xyz about that.
[02:39] <wgrant> That explains why they're mostly edge.
[02:40] <wgrant> lifeless: I should file a bug on oops-tools about that?
[02:41] <lifeless> there are bugs for auto adjusting already
[02:42] <lifeless> there is a wiki page explaining how to update things laready
[02:42] <lifeless> uhm
[02:42] <lifeless> if its hard to find or whatever then yes, a bug.
[02:44] <wgrant> I gather it has to be done through the web UI now.
[02:44] <wgrant> By an unknown set of privileged people.
[02:46] <wgrant> Ah, there we go.
[02:46] <wgrant> New prefixes added.
[02:46] <wgrant> You can import them from lp-p-c without auth.
[02:46] <lifeless> nicely done
[02:46] <lifeless> if only it was in cron
[02:51] <wgrant> .....
[02:52] <wgrant> IE10 will not run on Vista.
[02:52] <wgrant> Grar.
[02:57] <wgrant> lifeless: Do you know how to rescan the last couple of days' OOPSes?
[02:58] <lifeless> AIUI each scan scans all oops prefixes known
[02:58] <lifeless> runs every 7 minutes
[02:58] <lifeless> so may have a bit of a backlog, but should catch up pretty soon
[02:58] <wgrant> Ah, true.
[03:43] <StevenK> As expected p-s-c has done nothing over the weekend.
[03:44] <lifeless> StevenK: on any of the 4 services?
[03:44] <StevenK> lifeless: Er, it runs on loganberry only?
[03:44] <lifeless> + staging
[03:44] <lifeless> + qastaging
[03:44] <lifeless> + dogfood
[03:45] <StevenK> dogfood doesn't run it, and we need to re-import the database onto mawson in 1.5 weeks anyway
[03:45] <lifeless> :)
[03:45] <StevenK> staging won't need to after this weekends re-import
[03:46] <StevenK> And qastaging, "meh" ?
[03:46] <StevenK> lifeless: And also, it doesn't hurt anything if it stops running early -- it isn't like your index change, where stuff completly breaks if it's NULL
[03:47] <lifeless> you sure about that ?
[03:48] <StevenK> The only thing that uses SPR.changelog is DSD base version calculation -- if it can't find the ancestry, it will return early, not OOPS.
[03:57] <wgrant> lifeless: He's right.
[03:58] <wgrant> It's not like BugMessage:+index.
[03:58] <wgrant> Er.
[03:58] <wgrant> BugMessage.index
[03:58]  * lifeless shrugs
[03:58] <StevenK> lifeless: I can see I've not convinced you, so meh
[03:59] <lifeless> I would be most comfortable with a situation where we don't have partial migrations done
[04:00] <lifeless> but its your call; you are doing the work.
[04:01] <StevenK> As you would have seen on the list, I'm somewhat around this week, so I'm just going to not care until Friday
[04:02] <StevenK> lifeless: I also seriously question having to perform this (very expensive) migration on four seperate instances
[04:21] <lifeless> wow
[04:21] <lifeless> my net is so farked
[08:13] <LPCIBot> Project windmill build #184: STILL FAILING in 1 hr 0 min: https://lpci.wedontsleep.org/job/windmill/184/
[08:29] <LPCIBot> Project devel build #645: FAILURE in 5 hr 33 min: https://lpci.wedontsleep.org/job/devel/645/
[08:34] <StevenK> Sigh. That test needs a rewrite to not be racy.
[20:15] <LPCIBot> Yippie, build fixed!
[20:15] <LPCIBot> Project devel build #646: FIXED in 5 hr 34 min: https://lpci.wedontsleep.org/job/devel/646/
[20:28] <LPCIBot> Project windmill build #185: STILL FAILING in 1 hr 0 min: https://lpci.wedontsleep.org/job/windmill/185/
[20:50] <lifeless> morning
[21:49] <jelmer> Has something changed in the ~vcs-imports owner recently?
[21:49] <jelmer> I now get a rejection email from launchpad-bugs@ every time I change a vcs import
[21:50] <lifeless> I think we'll nuke that team (-bugs)
[23:14] <poolie> hi all
[23:56] <lifeless> thumper: hey
[23:56] <thumper> lifeless: hi
[23:56] <lifeless> thumper: how does enum sorting work with queries
[23:56] <thumper> what do you mean?
[23:57] <lifeless> thumper: I'm looking at making INCOMPLETE_WITH_RESPONSE and INCOMPLETE_WITHOUT_RESPONSE real status values in the db
[23:57] <lifeless> bug 759467
[23:57] <_mup_> Bug #759467: incomplete-with-response searches require complex searches <Launchpad itself:Triaged> < https://launchpad.net/bugs/759467 >
[23:57] <lifeless> see lib/lp/bugs/interfaces/bugtask.py and BugTaskStatus/BugTaskStatusSearch
[23:57] <thumper> ok...
[23:58] <lifeless> so from my brief checks we just issue order by status
[23:58] <lifeless> where status is the enum column
[23:58] <lifeless> an int in the schema
[23:58] <lifeless> and we have no special handling
[23:58] <lifeless> *but*
[23:58] <lifeless> BugTaskStatusSearch
[23:58] <lifeless> has a sort_order attribute
[23:58] <lifeless> and I'm lke 'wtf'