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