[15:00] <matsubara> #startmeeting
[15:00] <MootBot> Meeting started at 09:00. The chair is matsubara.
[15:00] <MootBot> Commands Available: [TOPIC], [IDEA], [ACTION], [AGREED], [LINK], [VOTE]
[15:00] <matsubara> Welcome to this week's Launchpad Production Meeting. For the next 45 minutes or so, we'll be coordinating the resolution of specific Launchpad bugs and issues.
[15:00] <matsubara> [TOPIC] Roll Call
[15:00] <MootBot> New Topic:  Roll Call
[15:00] <sinzui> me
[15:00] <gmb> me
[15:00] <gmb> (in for intellectronica)
[15:00] <henninge_> me
[15:00] <flacoste> me
[15:00] <bigjools> me
[15:01] <Ursinha> erm
[15:01] <Ursinha> me?
[15:01] <mrevell> me
[15:01] <matsubara> stub, herb, henninge?
[15:01] <stub> me
[15:01] <matsubara> rockstar: ?
[15:01] <henninge_> me!
[15:01] <herb> me
[15:01] <rockstar> me
[15:01] <rockstar> Sorry, was ill yesterday, still not at 1[[%
[15:01] <rockstar> 100%
[15:02] <matsubara> all right, everyone is here
[15:02] <matsubara> [TOPIC] Agenda
[15:02] <MootBot> New Topic:  Agenda
[15:02] <matsubara>  * Next meeting
[15:02] <matsubara>  * Actions from last meeting
[15:02] <matsubara>  * Oops report & Critical Bugs
[15:02] <matsubara>  * Operations report (mthaddon/herb/spm)
[15:02] <matsubara>  * DBA report (DBA contact)
[15:02] <matsubara> so next meeting, same time next week?
[15:03] <matsubara> I guess that's a yes
[15:03] <matsubara> all right
[15:03] <matsubara> [topic] * Actions from last meeting
[15:03] <MootBot> New Topic:  * Actions from last meeting
[15:03] <matsubara> * rockstar to work with beuno re: critical loggerhead (bug 156453)
[15:03] <matsubara> rockstar: any news about that one?
[15:03] <rockstar> matsubara, working on it.
[15:03] <Ursinha> +1
[15:04] <rockstar> I don't think it's something that's going to happen overnight.
[15:04] <Ursinha> rockstar, is it really critical?
[15:04] <rockstar> Ursinha, well, yes.
[15:05] <matsubara> rockstar: any eta?
[15:05] <rockstar> I bet the LOSAs think it's psat Critical.
[15:05] <henninge> me again
[15:05] <rockstar> matsubara, until we're sure what the problem is, I can't give you an ETA.
[15:06] <matsubara> rockstar: or can you give us regular status report on the bug report itself? critical bugs shouldn't be left like nobody is looking at them
[15:06]  * herb definitely thinks it's critical.
[15:06] <herb> particularly since I got a page about it right before the meeting. :)
[15:06] <rockstar> matsubara, I don't really have much to report on it.
[15:07] <rockstar> It's easy to make it leak memory, it's hard to see where it is leaking memory.
[15:07] <Ursinha> rockstar, nothing, like partial reports, what are you guys thinking to do
[15:07] <Ursinha> ?
[15:07] <Ursinha> oh
[15:07] <Ursinha> see
[15:07] <matsubara> rockstar: by looking at the report it seems that it's been stuck since 2008-11-06
[15:08] <rockstar> matsubara, I can put "Still working on this" every once in a while.  I just don't have specifics, unfortunately.
[15:08] <matsubara> right
[15:09] <rockstar> Okay, I'll do that.
[15:09] <matsubara> thanks rockstar
[15:09] <matsubara> [TOPIC]  * Oops report & Critical Bugs
[15:09] <MootBot> New Topic:   * Oops report & Critical Bugs
[15:10]  * matsubara hands the mic to Ursinha 
[15:10] <Ursinha> ok
[15:10] <Ursinha> mics make me nervous
[15:10]  * bigjools waits for the Karaoke
[15:10] <Ursinha> have two bugs and one timeout
[15:11] <Ursinha> matsubara's bug: 300320
[15:11] <Ursinha> argh
[15:11] <Ursinha> bug 300320
[15:11] <matsubara> that's not critical but it's blocking our work
[15:11] <Ursinha> so the bot isn't here
[15:11] <matsubara> I've asked herb to fix the permission
[15:11] <Ursinha> hahaha
[15:11] <Ursinha> ok
[15:11] <Ursinha> so matsubara filed this one
[15:12] <matsubara> but we need to find out what's resetting the permission every once in a while
[15:12] <herb> matsubara: trying to do some debugging on that, but will reset the permissions after the meeting.
[15:12] <Ursinha> matsubara, indeed, just got one of these before the meeting
[15:12] <matsubara> thanks herb. let me know any news on the report please
[15:12] <matsubara> flacoste: I'm not sure that's a foundations or registry issue, btw
[15:12] <Ursinha> ok
[15:13] <sinzui> Bug 300183 is critical. I just made it critical
[15:13] <flacoste> matsubara: registry
[15:13] <Ursinha> the other is for bugs, bug 300324
[15:13]  * Ursinha kicks ubottu 
[15:13] <flacoste> sinzui: you are aware of bug 300320?
[15:13] <matsubara> flacoste: I'll re-assign and coordinate with barry and sinzui then if it's a code or LP config problem. thanks
[15:13] <Ursinha> it's the bug regarding that bug that had its comment 0 deleted accidentally
[15:13] <gmb> Ursinha: I've just triaged that one.
[15:14] <gmb> The simple fix is to delete all of bug 297388's subscribers
[15:14] <gmb> and to mark it private
[15:14] <gmb> hush, ubottu
[15:14] <sinzui> flacoste: I saw it today. I believed it related install problem that is bug 300183
[15:14] <gmb> Doing that will make it invisible, to all intents and purposes.
[15:14] <stub> The OOPS dir permissions are probably being reset by rsync, so the fix is to ensure permissions are set correctly on forster or to tell rsync to make everything locally world readable
[15:14] <Ursinha> gmb, thanks, it's really annoying and I'm just waiting for some nice bugs guy to solve that for us
[15:15] <gmb> Ursinha: Ultimately we want to fix bug 297411
[15:15] <Ursinha> hahaha you just caused an oops
[15:15] <gmb> But it's not easy to do.
[15:15]  * Ursinha kicks ubottu again
[15:15] <matsubara> thanks stub.
[15:15] <Ursinha> gmb, I saw BjornT 's comment
[15:16] <Ursinha> gmb, but for now we need something to stop this bug to oops
[15:16] <stub> gmb: If we only hit the red button for spam, we can do it by changing a load of constraints to ON DELETE CASCADE.
[15:16] <Ursinha> it's filling the summaries with oopses
[15:16] <gmb> Ursinha: Well, hiding it should do that.
[15:16] <gmb> Because veeryone will get "you can't access this bug" eros.
[15:16] <gmb> Erk.
[15:16] <gmb> Waaaay wrong word, there.
[15:16] <gmb> *errors
[15:16] <Ursinha> gmb, hm
[15:17] <Ursinha> gmb, is it the easiest thing to do?
[15:17] <gmb> Ursinha: Yes. By far.
[15:17] <gmb> The trouble is that the Bug table has a lot of dependencies
[15:17] <gmb> And the dependencies also have a lot of dependencies
[15:18] <gmb> So we have to find all the things that might depend upon the Bug record before we can DELETE it.
[15:18] <Ursinha> gmb, well, but do you need that when hiding?
[15:18] <Ursinha> considering hiding != deleting
[15:19] <gmb> UPDATE Bug SET private = True WHERE id = 287411;
[15:19] <gmb> DELETE FROM BugSubscription WHERE bug = 297411;
[15:19] <gmb> (yes, the first number was wrong)
[15:19] <gmb> And that should do it.
[15:19] <Ursinha> gmb, making it private will prevent privileged people to get the oops?
[15:19] <matsubara> gmb: can you add that to LaunchpadProductionStatus page and ask the Losas to run it?
[15:19] <gmb> Good question.
[15:20] <gmb> matsubara: Sure.
[15:20] <stub> gmb: But we can ignore a lot of the dependencies - if this is spam protection, those dependencies won't exist.
[15:20] <matsubara> [action] gmb to add sql to hide bug 297411 as a fix for bug 300324
[15:20] <MootBot> ACTION received:  gmb to add sql to hide bug 297411 as a fix for bug 300324
[15:20] <gmb> stub: Is there a way to do a DELETE without Postgres erroring on un-deleted dependenices?
[15:20] <Ursinha> another oops coming..
[15:21] <matsubara> shit, that action is wrong
[15:21] <matsubara> [action] gmb to add sql to hide bug 297388 as a fix for bug 300324
[15:21] <MootBot> ACTION received:  gmb to add sql to hide bug 297388 as a fix for bug 300324
[15:21] <gmb> Ursinha: If ubottu listens to its own drivel.
[15:21] <gmb> Damn.
[15:21] <stub> gmb: No, but we can put up with an oops in that case since an admin is hitting the button when they shouldn't
[15:21] <Ursinha> arrrrr
[15:22] <gmb> stub: I'm not quite sure that I'm on your wavelength here. Are you talking about a fix for the OOPS Ursinha raised or for bug 297411 in general?
[15:22]  * gmb avoids another OOPS
[15:22] <stub> gmb: Bug deletion in general (so wrong channel I guess)
[15:23] <matsubara> Ursinha: anything else?
[15:23] <gmb> stub: Ah right. Yes, let's talk about that elsewhere and not pollute the meeting.
[15:23] <Ursinha> thanks gmb :P
[15:23] <matsubara> I think we can discuss the bug deletion bug in the mailing list or whatever. it's not a simple fix anyway
[15:23] <Ursinha> matsubara, I have one timeout oops
[15:23] <Ursinha> OOPS-1055EC45
[15:23] <Ursinha> I'd like someone to take a look on it
[15:24] <Ursinha> few occurrences but high sql time, after the rollout
[15:24] <Ursinha> ubottu, I hate you man
[15:24] <Ursinha> lol
[15:24] <Ursinha> https://lp-oops.canonical.com/oops.py/?oopsid=OOPS-1055EC45
[15:24] <matsubara> sinzui: ^
[15:25] <matsubara> can you take a look?
[15:25] <Ursinha> I have an incredible lag today
[15:26] <sinzui> yuck
[15:26] <flacoste> matsubara: could you make the left pane on that page viewport fixed (so that it is always available wherever you are on the oops)?
[15:26] <flacoste> matsubara: the oops report page i mean
[15:26] <Ursinha> flacoste, good idea
[15:26] <matsubara> flacoste: yeah, got that. will do
[15:26] <matsubara> flacoste: and thanks for the suggestion :-)
[15:27] <matsubara> [action] ursinha to file a bug about OOPS-1055EC45 and coordinate with Registry to get it fixed
[15:27] <Ursinha> this is all from me
[15:27] <MootBot> ACTION received:  ursinha to file a bug about OOPS-1055EC45 and coordinate with Registry to get it fixed
[15:28] <matsubara> let's move on then
[15:28] <matsubara> thanks Ursinha and everyone else
[15:28] <matsubara> [topic] * Operations report (mthaddon/herb/spm)
[15:28] <MootBot> New Topic:  * Operations report (mthaddon/herb/spm)
[15:28] <sinzui> matsubara: flacoste I can pass this to Edwin because I think he has  day for this.
[15:28] <herb>  2008-11-19: Rolled out r7316 to production.
[15:28] <herb> - Bugs #118625 and #156453 continue to be a problem causing us to restart codebrowse on a number of ocassions this week. As we discussed earlier.
[15:28] <herb> - We can probably mark bug #247227 as Fix Released since the app servers have been stable for several weeks now.
[15:28] <herb> - Do we have a decision on if/when there will be a re-roll?
[15:28] <Ursinha> thanks guys
[15:28] <matsubara> thanks sinzui
[15:28] <matsubara> Ursinha: add that the report ^ :-)
[15:28] <matsubara> s/the/to the/
[15:29] <Ursinha> matsubara, will do
[15:29] <matsubara> herb: I talk to kiko about it today and let you know
[15:29] <matsubara> about the re-roll I mean
[15:29] <herb> matsubara: ok
[15:29] <Ursinha> I'll ask him to join
[15:30] <kiko-fud> yes dears
 - Do we have a decision on if/when there will be a re-roll?
