[02:45] <wallyworld_> wgrant: since upgrading to postgres 9.1, my /var/lib/postgresql/9.1/main/base directory has gobbled up all my diskspace in / and now i'm really low. do you know how to fix?
[02:46] <wgrant> wallyworld_: Do you have lots of old testrunner databases, perhaps?
[02:46] <wallyworld_> maybe. how to i check?
[02:46] <wgrant> \l in psql
[02:47] <wallyworld_> wgrant: yes, so it seems i have 100s of the little fuckers
[02:48] <wallyworld_> thanks, is there a quick way to delete them all?
[02:49] <wgrant> Um, easiest way might be to just rebuild your cluster from scratch
[02:50] <wgrant> ie. rerun utilities/launchpad-database-setup
[02:50] <wgrant> As long as you have nothing important in your pg9.1 installation
[02:50] <wallyworld_> yeah, was thinking i would need to do that.
[02:50] <wallyworld_> no, just lp
[02:50] <wallyworld_> thanks
[07:44] <lifeless> wgrant: nice bug - 1071562
[07:44] <lifeless> stub: o/
[07:44] <stub> lifeless: o/
[07:46] <stub> awsome, our ppas scale that well!
[08:26] <wgrant> stub: Well, not exactly...
[08:26] <wgrant> lifeless: Yeah
[08:26] <wgrant> I spent today starting to clean that up
[08:27] <wgrant> There's only about a million extra pubs
[08:46] <lifeless> wheee
[08:46] <lifeless> much fallout ?
[08:49] <stub> Ideally, this sort of thing should clean itself up automatically - heuristics to remove unloved publications. I guess heuristics is a scary word to use when discussing deleting stuff though.
[08:50] <adeuring> good morning
[08:51] <lifeless> adeuring: hi
[08:51] <adeuring> hi lifeless!
[08:59] <czajkowski> morning folks
[09:00] <czajkowski> stub: just the person
[09:00] <czajkowski> stub: https://support.one.ubuntu.com/Ticket/Display.html?id=20963  I need a DB person, sinuzi has left a comment on the last bit
[09:02] <wgrant> czajkowski: sinzui's last comment is not correct
[09:02] <wgrant> OpenID identifiers can be transferred if the SSO account's primary email address shows up on a different LP account.
[09:02] <wgrant> That's likely to be what happened here.
[09:06] <wgrant> czajkowski: It sounds like the user might want to merge the old LP account into the new, perhaps
[09:06] <wgrant> They can use https://launchpad.net/people/+requestmerge to do that
[09:09] <czajkowski> wgrant: they've tried that and failed also
[09:09] <czajkowski> it's gone back and forth from us to isd for weeks now, be nice to give them a resolution one way or another
[09:10] <wgrant> czajkowski: Failed how?
[09:10] <wgrant> Oh, is this the one the bug was filed about a couple of weeks back?
[09:10] <wgrant> And fixed a day later...
[09:11] <wgrant> No, different account
[09:11] <wgrant> So, what failure?
[09:11] <wgrant> Simply saying it failed is not entirely useful :)
[09:11] <czajkowski> wgrant: gimmie a tick trying to find log
[09:11] <czajkowski> and multitasking before I've had a cuppa tea is not helping
[09:12] <wgrant> Heh
[09:12] <czajkowski> wgrant: seems te user has been dealing with 4 people and is possibly a little confused and said it faied as it didnt work
[09:12] <czajkowski> perhaps due to the bug wallyworld_ has just fixed
[09:13] <czajkowski> https://answers.launchpad.net/launchpad/+question/212913 similar issue. but bug now fixed.
[09:20] <stub> .me has a look
[09:21]  * czajkowski hands stub a bucket of tea also 
[09:25] <stub> The RT sounds like a request to merge andri-ch into andreichiver, which hasn't been done
[09:26] <wgrant> That is indeed what I would suggest
[09:26] <stub> Then perhaps clean out openid identifiers *if* they can't log in.
[09:27] <stub> Its confused by all the openid noise at the start, which is irrelevant to the actual request
[09:27] <stub> Where is our merge form?
[09:28] <wgrant> 20:06:08 < wgrant> They can use https://launchpad.net/people/+requestmerge to do that
[09:28] <wgrant> :)
[09:28] <wgrant> But czajkowski says that they have said it fails
[09:28] <stub> The admin one, I'll assume that the self help one is failing
[09:28] <wgrant> https://launchpad.net/people/+adminpersonmerge
[09:28] <wgrant> Or https://launchpad.net/people/+adminpeoplemerge
[09:28] <wgrant> Yeah, the latter
[09:30] <stub> webops: Per RT 20963, can you please merge andreichiver and andri-ch ? andreichiver is the account to keep.
[09:30] <mthaddon> checking
[09:31] <stub> I dropped my superpowers, first time I've missed it :)
[09:32] <mthaddon> stub: this is Ubuntu RT? I don't see that ticket
[09:32] <stub> (16:00:35) Laura (czajkowski): stub: https://support.one.ubuntu.com/Ticket/Display.html?id=20963  I need a DB person, sinuzi has left a comment on the last bit
[09:32] <stub> Ubuntu One
[09:32] <mthaddon> ah
[09:32] <stub> ECHAN
[09:33] <czajkowski> so many rt systems :)
[10:36] <wallyworld_> jml: hello
[10:36] <wallyworld_> sorry, wrong nic
[10:36] <wallyworld_> jam: hello
[10:37] <jam> wallyworld_: hey
[10:37] <wallyworld_> i just got back from soccer
[10:37] <wallyworld_> so, which medium do you want to use?
[10:38] <jam> wallyworld_: we've got a google hangout for the group, it is attached to the invite: https://plus.google.com/hangouts/_/188d69cd3499f77266a3d184bc2a9433292f8979#
[10:40] <wallyworld_> jam: i'm in the "you need to install plugin" loop from hell, let me see if i can escape the roundabout
[10:40] <jam> wallyworld_: k, we'll just chat behind your back :). But if you need us to switch to mumble, just let us know
[10:41] <czajkowski> wallyworld_: I found changing browsers helped that issue. used to happen me a lot using chromium, but not FF
[11:03] <wallyworld_> czajkowski: i got it working, thanks! i installed the deb by hand
[11:04] <czajkowski> ahh
[11:04] <czajkowski> yes I have had to do that in the past also
[11:04] <czajkowski> even when it was already there
[11:48] <rick_h> morning
[11:56] <czajkowski> rick_h: ello
[13:36] <czajkowski> rick_h: you not off today ?
[13:36] <rick_h> czajkowski: no, swapped for friday after thanksgiving
[13:36] <czajkowski> rick_h: https://bugs.launchpad.net/launchpad/+bug/1077941  one for orange
[13:37] <_mup_> Bug #1077941: changing maintainer of proprietary project gives incorrect message <privacy> <private-projects> <projects> <Launchpad itself:Triaged> < https://launchpad.net/bugs/1077941 >
[13:37] <czajkowski> can you mention it to deryck please.
[13:37] <rick_h> czajkowski: will do
[13:37]  * cjwatson goes back to trying to sort out the xx-copy-packages.txt failures I induced last week by trying to remove the sync copy path
[13:37] <cjwatson> Oh God the pain
[13:37] <rick_h> cjwatson: /me sends much coffee
[13:37] <czajkowski> cjwatson: I'll swap you for hiccups for over 90 mins shall I for pain!
[13:38] <cjwatson> Hmm.  No ta
[13:42] <rick_h> hah, for the other side of the world crowd wgrant wallyworld_ http://aws.typepad.com/aws/2012/11/asia-pacific-sydney-region-open.html
[13:42] <wallyworld_> \o/
[14:00] <jcsackett>  morning all.
[14:00] <czajkowski> jcsackett: ello
[14:01] <rick_h> morning jcsackett
[14:01] <czajkowski> grabing some lunch bbiab
[14:51] <jcsackett> abentley: i know you've got a call in a few moments. any chance you can fill me in on the mismatch card before then?
[14:51] <abentley> jcsackett: Sure.  Actually, the call's in an hour.
[14:51] <jcsackett> abentley: ah, ok.
[14:51] <abentley> jcsackett: Chat in the standup hangout?
[14:52] <jcsackett> sure.
[15:17] <czajkowski> rick_h: can you pop into lp please
[15:17] <rick_h> czajkowski: sure thing
[15:17] <czajkowski> thanks
[16:06] <rick_h> yay IE tests passed on first try woot!
[16:06] <czajkowski> whoo
[16:06] <czajkowski> good start to the week rick_h
[16:32] <rick_h> jcsackett: you fueled up for another review?
[16:32] <rick_h> https://code.launchpad.net/~rharding/launchpad/wire_new_banner/+merge/133927 or sinzui/deryck
[16:36] <jcsackett> rick_h: in the middle of a test case; i can look at it in a few though.
[16:36] <jcsackett> (just don't want to lose my train of thought)
[16:37] <rick_h> jcsackett: not a problem, thanks
[16:53] <abentley> bac: I've made some tweaks to the branch you reviewed on Friday.  Do you have a chance to take a look?  It's r16240: https://code.launchpad.net/~abentley/launchpad/optimize-spec-query/+merge/133716
[16:55] <jcsackett> rick_h: ok, taking a look now.
[16:55] <abentley> bac: BTW, the merge proposal page is completely lying about the contents of r16240.  It's actually http://bazaar.launchpad.net/~abentley/launchpad/optimize-spec-query/revision/16240
[16:57] <abentley> rick_h: When you saw these spurious changes that made it look like you were applying abel's code, was it on the merge proposal web page?
[16:59] <jcsackett> rick_h: this branch is a continuation of the previous one, right? any chance of resubmitting it with that as a prereq to cut down on diff noise? i feel like i'm rereading a lot here.
[17:00] <rick_h> abentley: yes
[17:00] <rick_h> jcsackett: it should be cut down on noise as the first branch is landed
[17:00] <rick_h> jcsackett: the noise in this one is the deletion of the old code, shouldn't be any big adds
[17:00] <abentley> rick_h: Was it one of the fold-out diffs, or the "Preview diff" at the bottom?
[17:01] <jcsackett> rick_h: yes, you're right. i'm mixing up when i looked at your branch last week and when i looked at the massive branch.
[17:01] <rick_h> abentley: preview at the bottom
[17:01] <rick_h> I was reviewing my diff before doing the MP comments
[17:01] <abentley> rick_h: Okay, never mind then.
[17:11] <abentley> deryck: Could you please have a look at my follow-on changes as we discussed on the call?  http://bazaar.launchpad.net/~abentley/launchpad/optimize-spec-query/revision/16240
[17:14] <deryck> abentley, sure
[17:14] <abentley> deryck: Thanks.
[17:15] <jcsackett> rick_h: r=me, with some comments.
[17:16] <rick_h> jcsackett: ty lookimg
[17:16] <rick_h> err ing
[17:18] <deryck> abentley, looks good to me.
[17:18] <abentley> deryck: Thanks.
[17:18] <deryck> np!
[17:19] <rick_h> jcsackett: good calls, thanks for the catches
[17:20] <jcsackett> rick_h: you're welcome.
[19:02] <rick_h> deryck: ping
[19:04] <deryck> rick_h, otp
[19:04] <rick_h> snap-l: deryck np