[08:26] <lifeless> ahahha
[08:27] <lifeless> wgrant: I found 250-odd lines of bugheat you missed :)
[08:27]  * lifeless claims the LoC win
[08:30] <lifeless> oh, and a table too. WIN.
[08:31] <nigelb> lol
[08:31]  * lifeless strokes his precioouuuus
[08:31] <nigelb> uhh, wha?
[08:31] <lifeless> nigelb: spare LoC to write new stuff in
[08:32] <lifeless> is a precious resource (though really quite easy to make)
[08:32] <nigelb> heh
[08:32] <lifeless> speaking of which
[08:32] <lifeless> you still keen to do that js oops glue ?
[08:33] <nigelb> yep
[08:33] <nigelb> my ubuntu laptop is temporarily out of action
[08:33] <nigelb> the adapter caught fire spontaneously
[08:33] <nigelb> I've been frustratingly trying to work on a macbook.
[08:33] <lifeless> meep
[08:33] <lifeless> Install Ubuntu ? :)
[08:34] <nigelb> Nah, getting a new adapter on Monday :)
[08:34] <nigelb> all my open source coding was on the Ubuntu machine. Every single project is on hold :(
[08:41] <lifeless> bug https://bugs.launchpad.net/launchpad/+bug/946164 FWIW
[08:41] <_mup_> Bug #946164: bugjob is orphaned code <tech-debt> <Launchpad itself:Triaged> < https://launchpad.net/bugs/946164 >
[09:07] <wgrant> lifeless: In my defense, I thought that was dropped 18 months ago.
[09:13] <lifeless> wgrant: no opprobobium attached
[09:14] <lifeless> wgrant: it just shows how sticky fat is
[09:23] <lifeless> wgrant: are there docs on the deletion dance /
[09:23] <wgrant> lifeless: No, it's more fun this way.
[09:25] <lifeless> ok
[09:25] <lifeless> so you get to talk me through it :)
[09:27] <wgrant> ALTER TABLE bugjob SET SCHEMA todrop;
[09:27] <wgrant> EOF
[09:27] <lifeless> FK's ?
[09:28] <wgrant> They only matter when they're to another table that you're dropping, or to branch, or to person and involved in a unique constraint or otherwise have special person merging code.
[09:28] <wgrant> None of those seem to apply here.
[09:29] <lifeless> so the drop happens during the downtime ?
[09:31] <lifeless> wgrant: ^
[09:32] <wgrant> lifeless: Yes
[09:33] <wgrant> upgrade.py drops anything that's in todrop at the end.
[09:33] <wgrant> It could be done after the downtime if we removed foreign keys first.
[09:33] <lifeless> wgrant: could you add someting to the DB schema patches policy page or something, noting this ?
[09:39] <wgrant> I've expanded the dropping bits of https://dev.launchpad.net/PolicyAndProcess/DatabaseSchemaChangesProcess
[09:40] <wgrant> lifeless: ^^
[09:40] <lifeless> thanks
[09:51] <lifeless> anyone know what we keep ./database/schema/archive for ?
[10:01] <lifeless> ww
[10:01] <lifeless> wow
[10:01] <lifeless> arora is a terrible browser
[10:12] <nigelb> lifeless: Aurora? Why? :(
[10:13] <lifeless> no, arora
[10:13] <nigelb> ah webkit
[10:13] <lifeless> apt-cache show arora
[10:15] <lifeless> grah
[10:15] <lifeless> whats the fix for
[10:15] <lifeless>     key = self._config_stack.get('gpg_signing_key')
[10:15] <lifeless> AttributeError: 'BranchConfig' object has no attribute 'get'
[10:16] <lifeless> wgrant: can you ec2 land https://code.launchpad.net/~lifeless/launchpad/bugjob/+merge/95773 ? my landing story is still naffed ..
[10:16] <wgrant> Hmmm, now I wonder if we have someone on the team who was a bzr developer for years ;)
[10:16] <lifeless> and who is going to bed :P
[10:16] <lifeless> [and yes, you do - Aaron :)]
[10:17] <wgrant> Curses.
[10:17] <lifeless> if it wasn't 23:17 I would probably dig, I'm sure Aaron has fixed this upstream, but it is 23:18 and ESLEEPNEEDED
[10:17] <wgrant> Give my gettys back, you damn LXC
[10:17] <lifeless> nn
[10:17] <wgrant> Night.
[10:18] <nigelb> heh
[21:45] <lifeless> StevenK: is MVE meant to be solved at this point ?
[23:53] <wgrant> I need an SSD.
[23:53] <wgrant> lifeless: No complaints about your Intel one?
[23:55] <StevenK> wgrant: Right, clearly I'm missing something, since making your changes in the garbo job the error is "duplicate key value violates unique constraint "accesspolicy_pkey""
[23:56] <wgrant> StevenK: Check the query log.