[01:11] LP is allowing me to download things, but my upload of Cala just got rejected with an HTTP 500 error. [01:11] You people probably already know about this, but just in case not, maybe that'll be helpful. Thanks for everything you do! === sarnold_ is now known as sarnold [02:28] 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] sam_: hah, I'm getting an oops trying to log in to the oops viewer. sigh. [02:42] oops! :) [02:54] :D [02:57] anyway no hurry, I'll lurk here and ask again in a few days if nothing happens [02:57] I'm a patient guy! [03:02] it's been a few years, why rush it? :) [03:08] sam_: Two... years? I can't tell if that's a typo or if you're serious :P [03:08] The outage today has been bad but not *that* bad. [03:08] no, genuinely very serious, i just figured it'd fix itself [03:08] i just ended up asking other people to file the bugs for me lol [03:09] wow [03:09] you officially hold the record for longest account outage I've ever seen. [03:10] I guess I should've picked another day to encourage sam_ to get his account fixed for openstack-y purposes :D [07:40] @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] The stack trace in the OOPS indicates some issue when invoking setPreferredEmail() [07:41] it should be thesamesam, I think (it's what I see in "personal details" on ubuntu one) [07:47] Thanks! My colleague will take over here, as we just realised we were both working on this simultaneously :) [07:48] * colleague waves * [07:48] We'll get that working [07:49] thanks folks :) [07:49] Unless you'd like to make your record of not being able to login even more impressive :P [07:57] Could you try loging in now @_sam? [07:57] Should be fixed [07:58] it's a miracle! [07:59] thank you all [07:59] there's a lesson in here about procrastinating i think [08:30] 🎉 [09:20] 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 === nesda is now known as ialmeida === ChanServ changed the topic of #launchpad to: Help contact: ialmeida (08:00-16:00 UTC, Mon-Fri) | Launchpad is an open source project: https://dev.launchpad.net/ | This channel is logged: http://irclogs.ubuntu.com/ | User Guide https://help.launchpad.net/ | Support and spam reporting: https://answers.launchpad.net/launchpad [20:48] https://launchpad.net/+search?field.text=foo&field.actions.search=Search [20:48] " The page search service was not available when this search was performed." [20:48] Known issue? [21:34] xdddd [21:34] description [21:34] If we have a query which has [21:34] - regular ("cheap") constant condition that evaluates to FALSE [21:34] - an expensive constant condition (doesn't matter what it evaluates to) [21:34] then "Impossible WHERE" will not be generated. [21:34] Example: [21:34] create table t1 (a int); [21:34] insert into t1 values (1),(2),(3); [21:34] create table t2 as select * from t1; [21:34] create table t_pk1 (a int primary key); [21:34] create table t_pk2 (a int primary key); [21:34] insert into t_pk1 select a from t1; [21:34] insert into t_pk2 select a from t1; [21:34] alter table t_pk1 add b int; [21:34] alter table t_pk2 add b int; [21:34] ## Here t_pk1 is a constant table, and "t_pk1.b> 3" is a cheap constant [21:34] condition that evaluates to FALSE: [21:38] mews