[02:02] <wgrant> spm: Around?
[02:02] <spm> wgrant: yarp, sup?
[02:03] <spm> it always worries me, when a fast response is followed by a long pause. implies "zomg lots of typing problem coming right up"
[02:04] <wgrant> spm: I'm working on Soyuz ddeb support, and I'd like to confirm that there aren't already any in the DB, because if any are there then they are broken.
[02:04] <wgrant> I am hoping that 'SELECT COUNT(*) FROM binarypackagefile WHERE filetype=4;' will return 0.
[02:04] <spm> hope, springs eternal...
[02:05] <spm> wgrant: sadly in this case, it does spring eternal. count == 16
[02:05] <wgrant> Crap.
[02:06] <spm> doing a Q&D sel *; suggests they may be related in some way; all are nearly sequential libraryfile
[02:10] <wgrant> spm: SELECT person.name, archive.name, libraryfilealias.filename FROM binarypackagefile JOIN libraryfilealias ON libraryfilealias.id = binarypackagefile.libraryfile JOIN binarypackagerelease ON binarypackagefile.binarypackagerelease = binarypackagerelease.id JOIN binarypackagebuild ON binarypackagebuild.id = binarypackagerelease.build JOIN packagebuild ON packagebuild.id = binarypackagebuild.package_build JOIN archive ON archive.id = ...
[02:10] <wgrant> ... packagebuild.archive JOIN person ON person.id = archive.owner WHERE binarypackagefile.filetype = 4;
[02:11] <spm> wgrant: hrm. I dunno. surely you can fit a *few* more joins in there???
[02:12] <wgrant> Heh, probably.
[02:12]  * spm remembers fondly the 16+ join we had at #job-1
[02:12] <spm> huh. yes. nicely guessed, same pacakges. will paste...
[02:13] <spm> wgrant: http://paste.ubuntu.com/462294/
[02:13] <wgrant> Craaaaaap primary archive.
[02:13] <wgrant> At least it's only one build.
[02:14] <wgrant> Thanks.
[02:14] <spm> np
[02:15] <spm> wgrant: so, in laymans terms - what does that actually mean/imply. that it's broken, sure - but what does that imply?
[02:15] <wgrant> Oh, they were all rejected, anyway.
[02:15] <wgrant> So there may not be any DB surgery required later on.
[02:16] <spm> lack of DB surgery is always welcome :-)
[02:16] <wgrant> spm: Basically, ddebs must always be linked to a deb, or they get lost and float around in space forever.
[02:16] <spm> chewup librarian space? or worse?
[02:16] <wgrant> Stay around in the archive forever, basically.
[02:16] <wgrant> And chew up librarian space, I guess, yes.
[02:17] <spm> this would be uncool on both fronts.
[02:17] <wgrant> Now, of course, ddebs have been accepted for a year or so, but the code to link them was never written.
[02:17] <spm> ahhh! I see. mucch becomes clearer.
[02:19] <wgrant> But in this case they never made it into the archive, so we are reasonably OK.
[02:21] <spm> kk
[08:58] <lifeless> wgrant: hi
[08:58] <lifeless> this sort of VWS drives me batty:
[08:58] <wgrant> lifeless: Hi.
[08:58] <lifeless> +        self.debug("Dominating packages...")
[08:58] <lifeless> +
[08:58] <lifeless> +        for name in pubs.keys():
[08:58] <wgrant> Oy, 'Work in progress' :P
[08:59] <lifeless> please see PEP8 :) - only do that when there is a significant difference mid-function
[08:59] <lifeless> wgrant: 'proposed for merging' -> instant review for you
[09:02] <wgrant> bigjools: Hi. When you have a moment, I'd like to discuss ddebs.
[09:02] <elmo> wgrant: or your money back!
[09:03] <wgrant> Heh/
[09:04] <wgrant> Also, it'd be reallly nice if launchpad-bugs-owner would stop spamming me.
[09:04] <lifeless> yes
[09:04] <lifeless> uhm
[09:04] <lifeless> I think matsubara was doing something about that; I'm sure he's here somewhere ;)
[09:06] <matsubara> lifeless, wgrant: I found out why and described how to fix in the thread. I didn't do it because I don't have the permission
[09:06] <thumper> what is VWS?
[09:06] <lifeless> matsubara: what permission is needed?
[09:06] <lifeless> thumper: vertical white space
[09:06] <wgrant> thumper: Vertical whitespace.
[09:06] <wgrant> matsubara: There was a thread?
[09:06] <lifeless> wgrant: internally, I think
[09:07] <wgrant> Ah, there.
[09:07] <matsubara> lifeless, I think lp admin. we just need to remove ~launchpad as the default review team IIRC
[09:07] <wgrant> No, it was on the public one.
[09:07] <matsubara> yeah, I think it's in lp-dev
[09:07] <lifeless> matsubara: on https://code.edge.launchpad.net/~launchpad-pqm/launchpad/devel ?
[09:08] <lifeless> hmm, we should change the owner to a steering team too.
[09:08] <lifeless> matsubara: who should it be ?
[09:08] <matsubara> lifeless, ~launchpad-reviewers seems to be the correct choice
[09:09] <bigjools> wgrant: ok, although I'm not sure when I will have time when you're awake
[09:09] <lifeless> mthaddon: can you change the default reviewer on lp devel, db-devel, production etc etc etc to be launchpad-reviewers? thanks.
[09:10] <mthaddon> sure
[09:10] <lifeless> I can rt it if needed.
[09:11] <mthaddon> np
[09:12] <mthaddon> lifeless: just the "-devel" branches, I assume - not needed for the "-stable" branches. If so, done
[09:13] <lifeless> mthaddon: thats a great start; we can deal with future glitches as needed
[09:13] <mthaddon> k
[09:13] <lifeless> wgrant: ^
[09:13] <wgrant> lifeless, mthaddon, matsubara: Thanks.
[09:14] <wgrant> bigjools: Yeah, I suspected as much.
[09:14] <bigjools> it's probably best to send me an email
[09:14] <Aju> Hi!
[09:16] <Aju> While installation of lauchpad on my development machine, I am receiving the following error:
[09:16] <Aju> * Creating database "launchpad_empty".
[09:16] <Aju> * Installing PL/PythonU
[09:16] <Aju> createlang: language installation failed: ERROR:  could not access file "$libdir/plpython": No such file or directory
[09:16] <Aju> make[1]: *** [create] Error 1
[09:16] <Aju> make[1]: Leaving directory `/root/launchpad/lp-branches/devel/database/schema'
[09:16] <Aju> make: *** [schema] Error 2
[09:16] <wgrant> bigjools: Sure.
[09:16] <Aju> Please help.
[09:16] <wgrant> Aju: Install postgresql-plpython-8.4
[09:16] <Aju> It's already installed.
[09:17] <Aju> I have checked it.
[09:17] <wgrant> 8.4, not just 8.3?
[09:17] <Aju> Yes 8.4 ver.
[09:17] <wgrant> Do you have PostgreSQL 8.3 installed?
[09:17] <Aju> Yes
[09:18] <Aju> Do both versions conflict?
[09:18] <wgrant> Maybe it's using that. Do you have both postgresql-plpython-8.3 and postgresql-plpython-8.4 installed?
[09:18] <Aju> Let me check that.
[09:20] <Aju> Thanks a lot, it works.
[09:22] <Aju> Do I have to run the make schema script again?
[09:22] <Aju> I have just fired the command:
[09:22] <Aju> sudo -u postgres make create
[09:25] <wgrant> You should run 'make schema' again, yes.
[09:25] <Aju> Okay, thanks.
[09:55] <Aju> Hi!
[09:55] <Aju> I am receiving the following error, while running the 'make schema' command:
[09:55] <Aju> 2010-07-12 14:09:31 WARNING No permissions specified for [u'public.openidnonce', u'public.openidauthorization']
[09:55] <Aju> Traceback (most recent call last):
[09:55] <Aju>   File "security.py", line 413, in <module>
[09:55] <Aju>     sys.exit(main(options))
[09:55] <Aju>   File "security.py", line 179, in main
[09:55] <Aju>     reset_permissions(con, config, options)
[09:55] <Aju>   File "security.py", line 394, in reset_permissions
[09:55] <Aju>     con.commit()
[09:55] <Aju> psycopg2.ProgrammingError: server closed the connection unexpectedly
[09:55] <Aju>         This probably means the server terminated abnormally
[09:55] <Aju>         before or while processing the request.
[09:55] <Aju> make[1]: *** [create] Error 1
[09:55] <Aju> make[1]: Leaving directory `/root/launchpad/lp-branches/devel/database/schema'
[09:55] <Aju> make: *** [schema] Error 2
[10:05] <jtv> Aju: we're all sprinting right now, so a bit busy!  Sounds like your postgres is having a problem.
[10:12] <Aju> Okay, thanks
[11:04] <wgrant> sinzui: Should the error message shown when a package is not found be adjusted?
[11:04] <wgrant> At the moment it tells people to file bugs.
[11:04] <wgrant> But they are inevitably rejected.
[11:13] <sinzui> wgrant, yes in short. I ponder removing fedora and gentoo to wrong expectation
[11:15] <sinzui> wgrant, yes in short. I ponder removing fedora and gentoo to avoid setting wrong expectation
[11:16] <wgrant> sinzui: Removing the distributions? That doesn't seem like a good idea.
[14:28] <poolie> mthaddon, is it just me (or just this network) or are we getting a lot of 500s on the librarian?
[14:31] <mthaddon> poolie: let me take a look
[14:34] <mthaddon> not seeing a lot of 500s
[14:49] <poolie> mthaddon, https://bugs.edge.launchpad.net/launchpad-foundations/+bug/604620
[14:49] <_mup_> Bug #604620: intermittent 404 errors on existing librarian files <Launchpad Foundations:New> <https://launchpad.net/bugs/604620>
[15:07] <mthaddon> thx
[15:46] <jml> thumper, I'm going to delete "19881 branches associated with bug reports" from the code.launchpad.net homepage. Objections?
[16:10] <thumper> nope
[16:10] <thumper> jml: ^^^
[16:10] <jml> thumper, thanks.
[16:12] <StevenK> jml: Where are you hiding?
[16:12] <jml> StevenK, it's on the unsprint whiteboard
[16:12] <jml> StevenK, I can't remember how to spell it.
[16:13] <StevenK> jml: But I do want to talk to you about stuff you're working on
[16:13] <jml> StevenK, then come in and let's talk :)
[16:35] <mpt> So, there are now 12 bug statuses
[16:38] <mpt> I'm still hopeful that one day we'll have only six :-)