[00:16] <StevenK> wgrant: http://pastebin.ubuntu.com/972558/
[00:16] <wgrant> What's the generated SQL?
[00:17] <wgrant> Need to ensure that there's no ORDER BY etc.
[00:17] <StevenK> 0-21@SQL-main-master UPDATE Branch SET information_type=CASE WHEN transitively_private THEN 4 ELSE 1 END WHERE Branch.id IN (77)
[00:17] <wgrant> Huh, interesting that it evaluates that early.
[00:18] <wgrant> I would have expected it to use a subselect.
[00:18] <wgrant> Still, okay either way
[00:18] <StevenK> Just checking what happens with bigger chunks
[00:20] <StevenK> 0-4@SQL-main-master UPDATE Branch SET information_type=CASE WHEN transitively_private THEN 4 ELSE 1 END WHERE Branch.id IN (7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 75, 76)
[00:20] <wgrant> Mm, might as well turn it into an explicit subselect.
[00:21] <wgrant> Oh, but it's wrapped in a method, isn't it.
[00:21] <wgrant> So you'd have to duplicate.
[00:21] <wgrant> Not worth it, just go with this way
[00:21] <StevenK> wgrant: Yup, let me commit, push and pqm-submit
[02:32] <wgrant> StevenK: How goes QA?
[03:07] <StevenK> wgrant: Trying to get access to the staging mailbox
[03:08] <wgrant> StevenK: Don't you only need inbound mail?
[03:09] <StevenK> wgrant: I thought new@bugs ... would reply back?
[03:09] <wgrant> StevenK: Sure, but why do you care about that?
[03:09] <wgrant> You didn't change the response AFAIK
[03:09] <StevenK> wgrant: Because I want to see if ' informationtype proprietary' dies horribly.
[03:10] <wgrant> Ah
[03:11] <StevenK> wgrant: Or you can rummage inside the staging mailbox and see if the malonehandler yelled at me.
[03:11] <wgrant> I'm currently wondering if stub will hate me for adding more indices to bugtaskflat :)
[03:12] <wgrant> Well
[03:12] <wgrant> I think Thunderbird hung before it even hit the network to retrieve the mailbox
[03:12] <wgrant> How nice of it
[03:12] <StevenK> Haha
[03:29] <StevenK> wgrant: Thunderbird still hates you?
[03:29] <wgrant> It's still restarting.
[03:29] <wgrant> I think I might need to vacuum some SQLite.
[03:29] <wgrant> Let me delete indices and see what happens./
[03:30] <lifeless> wgrant: got time for a brief call ?
[03:31] <wgrant> lifeless: Sure
[03:32] <lifeless> hows your skype install these days ?
[03:32] <wgrant> Calling...
[03:33] <jtv> I wonder who knows about PQM these days?  It won't let me land branches.
[03:34] <wgrant> jtv: What's it saying?
[03:34] <jtv> 'Failed to verify signature: gpgv exited with error code 2'
[03:35] <wgrant> Sure you're using the right key and email address?
[03:36] <jtv> I don't see any sign that I'm not.
[03:37] <jtv> I registered a key for it, which is the same key that I get prompted for to sign my revisions, and for the same email address that the email is addressed to and that bzr is set up to use.
[03:38] <StevenK> jtv: Do you know which key PQM is using, since PQM is entirely seperate.
[03:38] <jtv> It's not basing it on the email address I'm using?
[03:38] <wgrant> jtv: It has a keyring.
[03:39] <jtv> So I need to have this key registered somewhere besides Launchpad?
[03:40] <StevenK> jtv: Yup. If it's a new key, you need to file an RT to get the webops to add it to PQM's keyring.
[03:40] <wgrant> jtv: Yes. PQM doesn't know about Launchpad.
[03:40] <jtv> Arrrh.  Thanks.
[03:43] <jtv> (It used to let me land branches with this key, although ec2 wouldn't)
[03:44] <StevenK> jtv: I have one key, it saves thinking about it.
[03:44] <StevenK> wgrant: Thunderbird still hates the world?
[03:45] <jtv> So did I — but then the trouble started.  First ec2 stopped accepting it, and now apparently pqm as well.
[03:45] <jtv> Sorry, actually it was more complicated than that.
[03:45] <jtv> One key is not necessarily simpler.
[03:47] <StevenK> jtv: I just transistioned from a 1024 DSA key to a 4096 RSA key, and I know that ec2 and pqm-submit/lp-land use completly different codepaths to get the signing key.
[03:48] <jtv> Yeah, what happened is that one of the earlier changes forced me to add a new key, and then ec2 had trouble with that.  But now that trouble seems to have extended to pqm.
[03:49] <StevenK> jtv: How do you get forced to generate a new key?
[03:50] <jtv> My old one was no longer accepted.
[03:57] <wgrant> Howso?
[04:02] <spm> jtv: that error message is also what you'll get if your email address order in the 'right' key changes.
[04:02] <spm> but seeing as that requires one of us to change your key on pqm, probably not that.
[04:04] <jtv> spm: sorry, I don't follow… if my email address order in the "right" key changes?  What does that mean?
[04:06] <spm> jtv: eg mine: http://keyserver.ubuntu.com:11371/pks/lookup?search=0x19273D1D1CC65F5BBC798AA93D8EAB2DEBE3BC06&op=index <== if I changed the primary contact email in that, pqm will not recognise it as valid.
[04:07] <jtv> Ah.  No, that can't have happened here.
[04:07] <spm> the flip side, is if the address you send as changes; it has a similar effect too
[04:34] <lifeless> jtv: did the key expored ?
[04:34] <lifeless> expire
[04:35] <jtv> No.  It was a while ago but if I recall correctly, the problem was that it wasn't attached to my canonical address.
[04:35] <StevenK> You can edit the key and 'adduid'
[04:35] <wgrant> StevenK: Error message:
[04:35] <wgrant> Proprietary bugs are forbidden to be filed via the mail interface.
[04:35] <StevenK> wgrant: Win!
[04:36] <StevenK> wgrant: There should be another message in there
[04:36] <wgrant> What should it look like?
[04:36] <wgrant> There's about 20000 other messages in there.
[04:36] <wgrant> And that's after I deleted 100000
[04:37] <StevenK> wgrant: It was exactly the same as the Proprietary mail, but set it to Unembargoed Security.
[04:38] <wgrant> StevenK: That's a bugnotification.
[04:38] <cjwatson> jtv: It's allowed to have a PQM key whose primary UID isn't your Canonical address, but you do need to get ops to set your primary UID as permitted.
[04:38] <StevenK> wgrant: What's the bug number?
[04:38] <wgrant> StevenK: We don't send bug notifications automatically.
[04:38] <StevenK> Ahh.
[04:39] <cjwatson> (I deduce that it's allowed because my key is that way.)
[04:39] <wgrant> So I'd look for it in the web UI
[04:39] <jtv> cjwatson: I think ec2 forced me to use my canonical address.
[04:39] <wgrant> It doesn't.
[04:39] <StevenK> wgrant: Yeah, I'm doing so.
[04:39] <wgrant> My primary isn't canonical.com
[04:39] <cjwatson> DOesn't for me.
[04:39] <StevenK> Depends on the mail setup.
[04:39] <wgrant> My canonical.com address isn't primary for anything anywhere.
[04:39] <wgrant> And it works for me :)
[04:40] <jtv> wgrant, cjwatson: I didn't say "as primary"
[04:40] <cjwatson> It's trivial to add a Canonical UID to an existing key.
[04:40] <StevenK> wgrant: qa-ok, finally.
[04:40] <wgrant> StevenK: Great.
[04:40] <StevenK> wgrant: Thanks for the assist.
[04:41] <jtv> cjwatson: maybe it is, but for other reasons I did not want to do that.
[04:55] <lifeless> http://www.slideshare.net/dings/dont-play-games-with-me-promises-and-pitfalls-of-gameful-design
[04:55] <lifeless> worth a read
[10:54] <StevenK> wgrant: We just need jml's QA now.
[10:57] <wgrant> StevenK: Unfortunately I believe achuni is likely to be at UDS.
[10:57] <wgrant> But hopefully not.
[10:58] <StevenK> We can deploy r15204 if we want.
[10:58] <StevenK> In terms of my stuff, that's the mail command and adding information_type to IBranch.
[11:03] <danhg> hey all
[11:18] <rick_h_> howdy danhg
[11:21] <nigelb> StevenK: ping, around?
[11:25] <StevenK> nigelb: O hai
[11:25] <nigelb> Heya, got a few mins for a PM?
[11:25] <StevenK> nigelb: Sure.
[13:29] <abentley> rick_h_: per deryck's email, he and adeuring aren't standupping today.  Would you like to stand up anyhow?
[13:30] <rick_h_> abentley: sure
[13:53] <czajkowski> morning
[14:06] <rick_h_> party czajkowski
[14:07] <czajkowski> sleepy czajkowski this timezone lark is most confusing :)
[14:08] <rick_h_> hah, timezones do suck. My wife says melatonin ftw (she's a doc) and helped when I hit budapest I think
[17:45] <lifeless> morning
[18:00] <czajkowski> morning
[18:13] <lifeless> flacoste: how is UDS ?
[18:17] <czajkowski> I've gottent to mee huw and rvba :)
[18:17] <czajkowski> niec to put the face to the names
[18:17] <czajkowski> *gotten
[18:18] <lifeless> cool
[18:20] <czajkowski> lifeless: flacoste isnt here this week
[18:20] <flacoste> lifeless: on the phone with deryck
[18:21] <lifeless> czajkowski: oh, I thought he was ;)
[18:21] <lifeless> flacoste: o/
[18:31] <lifeless> gary_poster: around ?
[18:32] <gary_poster> lifeless, yes.  hey.  I got your email.  I don't have any other branches to land, but I wanted to see if the trunks would all work for us if we put them in a PPA before I replied.  You could go ahead and release optimistically: that will make it easier for me to test
[18:32] <lifeless> gary_poster: you read my mind :)
[18:32] <gary_poster> :-) ok cool
[19:19] <lifeless> gary_poster: testtools 0.9.15 is up
[19:19] <gary_poster> ok cool thanks lifeless will try soon
[20:28] <lifeless> gary_poster: did you end up trying an HVM AMI?
[20:28] <gary_poster> lifeless, no we still have a card for it.  Could well be this week.
[20:36] <flacoste> lifeless: do you want to catch-up?
[20:40] <lifeless> flacoste: I'd love to
[20:40] <lifeless> flacoste: when suits ?
[20:40] <flacoste> lifeless: now?
[20:40] <lifeless> sure
[20:40] <lifeless> hangout? skype?
[20:41] <lifeless> flacoste: ^
[20:46] <nigelb> 6/ws 27
[20:46] <nigelb> grrr
[21:15] <abentley> deryck: btw, listing queued jobs is working, and the next step, finding "ready" jobs that aren't queued is also working.
[21:15] <deryck> abentley, nice!  good news then.
[21:16] <abentley> deryck: Also, bug filed: https://github.com/ask/kombu/issues/126
[21:17] <deryck> abentley, man, that's a nice bug report!  :)  Code and everything! :)
[21:39] <gmb> Has anyone ever seen the following error whilst trying to connect to launchpad.dev:
[21:39] <gmb> An error occurred during a connection to launchpad.dev.
[21:39] <gmb> SSL received a record that exceeded the maximum permissible length.
[21:39] <gmb> (Error code: ssl_error_rx_record_too_long)
[21:40] <gmb> Hmm. Could be a proxy problem...
[21:42] <lifeless> .dev? no.
[21:42] <lifeless> or rather, not I
[21:47] <mwhudson> gmb: that can mean one side thinks it's doing ssl and the other side doesn
[21:47] <mwhudson> 't
[21:48] <mwhudson> gmb: does http://launchpad.dev:443/ "work" ?
[21:48] <gmb> mwhudson, Checking now. It works from within the host machine (this is on ec2 btw)
[21:49] <gmb> mwhudson, Ahh, I see what's happened.
[21:49] <gmb> rf-setup clobbered my apache config.
[21:49] <gmb> Thanks for the hint.
[21:49] <lifeless> orly ? :P
[21:49] <lifeless> gmb: having a fun time at UDS ?
[21:49] <gmb> lifeless, So far :)
[21:49] <gmb> Ask me again after the clinic tomorrow.
[22:05] <wgrant> gmb: What broke about the config?
[22:05] <wgrant> gmb: `make LISTEN_ADDRESS=* install` should now do all the remote access stuff for you
[22:07] <sinzui> jcsackett, mumble?
[22:15] <czajkowski> aloha
[22:16] <czajkowski> wgrant: a ticket has been assinged to me in RT from toykeeper you were involved with https://support.one.ubuntu.com/Ticket/Display.html?id=13727 user still having issues and has followed your instructions.
[22:27] <wgrant> czajkowski: Looking
[22:28] <czajkowski> wgrant: thanks
[22:28] <wgrant> czajkowski: Huh, how did that site for 3 weeks without being bounced back to us :(
[22:28] <wgrant> s/site/sit/
[22:28] <czajkowski> wgrant: it only got assigned to me yesterday
[22:29] <czajkowski> and has been sitting in the other IS queue till then
[22:29] <wgrant> Dammit
[22:29] <wgrant> That OOPS has expired
[22:30] <wgrant> czajkowski: Anyway, looks like the usual Active/Deactivated thing. He was Active, needed to be Deactivated to get the email address reactivation behaviour.
[22:33] <czajkowski> ah ok
[22:35] <czajkowski> wgrant: confused as to which account https://launchpad.net/~nsates  or https://launchpad.net/~enesates/
[22:36] <wgrant> czajkowski: nsates was merged into enesates
[22:37] <czajkowski> ah
[23:19]  * StevenK staples wallyworld to the Internet.
[23:20] <lifeless> I think you may want to upgrade to a rivet gun.
[23:20] <StevenK> I might hit vital bits.
[23:22] <bigjools> it won't make any difference
[23:52] <lifeless> jelmer: any chance you could look at bug 987938 ?
[23:52] <_mup_> Bug #987938: subunit trunk packaging breaks subunit-* commands <subunit:Incomplete> < https://launchpad.net/bugs/987938 >
[23:53] <lifeless> gary_poster: subunit releases are up; sorry for the delay.
[23:53] <gary_poster> cool thanks lifeless
[23:54] <lifeless> cutting testrepository in a second