[03:56] <jamesh> stub: with the bug comment updater script, would you be happy with the script if it only updated MessageChunks which have a MessageChunk -> Message -> BugMessage relationship?
[03:57] <stub> Yes. I would have modified it myself if I wasn't tired and could remember the SQLObject magic to do it ;)
[03:57] <jamesh> I'll make the change.
[03:58] <stub> It probably doesn't really matter, as most messages are bugs and are unlikely to contain the strings.... but it would be nicer to do it that way.
[03:59] <stub> Maybe only do bugs in the bugzilla import bug# range?
[03:59] <stub> WHERE id BETWEEN foo AND bar ?
[03:59] <jamesh> I'm not sure what that range is
[03:59] <jamesh> I could probably work out an upper bound
[03:59] <stub> Do the bugzilla imported bugs have nicknames we can LIKE match?
[04:00] <jamesh> we were using bug watches to identify them for the bz import
[04:02] <jamesh> looks like it is from 6761 to 36280
[04:03] <jamesh> (there are some non-imported bugs in that range)
[04:03] <jamesh> but I don't think there'll be major problems from running it over the entire range
[04:13] <jamesh> stub: okay.  I'
[04:13] <jamesh> ve updated the script to only select message chunks associated with bugs in that rangew
[04:13] <stub> Same URL?
[04:13] <jamesh> yeah
[04:14] <jamesh> the only change is near the top of updateMessageChunks
[04:15] <stub> devpad seems to be slow :-/
[04:18] <stub> jamesh: You tested the old version against demo and it worked fine? 
[04:19] <jamesh> yeah
[04:19] <jamesh> I needed to enable update to MessageChunk for the user it was running as
[04:26] <stub> If you have a look at the scripts like in database/schema/fti.py, you will find a helper for command line arguments to specify what user / host etc. to connect to the db as allowing a simple way of overriding what is in the launchpad.conf
[04:26] <jamesh> I didn't really bother with it for this script because it was going to be a one off throw-away script
[04:28] <stub> jamesh: all done
[04:29] <jamesh> stub: thanks
[04:33] <jamesh> stub: does the supermirror SFTP server usually get updated with new code rollouts?
[04:33] <stub> Yes, unless I'm sure there are no changes in that code that need to go out.
[04:33] <stub> (which I'm not)
[04:34] <jamesh> cool.  There is a fix I made since the last rollout
[04:34] <jamesh> gets rid of the need to use "--create-prefix" on the initial push of a branch
[04:41] <stub> Launchpad will be going down in 15 mins for its regular code update. Estimated downtime is 10 mins.
[06:02] <bradb_> stub: ping
[06:04] <stub> bradb_: pong
[06:04] <stub> Go to bed!
[06:05] <bradb_> stub: bah. :P just wondering, what rev is on staging?
[06:06] <jamesh> bradb_: I did up a spec on automatic BugBranch creation (posted about it on the list).  You might want to look at it when you wake up
[06:08] <bradb_> jamesh: cool. will try to have a look tomorrow.
[06:13] <stub> bradb_: It will be running HEAD in an hour or so - the update is happening now
[06:23] <bradb_> stub: I take it the rollout already happened today?
[06:23] <mpt> hey bradb_, what was the impetus behind <https://launchpad.canonical.com/SubscriptionsInLaunchpad>? Did you create it from any particular issue?
[06:28] <stub> bradb_: yes
[06:32] <bradb_> stub: ok, thanks
[06:34] <bradb_> mpt: premature abstraction, no doubt. but i don't recall writing almost any of that
[06:39] <mpt> bradb_, there is a good reason for such abstraction, I think
[06:39] <mpt> and that is the person who sits down in front of their Inbox one day and realizes, "Launchpad is sending me too much mail. This has got to slow down."
[06:39] <mpt> So they want to see a single page containing all the reasons they are getting mail from Launchpad
[06:40] <mpt> so Launchpad needs to be able to collect all those in some way
[06:42] <mpt> bradb_, another question, am I correct in understanding that a bug contact is notified of new bug reports, but not of other changes to bug reports?
[06:53] <bradb_> mpt: i agree that abstracting subscriptions is morally the right thing to do, but that doc was probably premature abstraction, given that it's still mostly not implemented 10 months later :)
[06:53] <bradb_> mpt: bug contacts get all bugmail
[06:55] <mpt> bradb_, so bug contact could theoretically be replaced by subscription to the Bugs facet for a thing
[06:58] <bradb_> mpt: yeah, that's basically what a bug contact does already. they should be able to unsub from individual bugs too.
[07:04] <mpt> yeah, hence the ignore subscription
[07:04] <jamesh> getting "don't email me for my own changes" support would be nice
[07:09] <mpt> That particular problem is much simpler than generalizing subscriptions, I think
[07:13] <jamesh> if generalized subscriptions also means generalized email notification, it should be possible to implement it reliably
[07:13] <jamesh> rather than once in each component
[07:20] <jamesh> good thing we got the imported bugzilla comments fixed up now rather than waiting til we rearrange all the URLs ...
[07:28] <stub> :)
[07:33] <mpt> jamesh, got time for a five-minute review?
[07:34] <jamesh> mpt: okay
[07:34] <stub> bradb_: If BugTask.productseries is set, should BugTask.product also be set? Always?
[07:35] <mpt> jamesh, https://devpad.canonical.com/~andrew/paste/filedcG5GQ.html
[07:35] <mpt> this is to fix sabdfl's bug 56713
[07:35] <Ubugtu> Malone bug 56713 in malone "Bug id should be linked in preference to bug title" [Medium,Confirmed]  http://launchpad.net/bugs/56713
[07:36] <stub> bradb_: I see. No, product and productseries should not both be set.
[07:41] <jamesh> mpt: by the look of it, if the ID column is shown, that patch will link the bug number and the bug title, but if the ID column is not shown, the bug title won't be linked.
[07:41] <jamesh> mpt: am I reading it wrong?
[07:42] <mpt> jamesh, that's not the way it behaves locally :-)
[07:42] <mpt> well, your second clause is correct
[07:42] <mpt> but if the ID column is shown, it links only the bug number and not the bug title
[07:43] <mpt> ah, I see what you mean
[07:43] <mpt> weird, I wonder why that didn't happen when I ran it
[07:44] <jamesh> I guess "not: context/show_column/id|nothing" evaluates as "(not: context/show_column/id)|nothing" rather than "not: (context/show_column_id|nothing)"
[07:44] <jamesh> (guessing)
[07:44] <mpt> I could get rid of those |nothings
[07:44] <jamesh> that'd break things
[07:45] <jamesh> show_column is a dict of shown column names, iirc
[07:45] <jamesh> so context/show_column/id gives a KeyError if the id column isn't being displayed
[07:45] <mpt> poo
[07:45] <jamesh> hence the "|nothing" bit
[07:45] <mpt> ok
[07:45] <jamesh> try this:
[07:45] <mpt> So I reversed the not
[07:46] <mpt> and it works exactly the same, afaict
[07:46] <jamesh> on the <td> element add tal:define="show_id context/show_column/id|nothing"
[07:46] <jamesh> then you can use tal:condition="show_id" and tal:condition="not:show_id"
[07:46] <mpt> Ah, and I should be doing that anyway, to save TAL processing time
[07:47] <jamesh> this sounds like it needs a page test :)
[07:47] <mpt> actually
[07:47] <mpt> I think every bug listing in Launchpad includes the bug ID
[07:48] <jamesh> although, do we ever not show the ID?
[07:48] <jamesh> yeah.
[07:48] <mpt> so I could just simplify the code and see if any *existing* test breaks :-)
[07:48] <jamesh> you'll probably need to update some page tests either way
[07:51] <mpt> I think the plan is to make the columns customizable eventually
[07:52] <jamesh> so it is probably worth having the code to enable/disable the column
[07:52] <jamesh> you can probably toggle the column display in the view class to test
[07:57] <mpt> We don't seem to have any existing pagetests that mention columns w.r.t. bug listings
[07:59] <mpt> and bugtarget.py doesn't mention columns either
[07:59] <mpt> hmmm hmmm
[08:04] <mpt> ah, it's in batching.py
[08:05] <jamesh> stub: do you know why PageTestLayer.endStory() calls force_dirty_database()?
[08:06] <stub> jamesh: Because we may have committed changes to the database in one of the earlier files in the story, but have no way of knowing that.
[08:07] <jamesh> stub: okay.  It gets called after each file in the pagetests/standalone directory
[08:07] <stub> Its fixable I think, and should speed things up if we do
[08:08] <stub> We should be able to detect the dirty status in PageTestLayer.testTearDown or in the TestCase.tearDown and remember it, so PageTestLayer.endStory only calls force_dirty_database() when necessary
[08:10] <stub> Or we could just deprecate stories - most stories could happily live in a single file with the new page test machinery ;)
[08:20] <mpt> bah
[08:22] <mpt> jamesh, thanks for the review, I think I'll hand it over to bradb because I don't know how how to tweak the view class from a pagetest (or conversely, to get the piece of rendered HTML in a doctest)
[09:01] <danilos> morning
[09:04] <SteveA> morning!
[09:04] <dsas> hmm, has the update for the support tracker been pushed live? I get an oops every time I reply to a ticket via the web.
[09:06] <BjornT> dsas: yes it has. could you tell me the OOPS id you got?
[09:10] <dsas> BjornT: OOPS-248C279
[09:10] <Ubugtu> https://chinstrap.ubuntu.com/~jamesh/oops.cgi/248C279
[09:16] <BjornT> dsas: thanks. i'll take a look at it soon. it takes a while before it gets copied from our logs so that i can see it.
[09:23] <jamesh> dsas: looks like we need an extra KarmaAction row in the production database
[09:24] <BjornT> stu1: ping
[09:27] <carlos> morning
[09:28] <dsas> jamesh: Is it likely to be something that's fixed before the usual (weekly?) code roll-out?
[09:28] <BjornT> dsas: it should have been fixed, and i'm trying to get hold of stu1 so that he can fix it now.
[09:28] <jamesh> dsas: it is a problem caused by the code and database being out of sync (in this case, todays code rollout relied on some data in the database that isn't present)
[09:29] <dsas> Ok, thanks for the info. I'll hang around to see when it's fixed, or try again tomorrow :)
[09:36] <malcc> stub: Ping!!
[09:36] <jamesh> Is there any particular reason we have "Appoint driver" as a separate form for product series?
[09:36] <SteveA> mpt: ping
[09:36] <malcc> stu1: Ping!!
[09:36] <SteveA> malcc: something urgent?
[09:36] <malcc> SteveA: Yes, looks like Soyuz is brokne
[09:36] <SteveA> malcc: stu said he was going to take a nap, so phone him if urgent
[09:36] <malcc> 03:12	malcc	kiko: Dropping the permissions for these views in rocketfuel, is that going to lead to them being dropped from the live db while the old codeline still live on drescher requires them?
[09:36] <malcc> 03:14	kiko	malcc, no, to drop something from the DB requires a DB patch.
[09:36] <malcc> Looks like, not so much :(
[09:37] <SteveA> also, when you phone him, theres a support tracker regression too
[09:37] <jamesh> malcc: r4006 was rolled out.  Was the db patch to remove the view in that rev?
[09:37] <malcc> Where do I find his number?
[09:38] <malcc> jamesh: No, the patch to remove the view is not yet submitted
[09:38] <SteveA> mpt: would you send usman the example template, zipped ?
[09:38] <SteveA> malcc: 
[09:38] <SteveA> https://wiki.canonical.com/Offices
[09:38] <malcc> SteveA: Ta
[09:38] <BjornT> malcc: re the support tracker regression, please tell him to look for an email from me re missing KarmaActions
[09:40] <jamesh> seb128: malcc already knows about the soyuz problems
[09:40] <seb128> hi jamesh
[09:40] <jamesh> hi
[09:40] <seb128> jamesh: what soyuz problems? I'm just waking up ;)
[09:40] <jamesh> seb128: I just assumed you were here to tell us about a problem :)
[09:41] <seb128> ahah, maybe in 10 min when I'll start uploading the next GNOME 2.16 package updates :p
[09:42] <malcc> stub: So kiko did something to the permissions, on views which the codeline on drescher still needs, which has broken Soyuz
[09:42] <malcc> stub: I'm just finding the exact revision now
[09:43] <SteveA> hi stub.  Bjorn also mentioned a support tracker regression.
[09:43] <stub> So I need to revert rather than just fix the permissions?
[09:43] <malcc> stub: No, fixing the permissions should be fine for drescher
[09:43] <malcc> stub: I'm looking for the rev so I know exactly what's gone
[09:44] <BjornT> stub: it seems like database/schema/pending/support-tracker-karma.sql needs to be run. the support tracker currently oopses due to missing KarmaActions
[09:44] <stub> Score 1 for people filling out the new section on LaunchpadProductionStatus
[09:46] <stub> Bah - that script hard codes id's :-P
[09:46] <malcc> My lack of bzr-fu is showing up, I can't locate the exact permissions change
[09:47] <stub> support tracker karma stuff added
[09:47] <stub> So support tracker should be fine now
[09:47] <SteveA> stub: were you not asked to review that karma sql update?
[09:48] <BjornT> dsas: the support tracker should work now again.
[09:49] <stub> malcc: I have permission changes in sourcepackagepublishinghistory and binarypackagepublishinghistory, amonst others.
[09:50] <SteveA> BjornT: please let matsubara know about what happened, so he can take it into account when looking at the oops logs
[09:50] <malcc> stub: The errors are currently failing to select on sourcepackagepublishing, that I've seen
[09:50] <carlos> stub: hi, did you see kiko's request for a new server for the language pack exports?
[09:50] <malcc> stub: Permissions added to some views can be left, but permissions taken away from some publishing views were premature, and we need them back
[09:51] <malcc> stub: Looks like cprovs r3967 did at least some of it
[09:52] <SteveA> stub: if you weren't asked to review it, that points to a shortcoming in our review process.  (I'm saying this because you were surprised that the script hard-codes ids)
[09:52] <stub> granted select on sourcepackagepublishing and binarypackagepublishing to everyone. That should do it as a band aid.
[09:52] <stub> SteveA: I can't remember
[09:52] <BjornT> SteveA: i sent a mail to the list about it. i'll point him to that when he comes online.
[09:53] <stub> carlos: yes
[09:54] <carlos> stub: is there any chance to get that done today?
[09:54] <carlos> or anytime soon?
[09:54] <carlos> I only need read only access
[09:55] <stub> carlos: I doubt it. I don't have hardware available. The only suitable box is Carbon, and it needs its external drive array plugged in.
[09:56] <malcc> stub: I'm still getting permission denied on sourcepackagepublishing
[09:56] <carlos> I see
[09:56] <carlos> ok
[09:56] <stub> malcc: Sorted
[09:57] <malcc> stub: Thanks
[09:57] <sivang> morning
[09:57] <malcc> I so should have seen this coming
[09:58] <SteveA> thanks BjornT 
[09:59] <SteveA> stub: what do you think of james t.'s warning against using carbon for critical stuff?
[09:59] <SteveA> stub: I was thinking that for langpacks, we can do it on staging if carbon needs cannibalizing
[09:59] <stub> Valid, but language packs aren't critical at the moment (if they where, we couldn't be using carbon for them)
[09:59] <SteveA> and meanwhile, use carbon for its 31337 speed
[10:00] <stub> Unfortunately, Carbon doesn't have all its disks plugged in so I can't create another database.
[10:03] <lifeless> whats wrong with carbon?
[10:03] <stub> stub: Unfortunately, Carbon doesn't have all its disks plugged in so I can't create another database.
[10:03] <lifeless> yes, got that, curious about the why
[10:04] <lifeless> as in , why are they not plugged in ;)
[10:05] <stub> I think Carbon was live before the extra disks arrived and never got installed because I didn't actually need them yet. Or I may just be imagining that.
[10:08] <jamesh> I thought elmo said he was going to power down Carbon to reconfigure the disks a while back
[10:09] <jamesh> (when we were running into the free space issues last time)
[10:10] <stub> Yes, but it never happened. I can't remember why.
[10:13] <danilos> carlos: have you seen the neil mail on xaralx translators?
[10:14] <carlos> yeah, I will prepare the list today
[10:14] <danilos> carlos: ok, just checking :)
[10:15] <SteveA> mpt: ping
[10:50] <mpt> SteveA, pong
[10:52] <SteveA> hi mpt.
[10:52] <SteveA> would you send to usman a zipped new template example?
[10:52] <SteveA> i'm merging in your branch
[10:54] <mpt> sure
[10:54] <mpt> Does he now have Launchpad running with the ability to drop in the new template?
[10:54] <mpt> (hmm, he'd need to change zcml as well for the new style sheet)
[10:59] <SteveA> mpt: I'm still setting all that up.  I have a call with him later this afternoon to sort stuff out.
[10:59] <SteveA> oh, I'm not suggesting you send him an actual page template
[10:59] <SteveA> just the template with the ids, classes and correct elements, and basic CSS.
[10:59] <SteveA> the simple thing that is just a guide to what we're doing
[11:00] <SteveA> I don't want usman to ever have to see a zope page template :-)
[11:00] <mpt> humm
[11:00] <mpt> I have the skeleton HTML that he's already seen
[11:01] <mpt> and I have the main-template.pt adapting that to Launchpad
[11:01] <SteveA> I mailed him it, but he hadn't seen it properly
[11:01] <mpt> oh, ok
[11:01] <SteveA> because outlook mangled it
[11:01] <SteveA> and he didn't receive my original email
[11:01] <SteveA> so, he's asked to recieve it zipped
[11:01] <SteveA> to stop MS outlook from mangling it
[11:01] <mpt> I know
[11:02] <mpt> But I haven't changed that since I sent it to you, so when you talked about "the latest template" I thought you were referring to something else
[11:49] <realist> Hello, are any support people awake?
[11:50] <malcc> realist: Best to just ask your question and see who answers :)
[11:51] <realist> Sure, has anyone experienced and/or heard of the following issue;
[11:51] <realist> https://launchpad.net/products/launchpad/+ticket/1697
[11:52] <realist> It's quite a frustrating 'bug', if that's even what it is...
[11:57] <jamesh> realist: have you ever checked the "disable this account forever" checkbox in the wiki UserPreferences page?
[11:58] <realist> Not that I remember, but it's quite possible
[11:58] <realist> I don't suppose it can be reversed?
[11:58] <jamesh> so you've been able to log in in the past?
[11:58] <realist> Yes
[11:58] <jamesh> and you are using your email address as a login name on the wiki?
[11:59] <realist> One thing I *do* remember doing, is changing my WikiName from launchpad
[11:59] <realist> Yes, using the same credentials to login to wiki, as I was using on launchpad
[11:59] <jamesh> that shouldn't be a problem, since you don't use your wikiname to log in
[12:00] <realist> Can I re-create my wiki account?
[12:00] <jamesh> realist: I'd suggest emailing the launchpad-users mailing list asking if someone can check if you disabled your account
[12:03] <realist> I have a feeling it would be faster, easier, and less embarassing to start a whole new lanchpad/wiki account
[12:04] <jamesh> We do need to disable the "disable account forever" checkbox on the wiki, or rename it to "shoot yourself in the foot"
[12:06] <realist> My thoughts precisely
[12:06] <realist> It doesn't really serve any other purpose
[12:06] <jamesh> well, it lets you disable your account forever (or until a sysadmin reenables it)
[12:06] <realist> Especially when you can't create a *new* wiki account very easily
[12:07] <realist> I couldn't find the "change wiki name" feature on the wiki itself, which I why I may _possibly_ have selected the "disable account forever"... naively thinking I could re-create a new one easily
[12:08] <realist> It wasn't until later, I found the feature I wanted on launchpad
[12:08] <realist> So I've no idea which one I'd actually shot myself in the foot with
[12:08] <realist> Despite all this, it's certainly a disincentive to a new ubuntu user, and potential contributor

