=== cprov [~cprov@200.158.100.251] has joined #launchpad [12:59] (dilys/#launchpad) Merge to rocketfuel@canonical.com/launchpad--devel--0: continue malone code reorganisation (patch-624) === stub [~stub@dsl-246.248.240.220.dsl.comindico.com.au] has joined #launchpad === BradB [~bradb@modemcable165.196-131-66.mc.videotron.ca] has joined #launchpad [04:38] Morning [05:26] !lilo:*! Of possible interest: #accounting, a channel for accounting support for small not-for-profit entities. If you have accounting experience, please stop by. Thanks! === BradB_ [~bradb@modemcable165.196-131-66.mc.videotron.ca] has joined #launchpad [07:53] (dilys/#launchpad) New bug 2119 for Launchpad/Database: Use of __del__ in sqlobject [07:53] (dilys/#launchpad) https://bugzilla.warthogs.hbd.com/bugzilla/show_bug.cgi?id=2119 [08:52] (dilys/#launchpad) Merge to rocketfuel@canonical.com/launchpad--devel--0: Improved PostgreSQL/Launchpad sample data test harness (now an order of magnitude faster) (patch-625) [09:06] (dilys/#launchpad) Merge to rocketfuel@canonical.com/launchpad--devel--0: Tabnanny putting on her jackboots for the whitespace impared (patch-626) === jblack [~jblack@static-209-158-45-74.scr.east.verizon.net] has joined #launchpad [09:12] spiv: around? === lulu [~lu@host217-37-231-28.in-addr.btopenworld.com] has joined #launchpad === Kinnison [~dsilvers@haddenham.pepperfish.net] has joined #launchpad [10:39] Morning [10:44] Morning === carlos [~carlos@69.Red-80-33-181.pooles.rima-tde.net] has joined #launchpad [11:11] who here has really slow star-merges? [11:11] as in longer than 2 minutes? [11:38] jblack: I'm fairly certain that is only the Mac OSX users, so that would be BradB_and Limi (I'm on Ubuntu now) [11:38] stub: I've been hearing of slow star-merges on x86 boxes too. === stub throws that theory out the window [11:39] stub: Well, that may play part too, if os x boxes tend to come with less memory. [11:39] I know that bradb only has 256 megs [11:40] I had problems on a box with 1GB [11:40] with libraries and local mirrors ? === Kinnison has never had a slow star-merge. I use Ubuntu on x86 with 512 megs of ram and have a revlib but not a local mirror of rocketfuel [11:41] Yes - I think you commented on it at the conference. I don't have the box any more though so I can't do proper comparisons or confirm that with 100% certainty. [11:41] but then again; I've only been doing simple stuff in my archive [11:41] stub: Ok. [11:43] I suspect Limi will have a reasonable amount of memory, so he might be your best bet at the moment. [11:44] Ok. I'll hunt him down [11:44] stub: we know hfs+ sucks :[. we're trying to identify the x86 problems, to reduce the scope of the problem. [11:44] what we are gonna do about the hfs+ users,I'm not sure right now. [11:45] yeah. according to my filesystem timings, os x is *1/6* the speed of reiserfs [11:46] running bonnie++ [11:46] ? [11:47] nothing so extravagant. various dd timings. [11:47] that would be a good basis for comparison actually, a bonnie ++ script to get disk comparisons, then a tla-script of some sort. [11:47] 5 meg file 50 meg file 1 gig file, consistantly about 1/6 [11:47] dd is 1/6th - sheesh. thats /sad/ [11:47] it might be the disk though... [11:47] I was about to ask - same hardware? [11:47] he claims its a reasonably modern machine. [11:47] No, not the same hardware. [11:48] a rather new, high end x86 laptop against a new-a-year-ago mac [11:48] the thing that struck me about bradb's machine was that it acted as if it didn't have buffer cache [11:51] It might not for all I know - it would be quite valid to limit free ram usage for disk cache in exchange for other caches === SteveA [~steve@adsl-213-190-44-43.takas.lt] has joined #launchpad [11:55] SteveA: do you publish summaries of the launchpad meetings anywhere? [11:55] hi [11:55] no, not usually [11:55] very ocassionally [11:56] points may come out as part of warthogs traffic [11:56] Right [11:56] would you find summaries very useful? [11:57] I think they would be useful; yes. [11:57] I find it quite hard to remember what everyone else has done [12:14] BradB_: ping [12:14] (a bit early, I think) [12:14] (dilys/#launchpad) Merge to rocketfuel@canonical.com/launchpad--devel--0: malone reorganisation (patch-627) [12:14] stub: hello [12:15] Morning [12:16] SteveA: Was there any luck with Plone and secure auth? [12:16] Last week, I was going to request a "malone deployment" meeting for today [12:16] but, the email languished in my outbox [12:17] it would be good if you, brad, elmo (perhaps) and sabdfl talked together today about getting malone running on mawson [12:17] over the next few days [12:17] I have no reply from roche, so I need to chase that up [12:17] then again, brad could install the patch for us, which might be easier [12:18] I can test what the cookies look like after that patch is applied === sabdfl [~mark@host217-37-231-28.in-addr.btopenworld.com] has joined #launchpad [12:19] morning all lunchpadders [12:22] Morning sabdfl === Kinnison writes huuuuge views for lucille :-) [12:23] well, they're not that big, but they're useful [12:49] stub: landed a series of big malone reorganisations over the weekend and this morning [12:49] BradB_: ^^ [12:50] Yup - done a merge. Haven't looked closely at the latest iteration yet though. [01:01] (dilys/#launchpad) Merge to rocketfuel@canonical.com/launchpad--devel--0: Lucille-related DB stuff (again) (patch-628) === spiv has internet again! [01:07] welcome back, king of doap! [01:07] hmm... need to send mail to the list in that regard [01:08] If I have an SQLObject result from a selectBy which included a transaction; will any foreign key provided object also have that transaction embeded in it (for update purposes)? [01:09] (spiv/#launchpad) Kinnison: You're explicitly passing connection= to selectBy? [01:10] Erm, well, that's the way the librarian does it [01:13] stub: I need to coordinate with you to merge my pomsgset/potmsgset split branch into rocketfuel [01:14] Yup. Is it ready for me to look at now? [01:14] stub: I'm still removing small bugs, but the DB patch is ready [01:14] stub: we cannot merge it yet into rocketfuel [01:15] until I finish the review, but I suppose you will be sleeping... [01:15] (spiv/#launchpad) Kinnison: Oh, right. I expect that SQLObject probably does the right thing, but I'd double-check by reading the source... [01:15] yup. Got a revision available on chinstrap for me to look at? [01:16] archzoom or tla? [01:16] what do you prefer? [01:16] tla [01:16] carlos.perello@canonical.com--2004/launchpad--msgset-split--0 [01:16] (spiv/#launchpad) Kinnison: Although if I get this bug of lifeless's sorted out, then we can use that work and not pass transactions around epxplicitly anymore. [01:17] I need to commit a fix to the current.sql file [01:18] stub: it's ready [01:19] Cool. I'm not too fussed about current.sql, as it may need to be rebuilt by the time commit actually happens. [01:20] stub: I'm merging all changes from rocketfuel, so it should be updated with latest changes [01:21] carlos: current.sql won't merge well [01:22] stub: It should I fixed the conflicts by hand and recreate it from that [01:22] Hmm... scary. You confident no data has been lost? [01:23] stub: yes, I'm sure, the changes I'm doing don't affect the modified sample data [01:24] so the conflicts were minor [01:24] ok [01:46] carlos: I don't have any problems with the patch and it all seems to load cleanly. I'll want to add a 'set client_min_messages to error' at the top to remove noise and name the unnamed constraints. [01:47] stub: sure, will you do it? or do you want I do it? [01:48] carlos: I'm happy to do it, so I might as well unless you particularly want to or need to get this committed when I'm in bed. [01:49] I'm personally getting to dislike having a simple 'create table' followed by a raft of alter tables for the constraints, but that is just taste and has no effect on the database :-) [01:49] stub: that depends on Daf, if we need to merge it to continue our work, is it ok If I add it myself? [01:50] stub: I can fix it, I just did the same we have at this moment :-) === Kinnison whoops excitedly as canoncal.lucille.publishing.SourcePackagePublisher publishes an archive's pool [01:51] well, it's publishing the sourcepackages anyway [01:51] Yes. In this case I'm happy to have you commit it as there are no outstanding patches in the queue to conflict and it only affects the rosetta work (hopefully for the good ;) ) [01:51] It will involve 'tla mv patch-3-99-0.sql patch-3-11-0.sql' of course. [01:51] Kinnison: good work [01:52] was it correct? [01:52] sabdfl: It's still publishing :-) [01:52] carlos: The launchpad-3-00-0.sql is a database dump - it is not to be used as an example of good style ;) [01:52] sabdfl: 20,000 files don't come out of the librarian onto disk that fast :-) [01:52] stub: ok, should I change the the way I'm creating the restrictions so it's all inside the create table? [01:52] sabdfl: but so far it looks to be building the pool structure correctly :-) [01:52] carlos: Don't bother - like I said, it makes no difference to the database. [01:52] ok [01:52] stub: thanks [01:53] sabdfl: it was all kicked off with pub.publish(SourcePackageFilesToPublish.selectBy(drd=1)) to publish all sources pending publication for distribution 1 (ubuntu) [01:55] carlos: The names of the foreign keys should be changed though so I don't have to do it in future tidies - the current (rather arbitrary) standard I'm using is like - ALTER TABLE potmsgset ADD CONSTRAINT potmsgset_primemsgid_fk FOREIGN KEY (primemsgid) REFERENCES pomsgid(id); [01:56] carlos: Oh - and there had better be comments added in comments.sql which will save pain later (easier now while it is all fresh in your mind). [01:57] ok === cprov [~cprov@200.158.100.251] has joined #launchpad [02:08] stub: i haven't had much chance to look at roundup for ticketing [02:09] is it zodb based? [02:09] or rdbms based? [02:11] Nope. A chunk of Roundup is what is called Hyperdb, which is yet another database. It has backends to postgresql, mysql, sqllite etc. It seems a bit like a poor mans object database (which is not necessarily a bad thing). === kiko [~kiko@200.226.3.77] has joined #launchpad [02:11] Would sqlobject get really upset if the id field wasn't an integer? === debonzi [~debonzi@200.226.3.77] has joined #launchpad [02:12] morning [02:12] SteveA, cprov: #launchpad-meeting? [02:12] stub: does it use fixed table names when it maps to the rdbms? [02:13] Kinnison: It supports string ids as well - they just can't be compound primary keys. But I suspect it is better to stick with our internal standards unless there is a damn good reason otherwise. [02:13] or does it create tables on the fly? [02:13] stub: I'm trying to make a view, only the only way to guarantee a unique ID will be to stringify and concatenate various columns [02:13] sabdfl: It creates tables on the fly. You define classes and it builds or modifies the backend tables for you. [02:14] Kinnison: Sounds valid. Don't ask me for the syntax to do it though - I just know it supports it :-) [02:14] Kinnison, an sql view? [02:14] stub: okay; I'll play with the SQL [02:14] kiko: yes [02:14] Kinnison, I have one living in a patch somewhere which provides a unified sourcepackage [02:14] it provides all the major columns [02:15] and is a *major* performance improvement [02:15] kiko: I have a view which shows all the columns I need for publishing a sourcepackagerelease to a given distrorelease in a distribution [02:15] kiko: it goes delving off into the libraryfilealias table etc to retrieve filenames [02:15] stub: ok, don't want that anywhere near emperor then [02:16] cprov, #launchpad-meeting === cprov [~cprov@200.158.100.251] has joined #launchpad === cprov [~cprov@200.158.100.251] has joined #launchpad [02:39] spiv: /join #launchpad-meeting please [02:54] elmo: where do I use userdir-ldap ? [02:59] stub: It seems that I'm not allowed to make id a string column :-( [03:00] stub: I'm going to have to prod about more now :-( [03:10] elmo: can we bring an archive mirror up on mawson for gina and friends? [03:10] (elmo/#launchpad) yeah [03:10] Kinnison: http://sqlobject.org/docs/SQLObject.html#non-integer-keys seems to suggest 'it just works', but I remember something flying past on sqlobject-discuss that mentioned some magic setting in the class definition. [03:11] stub: I'll take a look === Kinnison has a specious id field for now anyway [03:11] (elmo/#launchpad) good god, I just created a new user on mawson and it has some crackful color prompt by default === BradB_ is now known as BradB [03:12] the "gentoo effect" === BradB [~bradb@modemcable165.196-131-66.mc.videotron.ca] has joined #launchpad [03:13] sabdfl: I'm about 50% of the way through a re-publish to see if the new id column works better [03:13] elmo, can I have an account with color prompts too [03:14] ok [03:15] elmo: heh, can you kick this rainbow colourful prompt, please :) [03:17] elmo: please defer artwork discussions to #ubuntu, 1400 UTC :-) [03:19] (elmo/#launchpad) yeah, that's what we need, an ascii-art version of the artwork in /etc/motd !!1 [03:19] (elmo/#launchpad) ahem, anyway, mirror's running - it'll be a while.. [03:22] elmo: only on april 1st, 'k? [03:22] cow porn === limi [~limi@host217-37-231-28.in-addr.btopenworld.com] has joined #launchpad === limi is now known as limi|london [03:24] elmo: do you have a few minutes to talk about running a soyuz dogfood server on mawson? #launchpad-meeting [04:00] sabdfl: What's the difference between watching a bug and being CC'd on a bug? The terminology makes it seem like the former means you subscribed yourself, the latter means someone else subscribed you. [04:01] in Bugzilla you watch *users*, and when you do so you get all their bugmail [04:01] Big Brothzilla [04:01] kiko: Hm, then Malone's interface is confusing, if its intent is to imitate that behaviour. [04:02] Because, on a bug, I've got a "subscribers" portlet, listing CC'd, and right below, watching. [04:02] I"m not sure it does, though, just adding a datapoint [04:02] ah === limi|london thinks it may have something to do with whether people are CCed email-wise or just have the bug in their web "favorites" [04:05] that's possible too [04:09] is mawson down? [04:14] (elmo/#launchpad) limi|london: no? [04:14] (elmo/#launchpad) at least the machine itself is fine [04:15] hm [04:15] http://mawson.ubuntu.com/ doesn't work for me === cprov [~cprov@200.158.100.251] has joined #launchpad === stub [~stub@dsl-246.248.240.220.dsl.comindico.com.au] has joined #launchpad [04:23] !dmwaters:*! Hi all! It looks as though level3 is having some routing problems. I've pulled the affected rotation server for now [04:30] limi|london: it should be https [04:30] same result [04:30] but, I think daf needs to be prodded to get it running [04:30] aha === limi|london prods daf [04:30] (daf/#launchpad) ow [04:32] hi daf. having a rosetta meeting today? [04:32] (daf/#launchpad) yes, as soon as Carlos is back from his meeting [04:33] what meeting is carlos at? university thing? [04:33] (daf/#launchpad) yes [04:33] (daf/#launchpad) I think I CC'd you about it [04:34] ok [04:34] (daf/#launchpad) I don't know what's up with Mawson [04:34] (daf/#launchpad) Launchpad is running -- perhaps a problem with Apache? [04:35] lulu: I'll open a bug about having a + in email addresses. Does the user in question need his password to be reset? [04:37] elmo: is apache forwarding to launchpad? === cprov_ [~cprov@200.158.100.251] has joined #launchpad [04:37] SteveA: Thanks - I assume so - do you want me to check first? [04:37] (elmo/#launchpad) hmm, what apache? :/ [04:37] (dilys/#launchpad) New bug 2120 for Launchpad/Launchpad: forgotten password app doesn't work if + in email address [04:37] (dilys/#launchpad) https://bugzilla.warthogs.hbd.com/bugzilla/show_bug.cgi?id=2120 [04:38] (daf/#launchpad) elmo: Mawson is refusing connections on HTTPS [04:38] lulu: yes, please check. From the email, he might have just been trying things out and kindly reporting a bug. If he does want his password reset, then andrew can do that for him. [04:39] SteveA: sure - will do. [04:39] I've filed a bug on it. I expect this will be fixed in the next update of the app server on macquarie, but that won't be for a while. [04:40] spiv: any idea how many email addresses with "+" in them are in the database on emperor? [04:40] (elmo/#launchpad) daf: see "what apache" === cprov_ is now known as cprov [04:41] (daf/#launchpad) elmo: doesn't https://mawson.ubuntu.com/ go through an Apache proxy? === elmo throws a bus at daf [04:43] (elmo/#launchpad) apache died. I'm working on it [04:43] (daf/#launchpad) ow [04:43] (daf/#launchpad) thanks [04:48] (spiv/#launchpad) SteveA: I'll take a look [04:50] (spiv/#launchpad) SteveA: Zero. [04:51] that's odd [04:51] what email addresses have "ennis" in them? [04:52] (spiv/#launchpad) Also zero. [04:52] BradB: The way I interpreted the Watch/CC thing was that if you watch a bug you see it in your reports ('My bugs', dashboard etc), and if you are CC you also get email updates. [04:53] spiv: I don't understand the email lu forwarded. [04:53] (spiv/#launchpad) SteveA: I'm just grabbing my email now. [04:54] any addresses ending in "ubuntu@gmail.com" ? [04:54] (spiv/#launchpad) Also zero. [04:54] (spiv/#launchpad) There's only one gmail address at all.. [04:55] (spiv/#launchpad) Hmm. [04:55] so, I must assume that geoff ennis has never actually signed up [04:56] stub: ok [04:56] (spiv/#launchpad) I suppose so. I assume they tried, and that plone somehow thwarted them before the database became involved. [04:56] (elmo/#launchpad) okay, apache's back up but it's now using the client cert - which has been emailed to the launchpad list [04:57] (elmo/#launchpad) (for mawson.ubuntu.com - the alpha site is unchanged for now) [05:02] what is https://mawson.ubuntu.com/ supposed to present? === ddaa [~ddaa@nemesis.xlii.org] has joined #launchpad [05:02] spiv: I don't know what in plone could account for this. [05:02] (elmo/#launchpad) SteveA: the devel server? [05:02] lulu: you'll need to import some certificates into your browser in order to use the launchpad servers [05:03] lulu: also, andrew can't find any record of geoff ennis in the database at all. very odd. [05:04] SteveA: ok. Could you pop me an email on this - import some certificates into your browser in order to use the launchpad servers.... [05:04] ok [05:04] SteveA: very odd - ok - I'll get back to Geoff and ask him to re register. I saw a gmail was found...what was that? [05:05] lulu: what browsers do you use? [05:06] Firefox, netscape, Safari, IE to test stuff. Firefox default. [05:06] I'll mail you how to import a certificate for firefox. I don't know what to do about the rest [05:06] (spiv/#launchpad) SteveA: Neither do I, but the fact that "+" is being mistreated smells an awful lot like a web issue, not a DB issue... [05:06] ok - thanks :o) [05:08] spiv: is it a Plone prob? perhaps Roche can have a look [05:08] (spiv/#launchpad) lulu: I'm purely speculating :) [05:09] (spiv/#launchpad) lulu: But my guess would be it's somewhere on the web end, before the authserver or the DB gets involved. [05:10] we need someone on our end who has a valid email address containing a "+" to test this properly. [05:10] daf: what's the correct address for the rosetta alpha now? [05:11] (elmo/#launchpad) rosetta.shuttleworthfoundation.org I think === Riddell [jr@muse.19inch.net] has joined #launchpad [05:12] lulu: mailed you information on how to import certificates [05:12] SteveA: Thanks hon :o) [05:13] if you need to use them with other browsers, we'll have to find out how to import certificates for them [05:13] (daf/#launchpad) SteveA: it hasn't changed... [05:14] should I be getting a launchpad devel server on https://mawson.ubuntu.com/ ? === BradB tries that again [05:14] wow, we've really been chopping down trees in the page tests [05:14] queue canadian lumberjack joke [05:15] s/queue/cue/ [05:15] the malone bug index test now looks like this: [05:15] ... [05:15]

