[01:11] <arraybolt3> LP is allowing me to download things, but my upload of Cala just got rejected with an HTTP 500 error.
[01:11] <arraybolt3> You people probably already know about this, but just in case not, maybe that'll be helpful. Thanks for everything you do!
[02:28] <sam_> hi, I've been trying to login to launchpad for about 2 years, and every time I need to actually get in, I just end up asking someone else to file a bug or comment on it or whatever for me. I can login to other services via Ubuntu One, but when I login to launchpad, I get 'oops!' and the error code is  OOPS-223df61fde80a2a39cbc63835bc53eb8
[02:40] <sarnold> sam_: hah, I'm getting an oops trying to log in to the oops viewer. sigh.
[02:42] <sam_> oops! :)
[02:54] <sarnold> :D
[02:57] <sam_> anyway no hurry, I'll lurk here and ask again in a few days if nothing happens
[02:57] <sam_> I'm a patient guy!
[03:02] <sarnold> it's been a few years, why rush it? :)
[03:08] <arraybolt3> sam_: Two... years? I can't tell if that's a typo or if you're serious :P
[03:08] <arraybolt3> The outage today has been bad but not *that* bad.
[03:08] <sam_> no, genuinely very serious, i just figured it'd fix itself
[03:08] <sam_> i just ended up asking other people to file the bugs for me lol
[03:09] <arraybolt3> wow
[03:09] <arraybolt3> you officially hold the record for longest account outage I've ever seen.
[03:10] <JayF> I guess I should've picked another day to encourage sam_ to get his account fixed for openstack-y purposes :D 
[07:40] <clinton-fung> @sam_ can you please confirm your Launchpad username for me (via DM if need be). When I search Launchpad for the e-mail address listed in the OOPS, I don't get a hit, so perhaps something weird happened there
[07:41] <clinton-fung> The stack trace in the OOPS indicates some issue when invoking setPreferredEmail()
[07:41] <sam_> it should be thesamesam, I think (it's what I see in "personal details" on ubuntu one)
[07:47] <clinton-fung> Thanks! My colleague will take over here, as we just realised we were both working on this simultaneously :)
[07:48] <nesda> * colleague waves *
[07:48] <nesda> We'll get that working
[07:49] <sam_> thanks folks :)
[07:49] <nesda> Unless you'd like to make your record of not being able to login even more impressive :P
[07:57] <nesda> Could you try loging in now @_sam?
[07:57] <nesda> Should be fixed
[07:58] <sam_> it's a miracle!
[07:59] <sam_> thank you all
[07:59] <sam_> there's a lesson in here about procrastinating i think
[08:30] <clinton-fung> 🎉
[09:20] <nesda> Launchpad status after the outage: Launchpad seems to be running as normal in the past few hours, including the builders. It was quite a long one, so thank you for being patient
[20:48] <rbasak> https://launchpad.net/+search?field.text=foo&field.actions.search=Search
[20:48] <rbasak> " The page search service was not available when this search was performed."
[20:48] <rbasak> Known issue?
[21:34] <Guest83> xdddd
[21:34] <Guest83> description
[21:34] <Guest83> If we have a query which has
[21:34] <Guest83> - regular ("cheap") constant condition that evaluates to FALSE
[21:34] <Guest83> - an expensive constant condition (doesn't matter what it evaluates to)
[21:34] <Guest83> then "Impossible WHERE" will not be generated.
[21:34] <Guest83> Example:
[21:34] <Guest83> create table t1 (a int);
[21:34] <Guest83> insert into t1 values (1),(2),(3);
[21:34] <Guest83> create table t2 as select * from t1;
[21:34] <Guest83> create table t_pk1 (a int primary key);
[21:34] <Guest83> create table t_pk2 (a int primary key);
[21:34] <Guest83> insert into t_pk1 select a from t1;
[21:34] <Guest83> insert into t_pk2 select a from t1;
[21:34] <Guest83> alter table t_pk1 add b int;
[21:34] <Guest83> alter table t_pk2 add b int;
[21:34] <Guest83> ## Here t_pk1 is a constant table, and "t_pk1.b> 3" is a cheap constant
[21:34] <Guest83> condition that evaluates to FALSE:
[21:38] <Guest83> mews