[01:00] <StevenK> IntegrityError: new row for relation "bug" violates check constraint "sane_description"
[01:00] <StevenK> Success
[01:02] <mwhudson> i bet there are plenty of bugs that pass that constraint but are still not sane
[01:02] <StevenK> mwhudson: Hush
[01:02] <lifeless> mwhudson: I don't believe bugs can be sane or not.
[01:03] <mwhudson> lifeless: all observations depend on where you stand and all that?
[01:03] <StevenK> Anyway, checking that description is under 50000 chars and then adding more characters to it [01:03] <lifeless> indeed
[01:36] <mwhudson> :(
[01:37] <mwhudson> https://launchpad.net/lava/+milestone/2012.11 is timing out
[01:37] <mwhudson> doesn'
[01:37] <mwhudson> doesn't for an icognito window
[01:37] <mwhudson>  OOPS-c9dfbe1f7caf5911bd217ad90e6b1ea7
[01:40] <mwhudson> i wonder if it will work if i leave beta testers...
[01:40] <mwhudson> and then lp-oops.canonical.com said OOPS-2dbf673404dbb8692b14ac4ccb7133a6
[01:41] <mwhudson> i think this is an indication to stop looking at this
[01:43] <wgrant> mwhudson: oops.canonical.com
[01:44] <wgrant> It's there
[01:44] <wgrant> But no comment :)
[01:44] <mwhudson> oh right
[01:44] <mwhudson> raise TemplateDoesNotExist(name)
[01:44] <wgrant> https://oops.canonical.com/oops.py/?oopsid=OOPS-c9dfbe1f7caf5911bd217ad90e6b1ea7
[01:45] <mwhudson> LaunchpadTimeoutError: Statement: 'SELECT DISTINCT
[01:45] <mwhudson> not a promising start
[01:47] <mwhudson> looking at the query certainly makes me think it will work if i leave beta testers...
[01:58] <mwhudson> ah yes
[03:36]  * StevenK stabs zope.formlib
[03:53] <wallyworld> StevenK: is the next FDT 08:00UTC?
[03:54] <StevenK> wallyworld: We've been doing our FDTs whenever, due to pretty much no downtime
[03:54] <wallyworld> ok
[03:58] <StevenK> wallyworld: It's all good on staging?
[03:58] <wallyworld> StevenK: yes, the new tables are as yet unused
[03:59] <StevenK> wallyworld: How long did the patch take to apply?
[03:59] <wallyworld> 0.0
[04:43] <nigelb> Is today the day you guys get a holiday for a "sporting" event?
[04:43] <StevenK> Only wgrant
[04:43] <nigelb> Oh, so he's just gonna continue working :P
[04:44] <StevenK> Melbourne has a public holiday for Melbourne Cup Day, the rest of Victoria and Australia do not.
[04:44] <nigelb> ah
[04:44] <nigelb> I thought the entire state got a holiday. Thought wrong I guess :)
[04:45] <StevenK> I might wrong, but I thought it was just Melbourne itself.
[04:45] <nigelb> You're right.
[04:47] <bigjools> lazy b'stards
[04:47] <nigelb> lol
[04:48] <StevenK> bigjools: Speaking of those, Prince Charles and a horse were in the crowd watching
[04:48] <StevenK> Oh, it wasn't a horse. It was Camilla
[04:48] <bigjools> haha
[04:48] <nigelb> haha
[04:48] <nigelb> StevenK++
[04:48] <nigelb> I can't stop laughing. Thank god I work from home.
[04:49] <bigjools> in that case: lazy, privileged, tax-thieving b'stards
[04:49] <StevenK> bigjools: Did you see https://plus.google.com/101824923181156392444/posts/1N6PcSMKL4g ?
[04:52] <nigelb> That is brilliant!
[04:55] <nigelb> play rugby (which has some similarities to American football, but does not involve stopping for a rest every twenty seconds or wearing full kevlar body armour like a bunch of nancies)
[04:56] <nigelb> hahahah
[04:57] <bigjools> I think that appears every year, with various details amended to reflect current reality
[04:58] <nigelb> heh
[05:02] <bigjools> 'We will tell you who killed JFK when you apologize for the abomination known as “Teletubbies"'
[05:02] <bigjools> rofl
[05:02] <nigelb> haha
[05:25] <alicatux> $ bzr branch lp:launchpad
[05:25] <alicatux> KilledkB   213kB/s | Fetching revisions:Inserting stream:Estimate 975008/131177
[05:26] <alicatux> 3rd attempt... still getting bzr killed...
[05:28] <StevenK> On your machine?
[05:43] <StevenK> wallyworld__: O hai. Can haz review?
[05:43] <wallyworld__> sure
[05:43] <StevenK> wallyworld__: https://code.launchpad.net/~stevenk/launchpad/filebug-description-widget/+merge/133009
[05:48] <wallyworld__> StevenK: 66	+ string = 'y' * 50001  ---- dont' you want to make the string nominally smaller than 50000 to ensure that the extra text tips it over an causes the error?
[05:52] <StevenK> wallyworld__: I want it larger than 50000. I can, if you wish
[05:52] <wallyworld__> yes, but you want the extra text to be the thing that makes it too large. that's the point of the branch
[05:53] <wallyworld__> shoul the check on line 27 be > 50000 not > 50001 ?
[05:53] <StevenK> wallyworld__: Yes, that's the extra check. The 'y' * 50001 will turn up as extra_description not the comment
[05:53] <StevenK> wallyworld__: sane_description wants <= 50000
[05:54] <StevenK> Therefore, > 50001
[05:54] <wallyworld__> yes so > 50000 is the check
[05:54] <StevenK> Right
[05:54] <wallyworld__> > 50000 is the opposite of <=50000
[05:54] <wallyworld__> ack on the y * 50001
[05:55] <wallyworld__> so r=me with the 50000 change
[05:56] <StevenK> wallyworld__: http://pastebin.ubuntu.com/1336641/
[05:56] <wallyworld__> yes cool, thanks
[05:56] <StevenK> wallyworld__: Thanks
[05:56] <wallyworld__> np
[07:09] <alicatux> yes, onmy machine
[07:09] <StevenK> alicatux: How much RAM do you have?
[07:09] <alicatux> 768
[07:10] <StevenK> Wow
[07:10] <StevenK> That might be why
[07:10] <alicatux> old machine...
[07:10] <alicatux> i see
[07:11] <StevenK> alicatux: I'd recommend at least 4GiB if you want to run Launchpad for development, you probably need 2 to develop on it
[07:15] <alicatux> resort to the cloud then, lol
[08:16] <alicatux> i made it.
[08:29] <alicatux> https://dev.launchpad.net/Running/LXC
[08:29] <alicatux> step 2 "-a i386"
[08:30] <alicatux> it's a 64 bit machine should I stick with i386?
[08:51] <adeuring> good morning
[11:53] <StevenK> dpm: You should check out translations for raring.
[11:53] <StevenK> dpm: I think that should be everything
[11:54] <adeuring> good morning frankban, could you please review this MP: https://code.launchpad.net/~adeuring/launchpad/product-lp-limitedview/+merge/133046 ?
[11:55] <frankban> hi adeuring, sure, right after grabbing some food
[11:55] <adeuring> frankban: sure, enjoy lunch!
[11:58] <dpm> hey StevenK, looks good now. The contributors list seems to match the one from Q
[11:58] <StevenK> Indeed.
[11:58] <dpm> excellent, thanks
[11:58] <StevenK> dpm: So you can handle everything else and I'm all done, until it's time to export langpacks?
[12:01] <dpm> StevenK, I believe yes, your job is done. The next step will be to modify the cron jobs to do Raring language pack exports, but I'll file an RT for that.
[12:02] <StevenK> dpm: You'll probably have to drop one series
[12:02] <dpm> yes
[12:03] <StevenK> steven@undermined:~/lp-production-crontabs% grep language-pack-export loganberry-launchpad | cut -d\  -f11 | tr '\n' ' ' ; echo
[12:03] <StevenK> precise quantal lucid
[12:04] <dpm> yeah, we can probably drop lucid, so that we've got at least the latest LTS and stable release
[12:21] <nigelb> james_w: Happy Birthday!
[13:17] <balboah> is my username supposed to include the superlong login hash in every place it is displayed?
[13:17] <balboah> it doesn't fit the layout
[13:20] <benji> gary_poster: once I fix some lint I'll have a tired, poor branch for you to look at... hmm, or maybe not, since it was based on one of Matt's branches; I'll need to figure out the right lbox way to do that
[13:21] <gary_poster> cool benji.  I think you should just adopt it, myself
[13:21] <czajkowski> balboah: can you show us what you mean ??
[13:21] <gary_poster> benji, btw, notice channel :-P
[13:21] <benji> pfft
[13:21] <gary_poster> :-)
[13:24] <balboah> czajkowski: I mean this https://dl.dropbox.com/u/2468164/Screen%20shot%202012-11-06%20at%2014.21.41.png and this: https://dl.dropbox.com/u/2468164/Screen%20shot%202012-11-06%20at%2014.23.26.png
[13:24] <czajkowski> balboah: ok so if you go to edit your LP page you can change the LP display name
[13:24] <czajkowski> your ac was autocreated
[13:25] <czajkowski> balboah: https://launchpad.net/~/+edit
[13:26] <balboah> czajkowski: aha. Hmm I wonder where the auto create happened. Oh well now it looks better, thanks
[14:06] <czajkowski> sinzui: what is the difference in the tag easy and trivial
[14:06] <sinzui> trivial can be fixed in one hour and probably does not need tests.
[14:07] <sinzui> easy can be fixed in a day and definitely needs tests.
[14:07] <mgz> that's a more concrete answer than I'd have managed :)
[14:07] <sinzui> lots of text/UI changes are untestible
[14:07] <czajkowski> sinzui: hmmm
[14:07] <sinzui> easy was added years after trivial
[14:07] <czajkowski> thats really not a great way for me to see it tbh, they both mean the same thing
[14:07] <czajkowski> and a text change to me seemed trivial
[14:08] <sinzui> czajkowski, we say hour because we observed in 2009 that an experienced Lp engineer can fix 8 in one day
[14:08] <czajkowski> nods
[14:09] <sinzui> czajkowski, I rarely use easy since most bugs can be fixed in day :)
[14:10] <czajkowski> sinzui: yes but I'm not you :) and ti seemed trivial
[14:10] <czajkowski> no point in arguing it just feels like semantics :s
[14:11] <mgz> it seems more like there is a (semi) useful distinction, but then it becomes impossible to triage without understanding exactly how much work any particular minor change would take... which I certainly don't know at a glance
[14:12] <czajkowski> and nobody had ever told me the difference almost 9 months in
[14:12] <sinzui> czajkowski, there is no right answer. Lots of things people have marked easy or trivial were not. The only real way to judge them to for someone to outline the fix so that other can judge how long it would take them to complete
[14:12] <czajkowski> nods
[14:54] <james_w> thanks nigelb
[14:54] <deryck> sinzui, hi.  got a sec?
[14:54] <sinzui> yes
[14:55] <deryck> I'd like to get some voice time today with you, just to chat about transitive privacy and other related things.
[14:55] <deryck> sinzui, do you have a time that's best?
[14:55] <czajkowski> deryck: have you seen https://bugs.launchpad.net/launchpad/+bug/1075365
[14:55] <_mup_> Bug #1075365: Timeout when trying to visit previous sprint pages <fallout> <lp-blueprints> <private-projects> <regression> <timeout> <Launchpad itself:In Progress by abentley> < https://launchpad.net/bugs/1075365 >
[14:55] <deryck> czajkowski, indeed.  see abentley is already on it. :)
[14:55] <abentley> czajkowski: Yes, and I'm investigating.
[14:56] <sinzui> deryck, within the next 4 hours
[14:56] <czajkowski> ah joys of not refreshing pages
[14:56] <czajkowski> grand job
[14:56] <czajkowski> shall move on to other bits :)
[14:56] <czajkowski> thanks
[14:56] <deryck> :)
[14:56] <czajkowski> deryck: sorry would this be related to it ? https://bugs.launchpad.net/launchpad/+bug/1075569
[14:56] <deryck> sinzui, how about 17:00 UTC, 11 for me, 12 for you, I believe?
[14:57] <sinzui> okay
[14:57] <deryck> sinzui, thanks.  I'll add a calendar event so we get this nice hangout setup now. :)
[14:57] <sinzui> thank you
[14:58] <deryck> czajkowski, that could be related, but there's a slightly different longer running query there.  abentley, can you glance at that bug in parallel to determine if it's related?
[14:59] <nigelb> james_w: :)
[14:59] <czajkowski> deryck: abentley thank you
[14:59] <deryck> np!
[15:00] <abentley> deryck: looking...
[15:00] <deryck> abentley, thanks!  Feel free to triage and add a card to the board if it seems not directly related.
[15:03] <abentley> deryck: Not clear whether it's related.  If we find a way of speeding up the privacy clause, that might affect both.  Added to board.
[15:03] <deryck> abentley, ack, thanks.
[15:04] <czajkowski> cheers folks
[15:05] <mask19> I `make run`ed a new launchpad and I got "OpenSSL: error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol
[15:05] <mask19> Unable to establish SSL connection."
[15:05] <mask19> (wget result)
[15:06] <mask19> how to fix?
[15:11] <mask19> and Connection refused now...
[15:13] <mask19> hmmm... it seems I cant wget it outside the container... solved
[15:14] <rick_h> mask19: yea, by default apache only listened on localhost
[15:15] <mask19> how do I expose it? simply change the apache config?
[15:16] <rick_h> mask19: there's supposed to be a flag you can pass to a make command that lists the interfaces. looking
[15:17] <deryck> You can `make install` in your lp tree to get Apache setup correctly.
[15:17] <rick_h> deryck: right, but there's a BIND_ADDRESS or something you need to set to *
[15:17] <rick_h> https://dev.launchpad.net/Running/RemoteAccess?highlight=%28make+install%29
[15:18] <rick_h> there we go, knew there was a doc for it
[15:18] <rick_h> LISTEN_ADDRESS
[15:18] <jcsackett> sinzui: any chance you have time to chat when you're done chatting with deryck?
[15:18] <sinzui> yes
[15:18] <mask19> thanks~
[15:19] <jcsackett> sinzui: excellent. ping me when you're available?
[15:19] <sinzui> okay
[15:19] <deryck> rick_h, mask19 -- but make install should do that for you.  If it doesn't, we should file a bug and fix it.
[15:19] <rick_h> deryck: what it does is setup the apache config to only listen on 127.0.0.1 by default
[15:20] <rick_h> deryck: so you have to override that if you want to access it remotely
[15:20] <rick_h> e.g. server on lxc container but access with local browser
[15:20] <deryck> oh wait, you mean via another machine on the same network.  sorry, ignore me.
[15:20] <deryck> right, gotchas.
[15:23] <abentley> deryck: Could you please run this with EXPLAIN
[15:23] <abentley> ANALYSE: https://pastebin.canonical.com/77729/ ?
[15:23] <deryck> abentley, sure.  getting it now....
[15:24] <mask19> do you have to make run it as root after install?
[15:25] <abentley> deryck: I just discovered that even though the "Long SQL Statements" portion of an OOPS does not show variable substitutions, the "SQL statement log" *does* show substitutions.
[15:25] <deryck> ah, cool.
[15:26]  * deryck is still waiting
[15:26] <mask19> I got " Operation not permitted: '/var/tmp/mailman' "
[15:26] <deryck> first runs on staging db are slowwwwww
[15:27] <deryck> mask19, yeah, you need to run it as root
[15:27] <deryck> oh wait
[15:27] <deryck> mask19, you need to make install as root, but make run should not be.
[15:30] <mask19> rm-ed "/var/tmp/mailman", and fine
[15:30] <mask19> sudo make clean actually
[17:11] <czajkowski> jcsackett: ello, can you help me with https://answers.launchpad.net/launchpad/+question/213444
[17:12] <rick_h> czajkowski: yea, so when you auth an app you end up generating a token for that application you authorized
[17:12] <czajkowski> rick_h: aye that I get
[17:12] <czajkowski> the delay bit not seen before though
[17:12] <rick_h> yea, not sure why it's not listed
[17:12] <rick_h> I can't see his tokens to know if he's just not seeing it
[17:13] <czajkowski> rick_h: ahh
[17:13] <rick_h> the delay is just that the email is sent from the job system
[17:13] <rick_h> so not unexpected, but guess I'm not sure why it was 16hr :/
[17:14] <czajkowski> nods
[17:14] <czajkowski> 16 is a bit much
[17:15]  * rick_h isn't sure what the normal run time of that background email job stuff is
[17:15] <czajkowski> <16 :)
[17:15] <rick_h> lol
[17:49] <mask19> where's zope.app.form?
[18:21] <sinzui> jcsackett, we can talk now. I have a meeting at 2:00 EST
[18:23] <jcsackett> sinzui: ok, be on g+ momentarily.
[18:37] <jcsackett> sinzui: http://bazaar.launchpad.net/+branch/launchpad/+filediff/~jcsackett/launchpad/filediff-permission-denied
[18:37] <jcsackett> sinzui: https://oops.canonical.com/?oopsid=787fce475f899a29b3241cc900517fb3
[18:48] <lifeless> https://bugs.launchpad.net/launchpad/+bug/6 needs toggling back to invalid
[18:48] <_mup_> Bug #6: "next 10 entries" at bottom of page <lp-translations> <Launchpad itself:Fix Released by carlos> < https://launchpad.net/bugs/6 >
[18:48] <lifeless> apparently I didn't get the emeritus stuff anywhere as near setup as I thought I had
[18:48] <lifeless> cause I can't :)
[18:52] <rick_h> lifeless: updated
[18:52] <lifeless> danke :P
[19:50] <sinzui> jcsackett, how goes it? time for another hangout?
[20:02] <jcsackett> sinzui: it goes. it's definitely a javascript error, though i have learned that the urls in the oopses are wrong. if you click one of the erroring urls in the javascript, the url accompanying the oops isn't a match.
[20:03] <sinzui> \o/
[20:03] <sinzui> lets hangout
[20:04] <jcsackett> sinzui: ok, let me figure out where i've since put my phone. :-)
[20:06] <jcsackett> sinzui: i'm on now, having responded to your invite.
[20:06] <jcsackett> but you are gone.
[20:30] <jcsackett> sinzui: cat disconnect you?
[20:30] <sinzui> My phone thought I needed to get children
[20:30] <jcsackett> ah. :-)
[22:25] <StevenK> mwhudson: O hai, do you have a sec?
[22:26] <mwhudson> StevenK: yes
[22:26] <StevenK> mwhudson: Bug 820069 for reference, is BranchType 2 (MIRRORED) used anymore?
[22:26] <_mup_> Bug #820069: BadUrlLaunchpad raised mirroring a branch <branch-puller> <oops> <Launchpad itself:Triaged> < https://launchpad.net/bugs/820069 >
[22:27] <mwhudson> StevenK: i believe there are still branches of that type
[22:27] <mwhudson> it is not possible to create them any more
[22:27] <mwhudson> but the existing ones are still there
[22:27] <StevenK> So the UI to create MIRRORED doesn't exist any more
[22:27] <mwhudson> right
[22:27] <StevenK> That would explain why I couldn't find it
[22:28] <StevenK> mwhudson: So the puller is still running?
[22:28] <mwhudson> yeah
[22:28] <joey> OOPS-16745647cef3ea06f938ac0919f22630
[22:28] <mwhudson> for mirrored and imported branches
[22:29] <joey> let me rephrase that, sinzui if you are still interested in time-out oopes,  OOPS-16745647cef3ea06f938ac0919f22630
[22:35] <sinzui> joey, I am reporting that oops as a bug
[22:35] <joey> sinzui: I had a different code block fail again but it might be related.  OOPS-ffd854a1f01abf0eea6ae144fc7111ac
[22:35] <joey> sinzui: they both use .endswith("blah")
[22:37] <joey> sinzui: specifically, team.name.endswith("-r")
[22:37] <joey> I can work around it. I'll just cache the team.names into python and iterate over that
[22:38] <sinzui> joey, the timeout is before, the method. The timeout is not being able to get the next batch. The query is ambiguous and certainly looks expensive
[22:39]  * joey nods.
[22:39] <joey> I have to admit I've learned more about the API in the last few weeks than I ever did when I was on LP.
[22:39] <joey> data-mining-r-us
[22:40] <joey> sinzui: *sigh* oh trying to cache the names resulted in  OOPS-dba5f06bc8e0b8fd6186cf4131717dab
[22:41] <joey> sinzui: I'm not using my privs to bypass the time outs (I'm using lp-shell)
[22:42] <joey> the list size sinzui that it's traversing is 1518 if that helps at all