[15:30] <kiko-fud> tonight 22:00 UTC if at all
[15:30] <kiko-fud> I have spoken
[15:30] <matsubara> cool. thanks kiko-fud
[15:31] <Ursinha> ok, great
[15:31] <matsubara> thanks herb
[15:31] <Ursinha> thanks kiko-fud
[15:31] <matsubara> [topic] * DBA report (DBA contact)
[15:31] <MootBot> New Topic:  * DBA report (DBA contact)
[15:31] <herb> thanks Ursinha, matsubara, kiko-fud
[15:31] <herb> et al
[15:31]  * matsubara hands the mic to stub 
[15:31] <stub> Our replica production database built happily, and maintaining the replica does not seem to be adding noticable load. My worries about diskspace where thankfully unfounded.
[15:31] <stub> We may find that chokecherry's load is too high when we start the appservers using the replica during staging rebuilds. If this turns out to be the case, we have the choice of not using the replica or moving staging somewhere else.
[15:31] <stub> oot
[15:33] <matsubara> stub: and the plan is to have that on production next cycle?
[15:33] <stub> Its just a config change - we can switch it on whenever.
[15:34] <matsubara> cool.
[15:34] <stub> I've got a branch prepared with the config changes and kiko knows already
[15:34] <matsubara> Ursinha: ^ got your answer for waht you asked me yesterday? :-0
[15:34] <matsubara> :-)
[15:34] <matsubara> great
[15:34] <Ursinha> matsubara, yes :)
[15:34] <matsubara> thanks stub
[15:34] <matsubara> anything else before I close?
[15:35] <flacoste> matsubara: i'll land that branch
[15:35] <Ursinha> thanks matsubara and statik
[15:35] <Ursinha> errr
[15:35] <Ursinha> and stub
[15:35] <Ursinha> sorry statik
[15:35] <matsubara> Thank you all for attending this week's Launchpad Production Meeting. See the channel topic for the location of the logs.
[15:35] <matsubara> #endmeeting
[15:35] <MootBot> Meeting finished at 09:35.
[15:35] <rockstar> Thanks matsubara
[15:35] <Ursinha> thanks matsubara
[15:36] <Ursinha> thanks guys
[15:36] <henninge> thanks Ursinha, don't forget to turn off the mic! ;)
[15:36] <Ursinha> henninge, :D