| daf | thanks a lot for your hard work recently | 12:00 |
|---|---|---|
| debonzi | daf, if I have a variable inside a zpt called context/foo and lets supose it is a list. Is there a way to get in zpt the firt element without tal:repeate? | 12:01 |
| daf | debonzi: I don't think so | 12:02 |
| daf | debonzi: you have to resort to "python: context.foo[0] " | 12:02 |
| debonzi | debonzi, Ok, thanks | 12:02 |
| daf | debonzi: or otherwise add a method to the view class to get it | 12:02 |
| debonzi | daf, Ill find a way.. thanks :) | 12:03 |
| daf | de nada :) | 12:03 |
| carlos | daf: no problem. It's a pity that rosetta is not only yet :-( | 12:08 |
| === elmo_ [~james@host217-37-231-28.in-addr.btopenworld.com] has joined #launchpad | ||
| daf | carlos: why does the personal information form submit to ViewPOFile? | 12:20 |
| carlos | daf: does it? | 12:20 |
| carlos | let me check, I don't remember it now | 12:21 |
| carlos | daf: it submits to TranslatorDashboard... | 12:21 |
| carlos | I implemented the code there | 12:22 |
| carlos | about why TranslatorDashboard... the template was pointing there, I did not changed it | 12:22 |
| carlos | daf: ? | 12:25 |
| daf | class ViewPOFile: | 12:26 |
| daf | ... | 12:26 |
| daf | def editSubmit(self): | 12:26 |
| daf | ... | 12:26 |
| carlos | that's not the personal information | 12:26 |
| carlos | that's for the plural forms editor | 12:26 |
| daf | elif "SAVE-PERSONAL" in self.request.form: | 12:26 |
| kiko | carlos, GO SLEEP | 12:26 |
| carlos | kiko: I did all pending tasks, let me end the conversation :-) | 12:27 |
| daf | kiko: he needs to answer this question first :) | 12:27 |
| carlos | and I will go to sleep | 12:27 |
| carlos | daf: if you have it indide the viewpo | 12:27 |
| carlos | you have a broken file | 12:28 |
| carlos | I have it inside TranslatorDashboard | 12:28 |
| daf | ah :) | 12:28 |
| daf | I think I have a broken file, then | 12:28 |
| daf | I've split up TranslatorDashboard into TranslatorDashboard and ViewPreferences, by the way | 12:28 |
| daf | so it seems something weird has happened | 12:29 |
| spiv | daf: Sorry, back... use Foo.set(field1=value1, field2=value2) to clump UPDATEs into a single query, rather than one per field. | 12:29 |
| spiv | (I think I mention this in the SQLObjectGuide?) | 12:29 |
| carlos | daf: yes :-) | 12:29 |
| daf | spiv: aha, thanks | 12:29 |
| carlos | do you want the original code? | 12:29 |
| daf | I think I can work it out using a launchpad checkout | 12:29 |
| === carlos adds that to the bug report and promises kiko that goes to the bed | ||
| carlos | ok | 12:30 |
| spiv | debonzi: You might be able to do context/foo/0 | 12:30 |
| === spiv catches up on scrollback :) | ||
| daf | spiv: nope | 12:31 |
| daf | spiv: it's equivalent to context.foo["0"] | 12:31 |
| spiv | Oh, right. | 12:31 |
| daf | spiv: (sadly) | 12:31 |
| kiko | good. | 12:31 |
| carlos | ok, now it's time | 12:33 |
| carlos | good night!!! | 12:33 |
| carlos | daf: do we have a meeting tomorrow? | 12:34 |
| daf | carlos: yes | 12:34 |
| carlos | 12:00UTC? | 12:34 |
| daf | yeah | 12:34 |
| carlos | ok | 12:34 |
| daf | will you be able to make it? | 12:35 |
| carlos | sure | 12:35 |
| daf | I'm willing to make an exception in this case | 12:35 |
| carlos | I'm not able to sleep more than 10 hours at the same time | 12:35 |
| daf | ok :) | 12:35 |
| carlos | see you | 12:35 |
| === npmccallum [~npmccallu@69-162-252-7.ironoh.adelphia.net] has joined #launchpad | ||
| kiko | sleeping sucks anyway. | 12:42 |
| daf | haha! | 12:43 |
| daf | To: daf@muse.19inch.net | 12:43 |
| daf | Name: KDE | 12:43 |
| daf | Description: | 12:43 |
| daf | http://www.kde.org | 12:43 |
| daf | (somebody requested that KDE be imported into Rosetta) | 12:44 |
| daf | I suspect it was Dwayne :) | 12:44 |
| daf | spiv: I think Carlos was really tired -- he mistook you for Stewart (https://bugzilla.warthogs.hbd.com/bugzilla/show_bug.cgi?id=1973) | 12:45 |
| spiv | Hah. | 12:46 |
| daf | he was up all of yesterday, all last night and all of today | 12:46 |
| kiko | as I say, sleep is overrated? | 12:47 |
| daf | :) | 12:48 |
| === npmccallum [~npmccallu@69-162-252-7.ironoh.adelphia.net] has joined #launchpad | ||
| === npmccallum [~npmccallu@69-162-252-7.ironoh.adelphia.net] has joined #launchpad | ||
| === debonzi see u all | ||
| === lifeless_ is now known as lifeless | ||
| === npmccallum [~npmccallu@69-162-252-7.ironoh.adelphia.net] has joined #launchpad | ||
| === npmccallum [~npmccallu@69-162-252-7.ironoh.adelphia.net] has joined #launchpad | ||
| === npmccallum [~npmccallu@69-162-252-7.ironoh.adelphia.net] has joined #launchpad | ||
| === stub [~zen@c211-28-34-252.sunsh1.vic.optusnet.com.au] has joined #launchpad | ||
| === doko [doko@dsl-082-083-141-180.arcor-ip.net] has joined #launchpad | ||
| === lulu [~lu@host217-37-231-28.in-addr.btopenworld.com] has joined #launchpad | ||
| === limi [~limi@159.80-202-72.nextgentel.com] has joined #launchpad | ||
| lulu | limi: morning! | 11:41 |
| === stub [~zen@dialup-33.53.194.203.acc03-dryb-mel.comindico.com.au] has joined #launchpad | ||
| limi | lulu: morning :) | 11:52 |
| lulu | saw that you felt in the deployment there are things you feel are outstanding. could you mail me the problems you found. If there are any further config changes we need done, I can get Upfront to do them. | 11:56 |
| SteveA | spiv, elmo: any progress on getting the xml-rpc server running on rosetta.w.h.c ? | 11:56 |
| === carlos [~carlos@69.Red-80-33-181.pooles.rima-tde.net] has joined #launchpad | ||
| carlos | morning | 11:58 |
| limi | lulu: nothing is set up for deployment at all on the caching side | 11:59 |
| limi | everything was set to not cache etc | 11:59 |
| lulu | yes - Upfront were not asked to do that. There was a decision taken that Squid would be used for cacheing for Launchpad tools and the webserver. In the meantime we are using Apache. Thanks for your help. | 12:00 |
| limi | Plone still needs to be tweaked before deployment, nop matter what system you use | 12:02 |
| SteveA | I think it is not sufficient to just turn on squid. You need to do some configuration in plone to allow squid to cache certain things. | 12:02 |
| carlos | limi, lulu: Will you add the announcement mail into the news section of www.canonical.com? | 12:06 |
| carlos | some people asks me for a link to the announcement so they can publish it in their news website | 12:06 |
| lulu | carlos: will do | 12:06 |
| carlos | ok | 12:07 |
| daf | they can link to the wiki, I think | 12:07 |
| carlos | daf: is the announcement there? | 12:07 |
| daf | yes, I think so | 12:07 |
| carlos | ok | 12:08 |
| daf | http://wiki.ubuntulinux.org/WartyWarthog_2fAnnouncementEmail | 12:08 |
| carlos | daf: thank you | 12:08 |
| carlos | I'm going to have breakfast now and back to work :-) | 12:08 |
| limi | eek, more _2f madness | 12:10 |
| daf | :) | 12:11 |
| === limi loves the irony of trying to use Wiki like a file system | ||
| lulu | daf: thanks- no point in having it in 2 places - need to consolidate what's on the wiki and what will be on web. | 12:14 |
| daf | lulu: yep | 12:15 |
| daf | lulu: the website looks great, by the way -- congratulations :) | 12:15 |
| lulu | daf: thanks Daf - thanks to everyone's hard work. Needs a slick design and loads more content but that will come! :o) | 12:19 |
| lulu | daf: looking forward to having the Rosetta tan up there! | 12:19 |
| lulu | tab! | 12:20 |
| daf | me too! | 12:23 |
| lulu | daf: howzit going? | 12:28 |
| daf | we're feature-complete for the Alpha release | 12:30 |
| daf | we'll do a review of the website today | 12:30 |
| daf | then, once we've imported some data, we're done | 12:31 |
| lulu | daf: do you need some of Limi's magic on the UI? | 12:38 |
| daf | lulu: yeah, we have some bugs filed about that | 12:40 |
| daf | https://bugzilla.warthogs.hbd.com/bugzilla/buglist.cgi?query_format=advanced&short_desc_type=allwordssubstr&short_desc=&long_desc_type=substring&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&emailassigned_to1=1&emailtype1=substring&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailcc2=1&emailtype2=substring&email2=limi&b | 12:41 |
| daf | (apologies for the horrible URL) | 12:41 |
| lulu | daf: that's ok! | 12:42 |
| limi | wow, that's crazy :) | 12:45 |
| === carlos checking the daf's patch | ||
| daf | basically #1949 and #1950 are pretty simple UI enhancements | 12:52 |
| daf | #1934 is more of a comprehensive UI review | 12:52 |
| carlos | good start for today. My archive is broken | 12:53 |
| carlos | grrrrrr | 12:53 |
| daf | carlos: any idea why scripts/poimpot.py instantiates TemplateImporter/POFileImporter with a None person? | 01:02 |
| carlos | daf: I fixed it yesterday before leaving | 01:03 |
| carlos | no idea why it was that way, but it's wrong and breaks the import | 01:03 |
| carlos | daf: you should have the patch at rocketfuel | 01:03 |
| daf | oh, ok | 01:04 |
| daf | I thought I was up to date | 01:04 |
| daf | I fixed it locally | 01:04 |
| carlos | it's an easy change | 01:04 |
| carlos | It's me or chinstrap connection is slooooow | 01:06 |
| carlos | ? | 01:06 |
| daf | I don't think it's you | 01:07 |
| daf | I couldn't even connect | 01:07 |
| daf | looks like they were discussing it on #canonical | 01:07 |
| daf | it means I can't log in to rosetta | 01:07 |
| carlos | ok | 01:09 |
| lulu | daf: elmo can log in - just a little slow | 01:14 |
| lulu | daf: can you log in now? | 01:14 |
| === daf tries | ||
| daf | yep, it's working now | 01:15 |
| lulu | daf: good - thanks | 01:15 |
| carlos | daf: your patch works | 01:23 |
| carlos | we have only an UPDATE instead of 4 | 01:23 |
| daf | I thought it was 6 :) | 01:23 |
| carlos | but it's still slow (as you already know) | 01:23 |
| daf | right, I feared as much :( | 01:23 |
| carlos | daf: well, It was yesterday when I detected it, I don't remember the exact number :-P | 01:24 |
| carlos | I was guessing it | 01:24 |
| carlos | daf: I don't think it's the database the bottleneck | 01:25 |
| carlos | as we know now :-) | 01:25 |
| carlos | I'm going to execute the import of the .po/.pot files now that lalo has fixed a bug I detected yesterday and at the same time I will try to profile the script | 01:26 |
| carlos | daf: or do you prefer to wait for the meeting in 30 minutes before start the profiling? | 01:27 |
| daf | no, I don't think we need to wait | 01:28 |
| daf | I think the bottleneck might still be in the database | 01:28 |
| daf | perhaps the SELECTs we're executing are slow | 01:28 |
| daf | I think Postgres has some tools for optimising queries | 01:28 |
| carlos | daf: the selects are too restrictive | 01:29 |
| carlos | well, forget that | 01:29 |
| carlos | if it's not an index | 01:29 |
| carlos | if it's not using an index it could be slow | 01:29 |
| daf | is it using an index? | 01:31 |
| carlos | daf: btw... I'm executing the same queries by hand from psql and they are really fast | 01:31 |
| carlos | daf: no, that's why I told you that forget my words :-) | 01:31 |
| carlos | btw, the queries are fast, and we don't have lots of queries for every msgset | 01:32 |
| daf | you think it is the code then? | 01:33 |
| carlos | yes | 01:33 |
| carlos | I suspect that | 01:33 |
| === carlos in profile mode | ||
| carlos | daf: could you commit your patch? | 01:34 |
| carlos | althought it's still slow, I think it's better if we do it that way | 01:34 |
| daf | I'm in the middle of something right now | 01:38 |
| daf | feel free to apply and commit it yourself | 01:38 |
| carlos | ok | 01:39 |
| === ddaa [~david@nemesis.xlii.org] has joined #launchpad | ||
| === debonzi [~debonzi@200.158.100.251] has joined #launchpad | ||
| === cprov [~cprov@200.158.100.251] has joined #launchpad | ||
| stub | It is quite possible the database is a bottleneck - there has been no optimization done atm. If you identify columns that need indexes, let me know. | 02:02 |
| carlos | yes, I was wrong, top let's you see that postgres has more than a 80% of my CPU | 02:05 |
| carlos | lifeless, stub: I sent yesterday two changes to the DB schema, could you review them? | 02:10 |
| lifeless | someone added patch-1-08 and conflicted with me :[ | 02:14 |
| lifeless | I thought only the nazi was meant to add patches to the schema ? | 02:14 |
| carlos | lifeless: you are true | 02:14 |
| stub | That was me, not letting go ;-) | 02:14 |
| carlos | hnmmm | 02:14 |
| carlos | lifeless: you are right :-P | 02:14 |
| === lifeless larts stub | ||
| === lifeless larts stub | ||
| === lifeless larts stub | ||
| === lifeless larts stub | ||
| === lifeless is done now | ||
| stub | The larting? I hope so | 02:15 |
| === stub bleeds | ||
| lifeless | :} | 02:15 |
| carlos | daf: meeting? | 02:17 |
| carlos | daf: or are we waiting for lalo? | 02:17 |
| daf | carlos: I've no idea whether lalo will turn up | 02:19 |
| daf | SteveA: around? | 02:19 |
| daf | lifeless: is that URI syntax correct? | 02:20 |
| lifeless | daf what? | 02:20 |
| carlos | ok, then if you want we could do the meeting. | 02:20 |
| daf | lifeless: see my last email to the launchpad list | 02:20 |
| lifeless | dunno. | 02:20 |
| stub | daf: If you get it working, please make a canonical.lp.connect method - I don't want to remember the syntax if I can help it :-) | 02:20 |
| spiv | daf: The syntax is an SQLObject thing. | 02:21 |
| daf | stub: well, dbhost is '' at the moment, so it will work | 02:21 |
| lifeless | daf: not in production its not. | 02:21 |
| lifeless | thats why dbhost is there. | 02:21 |
| daf | lifeless: exactly | 02:21 |
| lifeless | is //host/stuff | 02:21 |
| daf | that's why I'm asking :) | 02:21 |
| daf | spiv: is it postgres://host/dbname? | 02:21 |
| spiv | daf: Don't know :) | 02:22 |
| daf | stub: how do we identify columns that need indexed? | 02:22 |
| daf | * indexes | 02:22 |
| carlos | daf: the ones that are used often | 02:24 |
| carlos | to access data | 02:24 |
| daf | how do we identify those? | 02:25 |
| daf | looking at Postgres logs? | 02:25 |
| carlos | daf: no, looking at the queries | 02:26 |
| carlos | the WHERE clause | 02:26 |
| carlos | or looking at the logs if you prefer | 02:26 |
| carlos | the selectBy and things like that | 02:26 |
| carlos | from the sqlobjects | 02:26 |
| daf | right | 02:26 |
| daf | well, how often they're referred to in the code and how often they are queried in the database are two different things | 02:27 |
| carlos | daf: true, but the import script (for instance) is executed many times | 02:28 |
| daf | sure | 02:28 |
| carlos | so we can improve those first, rosetta does not have problems (yet) | 02:28 |
| carlos | stub: a unique key is also an index right? | 02:29 |
| stub | Yup | 02:29 |
| carlos | so we have already some "optimizations" | 02:30 |
| carlos | and it's still slow | 02:30 |
| stub | daf: If a column appears in a WHERE clause (or in a SQLObject.select keyword argument) it probably needs an index | 02:30 |
| lifeless | postgress://dbhost/dbname | 02:31 |
| daf | lifeless: thanks | 02:31 |
| daf | lifeless: where did you find it? | 02:31 |
| lifeless | I figured it out when we setup launchpad in production on macquarie | 02:32 |
| stub | daf: If you turn on postgresql logging of SQL commands and watch the file, it is often obvious what queries are chewing up the time | 02:33 |
| daf | stub: ok, thanks -- we'll make a list and let you know | 02:33 |
| stub | Oh..... indexes won't be used after you import a load of data until you ANALYZE. This might be the problem. | 02:34 |
| stub | (cause PostgreSQL thinks the tables have only a few rows and it isn't worth using them - analyze updates these stats) | 02:35 |
| carlos | stub: yes, that could be the problem | 02:35 |
| carlos | stub: any way to improve it? | 02:35 |
| stub | psql -d launchpad_test -c vacuum analyze | 02:35 |
| stub | psql -d launchpad_test -c 'vacuum analyze' | 02:35 |
| carlos | stub: will it work while the database is being used (adding more rows?) | 02:36 |
| stub | Yes | 02:36 |
| carlos | that will fix a part of the problem | 02:36 |
| stub | Just slows things down a bit while it is running :-) | 02:36 |
| carlos | stub: any way to do it automatically or every X inserts? | 02:37 |
| carlos | because we are importing about 1000 or 2000 new rows | 02:37 |
| carlos | and we lookup that table with every addition | 02:38 |
| stub | You generally run it from cron, or after you have made significant changes (% wise, not number of rows type things) | 02:38 |
| stub | If you have 10,000 rows and add 1000, it won't make any difference. If you have 0 and add 1000, it will | 02:38 |
| carlos | stub: the field we use is a string and it's a unique key and should be indexed because the WHERE clause ask for it | 02:39 |
| daf | so VACUUM ANALYZE will lead to an immediate improvement, or we need to define indexes and VACUUM ANALYZE? | 02:39 |
| stub | If you know the query that is slow (eg. select foo from bar), run 'explain select foo from bar' in psql. You get some confusing output, but if you see Seq Scan it means it is slow (full table scan). | 02:39 |
| carlos | daf: the VACUUM sentence is to update the index | 02:40 |
| carlos | stub: ok | 02:40 |
| stub | daf: In this case, probably immediate improvements since the indexes are likely already there (primary keys etc). | 02:41 |
| stub | Please don't put any ANALYZE commands in your scripts, unless they are scripts that load sample data for development btw - prod will do this via cron | 02:42 |
| carlos | ok | 02:42 |
| carlos | stub: what happens if it's a big transaction with lots of inserts and queries against those previous inserts? | 02:43 |
| carlos | we are talking about 1500 INSERTS or UPDATES | 02:45 |
| stub | carlos: On production, it probably won't make any difference unless you are changing a significant % of the rows in the table (say - 30%). | 02:45 |
| carlos | no, with every new import, the proportion will be smaller | 02:46 |
| stub | So does the vacuum analyze speed things up in this case? | 02:47 |
| carlos | no, it's still slow | 02:48 |
| carlos | perhaps it helped | 02:48 |
| stub | Do you know the query that is running slow? | 02:48 |
| carlos | but I'm still importing the same .po file with 1500 strings | 02:48 |
| carlos | stub: no | 02:48 |
| daf | carlos: did you time it? | 02:48 |
| daf | carlos: "time python poimport.py"... | 02:49 |
| carlos | daf: no, but I think it started about 45 minutes ago | 02:49 |
| daf | ouch! | 02:49 |
| stub | I thought we were talking seconds... not minutes! | 02:49 |
| daf | I was thinking more along the lines of importing one file twice, once before the analyze, once after | 02:50 |
| carlos | stub: even hours :-) | 02:50 |
| === carlos laughts because don't want to cry | ||
| stub | something else is really screwy. Look at your postgresql log file to see what queries are being run | 02:51 |
| stub | (preferably after turning that logging feature on...) | 02:52 |
| carlos | stub: I did and the queries executed by hand were fast | 02:53 |
| === carlos testing a small .po file | ||
| carlos | real 0m44.759s | 02:53 |
| carlos | user 0m5.635s | 02:53 |
| carlos | sys 0m0.335s | 02:53 |
| carlos | a .po with 77 messages | 02:54 |
| stub | Still worth a 'tail -f' on the log during a run - might just be qualtity of queries | 02:54 |
| carlos | and a reimport test of the same .po file: | 02:56 |
| carlos | real 1m26.643s | 02:56 |
| carlos | user 0m5.238s | 02:56 |
| carlos | sys 0m0.334s | 02:56 |
| carlos | stub: I will test the import of a .po file with only a msgid so I get all queries we do to import it | 02:57 |
| carlos | hmm | 03:01 |
| carlos | 2004-09-16 15:01:09 [6093] LOG: unexpected EOF on client connection | 03:01 |
| carlos | is it normal after the script ends? | 03:01 |
| carlos | should we execute anything to close the connection? | 03:01 |
| stub | conection.close() is nice | 03:02 |
| daf | carlos: is this with poimport.py | 03:03 |
| daf | ? | 03:03 |
| carlos | daf: ye | 03:04 |
| carlos | yes | 03:04 |
| daf | hmm, that should be closing the transaction | 03:04 |
| === daf will be out for 10-15 minutes | ||
| daf | carlos: shall we have the meeting at 13:30? | 03:07 |
| carlos | daf: could we move it for later then? | 03:07 |
| carlos | daf: I will have lunch at that time | 03:07 |
| carlos | 14:00? | 03:07 |
| daf | I have a meeting with the Soyuz guys then | 03:08 |
| daf | perhaps we could do both in parallel | 03:08 |
| carlos | daf: we could delay it more if you want | 03:08 |
| carlos | daf: I have work to do | 03:09 |
| carlos | so I'm not blocked for the meeting | 03:09 |
| daf | ok | 03:09 |
| daf | carlos: in future, can you attach big files to Bugzilla rather than pasting them? :) | 03:09 |
| carlos | ok | 03:09 |
| carlos | O:-) | 03:09 |
| daf | ok, see you later :) | 03:09 |
| carlos | later | 03:10 |
| === lulu [~lu@host217-37-231-28.in-addr.btopenworld.com] has joined #launchpad | ||
| cprov | daf: meeting in ten minutes ? | 03:50 |
| daf | cprov: hi | 03:50 |
| daf | cprov: might have to delay by 10 minutes or so | 03:51 |
| SteveA | hi daf | 03:51 |
| daf | hi Steve | 03:52 |
| SteveA | so, some things are running really slowly in rosetta? | 03:52 |
| daf | yes | 03:53 |
| daf | specifically, the import | 03:53 |
| daf | on my laptop, about 1.5 minutes to import a 512-message set PO file | 03:53 |
| daf | the server is slow also | 03:53 |
| cprov | daf: no problem, I and debonzi are going to kiko's place, 10 minutes will be enough, see you later :), tks | 03:54 |
| daf | we have an open bug about it, which has some discussion about the problem | 03:54 |
| daf | cprov: ok | 03:54 |
| daf | https://bugzilla.warthogs.hbd.com/bugzilla/show_bug.cgi?id=1973 | 03:55 |
| === kiko [~kiko@200-206-134-238.async.com.br] has joined #launchpad | ||
| kiko | are we launching? | 03:55 |
| kiko | (or are we keeping radio silence) | 03:56 |
| daf | kiko: I'm going to be a bit late | 03:57 |
| kiko | daf: you heartless man | 03:58 |
| debonzi | daf, see u in some minutes | 03:59 |
| debonzi | kiko, 10 min I'll be there | 03:59 |
| === debonzi running | ||
| carlos | daf: 1.5 minutes for a 512-message set PO file is not too much time | 04:11 |
| carlos | we should improve it, yes, but it's not bad | 04:11 |
| carlos | for me it takes much more time | 04:12 |
| SteveA | carlos: what is the usual range of sizes for a po file? | 04:17 |
| === cprov [~cprov@200-206-134-238.async.com.br] has joined #launchpad | ||
| === debonzi [~debonzi@200-206-134-238.async.com.br] has joined #launchpad | ||
| carlos | SteveA: I think we could say between 1500 - 2000 for non trivial applications | 04:18 |
| carlos | wait | 04:19 |
| carlos | SteveA: http://l10n-status.gnome.org/gnome-2.8/es/desktop/index.html | 04:19 |
| kiko | so | 04:19 |
| kiko | are we on? | 04:19 |
| carlos | seems like most gnome applications have less than 500 strings | 04:20 |
| carlos | but we have some with > 1500 and evolution with > 4000 | 04:20 |
| carlos | if it's a text or trivial graphical application < 500 is the normal, a complex graphical application > 1500 | 04:21 |
| cprov | daf: just say when you are ready ... | 04:23 |
| daf | ok, back | 04:23 |
| kiko | ah, good. | 04:24 |
| daf | carlos: but if you have 30 languages, then importing that one product takes 45 minutes | 04:24 |
| carlos | daf: that's perfect, I'm taking 45 minutes for only one .po file!!1 | 04:24 |
| daf | carlos: really?! | 04:25 |
| carlos | daf: I'm going to do real test with time now | 04:25 |
| carlos | but I think soi | 04:25 |
| daf | carlos: which PO file? | 04:25 |
| carlos | gnome-applets | 04:25 |
| daf | kiko: ready when you are | 04:25 |
| kiko | so | 04:26 |
| kiko | cprov: can you paste in some urls for daf to check out where we want to fit the data? | 04:26 |
| cprov | kiko: yep, one minute | 04:26 |
| kiko | daf: some open questions first. | 04:26 |
| cprov | daf: first, can you update https://rosetta... | 04:27 |
| kiko | daf: do translations for a certain package have a "lifecycle"? | 04:27 |
| cprov | daf: the DB too, please :) | 04:27 |
| kiko | daf: i.e. do they start as open and then go through a review and closing process? | 04:27 |
| daf | kiko: they have a lifecycle | 04:28 |
| kiko | daf: what states? | 04:28 |
| daf | kiko: https://www.warthogs.hbd.com/RosettaTranslationStates | 04:28 |
| cprov | daf: aha | 04:29 |
| kiko | okay. | 04:30 |
| kiko | daf: what do you think makes sense to display from the soyuz side of things, related to: | 04:30 |
| kiko | - source packages | 04:30 |
| kiko | - people | 04:30 |
| kiko | - distribution | 04:31 |
| kiko | - distribution release | 04:31 |
| kiko | (assume distro and distro release are just a group of packages) | 04:31 |
| daf | hmm | 04:33 |
| daf | well, for source packages, distributions and releases, you could show translation statistics for a language | 04:34 |
| daf | you could show a pan-language translation statistic, but I don't think that's very useful | 04:34 |
| daf | for a person, not sure | 04:34 |
| daf | what sort of information about people does Soyuz currently show? | 04:34 |
| daf | cprov: server should be up now | 04:35 |
| kiko | daf: can we get this sort of statistic ready-made from rosetta? | 04:35 |
| daf | kiko: there are methods for statistics in th Rosetta interfaces | 04:35 |
| daf | kiko: but you will need to map source packages to projects | 04:35 |
| kiko | daf: also, is it interesting to show "open" or "pending" translations for a specific source packages? | 04:35 |
| kiko | daf: how would that be doable? | 04:35 |
| daf | what do you mean by "open" and "pending"? | 04:36 |
| cprov | daf: just have a look, at first, on ...soyuz/distros/ubuntu | 04:36 |
| kiko | I'm not sure -- perhaps something that indicates quickly that a certain package is "in need of" translations in certain languages. | 04:36 |
| kiko | daf: I'm thinking of something that will entice the soyuz user to hop into rosetta. | 04:37 |
| cprov | daf: It is the Distribution Main Page, we want to show, by Translation link (+translation) a set of translations informations . what do you think we can show ? | 04:38 |
| daf | cprov: I see it | 04:38 |
| daf | kiko: hmm | 04:38 |
| spiv | kiko: We can map SourcePackages to Products via the Packaging table, btw. | 04:39 |
| cprov | daf: so, do you have nice ideas ? | 04:39 |
| daf | if you have information about what languages a user speaks, then you can give them status of that package in those languages | 04:40 |
| kiko | spiv: ah, that is interesting indeed. | 04:40 |
| kiko | spiv: is that an easy query? In reality I want to get from a sourcepackage to a project. | 04:41 |
| kiko | daf: neat idea. but the user doesn't specify anywhere what language he speaks | 04:41 |
| kiko | daf: given a source package, for instance, can we provide a direct link that says "translate this package (using rosetta)"? | 04:42 |
| kiko | or help translate this package. | 04:42 |
| carlos | kiko: we have it from rosetta | 04:42 |
| daf | kiko: Rosetta stores information about a user's languages | 04:42 |
| daf | kiko: and you can quite easily get that information | 04:42 |
| kiko | daf: ah, cool. but is the user the same user as a soyuz user? : | 04:42 |
| spiv | kiko: I think so: select Project.id from Project where Project.id = Product.project and Product.id = Packaging.product and Packaging.sourcepackage = %d; | 04:42 |
| carlos | daf: https://rosetta.warthogs.hbd.com/rosetta/prefs | 04:43 |
| daf | kiko: yes | 04:43 |
| kiko | spiv: and with the project ID we can grab translation data, I assume? | 04:43 |
| kiko | daf: cool. jotted down. | 04:43 |
| spiv | Ask daf :) | 04:43 |
| carlos | hmm | 04:43 |
| carlos | kiko: https://rosetta.warthogs.hbd.com/rosetta/prefs | 04:43 |
| carlos | :-P | 04:43 |
| spiv | Although I suspect product is more useful to them (which is even simpler, if so) | 04:44 |
| carlos | daf should know about it already | 04:44 |
| daf | carlos: yeah, I think I've seen this page before | 04:44 |
| carlos | :-) | 04:44 |
| kiko | daf: don't you feel we should have a centralized "user central"? | 04:45 |
| daf | oops, looks like I broke the translator dashboard | 04:45 |
| daf | kiko: yeah, that's something we should be aiming for | 04:45 |
| kiko | I am bothered by the given name and password fields here that will need to be done in soyuz as well. | 04:45 |
| kiko | daf: but no effort towards that has started. that's bad. | 04:45 |
| === spiv agrees | ||
| carlos | kiko: that's a temporal solution so we can release the alpha | 04:46 |
| carlos | kiko: we work on the person table so it's the same for all launchpad | 04:46 |
| spiv | At the bare minimum, we should be aiming to re-use widgets between the soyuz/rosetta/malone people prefs pages, I think. | 04:46 |
| daf | what happened to widgets? | 04:46 |
| kiko | spiv: we need to use the same user data pages, I'm pretty sure. though under those you could have app-specific preferences if it made sense. | 04:47 |
| daf | kiko: it would be easy to link to Rosetta pages for products | 04:47 |
| kiko | spiv: I tend to think that languages are a "personal" configuration thing that isn't rosetta-specific. | 04:47 |
| spiv | kiko: I think we'll need app-specific prefs, but I think I'd prefer to re-use whole pages as well. | 04:47 |
| spiv | kiko: Right, not to mention generic stuff like name, passowrd and email address... | 04:47 |
| kiko | daf: okay, we'll start by doing that, I think then. | 04:47 |
| daf | so, you have a sourcepackage | 04:48 |
| spiv | kiko: For products, the query I gave above gets even simpler. | 04:48 |
| daf | you get the products for the sourcepackage | 04:48 |
| kiko | spiv: do you think you could get us some of this stuck in the database modules and then post a quick message to lp? | 04:49 |
| daf | for each product, you link to /rosetta/projects/${product/project/name}/${product/name} | 04:49 |
| spiv | kiko: Ok. | 04:49 |
| kiko | roxor | 04:49 |
| kiko | daf: what about those statistics, can we obtain those by just providing a product or group of products, or do we need to do more bit-scrubbing? | 04:50 |
| daf | kiko: well, it depends | 04:50 |
| daf | you can easily get a statistic for a (product, language) combination | 04:51 |
| daf | and you can easily make a pretty graph for it | 04:51 |
| kiko | ah, that's killer. | 04:51 |
| kiko | daf: any howto or example code? | 04:51 |
| daf | it's knowing which language to use that's the problem | 04:51 |
| kiko | daf: and for a group of products, this becomes harder? | 04:51 |
| daf | you *could* display all languages, but that would get very big | 04:52 |
| spiv | So, I'm expecting distributions will have a set of languages that they care about. | 04:52 |
| daf | kiko: well, you could average the stats across groups of products | 04:52 |
| kiko | spiv: ah, but the database says nothing of that :) | 04:52 |
| daf | spiv: could be, but what if that set is very big? | 04:52 |
| spiv | kiko: Right :) | 04:52 |
| kiko | daf: well, we can choose the user's preferred languages. | 04:53 |
| daf | kiko: right | 04:53 |
| spiv | daf: Good point. | 04:53 |
| kiko | that's already a good compromise imo. | 04:53 |
| daf | kiko: and fall back to a simple list if they haven't got any | 04:53 |
| kiko | okay. | 04:53 |
| kiko | daf: so we want example code that uses these stats. name a module! | 04:53 |
| spiv | And perhaps there will be multiple sets -- i.e. "we want 100% english, french, spanish, 95%+ for ...." | 04:53 |
| daf | kiko: look at canonical.rosetta.interfaces | 04:54 |
| spiv | Which is something to figure out later, but just a thought to keep in mind :) | 04:54 |
| daf | kiko: the *Count methods is what you want | 04:54 |
| kiko | daf: no callsites use this code today? | 04:55 |
| daf | kiko: yes | 04:55 |
| daf | kiko: I mean, some do | 04:55 |
| daf | I mean, what does "callsites" mean? | 04:56 |
| === kiko provokes daf into violence! | ||
| kiko | a callsite.. | 04:56 |
| kiko | a consumer perhaps? someone who uses that interface? | 04:56 |
| spiv | "caller"? | 04:56 |
| kiko | (callsite is pretty frequent in the mozilla circles but whatever). | 04:57 |
| daf | ok, with you now | 04:57 |
| daf | violence is never necessary :) | 04:57 |
| carlos | kiko: https://rosetta.warthogs.hbd.com/rosetta/projects/gnome/evolution/ | 04:58 |
| carlos | that page use them | 04:58 |
| kiko | carlos do you have a module name for that? | 04:58 |
| daf | carlos: ah, you beat me to it | 04:58 |
| carlos | kiko: browser.py | 04:58 |
| kiko | aha. | 04:58 |
| spiv | (ooh, shiny!) | 04:58 |
| cprov | spiv: don't you think we can simply link to this page (using srcpkg product) ? | 05:02 |
| cprov | spiv: I mean, do it now, and after work on a "translation console". | 05:03 |
| spiv | cprov: Well, first I'll add a .product attribute to SoyuzSourcePackage :) | 05:03 |
| carlos | daf: 4 minutes to import a .pot file... perhaps I had a problem in other place (perhaps in my mind) or it has been improved... | 05:03 |
| spiv | cprov: But yes, it should be easy to link to. | 05:04 |
| spiv | cprov: And I'd be happy to link first, and develop a console/portlet/whatever-we-call-it incrementally from there :) | 05:05 |
| cprov | spiv: ok, it would be nice anyway, get some colorfull details sometimes :) | 05:05 |
| spiv | Yeah, everyone loves shiny colourful graphs :) | 05:05 |
| carlos | spiv, cprov, kiko: If you are playing with the login stuff, look at rosetta/scripts/createuser.py | 05:06 |
| debonzi | spiv, I can make do .product attribute in SoyuzSourcePackage.. ok for you? | 05:09 |
| kiko | okay | 05:10 |
| kiko | this sounds like a good start | 05:10 |
| kiko | spiv, cprov, debonzi: you guys have anything else you are curious about? | 05:10 |
| debonzi | kiko, thats ok for now | 05:11 |
| spiv | debonzi: I've already started. | 05:11 |
| debonzi | spiv, no problem.. go already | 05:11 |
| cprov | kiko: not now, I think we can go ahead by email ... fitting ideas about portlet/console | 05:12 |
| spiv | kiko: Not at the moment.. I think we should probably bring up the people pages issue at the next launchpad meeting? | 05:12 |
| spiv | (and/or on the list?) | 05:13 |
| cprov | spiv: btw, have you seen the distro/team ? | 05:13 |
| cprov | spiv: I have add some confusing data to DB to explicity show the problems with person/team | 05:13 |
| kiko | spiv: definitely. | 05:13 |
| spiv | cprov: I haven't yet, I'll take a look. | 05:14 |
| cprov | spiv: ok | 05:14 |
| cprov | daf: carlos: spiv: thanks for the hints, lunch time | 05:19 |
| carlos | ok, later | 05:19 |
| === debonzi lunch | ||
| kiko | so | 05:27 |
| kiko | I'll write up a summary tonight. | 05:28 |
| kiko | and give some prodding where it's necessary. :) | 05:28 |
| carlos | about 15 minutes to import one .po with about 1500 strings, it's too much time but I think we could work on it after the alpha release (and before the beta release) | 05:35 |
| carlos | daf: is it ok for you? | 05:35 |
| carlos | of course, we are talking about my laptop, in the server it will take less time | 05:36 |
| daf | it'll have to do for now | 05:38 |
| carlos | I will change the bug about this to block the beta | 05:41 |
| carlos | daf: how is going #1969? | 05:44 |
| daf | carlos: partly done | 05:45 |
| daf | elmo: can you turn off HTTP auth on the other Rosetta server? | 05:45 |
| carlos | daf: do you need help? | 05:45 |
| carlos | I'm without any pending task blocking the alpha release | 05:46 |
| carlos | well, the initial import | 05:46 |
| carlos | but that's a computer work | 05:46 |
| carlos | I can do other things at the same time | 05:46 |
| daf | ok, am I using a script to do an initial import? | 05:46 |
| daf | I mean, am I using your import script, or just running the basic one? | 05:46 |
| carlos | it's a basic one, I will send you a .sql | 05:47 |
| daf | ok | 05:47 |
| carlos | but it's still working | 05:47 |
| daf | right, let me know when it's done | 05:47 |
| carlos | so It will take some time | 05:47 |
| carlos | sure | 05:47 |
| daf | I wonder what happened to Steve | 05:48 |
| carlos | So we have #1907, #1908, #1930, #1932, #1934 and #1969 to be able to release the alpha, right? | 05:48 |
| daf | carlos: I'm going to merge a patch to fix the translator dashboard | 05:49 |
| daf | when it's in, it should ask you for authentication before you can use it | 05:49 |
| === carlos didn't know was broken | ||
| carlos | :-) | 05:49 |
| carlos | ok | 05:49 |
| daf | that list looks complete | 05:49 |
| daf | I think I broke it yesterday | 05:49 |
| daf | or this morning, rather :) | 05:49 |
| carlos | ok | 05:49 |
| carlos | does your patch close the 1930? | 05:50 |
| daf | it does | 05:51 |
| daf | but it's pretty ugly | 05:51 |
| carlos | perfect :-D | 05:51 |
| carlos | don't worry | 05:51 |
| carlos | if it works should be enough | 05:51 |
| daf | yeah, we can make it prettier later | 05:51 |
| carlos | I will take care of #1932 (only gnome-panel and gnome-applets for the initial alpha release) | 05:52 |
| daf | oh, cool | 05:53 |
| carlos | limi should work on 1934 (and we could move it to the beta, it's mainly UI improvements...) | 05:53 |
| carlos | and you said that #1969 is partially done, right? | 05:53 |
| daf | yes | 05:53 |
| daf | and finishing it should be really easy | 05:53 |
| carlos | so let's go to relese!!!! | 05:54 |
| carlos | :-P | 05:54 |
| daf | just need to change pages.zcml | 05:54 |
| daf | but I want the HTTP auth turned off first | 05:54 |
| carlos | the 1907 and 1908 are only reviews, so I suppose we could punt them to post alpha, right? | 05:54 |
| daf | if necessary | 05:55 |
| daf | if Steve can look at them before we release, that would be good | 05:55 |
| daf | but if everything else is closed, then yes, we should release | 05:56 |
| daf | limi should be back sometime today, I think | 05:56 |
| daf | he was only going to the dentist | 05:56 |
| carlos | ok | 05:57 |
| daf | "punt" is a good word | 05:57 |
| carlos | daf: I don't know the exact meaning, but it's the term we use with GNOME bugs | 05:58 |
| carlos | I get the idea | 05:58 |
| carlos | so I understand it :-) | 05:58 |
| carlos | but I don't know the translation, so... time to look for it :-D | 05:58 |
| daf | punting is to do with boars | 05:59 |
| daf | er, boats | 05:59 |
| carlos | hmm, I don't get the meaning in Spanish :-P | 06:01 |
| daf | it's a type of boat | 06:03 |
| daf | it's also a way of moving a boat using a pole | 06:03 |
| carlos | yes, it's more or less the meaning of the translation, but I don't see the meaning :-P | 06:04 |
| daf | well, when you're talking about bugs it means something completely different :) | 06:07 |
| carlos | :-) | 06:08 |
| carlos | shit, I was planning to attend the GNOME Summit but they moved it to October | 06:36 |
| carlos | :-( | 06:36 |
| daf | where is it? | 06:39 |
| carlos | daf: GNOME Summit 3 | 06:40 |
| carlos | October 9 - 11, 2004 | 06:40 |
| carlos | from 10:00 AM to 6:00 PM | 06:40 |
| carlos | Stata Center <http://web.mit.edu/evolving/stata/photos/photos2.html> | 06:40 |
| carlos | MIT | 06:40 |
| carlos | Cambridge, MA | 06:40 |
| carlos | I went last year | 06:40 |
| carlos | and I thought this year is also on november | 06:41 |
| daf | :( | 06:45 |
| === debonzi [~debonzi@200.158.100.251] has joined #launchpad | ||
| carlos | daf: merge confirmed | 06:50 |
| === cprov [~cprov@200.158.100.251] has joined #launchpad | ||
| daf | carlos: https://rosetta.ubuntulinux.org/++skin++Debug/rosetta/translator | 06:56 |
| daf | oh, whoops, mea culpa | 06:56 |
| carlos | daf: :-) | 06:57 |
| cprov | spiv: ping ? | 06:57 |
| spiv | pong! | 06:58 |
| daf | carlos: hmm, I can't seem to log in | 06:58 |
| daf | should be working now | 06:59 |
| cprov | spiv: you inserted the product "firefox" reference on sampledata-soyuz.sql before I was created (by rosetta) | 06:59 |
| carlos | daf: where could I see the query that the login dialog does? | 06:59 |
| carlos | the db query | 06:59 |
| daf | carlos: go to https://rosetta.ubuntulinux.org/rosetta, then click on the translator link | 06:59 |
| cprov | spiv: \s\I\it sorry | 07:00 |
| daf | the db query? not sure | 07:00 |
| spiv | cprov: Oh, right. | 07:00 |
| carlos | daf: I mean the python code :-P | 07:00 |
| daf | you'd need to ask Steve that | 07:00 |
| carlos | I was able to login | 07:00 |
| carlos | with my information | 07:01 |
| daf | hrm | 07:01 |
| carlos | but I saw your preferences :-? | 07:01 |
| spiv | Probably in canonical.lp.placelessauth? | 07:01 |
| daf | spiv: probably | 07:01 |
| carlos | let me check.. | 07:01 |
| daf | carlos: ok, I can log in as daf, but not as the test user | 07:01 |
| cprov | spiv: complicated solution, I though, or place it on rosetta or move all rosetta inserts for product firefox to soyuz ? | 07:02 |
| === carlos misses the logout button... | ||
| carlos | daf: it should work :-? | 07:04 |
| cprov | spiv: sorry, firefox product is a malone insert | 07:05 |
| spiv | cprov: Yeah, I was just noticing. | 07:05 |
| spiv | daf: Incoming parent... ;) | 07:05 |
| carlos | daf: it works for me | 07:06 |
| carlos | login: foo.bar@canonical.com | 07:06 |
| carlos | pass: test | 07:06 |
| carlos | I still see your personal data instead of the foo bar one | 07:06 |
| daf | oh, I thought it was test@ | 07:06 |
| daf | carlos: that's a bug in the preferences page | 07:07 |
| carlos | no, sorry O:-) | 07:07 |
| daf | >:-) | 07:07 |
| daf | we should get rid of the fake users where we can | 07:07 |
| spiv | cprov: The malone sampledata depends on soyuz sampledata; probably the easiest thing is to make a new sampledata-soyuz-extra.sql and add it to the Makefile..? | 07:08 |
| spiv | A little icky, but simple. | 07:08 |
| cprov | spiv: I just figured out that the Packaging INSERT should be on malone together others related to it (project, sourcepackagerelease and so on) | 07:08 |
| spiv | cprov: Ok, that's probably better than a new file. | 07:08 |
| cprov | spiv: yep | 07:09 |
| spiv | Even though strictly speaking it isn't sample data for Malone :) | 07:09 |
| spiv | Do you want to do that, or should I? | 07:09 |
| spiv | If you haven't already started, I'm happy to do it :) | 07:09 |
| cprov | spiv: even sourcepackagerelease ? you can do :) | 07:09 |
| carlos | daf: but I changed the fake user to be foo bar instead of you with the same patchset I added the emails | 07:10 |
| spiv | I was just going to move that one statement... oh, except it depends on soyuz data too :( | 07:10 |
| spiv | I think I'm leaning towards a new file, rather than dragging half the soyuz sample data into malone's. One statement isn't too bad, but half the file is a bit excessive. | 07:11 |
| spiv | cprov: Either way, I'll do it :) | 07:12 |
| cprov | spiv: anyway the data are arranged in dependecy level in soyuz, if you insert in the correct place no reference will be missed, except "Sample Person" ( ohhh ?? ) | 07:13 |
| daf | carlos: right, but we eventually want to get rid of fake_user() | 07:13 |
| carlos | daf: sure | 07:13 |
| daf | carlos: hmm, what langauges should the product-index.pt page show if the user is not logged in? | 07:14 |
| carlos | daf: that's a good question | 07:14 |
| cprov | spiv: yep, I'm waiting your patch | 07:14 |
| daf | carlos: I'll file a bug | 07:15 |
| carlos | we should hardcode a list or implement something like the widget that let's you navigate inside the strings to translate | 07:15 |
| carlos | so we don't show ever more than 5/8 languages | 07:15 |
| spiv | cprov: Nearly there :) | 07:16 |
| daf | https://bugzilla.warthogs.hbd.com/bugzilla/show_bug.cgi?id=1976 | 07:17 |
| spiv | cprov: mirrored, merge request sent. | 07:17 |
| carlos | ok | 07:18 |
| daf | https://bugzilla.warthogs.hbd.com/bugzilla/show_bug.cgi?id=1977 | 07:19 |
| daf | I'll make 1976 beta-critical | 07:20 |
| cprov | spiv: thanks, I'm waiting the lazy arch star-merge :( | 07:20 |
| carlos | daf: makes sense | 07:21 |
| daf | wow, the dependency graph has gotten messy | 07:22 |
| carlos | it should remove the old bugs or the graph will not be useful in some months | 07:23 |
| daf | yeah | 07:24 |
| daf | I asked it to generate a dependency graph for the .info imports and it went crazy :) | 07:24 |
| carlos | .info imports? | 07:24 |
| daf | yeah, for Warty | 07:24 |
| carlos | URL? | 07:24 |
| daf | don't bother | 07:25 |
| carlos | :-P | 07:25 |
| carlos | ok | 07:25 |
| daf | it takes about 10 minutes to generate a very silly graph | 07:25 |
| daf | with a few hundred bugs in it | 07:25 |
| daf | it was very narrow | 07:25 |
| daf | and very tall | 07:25 |
| daf | and had a few small dots on it | 07:25 |
| carlos | malone will do it better :-P | 07:25 |
| daf | I'm sure it will :-) | 07:25 |
| carlos | every .po file taks about 30 minutes to be imported now | 07:25 |
| carlos | I think I will give you a .sql with all ready to import gnome-panel's .po file in the server | 07:26 |
| carlos | (when I finish with gnome-applet) | 07:26 |
| carlos | it will be faster | 07:26 |
| === lulu [~lu@host217-37-231-28.in-addr.btopenworld.com] has left #launchpad [] | ||
| daf | carlos: how are you doing the import? | 07:54 |
| carlos | for i in `ls *.po`; do time python /home/carlos/Work/rosetta/scripts/poimport.py -o 4 -f $i -p gnome -d gnome-applets -t main-2.8 -l `echo $i |cut -f 1 -d '.'`; done | 07:54 |
| daf | do you have an estimate for how long it will take to finish? | 07:55 |
| carlos | I could tell you it | 07:55 |
| carlos | it's on en_CA now | 07:56 |
| daf | am I user id 4? | 07:56 |
| carlos | hmm | 07:56 |
| carlos | perhaps tomorrow <- impossible to do it in my laptop... | 07:56 |
| daf | I'm just wondering whether it might be faster for me to run that on the server | 07:56 |
| carlos | daf: yes I don't have the other launchpad data imported | 07:57 |
| carlos | daf: that's what I suggested some minutes ago | 07:57 |
| daf | oh | 07:57 |
| daf | right | 07:57 |
| carlos | I will wait until the en_CA.po is imported (it should finish soon) | 07:58 |
| carlos | and I will prepare a .sql file with my current database | 07:58 |
| carlos | so you don't need to start from scratch | 07:59 |
| carlos | daf: you need to "apt-get source gnome-panel gnome-applets" from warty | 08:01 |
| daf | arg, no deb-src line in sources.list | 08:01 |
| daf | can you give me a URL? | 08:01 |
| carlos | trying | 08:05 |
| carlos | but it's too slow | 08:05 |
| carlos | http://archive.ubuntu.com/ubuntu/pool/main/g/gnome-applets/ | 08:05 |
| carlos | http://archive.ubuntu.com/ubuntu/pool/main/g/gnome-panel/ | 08:05 |
| carlos | ok, the en_CA.po is imported | 08:07 |
| === carlos prepares a .sql export | ||
| carlos | daf: you have the .sql at chinstrap's /home/carlos/launchpad.sql.gz | 08:14 |
| daf | right, thanks | 08:14 |
| daf | what does it include? | 08:15 |
| carlos | you don't need the schema | 08:15 |
| carlos | it will drop the database | 08:15 |
| carlos | and create and fill it | 08:15 |
| carlos | only rosetta data | 08:15 |
| daf | ok | 08:15 |
| carlos | you can import the other .sql if you want | 08:15 |
| carlos | take care that perhaps it hardcode the launchpad_test name | 08:15 |
| carlos | I'm not sure | 08:15 |
| carlos | no, it's not hardcoded | 08:16 |
| carlos | you create a database and it will create all tables and data | 08:16 |
| carlos | when you have all ready, tell me it. | 08:16 |
| carlos | it includes already some gnome-applets .po files | 08:17 |
| daf | carlos: ok, so I run "zcat launchpad.sql.gz" | psql -f -"? | 08:33 |
| carlos | no | 08:33 |
| carlos | "zcat launchpad.sql | psql launchpad_test" | 08:33 |
| carlos | you need the database created (if it's empty it's ok) | 08:34 |
| carlos | the -f - is not needed | 08:34 |
| carlos | hmmm | 08:34 |
| carlos | sorry put it | 08:34 |
| carlos | I'm not sure now.. | 08:34 |
| daf | :) | 08:35 |
| daf | psql:<stdin>:67148: ERROR: must be owner of schema public | 08:37 |
| carlos | hmm | 08:37 |
| carlos | let me export it as INSERTS | 08:37 |
| carlos | perhaps it's more "portable" | 08:37 |
| daf | ok | 08:38 |
| carlos | daf: could you try to execute it into the psql? | 08:51 |
| carlos | ALTER TABLE ONLY public.sourcepackage DROP CONSTRAINT "$4"; | 08:51 |
| daf | carlos: I'm having some trouble with my connection to the server | 08:52 |
| carlos | ok | 08:52 |
| carlos | daf: when you are able to test it, tell me it, so I can continue with the .sql export | 08:55 |
| daf | ok | 08:56 |
| carlos | thanks | 08:56 |
| carlos | daf: should we ask lalo to join the channel so we can coordinate better the release? | 08:56 |
| daf | I suspect it might just be easier to run the import on the server | 08:56 |
| daf | carlos: I'll do that | 08:57 |
| carlos | daf: ok | 08:57 |
| carlos | daf: I will add then the products creation to the sampledata-rosetta-alpha.sql file | 08:57 |
| === npmccallum [~npmccallu@69-162-252-7.ironoh.adelphia.net] has joined #launchpad | ||
| daf | carlos: seems he can't use IRC at the moment | 08:59 |
| carlos | :-( | 09:00 |
| daf | carlos: I think I need to take a break -- my head is starting to hurt | 09:04 |
| carlos | daf: ok | 09:05 |
| carlos | daf: see you later | 09:05 |
| daf | carlos: I forgot to mention -- on the server, even though python is using 50% CPU and postgres 20%, importing the gnome-applets template takes 30s | 09:06 |
| carlos | daf: it took 4 minutes in my computer | 09:07 |
| carlos | it's the .po file what takes much more time | 09:07 |
| daf | right, I'll time that when I run it | 09:08 |
| carlos | ok | 09:08 |
| carlos | daf: go away!!! | 09:09 |
| carlos | :-P | 09:09 |
| === limi [~limi@193.80.99.106] has joined #launchpad | ||
| === limi [~limi@193.80.99.106] has left #launchpad [] | ||
| carlos | daf: ping | 10:49 |
| daf | pong | 10:50 |
| carlos | daf: any way to debug | 10:50 |
| carlos | the problem when you don't see any english text? | 10:50 |
| daf | can you reproduce it? | 10:50 |
| carlos | yes | 10:51 |
| carlos | my local server | 10:51 |
| daf | have you looked in the database? | 10:51 |
| carlos | with the gnome-applets have that problem | 10:51 |
| carlos | I don't know what should I look | 10:51 |
| daf | ok, can you find the message IDs for the PO file? | 10:51 |
| carlos | funny: Untranslated messages: -751 | 10:52 |
| carlos | daf: one second | 10:52 |
| === carlos is getting a .po file exported first | ||
| carlos | wow | 10:53 |
| carlos | the slow problem is also with po export... | 10:53 |
| carlos | daf: bug detected | 10:56 |
| carlos | launchpad_test=# SELECT * from pomsgid where id=1; | 10:56 |
| carlos | id | msgid | 10:56 |
| carlos | ----+-------- | 10:56 |
| carlos | 1 | _About | 10:56 |
| carlos | (1 row) | 10:56 |
| carlos | launchpad_test=# SELECT * from pomsgid where id=2; | 10:56 |
| carlos | id | msgid | 10:56 |
| carlos | ----+------- | 10:56 |
| carlos | 2 | | 10:56 |
| carlos | (1 row) | 10:56 |
| carlos | both are the msgid for the first msgset | 10:57 |
| daf | what do you mean, both are?! | 10:58 |
| daf | there are two message ID sightings? | 10:58 |
| carlos | that we have two rows where we should have only one | 10:58 |
| carlos | yes | 10:58 |
| daf | with the same plural form? | 10:58 |
| carlos | launchpad_test=# SELECT * from pomsgidsighting where pomsgset=1; | 10:59 |
| carlos | id | pomsgset | pomsgid | datefirstseen | datelastseen | inlastrevision | pluralform | 10:59 |
| carlos | ----+----------+---------+----------------------------+----------------------------+----------------+------------ | 10:59 |
| carlos | 1 | 1 | 1 | 2004-09-16 16:56:34.057532 | 2004-09-16 16:56:34.057532 | f | 0 | 10:59 |
| carlos | 2 | 1 | 2 | 2004-09-16 16:56:34.110388 | 2004-09-16 16:56:34.110388 | t | 1 | 10:59 |
| carlos | (2 rows) | 10:59 |
| carlos | that's not a plural form | 10:59 |
| daf | ok, but the second sighting has pluralform=1 | 10:59 |
| carlos | msgid "_About" | 10:59 |
| carlos | msgstr "" | 10:59 |
| daf | and the the first one also has inlastrevision=f | 10:59 |
| carlos | and the first one is the correct one | 11:00 |
| daf | weeeeeird | 11:00 |
| carlos | the second is "" | 11:00 |
| daf | bug! bug!! | 11:00 |
| carlos | big bug | 11:00 |
| daf | I am also getting weird problems with authentication | 11:00 |
| carlos | daf: seems like finally it works here | 11:00 |
| carlos | I don't see you information anymore, I see the default one | 11:01 |
| carlos | I mean the foo bar one | 11:01 |
| daf | I made some changes locally which breaks it somehow | 11:01 |
| daf | I can't work out how | 11:01 |
| carlos | hmm but my server did not asked me for a login... | 11:01 |
| carlos | is that normal? | 11:01 |
| carlos | ok, you don't have it activated in all places yet | 11:01 |
| daf | it should ask you for a login, I think | 11:02 |
| carlos | yes, but only from the translator dashboard | 11:02 |
| daf | oh right, yes | 11:02 |
| daf | the preferences one isn't activated | 11:02 |
| daf | I'll do that now | 11:03 |
| carlos | and now I see your information as mine, so it's still broken | 11:03 |
| carlos | ok | 11:03 |
| carlos | daf: do you need help to debug your problem? | 11:03 |
| daf | for now, I will just undo the change | 11:03 |
| daf | I've emailed Steve | 11:03 |
| carlos | ok, I will look at the bug with the import | 11:03 |
| daf | seems lalo is on Jabber | 11:04 |
| carlos | but I will file it first | 11:04 |
| daf | right | 11:04 |
| carlos | daf: not now | 11:04 |
| daf | he looks online to me | 11:04 |
| carlos | not for me :-? | 11:04 |
| carlos | restarting | 11:04 |
| carlos | still missing | 11:04 |
| carlos | yes, I see lalo now | 11:05 |
| daf | hmm, Jabber being weird again | 11:05 |
| carlos | I will file the bug report | 11:05 |
| carlos | daf: #1978 | 11:13 |
| daf | thanks | 11:14 |
| carlos | hmm | 11:23 |
| carlos | daf: do you read anything from me? | 11:23 |
| daf | yes | 11:23 |
| carlos | at jabber? | 11:23 |
| daf | yes | 11:23 |
| carlos | I don't get my text back | 11:24 |
| carlos | now | 11:24 |
| carlos | wow | 11:24 |
| carlos | lag | 11:24 |
| carlos | lag | 11:24 |
| carlos | lag | 11:24 |
| carlos | for one minute | 11:24 |
| daf | l | 11:24 |
| daf | a | 11:24 |
| daf | g | 11:24 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!