[12:13] <jgi> hello everyone
[12:13] <jgi> is it possible to search for a translation string, or part of it, for a given language?
[12:15] <jamesh> morning ddaa 
[12:15] <ddaa> Hello jamesh, wassup?
[12:16] <jamesh> ddaa: I've got most of the productseries branch stuff done.  Should be able to put it up for review today or tomorrow
[12:17] <ddaa> Sounds great. Would you mind if I review it applying my own standards?
[12:18] <ddaa> Which is a bit more than the normal review... If you are too busy, I can come back later if I find anything that I think needs improving.
[12:18] <jamesh> ddaa: go for it.  The branch is listed as w-i-p on the pending-reviews page.  I've pushed some changes recently so the diff there probably won't be up to date for an hour or so
[12:19] <ddaa> okay
[12:27] <mpt> jgi, not yet, but it will be soon
[12:39] <realist> jamesh: Thanks for your assistance.
[12:49] <SteveA> mpt: up for a voice call?
[01:01] <jordi> carlos, should we seek user input for bug #56717 ?
[01:01] <Ubugtu> Malone bug 56717 in rosetta "Team info page" [Wishlist,Needs info]  http://launchpad.net/bugs/56717
[01:02] <carlos> jordi: not yet
[01:03] <jordi> what do we tell matsubara about it?
[01:03] <carlos> I think we should do it when we see that we are going to work on it
[01:03] <carlos> jordi: you filed the bug ;-)
[01:04] <carlos> jordi: I mean... It's not that matsubara is going to fix it
[01:04] <carlos> but he's checking all bugs so no one is without answer and we classify it
[01:04] <carlos> so just add the idea you got when filed that bug
[01:05] <carlos> and we will ask more people for more input when we start with it. If we ask for input about it now, people will think we are going to implement it right now
[01:06] <jgi> mpt: cool!
[01:06] <jgi> mpt: thanks
[01:10] <Ubugtu> New bug: #59003 in soyuz "New override generation code gives MemoryError on real data" [Critical,Confirmed]  http://launchpad.net/bugs/59003
[01:13] <SteveA> stub: ping
[01:14] <ddaa> Rejoice! You can now change the name and product of a branch in the "Edit Branch Details" form. You can also change the owner of a branch in the "Change registrant" form!
[01:24] <jamesh> ddaa: added a response to your first comment on AutomaticBugBranchLinks
[01:25] <ddaa> I'm adding in more
[01:51] <jamesh> ddaa: the diff of my productseries branch on pending-reviews is up to date now
[01:51] <jamesh> (has been for a little while now)
[01:52] <ddaa> jamesh: how to do you get the full time instead of just the date?
[01:52] <jamesh> full time?
[01:52] <ddaa> in moinmoin
[01:53] <jamesh> @SIG@ expands to "-- JamesHenstridge $currentdate"
[01:53] <ddaa> Oooooh, shiney!
[01:53] <jamesh> it is the equivalent of wikipedia's --~~~
[02:06] <Ubugtu> New bug: #59010 in launchpad "How about unsubscribe a bug?" [Untriaged,Unconfirmed]  http://launchpad.net/bugs/59010
[02:06] <BjornT> hi matsubara 
[02:06] <matsubara> hello BjornT 
[02:07] <BjornT> matsubara: just so that you know, this morning there were some oopses due to missing karma actions for the support tracker. i sent an email about it, and it has been fixed already.
[02:08] <matsubara> BjornT: all right. I'm reading emails now and soon will get to yours. Thanks for the note.
[02:15] <Ubugtu> New bug: #59010 in launchpad "How about unsubscribe a bug?" [Untriaged,Unconfirmed]  http://launchpad.net/bugs/59010
[02:18] <danilos> carlos: reping
[02:18] <carlos> danilos: ping
[02:18] <danilos> carlos: :)
[02:19] <danilos> carlos: I want to test if one of my revisions actually fixed bug 30900 as well, and I am thinking of trying that on staging
[02:19] <Ubugtu> Malone bug 30900 in rosetta "can't remove "Australian languages" from my preferences" [Medium,In progress]  http://launchpad.net/bugs/30900
[02:19] <danilos> i.e. I'd have to manually add entry to database for eg. myself
[02:19] <carlos> danilos: prepare the INSERT command and I will execute it on staging
[02:20] <danilos> carlos: ok, great
[02:20] <carlos> jamesh: hi, how's going the review?
[02:44] <carlos> see you
[02:56] <cprov> salgado: hey, very nice hint about specific setUp/tearDown function for doctests, I got more errors, thank you.
[02:56] <salgado> cprov, cool, glad to hear that!
[02:58] <cprov> salgado: do you know if I need special perms to use simple_sendmail ?
[02:58] <salgado> no, I don't think so
[03:00] <cprov> salgado: ok, will investigate, tks
[03:10] <BjornT> stub: ping
[03:42] <BjornT> lifeless, SteveA: ping
[03:46] <Ubugtu> New bug: #59026 in launchpad "Need to be able to transfer ownership of distribution mirrors" [Low,Confirmed]  http://launchpad.net/bugs/59026
[03:54] <BjornT> lifeless, SteveA: unping
[04:46] <elmo> jamesh: ping?
[04:46] <jamesh> elmo: pong
[04:47] <elmo> what on earth is OCSP and how would I turn it on?
[04:47] <elmo> jamesh: more to the point, since you can turn it on, can you confirm it's also broken on e.g. wiki.ubuntu.com?
[04:48] <jamesh> elmo: it is cleverly hidden in firefox here: edit -> preferences, click the advanced tab, click the verification button then choose "Use OCSP to validate only certificates that specify an OCSP service URL"
[04:48] <jamesh> trying wiki.ubuntu.com
[04:49] <jamesh> same answer
[04:50] <jamesh> OCSP is essentially a replacement for certificate revocation lists.  I'd never heard of it, so don't know whether it is a case of it being generally flaky in Firefox or something about our CA
[05:03] <elmo> man, this ticket sucks
[05:05] <kiko> good morning vietnam
[05:05] <kiko> oi SteveA 
[05:05] <kiko> it is so sick that people actually spam my spamcop submit address
[05:06] <jordi> morning mr kiko
[05:06] <jordi> oh man unhappy customer
[05:07] <kiko> malcc, cprov: so the overrides set is growing too big?
[05:07] <kiko> malcc, cprov: why didn't this happen before?
[05:07] <kiko> malcc, cprov: perhaps something is wrong with the query?
[05:07] <kiko> (we changed it from BPPV to BPPH)
[05:07] <malcc> kiko: It can't be the overrides set, that's smaller than it was before
[05:08] <kiko> malcc, that's the only thing that grows in that loop though
[05:08] <malcc> kiko: What happens to the various objects constructed for the publishing records and the packagereleases from earlier in the loop?
[05:09] <malcc> kiko: Are they in a cache somewhere, or are they totally free to vanish right after we've used them?
[05:09] <kiko> well.
[05:09] <cprov> malcc: sqlobject keeps them, I think
[05:09] <kiko> malcc, the BPPH and SPPH objects are kept in the sqlobject cache, yes.
[05:10] <malcc> kiko: And also the sourcepackagerelease and binarypackagerelease objects?
[05:10] <kiko> malcc, if that's the problem then dirty_pockets indeed should fix the issue correctly.
[05:10] <kiko> malcc, if we traverse to them, which we do, then yes.
[05:10] <kiko> and distroarchrelease, etc, therefore
[05:11] <malcc> kiko: distroarchrelease etc. adds up to approximately zero objects in the scheme of things, it's the thousands of publishing and package records I think are the problem.
[05:11] <kiko> malcc, if dirty_pockets doesn't work (it might well not for universe) then you can blow up parts of the sqlobject cache.
[05:12] <kiko> let me tell you how as soon as I find out.
[05:12] <malcc> kiko: We're already doing clear_current_connection_cache between each call
[05:12] <malcc> kiko: I suspect that's what made the first new version, which didn't do anything with dirty pockets but just split the selects, not run into the memory problem
[05:14] <kiko> malcc, oh, so you've already gotten it to work once?
[05:15] <malcc> kiko: Yes, the trivial change made the memory problem go away, before I took a detour into dirty pockets and efficiency
[05:15] <kiko> malcc, that detour is fine because c_c_c_c is a VBH
[05:15] <kiko> malcc, let me see how you evict individual objects from the cache
[05:16] <malcc> kiko: I don't have any knowledge of that area at the moment, just my VBH
[05:21] <Slike> hello, i suppose this is the right channel for questions about launchpad.net?
[05:22] <salgado> Slike, yep, it is
[05:22] <Slike> ok, my question then: i'd like to sign ubuntu's code of conduct, but I need an openpgp key
[05:23] <Slike> i found what it is, but not really how to get one and how it works more in a practical way
[05:23] <Slike> are there any good resources to get more info about that?
[05:25] <kiko> Slike, there are many. did you do a google query for "gpg tutorial"?
[05:25] <kiko> I think there is even a link on launchpad.net that takes you to one
[05:26] <kiko> malcc, can you try the patch at https://devpad.canonical.com/~andrew/paste/fileFtEEH5.html -- ?
[05:26] <kiko> malcc, and then instead of calling c_c_c_c just evict the publication and its SPR?
[05:26] <matsubara> Slike: https://help.ubuntu.com/community/GnuPrivacyGuardHowto
[05:27] <malcc> kiko: I'll try it
[05:27] <kiko> thanks. it is freshly baked just for you.
[05:27] <carlos> BjornT, bradb: I'm not able to know who linked https://launchpad.net/products/rosetta/+bug/3 with Ubuntu distribution from the +activity page
[05:27] <Ubugtu> Malone bug 3 in rosetta "Custom links for each translation team." [Wishlist,Confirmed]  
[05:27] <carlos> is that normal?
[05:27] <Slike> i did some research on google but some things left me in doubt... for example: "Comment Think of this as pico-biography of yourself - e.g. "OpenSkills member"." (from openskills site)
[05:28] <kiko> carlos, sorta
[05:28] <Slike> matsubara: thx, I'll check the link
[05:29] <carlos> kiko: 'sorta' because it's normal because we don't have it implemented? or because it's the way it works?
[05:29] <bradb> carlos: It was "bisho", fwiw. https://launchpad.net/distros/ubuntu/+bug/3/+editstatus
[05:29] <Ubugtu> Malone bug 3 in rosetta "Custom links for each translation team." [Wishlist,Confirmed]  
[05:29] <carlos> bradb: he rejected it
[05:29] <bradb> I don't think it's horribly intentional that +activity doesn't show that
[05:29] <elmo> jamesh: ehm, launchpad and wiki both work fine for me with OCSP turned on
[05:29] <bradb> carlos: he created it too
[05:30] <carlos> Hmm, I see
[05:30] <carlos> that information is a bit hidden...
[05:31] <elmo> ARGH. STOP KILLING ASUKAS SSHD.  KTHX.
[05:32] <carlos> elmo: I'm working on it...
[05:41] <kiko> malcc, thumbs up or.. down?
[05:41] <kiko> hey bradb, are you around?
[05:41] <bradb> kiko: hi
[05:41] <kiko> I had a question for you
[05:42] <malcc> kiko: A big thumbs down to how long it takes to run soyuz-set-of-uploads.txt
[05:42] <kiko> malcc, life is full of ugly surprises
[05:42] <malcc> kiko: Thumbs are yet to be turned in a final direction on your cache clearing, due to the above
[05:42] <kiko> malcc, it takes like 5 minutes on my box
[05:43] <malcc> kiko: Yes, but then you realise you spelled a function wrong and have to run it again
[05:43] <kiko> malcc, I was concurring with you!
[05:44] <malcc> kiko: Ah cool. In that case, yes, sucks don't it?
[05:44] <kiko> it absolutely sucks black rocks of doom
[06:17] <ddaa> lemme write some code goddammit!
[06:19] <LarstiQ> Well, the positive side is that you're no longer bothered by such things. Shame about not writing code though.
[06:19] <ddaa> Well, I'm busy telling other people how they should write the code I want.
[06:20] <ddaa> In management jargon, we call that "higher leverage activities" :)
[06:20] <LarstiQ> hmm :)
[06:22] <ddaa> RMS is said to be a master at this sort of things: nagging people into doing what he thinks right. That probably does not help his popularity, but it appears to be effective.
[06:22] <danilos> ddaa: you're hugely popular, y'a know?
[06:23] <danilos> everybody loves ddaa! I love ddaa!
[06:23] <ddaa> danilos: I'm uncertain how to take that. So in doubt, I'll take it at face value ;)
[06:24] <danilos> :)
[06:24] <LarstiQ> haha :)
[06:25] <kiko> malcc, so, howditgo?
[07:50] <kiko-fud> malcc, cprov: any news
[07:50] <LarstiQ> kiko: any rosetta copyright news?
[07:51] <kiko> damn LarstiQ, but not from me. did SteveA get back to you?
[07:52] <cprov> kiko: dunno, nothing running at mawson.
[07:56] <bradb> seb128: ping
[07:56] <seb128> bradb: pong
[07:56] <bradb> seb128: is https://launchpad.net/products/malone/+bug/56349 still an issue?
[07:56] <carlos> LarstiQ: we had a meeting last week
[07:57] <carlos> LarstiQ: SteveA is talking about legal aspects of it with some people that understand more the problem
[07:57] <kiko> cprov, hmm, bummer.
[07:57] <bradb> seb128: It should be fixed now, but just thought I'd double-check with you.
[07:58] <seb128> bradb: seems to be fine, feel free to close it, I'll reopen if I face a such example again ;)
[07:58] <bradb> seb128: thanks
[07:58] <seb128> bradb: thank you for fixing it!
[07:58] <bradb> seb128: np :)
[07:58] <LarstiQ> kiko: I haven't seen any, no.
[07:59] <LarstiQ> carlos: ah, any chance of an eta on that? :/
[07:59] <seb128> bradb: BTW since you are around, quick question, is the upstream task dialog likely to be updated soon so we don't need to click on the box, pick a bug tracker and add the bug number
[07:59] <kiko> seb128, that's one of BjornT's next tasks.
[07:59] <seb128> bradb: you know the change we spoke about during the summit to Paris, just copying the bugzilla URI 
[07:59] <bradb> BjornT: ^^
[08:00] <seb128> kiko: ah, nice
[08:00] <bradb> When bug watches work with URLs I will be drunk off happiness
[08:01] <highvoltage> hi. on the launchpad FAQ it says certain parts of launchpad is available under free licenses. is there a list somewhere of which components the free ones are?
[08:02] <carlos> LarstiQ: no idea, SteveA is the only one that could give you it. Just note that it's being a priority for us right now, so I don't think it will take much more time
[08:03] <LarstiQ> carlos: ok
[08:08] <jordi> carlos: have you been able to look at those "KDE stuff missing" mails?
[08:09] <jordi> ie, why does konversation have a template but no translations?
[08:09] <jordi> hm, actually it does have translations now
[08:11] <jordi> apparently they are the dapper files
[08:11] <carlos> jordi: did you see the bug reports?
[08:11] <jordi> kopete is missing all l10n files
[08:11] <carlos> I already implemented the code to do the approvals automatically
[08:11] <jordi> https://launchpad.net/products/rosetta/+bug/58579 ?
[08:11] <carlos> It's in jamesh's review queue and I will request to cherry pick it
[08:12] <jordi> https://launchpad.net/products/rosetta/+bug/58526
[08:12] <carlos> no, I didn't see that concrete bug
[08:12] <jordi> ooh, I see your comment here
[08:12] <carlos> yeah
[08:12] <jordi> I'll link to this ontthe mailing list.
[08:12] <jordi> carlos: should that fix most of the KDE stuff?
[08:13] <carlos> yeah
[08:13] <carlos> I did a bunch of fixes
[08:13] <carlos> It should also fix GNOME's documentation
[08:14] <carlos> jordi: ok, thanks for handling it
[08:15] <carlos> kopete is not our problem it lacks any .po file...
[08:18] <jordi> reassign bug then?
[08:19] <jordi> just did
[08:20] <jordi> doh
[08:20] <jordi> we both did :D
[08:21] <carlos> ;-)
[08:21] <carlos> jordi: kopete upstream??
[08:21] <carlos> jordi: that's not right, it's a problem in Ubuntu! ;-)
[08:22] <jordi> I noticed I fucked up there. How can i fix that?
[08:22] <carlos> reassign it again to rosetta
[08:22] <carlos> as rejected
[08:23] <salgado> kiko, can you have another look at https://launchpad.canonical.com/PersonCreationRationale? (there are some other questions there)
[08:24] <jordi> carlos: hmm, apparently no permissions
[08:25] <carlos> kiko: could you help here?
[08:25] <carlos> https://launchpad.net/products/rosetta/+bug/58579
[08:25] <carlos> kiko: that bug should have the 'upstream' task pointing to Rosetta
[08:29] <kiko> salgado, not today, hmmm
[08:30] <kiko> carlos, it can't be changed, it's a bug.
[08:30] <carlos> oh, I see
[08:30] <carlos> ok
[08:33] <matsubara> carlos, jordi: could you take a look at: https://launchpad.net/products/rosetta/+bug/58548 ?
[08:34] <carlos> matsubara: it's related to the bugs we are talking about right now
[08:34] <carlos> It's a dupe
[08:34] <carlos> thanks
[08:34] <danilos> matsubara: I think it's the problem of non-standard imports, I think
[08:35] <danilos> carlos, jordi: I think I've seen some of those POT files in the queue
[08:35] <danilos> (for some of the bugs which were reported)
[08:35] <carlos> danilos: yeah, that's the problem
[08:35] <carlos> but I already wrote code to handle them
[08:36] <carlos> danilos: jamesh has my branch in his review queue
[08:36] <danilos> carlos: ah, ok, I'm just checking if I got it right :)
[08:37] <danilos> carlos: great
[08:39] <kiko> BjornT, have some time to review a patch?
[08:39] <kiko> BjornT, it does comment rendering in python 
[08:39] <BjornT> kiko: sure.
[08:40] <BjornT> kiko: have you done some testing to see how much faster it is?
[08:40] <kiko> BjornT, nope. I can test in a bit of course
[08:41] <BjornT> kiko: that'd be good. i'm fairly confident that moving the rendering to python will be faster, but i'd like to make sure that's really the case.
[08:42] <kiko> mmkay
[08:45] <kiko> bradb, BjornT: is there an easy API for adding a text comment?
[08:45] <BjornT> there should be
[08:45] <kiko> I agree there should be
[08:45] <kiko> but is there?
[08:46] <bradb> kiko: IMessageTarget.messageFromText or something? /me has to check
[08:46] <kiko> k
[08:46] <kiko> that's fine I guess
[08:47] <BjornT> kiko: there's at least IBugMessageSet.createMessage
[08:48] <bradb> kiko: or IMessageTarget.newMessage
[08:49] <bradb> i.e. bug.newMessage(owner, subject, content)
[08:55] <kiko> bradb, that seems to want a message object.
[08:56] <bradb> kiko: it creates a message object, AFAICT
[08:56] <bradb>     def newMessage(self, owner=None, subject=None, content=None, parent=None):
[08:56] <bradb>         """Create a new Message and link it to this bug."""
[08:56] <bradb>         msg = Message(
[08:56] <bradb>             parent=parent, owner=owner, subject=subject,
[08:56] <bradb>             rfc822msgid=make_msgid('malone'))
[08:56] <bradb>         MessageChunk(message=msg, content=content, sequence=1)
[08:56] <bradb> etc.
[09:06] <kiko> flacoste, wrap your mail dude!
[09:07] <flacoste> kiko: is it a problem with all my mail or just the last one?
[09:07] <kiko> the last one!
[09:07] <flacoste> kiko: I hit by error an HTML formatting key, so that might have switch the format from ASCII to HTML
[09:07] <kiko> ah mmm
[09:07] <kiko> carlos, you got space :-P
[09:08] <carlos> I saw it ;-)
[09:09] <flacoste> kiko: yeah, it sent it as content-type=multipart/alternative, ASCII and HTML versions, sorry
[09:09] <kiko> sure
[09:33] <carlos> night guys
[09:38] <kiko> BjornT, bradb: sent. the benchmark was a bit disappointing but.. it's wierd that this is so slow in production now that I have measured it.
[09:38] <kiko> I can't see what's so slow
[09:50] <flacoste> kiko: you underestimate me!
[09:51] <kiko> flacoste, but you had to preserve the +tickets part of the URL, no?
[09:51] <flacoste> the url is https://launchpad.net/distros/ubuntu/+source/yelp/+tickets
[09:52] <flacoste> computed from: canonical_url(sourcepackage) + '/+tickets'
[09:52] <flacoste> kiko: ok, I see what you mean, we lose other search criteria
[09:53] <flacoste> kiko: please fill a bug about that if you think it is important
[09:53] <kiko> flacoste, well, what I was pointing out is that you are linking the text of the source package name to the +tickets page
[09:53] <kiko> which is somewhat inconsistent with the rest of launchpad
[09:53] <flacoste> kiko: right, but convenient from a user perspective
[09:53] <kiko> sometimes. :)
[10:04] <kiko> matsubara, what's the bug for the bug-with-many-comments timeout?
[10:04] <matsubara> kiko: bug 54303
[10:05] <kiko> thanks
[10:07] <kiko> flacoste, maybe you should re-read my message :)
[10:10] <flacoste> kiko: well, now that you explained to me what you meant, your original messages makes sense :-)
[10:10] <kiko> heh
[10:10] <flacoste> kiko: "the source package page in question" I interpreted that as the +tickets page of the source package
[10:26] <kiko> canonical.testing.layers.LayerInvariantError: Component architecture should not be available
[10:26] <kiko> has anybody seen this? any clue what's up?
[10:28] <bradb> kiko: https://lists.ubuntu.com/mailman/private/launchpad/2006-August/010874.html
[10:29] <bradb> and https://launchpad.net/products/launchpad/+bug/55041
[10:54] <lifeless> BjornT: ?
[10:59] <ddaa> Hey lifeless
[11:00] <ddaa> I finally came around to followup on PrivateBranches
[11:00] <lifeless> good ;)
[11:00] <ddaa> Ping me when you need another round
[11:01] <ddaa> lifeless: anything you'd like to talk about? I'm heading out.
[11:02] <kiko> BjornT, bradb: if you can get some review lovin there until tomorrow I'll be able to land these changes before leaving for vacation, btw
[11:03] <kiko-afk> let me finish this report
[11:03] <bradb> kiko-afk: won't have time today, unfortunately. possibly tomorrow.
[11:03] <kiko-afk> sure.
[11:07] <ddaa> good night folks
[11:10] <lifeless> ddaa: gnight
[11:10] <lifeless> ddaa: sorry was reading mail
[11:56] <matsubara> bradb: do you think your work on bug 48860 will take care of bug 53484? (Although I couldn't reproduce what the guy reported in 53484)
[11:56] <Ubugtu> Malone bug 48860 in malone ""Also notified" makes difficult to unsubscribe" [Critical,In progress]  http://launchpad.net/bugs/48860
[11:56] <Ubugtu> Malone bug 53484 in launchpad "Unsubscribing from a duplicated bug does not unsubscribe user" [Untriaged,Unconfirmed]  http://launchpad.net/bugs/53484
[12:10] <Seveas> jordi, meeting time in #ubuntu-meeting