...

[05:15] ... [05:15] heh [05:16] SteveA: for the + in validation - it must be stripping characters from the email on submit. Let's set up a test user. [05:16] daf / stub: "A system error occured" on all the Malone pages - is that because I'm not logged in? === BradB goes ahead and checks in bug external ref support anyway...ignorance, bliss, etc. [05:17] limi|london: try port 8086 for debugging tracebacks [05:18] what was the passwd for the foo.bar user again? not "test"? [05:18] I'm getting a 403 forbidden on https://mawson.ubuntu.com/ [05:19] (daf/#launchpad) SteveA: did you install the certificate? [05:21] I did [05:21] both of them [05:23] (daf/#launchpad) both? [05:23] (daf/#launchpad) there's two? [05:26] canonical development, testers [05:27] (daf/#launchpad) I only have one, which elmo posted to the launchpad mailing list [05:27] testers.p12 [05:28] launchpad.p12 [05:28] (daf/#launchpad) where did you get testers.p12 from? [05:28] stub: you do realize that pagetests can be run in a particular order -- that is, the system has a dependency mechanism [05:29] daf: elmo mailed it to you, carlos and me [05:29] (daf/#launchpad) oh, so he did [05:30] SteveA: Yes, which also means if the early tests cause new side effects it could break all following tests [05:30] (daf/#launchpad) https://mawson.ubuntu.com/ [05:30] stub: that's the idea, surely, so you can see that happen, if it is important [05:30] (daf/#launchpad) ^^ works for me [05:30] if it is not important, the later tests should have sections elided as appropriate [05:31] daf: which certificates have you imported? [05:31] (daf/#launchpad) only the Launchpad one so far [05:31] (daf/#launchpad) importing certificates into Epiphany is tricky [05:31] SteveA: That isn't very scalable if we end up with hundreds of tests [05:31] (elmo/#launchpad) if you import both, it breaks. meh. [05:32] aha -- if I tell firefox to let me choose which certificate to use, i can manually choose the launchpad one [05:32] and it works [05:32] (elmo/#launchpad) galeon doesn't even have that option :/ [05:33] (daf/#launchpad) elmo: I ran my Epiphany profile under Mozilla and did it that way [05:34] (daf/#launchpad) elmo: the same trick should work for Galeon === Riddell [jr@muse.19inch.net] has left #launchpad [] [05:37] spiv: you have access to the database. Can you test the issue with email addresses and logging in / registering with the website? [05:37] spiv: I can supply you with some email addresses to test with. [05:44] SteveA: Just sent you another email on an underscore character being a problem too - do you think it's on our validation? [05:44] (spiv/#launchpad) Ste Ok. [05:45] (spiv/#launchpad) SteveA: Actually, don't we have + addresses at canonical.com? === spiv checkes [05:48] lulu: I have no idea. We'll need to look into it and try to reproduce the problem. [05:49] did someone already asked elmo to add a rsync service to chinstrap to speed up archive mirroring? [05:50] (dilys/#launchpad) Merge to rocketfuel@canonical.com/launchpad--devel--0: bug ext ref fixes (patch-629) [05:50] SteveA: thanks guys [05:50] (daf/#launchpad) elmo: did somebody already ask you to add an rsync service to chinstrap to speed up archive mirroring? [05:52] daf: well, I expected that my message would have the same effect, that wasu just a slightly more oblique way of asking "elmo, could you add a rsync service" :-) [05:52] (daf/#launchpad) ddaa: I think perhaps you're being a little more subtle than necessary here :) [05:57] (spiv/#launchpad) SteveA: Yes, andrew+test@canonical.com works, so I'll test with that... [05:58] thanks [06:00] (spiv/#launchpad) SteveA: Um, where do I sign up? :) [06:00] (elmo/#launchpad) daf: no [06:01] (elmo/#launchpad) and rsync using what? without ssh, rsync is a wide-open protocol [06:01] elmo: I'm not on top of it, but if it's possible to conveniently tunnel rsync through ssh that will cut it as well. [06:02] The basic idea is that "tla archive-mirror" is stupidly slow even if safe, and that rsync just works better if you understand how it can break. [06:02] (elmo/#launchpad) eh, just do 'rsync -e ssh' it works fine, doesn't need any changes by admin [06:03] elmo: thanks, I'll check that. [06:04] (spiv/#launchpad) lulu: Do you know where the sign up page these users are using is? [06:07] it's not readily available as yet http://www.ubuntulinux.org/join_form. This should be on https:// === BradB is now known as BradB|lunch [06:07] (spiv/#launchpad) lulu: Ah, thanks. [06:10] spiv: Brad is keen to install the new new cookiecrumbler - will this interfere with your testing? [06:11] (spiv/#launchpad) lulu: Hmm, that form hasn't been used for almost a week... is there another place, maybe in launchpad? [06:12] (spiv/#launchpad) lulu: Or are these user problems older than that? [06:17] That's weird. perhaps they are talking about the shipit database of Mako's [06:18] spiv: can i go ahead and install the new CC? [06:18] spiv: last week while I was away. Let me clarify with the users and get back to you ok!? === cprov is now known as cprov-food [06:20] (spiv/#launchpad) BradB|lunch: Sure. [06:20] (spiv/#launchpad) lulu: Heh, ok :) [06:20] (spiv/#launchpad) SteveA: Around? === Kinnison is now known as KinniLunch [06:26] spiv: yep [06:27] (spiv/#launchpad) SteveA: Is there a sign-up page in a launchpad somewhere, or are all sign-ups happening through the plone site? [06:28] through plone [06:28] (spiv/#launchpad) SteveA: Because the authserver's createUser doesn't work atm (because it hasn't been udpated for nicknames), so looking at the lack of errors in the logs I can see that no-one has tried the plone site's join_form page for about a week. [06:29] (spiv/#launchpad) Ok. [06:29] can you update the authserver now? [06:29] (spiv/#launchpad) So before I can test this, I need to add nickname generation to the authserver. [06:29] (spiv/#launchpad) Yeah, I can do that. [06:29] (spiv/#launchpad) But I'll have to workrave first ;) [06:30] (spiv/#launchpad) (and I'll have to actually code it, although assuming BradB's module is snae that won't take long) [06:30] (spiv/#launchpad) sane, rather. === spiv -> workrave === carlos [~carlos@69.Red-80-33-181.pooles.rima-tde.net] has joined #launchpad [06:35] hi [06:36] rah [06:37] 35726 entries in the librarian, 35726 files published to the pool by lucille === justdave [~dave@24.247.63.44.gha.mi.chartermi.net] has joined #launchpad === cprov-food is now known as cprov [06:56] KinniLunch: good job [06:56] spiv: noticed an interesting thing yesterday while editing the site [06:57] (you have to log in to https://site-edit.ubuntulinux.org/ to avoid cacheing by the way) [06:57] any pages i created were created by "1" which is my id in the db [06:57] would have thought either nickname or email would show up === sabdfl [~mark@host217-37-231-28.in-addr.btopenworld.com] has left #launchpad [] === sabdfl [~mark@host217-37-231-28.in-addr.btopenworld.com] has joined #launchpad [06:59] sabdfl: sounds like a plone thing. may be legitimate snagging for roche. [06:59] SteveA: are we passing the email / username to plone in the first place? [07:00] plone can find out the email and username of users [07:01] I have no idea how to actually tell plone that, though === KinniLunch is now known as Kinnison === ddaa [~ddaa@nemesis.xlii.org] has left #launchpad [] === ddaa [~ddaa@nemesis.xlii.org] has joined #launchpad [07:19] (daf/#launchpad) what's the deal with arrowBlank.gif? [07:20] daf: hey, when you want we could have the meeting [07:20] (daf/#launchpad) hi Carlos [07:20] (daf/#launchpad) did the meeting at the University go ok? === BradB|lunch really goes for lunch now [07:21] SteveA: do you know any release date for Zope3? I'm thinking on doing some development in my free time and I want to give it a try [07:22] daf: yes, I'm starting today with my "final project" (a kind of project that all students should do last year) [07:23] (daf/#launchpad) carlos: http://dev.zope.org/Wikis/DevSite/Projects/ComponentArchitecture/RoadMap [07:23] (daf/#launchpad) Zope X3 final is due today [07:24] true :-) [07:24] good news... [07:25] (daf/#launchpad) ok, shall we have a meeting? [07:29] (daf/#launchpad) spiv, sabdfl: both lib/canonical/foaf/browser.py and lib/canonical/launchpad/database/project.py have a ProjectContainer class [07:30] (daf/#launchpad) is this intentional? [07:30] (daf/#launchpad) (and yes, I know ProjectContainer is deprecated) [07:31] daf: good catch, no, the database/project.py one is the correct location, not sure which one is active in the code [07:31] (daf/#launchpad) the foaf one doesn't seem to be used anywhere [07:31] if there's anything useful in the foaf one please merge it into the database/ one and eliminate the foaf one [07:31] (daf/#launchpad) either in the Python or the ZCML [07:31] daf: yes, when you want [07:31] ok, then we can just remove it [07:31] (daf/#launchpad) but I'm not 100% sure [07:32] (spiv/#launchpad) daf: If you rename it, do the tests still pass? ;) [07:32] (daf/#launchpad) spiv: :D [07:32] (spiv/#launchpad) (We're not too far from being able to rely on that, thanks to the page tests...) [07:33] (daf/#launchpad) "you broke it!" / "no I didn't -- the tests were still working!" [07:34] there are some tests that are still failing [07:34] (spiv/#launchpad) daf: The annoying cases are "no I didn't -- the tests are still working!" / "not on my machine, they aren't" [07:34] but they are only detected by daf's script in rosetta [07:35] (daf/#launchpad) carlos: eh? [07:35] (spiv/#launchpad) daf: But hopefully we can avoid having fragile tests :) [07:35] (daf/#launchpad) carlos: the interface checker [07:35] (daf/#launchpad) spiv: true [07:35] daf: yes [07:35] we should move it outside Rosetta :-) [07:36] (daf/#launchpad) spiv: I'm fully in support of "if the tests still work and the code is broken, how was I supposed to know I broke it?" [07:36] (daf/#launchpad) carlos: yes [07:37] (spiv/#launchpad) daf: Absolutely. If the tests pass only under some conditions (or worse, only sometimes, randomly), then that's a bug (possibly in the tests) that needs fixing fairly urgently, due to the developer confusion it causes. [07:37] (daf/#launchpad) Kinnison: you need to add an __init__.py to lib/canonical/lucille/tests for it to be picked up by the test machinery [07:37] (daf/#launchpad) spiv: absolutely [07:38] (daf/#launchpad) Kinnison: will you or shall I? [07:38] (spiv/#launchpad) daf: Twisted has had some nasty issues in this area in the past (and to some extent, today as well :( ) [07:38] daf: If you do; it'll exploderificate [07:38] (daf/#launchpad) spiv: I have one sqlbase test failing here [07:38] daf: It's not ready to be integrated [07:38] daf: I have a hive somewhere which needs some work before I commit it [07:38] (daf/#launchpad) Kinnison: you COMMITTED BROKEN TESTS?! [07:38] (spiv/#launchpad) daf: Which one? [07:38] daf: the tests run [07:39] daf: But not as part of the integrated suite [07:39] daf: special paths needed for the data/ dir [07:39] (daf/#launchpad) Kinnison: grumble ;) [07:39] (daf/#launchpad) spiv: [07:39] (daf/#launchpad) Failure in example: sqlrepr(time(13, 45, 50), 'postgres') [07:39] (daf/#launchpad) from line #30 of canonical.database.sqlbase.quote [07:39] (daf/#launchpad) Expected: "'13:45:-1'" [07:39] (daf/#launchpad) Got: "'13:45:50'" [07:39] (spiv/#launchpad) Hmm. [07:39] (spiv/#launchpad) I thought I merged the fix for that one. [07:40] (daf/#launchpad) oh, I also have a failing authserver test === spiv adds that to his todo list [07:40] (daf/#launchpad) IntegrityError: ERROR: new row for relation "person" violates check constraint "valid_name" [07:40] (spiv/#launchpad) daf: I'm fixing the authserver right now :) [07:40] (daf/#launchpad) groovy :) [07:41] daf: If you cd into the test dir and run 'make check' it works fine :-) === carlos phone [07:42] (daf/#launchpad) Kinnison: my, what verbose test harnesses you have [07:42] Kinnison: if you need special paths, can you get them relative to a test_foo.py module's __file__ ? [07:43] (spiv/#launchpad) SteveA: Incidentally, Twisted has a convenience method for that. It's very handy. [07:43] (spiv/#launchpad) (twisted.python.util.sibpath, iirc) [07:44] (daf/#launchpad) spiv: "sibpath"? [07:44] (spiv/#launchpad) SteveA: It's probably worth writing one of our own to encourage the right organisation of test files. [07:44] (spiv/#launchpad) daf: short for "sibling path" [07:44] SteveA: probably [07:44] (spiv/#launchpad) (by analogy with "parent path" and "child path") [07:46] (daf/#launchpad) aha [07:46] (spiv/#launchpad) In fact, I think I've already used sibpath in the authserver functional tests (seeing as it depends on Twisted anyway...) [07:46] (daf/#launchpad) well, Launchpad has a Twisted dependency already, I think === debonzi [~debonzi@200.158.100.251] has joined #launchpad [07:46] (daf/#launchpad) so I don't see a problem with using that [07:47] (spiv/#launchpad) daf: Only sort of. The launchpad web app itself runs fine without it, it's just ancilliary stsuff like the librarian and the authserver that needs it. [07:47] (daf/#launchpad) spiv: I thought there was something else [07:47] (spiv/#launchpad) So I'm hesitant to make that dependency any stronger, as much as it would suit me... [07:47] (spiv/#launchpad) Oh, and buildbot/importd. [07:47] (daf/#launchpad) I have no objections to a twisted dependency [07:48] (daf/#launchpad) better that than rewriting code [07:48] (spiv/#launchpad) (And I think lamont has an XML-RPC server for his builders that uses that, but that's not in the laucnhpad source tree) [07:49] (spiv/#launchpad) daf: Me either, but I'm biased :) [07:50] (daf/#launchpad) :) === Kinnison doesn't see why it'd be bad to add a twisted dependency to the testsuite [07:51] (daf/#launchpad) Kinnison: an aversion to dependencies [07:51] (daf/#launchpad) (which I personally don't have) [07:51] daf: it's getting to the point where it's a given dependency anyway; hardly seems avoiding it [07:52] (daf/#launchpad) Kinnison: you're preaching to the converted, man :) [07:55] daf: good good :-) === Kinnison gets down from the pulpit [07:55] the air was thin up there [07:57] daf: do you remember the bug I show you on Friday? [07:59] daf: It was because there was a potmsgset without any pomsgidsighting, I'm not sure if it's a real bug, it was there because I had the sample data broken [07:59] (daf/#launchpad) I don't remember === lulu [~lu@host217-37-231-28.in-addr.btopenworld.com] has left #launchpad [] === daf workraves [08:00] daf: the out of index error when editing a translation [08:01] I don't remember it completely, let me look for the trace I sent you... [08:03] * Module canonical.rosetta.browser, line 785, in messageSets yield self._messageSet(set) * Module canonical.rosetta.browser, line 756, in _messageSet messageID = self._messageID(messageIDs[0] , set.flags()) * Module sqlobject.main, line 1238, in __getitem__ return list(self.clone(start=start, end=start+1))[0] IndexError: list index out of range [08:08] (daf/#launchpad) oh, *that* one [08:09] (daf/#launchpad) it was broken data? [08:09] yes [08:09] not sure if we should add extra checks [08:09] (daf/#launchpad) humph [08:09] (daf/#launchpad) I think extra checks are usually good [08:09] (daf/#launchpad) do we know which check to add in this case? [08:09] yes [08:10] messageIDs[0] [08:10] messageIDs is an empty list [08:10] (daf/#launchpad) aha [08:10] (daf/#launchpad) do we know where we would add the check? [08:10] yes, I think we should add it just in that line [08:11] (daf/#launchpad) in canonical.rosetta.browser? [08:11] or perhaps, move it into the method that returns messageIDs so we raise an exception if the list of msgids is empty [08:11] hmm, the later solution is better, it's inside database/pofile.py [08:12] (daf/#launchpad) spiv: at any rate, renaming the class didn't seem to make any tests fail that weren't failing before, so shall I delete it? [08:12] (daf/#launchpad) carlos: yes, that sounds good to me [08:12] also, we are returning a sqlrecordset (or whatever its named) instead of a plain list [08:12] (spiv/#launchpad) daf: Given that grep found no references, I'd say yes... [08:12] so the browser.py code is converting it into a list before use it [08:12] (daf/#launchpad) that's not usually a problem as long as it behaves like a list [08:13] (spiv/#launchpad) daf: Thanks for noticing :) [08:13] daf: no, it does not behaves like a list, you need to cast it as a list [08:13] (daf/#launchpad) spiv: de nada :) [08:13] (daf/#launchpad) perhaps the cast should be made in pofile.py then [08:13] (daf/#launchpad) carlos: is it OK to make changes to pofile.py? [08:13] (daf/#launchpad) will they case conflicts on your branch? [08:14] daf: please wait, I have my changes almost ready [08:14] daf: I would prefer if you could check the changes today as soon as I fix a small bugs that are remaining [08:15] I got stub's permission to commit the database changes this morning [08:15] (daf/#launchpad) no problem [08:15] daf: or are you stopped by it? [08:15] (daf/#launchpad) I'm not blocked on it [08:16] (daf/#launchpad) I just have a changeset from "tla undo" that I won't commit until your branch is merged [08:16] ok, thanks [08:20] spiv: any way to be able to omit unneeded fields when creating sqlobjects? they are not null in the database and notNull=False [08:20] but I get an exception asking for them [08:20] * Module sqlobject.main, line 856, in _create [08:20] raise TypeError, "%s() did not get expected keyword argument %s" % (self.__class__.__name__, column.name) [08:20] TypeError: POFile() did not get expected keyword argument filename [08:21] (daf/#launchpad) carlos: does the field have a default? [08:21] daf: no [08:21] default=None [08:21] ? [08:21] is it the only solution available? [08:21] (daf/#launchpad) so you'd like there to be an implicit default of None? [08:21] (daf/#launchpad) a default default? :) [08:22] well, when you create a row [08:22] and you omit a field [08:22] it's set to NULL [08:22] that's what I want [08:22] (daf/#launchpad) isn't that the same thing? [08:22] if you put default=None, yes [08:22] (spiv/#launchpad) carlos: To use the database's default value, use database.constants.DEFAULT. [08:22] but I don't have it at this moment [08:22] :-) [08:23] (spiv/#launchpad) I agree that SQLObject should be smarter about this... [08:23] (daf/#launchpad) right, so you're saying that if you don't put a default, the default should default to none? [08:23] spiv: the database does not have a default set for those fields (or a field that could be empty is a default value? [08:23] daf: I think so [08:23] (spiv/#launchpad) carlos: Then explicitly set None, whether in the column declaration or your invocation. [08:24] I mean, I thought that sqlobject was smart enough to do it alone, but seems like it's not as clever as I thought :-P [08:24] spiv: ok [08:24] (spiv/#launchpad) carlos: No, sqlobject is stupid here, unfortunately [08:24] (daf/#launchpad) carlos: file a bug, work around it :) [08:24] (spiv/#launchpad) But seeing as the solution is to be explicit, it's not too terrible a problem. [08:24] spiv: thanks for the confirmation :-) [08:25] (spiv/#launchpad) I posted to the mailing list about this some time ago... [08:25] (daf/#launchpad) (if you think it is a bug) [08:25] (daf/#launchpad) spiv: and...? [08:25] spiv: sorry, I don't remember it :-( [08:25] (spiv/#launchpad) carlos: Sorry, I meant the sqlobject-disucss list :) [08:26] ohh, then is normal I don't remember it :-D [08:38] daf: ping [08:41] (daf/#launchpad) cprov: pong! [08:44] daf: how to use launchpad pg_user on mawson (psql -U xx fails on IDENT) ? [08:45] (daf/#launchpad) cprov: "sudo -u launchpad psql" [08:46] (dilys/#launchpad) Merge to rocketfuel@canonical.com/launchpad--devel--0: Add nickname support to the authserver (fixing the failing test (patch-630) [08:50] daf: I can't use sudo cause I don't have password :) [08:51] (daf/#launchpad) cprov: you don't? [08:51] (daf/#launchpad) cprov: it's your normal login password it wants [08:51] daf: ssh id_dsa.pub [08:51] (daf/#launchpad) sure, I use certificate authentication also [08:51] (daf/#launchpad) but I need to use my password for sudo [08:52] (daf/#launchpad) if you don't have a password or don't remember it, you'll have to set one === cprov testing === BradB|lunch is now known as BradB [08:54] daf: I just can figure out that I don't have a password, none that I remember ... [08:56] (daf/#launchpad) cprov: you probably first got it in a gpg-encrypted email from elmo [08:56] (daf/#launchpad) cprov: but it's easy enough to set a new one, I think [08:56] daf: i'm looking for elmo email [08:59] daf: nop, I have no email from james with a pass, anyway, I ask him for a new pass [08:59] daf: tks, daf [09:00] (daf/#launchpad) cprov: use db.warthogs.hbd.com to do a password change === debonzi goes for a little university exam [09:05] daf: yep ! [09:06] (daf/#launchpad) cprov: ok, cool :) === BradB is now known as BradB|ank === jblack waves at the launchpad team [09:09] How are you guys? [09:09] daf: ehe, not that cool, dude, if chpasswd@db.warthogs.hbd.com can't understant my signature .. [09:10] jblack: Leaving in a Dream [09:10] (daf/#launchpad) cprov: hmm :( [09:11] daf: exactly what I thought ... [09:57] daf: Sorry. Everybody showed up at once. [09:59] (daf/#launchpad) jblack: no worries :) === cprov [~cprov@200.158.100.251] has joined #launchpad === BradB|ank is now known as BradB [10:25] daf: Ok. Where were we, boss ? [10:25] (daf/#launchpad) the East Coast, IIRC [10:25] Ahh. Yeah. [10:25] You're welcome out here any time. [10:26] Just let me know a couple days ahead of time so that I get the guest room ready for you [10:26] (daf/#launchpad) well, looks like there are buses [10:26] (daf/#launchpad) if I get on the right one, it takes 3 hours [10:28] Anything I should know? Allergies of any sort? [10:29] (daf/#launchpad) I'm slightly allergic to cats and I don't eat mammals [10:30] Ok. So I should have lettuce, carrots and what on hand? \ [10:30] (no cats, but I do smoke) [10:30] (daf/#launchpad) :) [10:31] (daf/#launchpad) fish are good, though [10:31] How about this. When you get here, we'll go grocery shopping, and we'll fill the fridge up with stuff you like. [10:33] (daf/#launchpad) sounds good :) [10:33] Ok. That just leaves when [10:33] (daf/#launchpad) probably not this week [10:34] (daf/#launchpad) I have a vague intention to go travelling further out at some point [10:34] Ok. some indefinite point in the future it is. =) [10:34] I have some questions for you now. [10:34] (daf/#launchpad) shoot [10:35] How long does star-merge take you on rocketfuel? [10:35] (daf/#launchpad) a minute or two, I think [10:35] arch/os ? [10:35] architecture/os, that is [10:36] (daf/#launchpad) i386/Linux [10:36] ubuntu, I take it? [10:36] (daf/#launchpad) cough [10:36] :D [10:36] gentoo! [10:36] Its ok if its not ubuntu. [10:36] (daf/#launchpad) it's Debian sid [10:37] ram ? [10:37] (daf/#launchpad) 768MiBs [10:37] (daf/#launchpad) (I recently upgraded) [10:37] (daf/#launchpad) from 256MiBs [10:37] you using libraries? if so, greedy/nongreedy sparse/nonsparse ? [10:37] (daf/#launchpad) I haven't really noticed much change in arch [10:37] (daf/#launchpad) greedy sparse [10:38] and last question. are you locally mirroring rocketfuel? [10:38] (daf/#launchpad) I'm not [10:38] (daf/#launchpad) I suspect my disk is slowing arch down, acutally [10:38] 2 minutes is about right. [10:39] If you're machine is top of the line, its about a minute. If you're machine is like mine, and merely rather nice, its about 2 minutes. [10:39] spiv: ping [10:39] carlos: you're on launchpad, right ? [10:40] jblack: yes [10:40] mind answering the same questions for me that I just asked daf ? [10:40] (daf/#launchpad) jblack: is it CPU-bound or memory-bound or network-bound or disk-bound? [10:40] daf: thats what I'm trying to figure out. [10:40] let me read them :-) [10:40] (daf/#launchpad) jblack: aha :) [10:40] when I went to bed last night, I was certain that it was disk bound. [10:41] ubuntu has a footprint of about 200 megs. And 90 megs of trees wouldn't get in the cache with a system w/ 256 megs (which would explain 1 hour star-merges for brad) [10:41] though in fairness, brad isn't runinng ubuntu at all, but presumably os x has a similiar footprint. [10:41] (daf/#launchpad) hmm [10:41] (daf/#launchpad) 90 megs? [10:41] daf: Yeah. RF is about 30 megs, the bulk of which is patchlogs. [10:42] (daf/#launchpad) gosh [10:42] depending on how you count, and how libraries play in, you're looking at 2 or 3 trees. [10:42] (daf/#launchpad) does that mean it's going to get worse in proportion with the number of revisions? [10:42] anyways, that went out the window when I talked to limi, who has os x and a gig of ram. He's taking 7 minutes, but I don't know yet whether he's using libraries. [10:42] troll of the day: use bdb to store patchlogs === jblack throws ddaa a nasty look [10:43] daf: Not for a long while. If there's a buffer cache line, its somewhere between 256 and 512. [10:43] you're very safe up there at 768 [10:43] More seriously, there are two sides to it: [10:43] (daf/#launchpad) right [10:44] 1. patch application: just check that the name [10:44] and the id stored in the patchlog match what is in the tree instead of making a full tree inventory. [10:44] jblack: How long does star-merge take you on rocketfuel? -> about 2 minutes 40 seconds (3 patchsets) [10:44] jblack: PPC/Ubuntu [10:44] RAM: 774188 [10:45] (/me strike out ppc as a possible cause) [10:45] 2. commit: we can make up something simple which uses commit limit with a cli of the form "tla touch file" which add the file to the limit of the next commit, [10:45] or something to that effect. [10:46] ddaa: How will that help with 1 hour star-merges ? [10:46] you using libraries? Yes but I don't remember the kind of .. the log says greedy, not idea about sparse, I did what the default was from the documentation... [10:46] carlos: tla library-config /the/path-to-your/library [10:47] jblack: does that figure include the revlib population or just the apply-delta with both revisions available in the library? [10:47] jblack: my laptop is two years old (three years since was launched to the market) [10:47] (daf/#launchpad) carlos: tla library-config `tla my-revision-library` [10:47] ddaa: mostly its the merge. [10:47] greedy and sparse [10:47] ddaa: I can't even build a library on bradb's machine. I fell asleep. [10:47] carlos: last question: local mirror? [10:47] jblack: Note: it doesn't take me an hour to star-merge per se, but rather to go through the whole process (tla tree-lint, tla changes, star-merge, etc.) tla changes and tla star-merge take mind-boggling amounts of time. [10:47] no [10:48] jblack: you are not answering... [10:48] And, of course, the more there is to merge, the worse it gets. [10:48] jblack: and a link of 512Kbps download 128Kbps upload [10:48] ddaa: I already answered. Its mostly the star-merge. [10:48]