| chat.freenode.net #tryton log beginning Thu Jul 28 00:00:03 CEST 2011 | ||
| 2011-07-28 00:32 <meanmicio> hi there. Is there a way of using the default (GTK) theme for some icons - like "gtk-ok" or we always have to provide the svg ? | ||
| 2011-07-28 00:37 <cedk> meanmicio: it is better for consistency to provide the svg | ||
| 2011-07-28 00:41 -!- zodman(~zodman@foresight/developer/zodman) has joined #tryton | ||
| 2011-07-28 00:42 -!- vladimirek(~vladimire@bband-dyn21.178-41-212.t-com.sk) has joined #tryton | ||
| 2011-07-28 00:57 -!- gremly(~gremly@200.106.218.64) has joined #tryton | ||
| 2011-07-28 01:07 -!- alimon(~alimon@201.158.247.118) has joined #tryton | ||
| 2011-07-28 01:32 -!- fremo(~fremo@noc.toile-libre.net) has joined #tryton | ||
| 2011-07-28 01:34 -!- ikks(~ikks@190.25.51.134) has joined #tryton | ||
| 2011-07-28 02:47 -!- meanmicio(~lfm@190.195.50.15) has joined #tryton | ||
| 2011-07-28 02:48 <meanmicio> cedk : thanks, i'm providing the SVGs, so we're ok :-) | ||
| 2011-07-28 03:03 -!- mhi1(~mhi@pd95b104a.dip0.t-ipconnect.de) has joined #tryton | ||
| 2011-07-28 03:03 -!- okko1(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-07-28 04:04 -!- bvillasanti(~bruno@190.105.69.216) has joined #tryton | ||
| 2011-07-28 05:16 -!- yangoon(~mathiasb@p54B4EF66.dip.t-dialin.net) has joined #tryton | ||
| 2011-07-28 05:21 -!- bvillasanti(~bruno@190.105.69.216) has left #tryton | ||
| 2011-07-28 05:32 -!- gremly(~gremly@200.106.218.64) has joined #tryton | ||
| 2011-07-28 05:45 -!- zodman_(~zodman@189.178.254.219) has joined #tryton | ||
| 2011-07-28 06:10 -!- alimon(~alimon@189.154.61.121) has joined #tryton | ||
| 2011-07-28 07:45 -!- vladimirek(~vladimire@bband-dyn21.178-41-212.t-com.sk) has joined #tryton | ||
| 2011-07-28 07:50 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2011-07-28 08:40 -!- ecarreras(~under@unaffiliated/ecarreras) has joined #tryton | ||
| 2011-07-28 08:46 -!- okko1(~okko@62.58.29.41) has joined #tryton | ||
| 2011-07-28 09:22 -!- enlightx(~enlightx@static-217-133-61-144.clienti.tiscali.it) has joined #tryton | ||
| 2011-07-28 09:43 -!- bechamel(~user@cismwks02-virtual1.cism.ucl.ac.be) has joined #tryton | ||
| 2011-07-28 09:53 -!- nicoe(~nicoe@62.58.29.41) has joined #tryton | ||
| 2011-07-28 09:54 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2011-07-28 10:27 -!- elbenfreund(~elbenfreu@g227130021.adsl.alicedsl.de) has joined #tryton | ||
| 2011-07-28 11:50 -!- sharkcz(~sharkcz@72.155.broadband6.iol.cz) has joined #tryton | ||
| 2011-07-28 12:47 -!- enlightx(~enlightx@dynamic-adsl-94-34-231-35.clienti.tiscali.it) has joined #tryton | ||
| 2011-07-28 13:22 -!- ccomb(~ccomb@94.122.102.210) has joined #tryton | ||
| 2011-07-28 14:15 -!- heg(~heg@dyn.144-85-162-171.dsl.vtx.ch) has joined #tryton | ||
| 2011-07-28 14:49 -!- saxa(~sasa@189.26.255.43) has joined #tryton | ||
| 2011-07-28 15:07 -!- sharoon(~sharoon@173-9-190-185-miami.txt.hfc.comcastbusiness.net) has joined #tryton | ||
| 2011-07-28 15:07 -!- sharoon_(~sharoon@2001:470:5:630:6446:eb0c:c0b5:b55d) has joined #tryton | ||
| 2011-07-28 15:15 -!- ccomb(~ccomb@94.122.102.210) has joined #tryton | ||
| 2011-07-28 15:37 -!- elbenfreund(~elbenfreu@g227130021.adsl.alicedsl.de) has joined #tryton | ||
| 2011-07-28 15:43 <sharoon> cedk: ping | ||
| 2011-07-28 15:46 <cedk> sharoon: pong | ||
| 2011-07-28 15:47 <sharoon> cedk: i really liked pysql | ||
| 2011-07-28 15:48 <cedk> sharoon: it is not yet the past :-) | ||
| 2011-07-28 15:48 <sharoon> cedk: is anything planned for documentation ? I could write sphinx style documentation for it if you you will be able to merge a diff | ||
| 2011-07-28 15:49 <cedk> sharoon: I will soon push it in a repository to start the shared development | ||
| 2011-07-28 15:50 <sharoon> cedk: sure, and then i will write the documentation for it | ||
| 2011-07-28 15:53 <sharoon> cedk: i feel we have a memory leak related to browse records, especially when the crons are run, have you seen any such behavior before ? | ||
| 2011-07-28 15:53 <cedk> sharoon: no | ||
| 2011-07-28 15:54 <sharoon> cedk: i used dowser and the graph was showing that BrowseRecord and BrowseRecordList to be the cluprits | ||
| 2011-07-28 15:54 <sharoon> cedk: it may be because of the strong reference that is held to cursor | ||
| 2011-07-28 15:55 <cedk> sharoon: it is clean once the cursor is closed | ||
| 2011-07-28 15:55 <sharoon> cedk: i am of the opinion that browse record's must not have a strong reference to the cursor, either call the cursor with Transaction().cursor or have a weak ref to cursor | ||
| 2011-07-28 15:55 <sharoon> cedk: what do you think about such an alternative ? | ||
| 2011-07-28 15:56 <cedk> sharoon: bad, BrowseRecord must always be used with the same cursor | ||
| 2011-07-28 15:57 <sharoon> cedk: so weak referencing can do that ? because it will return None once the cursor does not exist ? | ||
| 2011-07-28 15:59 <sharoon> cedk: on a separate note, our unit tests for mysql don't seem to be working | ||
| 2011-07-28 16:02 <cedk> sharoon: yes after upgrade of the server something is going wrong | ||
| 2011-07-28 16:03 <sharoon> cedk: do you want me to test BrowseRecord with weak ref to cursor and run the entire unit tests ? | ||
| 2011-07-28 16:03 <cedk> sharoon: I start to be boring on how crappy MySQL is | ||
| 2011-07-28 16:04 <sharoon> cedk: don't offend mysql ;) it runs the web including a few thousand by Facebook ;-) | ||
| 2011-07-28 16:05 <cedk> sharoon: MySQL is not as susceptible as OE :-) | ||
| 2011-07-28 16:06 <cedk> sharoon: if you want you can test but I'm not sure it is linked to that | ||
| 2011-07-28 16:06 <sharoon> cedk: "please take care about your "marketing"" | ||
| 2011-07-28 16:08 <cedk> sharoon: "marketing" is for bad software :-) | ||
| 2011-07-28 16:08 <sharoon> cedk: sure, will try and I am able to reproduce the problem with a cron task we have (with quite a few records) | ||
| 2011-07-28 16:08 <sharoon> cedk: i will try it and let you know if it solves the problem | ||
| 2011-07-28 16:09 <sharoon> cedk: also regarding pysql, a suggestion i have is we should optimize using __slots__ because if we start using it for software like tryton we will end up instantiating huge number of each of those classes | ||
| 2011-07-28 16:09 <cedk> sharoon: I don't see how BrowseRecord could survive after Transaction.stop | ||
| 2011-07-28 16:10 <sharoon> cedk: the ir.cron closes the Transaction only at the end of all the croons it will run, in our case this has resulted in over 800000 Browse Records in memory | ||
| 2011-07-28 16:10 <sharoon> cedk: s/croons/crons | ||
| 2011-07-28 16:11 <cedk> sharoon: I guess it is more your cron job that need to be improved | ||
| 2011-07-28 16:11 <sharoon> cedk: it is generate_purchase_requests | ||
| 2011-07-28 16:11 <cedk> sharoon: ha ok, then it needs to be improved :-) | ||
| 2011-07-28 16:12 <sharoon> cedk: and i feel the problem is it loads all products into memory too | ||
| 2011-07-28 16:12 <cedk> sharoon: yes | ||
| 2011-07-28 16:12 <sharoon> cedk: what do you think of computing purchase requests for products in batches ? | ||
| 2011-07-28 16:12 <cedk> sharoon: about __slots__, it will come later once API is clearly defined | ||
| 2011-07-28 16:13 <sharoon> cedk: great, i think that will make it really fast :-) | ||
| 2011-07-28 16:13 <cedk> sharoon: have you the LRU patch? | ||
| 2011-07-28 16:14 <sharoon> nope, is it applied on trunk ? | ||
| 2011-07-28 16:14 <cedk> sharoon: yes | ||
| 2011-07-28 16:16 <sharoon> cedk: does that speed this up ? | ||
| 2011-07-28 16:17 <cedk> sharoon: it prevent to fill the memory with BrowseRecord instance | ||
| 2011-07-28 16:18 <sharoon> cedk: ok, i will try with that first | ||
| 2011-07-28 16:18 <cedk> sharoon: it keeps in memory only a range of the record in the list | ||
| 2011-07-28 16:18 <sharoon> cedk: will try and let you know the result, just downloaded the patch set | ||
| 2011-07-28 16:22 <cedk> sharoon: how much products, locations and orderpoint have you? | ||
| 2011-07-28 16:23 <sharoon> cedk: locations - standard (we don't use locations feature much), order points for all products and 1M products | ||
| 2011-07-28 16:24 <cedk> sharoon: ok I really think you need LRU patch :-) | ||
| 2011-07-28 16:24 <sharoon> cedk: sure | ||
| 2011-07-28 16:31 -!- alimon(~alimon@189.154.61.121) has joined #tryton | ||
| 2011-07-28 16:43 -!- elbenfreund(~elbenfreu@p54B94558.dip.t-dialin.net) has joined #tryton | ||
| 2011-07-28 16:56 -!- dfamorato(~dfamorato@2001:470:5:630:c8d6:c063:228a:42bb) has joined #tryton | ||
| 2011-07-28 16:57 -!- cheche(cheche@46.25.80.67) has joined #tryton | ||
| 2011-07-28 16:58 <cheche> how do i force trutond to listen only on ipv4? | ||
| 2011-07-28 16:58 <cheche> how do i force trytond to listen only on ipv4? | ||
| 2011-07-28 16:58 <cedk> cheche: set an ipv4 as interface | ||
| 2011-07-28 16:59 <cheche> on ./etc/trytond.conf | ||
| 2011-07-28 16:59 <cheche> # Configure the IP address for trytond | ||
| 2011-07-28 16:59 <cheche> # If empty, the server will listen on all available interfaces | ||
| 2011-07-28 16:59 <cheche> #interface = br0 | ||
| 2011-07-28 17:00 <cheche> usually is eth0 i guess | ||
| 2011-07-28 17:01 <cedk> cheche: ok miss wording in the config file, interface accept only ip | ||
| 2011-07-28 17:02 <cedk> cheche: or hostname but not interface name | ||
| 2011-07-28 17:02 <cedk> ACTION arg! again a OE legacy | ||
| 2011-07-28 17:04 <cheche> shit, still not working. | ||
| 2011-07-28 17:04 <cheche> casa:/var/log# netstat -anp | grep LISTEN | grep py | ||
| 2011-07-28 17:04 <cheche> tcp 0 0 192.168.1.2:8070 0.0.0.0:* LISTEN 18805/python | ||
| 2011-07-28 17:04 <cheche> it listen on ipv4 | ||
| 2011-07-28 17:05 <cheche> but tryton cclinete still not connecting | ||
| 2011-07-28 17:05 <cheche> 2unable to connect to server" | ||
| 2011-07-28 17:05 <cheche> "unable to connect to server" | ||
| 2011-07-28 17:05 <cedk> cheche: check your firewall? | ||
| 2011-07-28 17:06 <cheche> I am trying to acces from same mmachine | ||
| 2011-07-28 17:06 <cheche> no firewall installed. | ||
| 2011-07-28 17:07 <cheche> telnet working | ||
| 2011-07-28 17:07 <cheche> casa:/var/log# telnet 192.168.1.2 8070 | ||
| 2011-07-28 17:07 <cheche> Trying 192.168.1.2... | ||
| 2011-07-28 17:07 <cheche> Connected to 192.168.1.2. | ||
| 2011-07-28 17:07 <cheche> Escape character is '^]'. | ||
| 2011-07-28 17:07 <cedk> cheche: what do you use as hostname in the client? | ||
| 2011-07-28 17:07 <cheche> 192.168.1.2 and localhost both fail | ||
| 2011-07-28 17:07 <cedk> cheche: is the client version the same as the server? | ||
| 2011-07-28 17:08 <cheche> yes 1.6.1 (whatever was on debian | ||
| 2011-07-28 17:09 <cheche> I only found this odd: | ||
| 2011-07-28 17:09 <cheche> [Thu Jul 28 17:04:06 2011] INFO:server:waiting for connections... | ||
| 2011-07-28 17:09 <cheche> [Thu Jul 28 17:04:24 2011] INFO:database:connect to "template1" | ||
| 2011-07-28 17:09 <cheche> should it connect to template1? | ||
| 2011-07-28 17:09 <cedk> cheche: yes to check if it is a tryton database | ||
| 2011-07-28 17:10 <cedk> cheche: i think if you see that it means the client send the requests for the list of database | ||
| 2011-07-28 17:12 <cheche> ok....i am going to check postgres users/databases... | ||
| 2011-07-28 17:13 <cedk> cheche: one way to test if database connection works is to create a empty database and run: trytond -d <database name> -i all | ||
| 2011-07-28 17:15 -!- woakas(~woakas@200.106.218.64) has joined #tryton | ||
| 2011-07-28 17:23 <cheche> psycopg2.OperationalError: could not connect to server: No such file or directory | ||
| 2011-07-28 17:23 <cheche> Is the server running locally and accepting | ||
| 2011-07-28 17:23 <cheche> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? | ||
| 2011-07-28 17:23 <cheche> ok checking postgres... | ||
| 2011-07-28 17:24 <cheche> /etc/postgresql/8.4/main/pg_hba.conf | ||
| 2011-07-28 17:24 <cheche> "local" is for Unix domain socket connections only | ||
| 2011-07-28 17:24 <cheche> local all all ident | ||
| 2011-07-28 17:29 <cedk> cheche: and what is in trytond.conf? | ||
| 2011-07-28 17:29 <cedk> cheche: do you have a postgresql user defined? | ||
| 2011-07-28 17:30 <cheche> yes, user tryton pass: tryton | ||
| 2011-07-28 17:30 <cheche> psql -U tryton ask for password and works | ||
| 2011-07-28 17:30 <cheche> but because i add this line right now: | ||
| 2011-07-28 17:30 <cheche> local all tryton password | ||
| 2011-07-28 17:31 <cedk> cheche: so you must add it also in trytond.conf | ||
| 2011-07-28 17:33 <cheche> what should i add on trytond.conf? | ||
| 2011-07-28 17:33 <cheche> db_user = tryton | ||
| 2011-07-28 17:33 <cheche> db_password = tryton | ||
| 2011-07-28 17:33 <cedk> cheche: yes | ||
| 2011-07-28 17:33 <cheche> db_type = postgresql | ||
| 2011-07-28 17:33 <cheche> but that was already | ||
| 2011-07-28 17:34 -!- lageekitude(~Senvara@24.106.58.138) has joined #tryton | ||
| 2011-07-28 17:36 <udono> cheche: hi, try with db_host = localhost | ||
| 2011-07-28 17:37 <udono> cheche: and maybe interface = 0.0.0.0 | ||
| 2011-07-28 17:37 <cheche> :sycopg2.OperationalError: could not connect to server: Connection refused | ||
| 2011-07-28 17:39 <udono> cheche: INFO:database:connect to "template1" usually means that trytond can not connect to the database, because of missing permissions. | ||
| 2011-07-28 17:40 <udono> cheche: db_host = localhost | ||
| 2011-07-28 17:40 <udono> db_port = 5432 | ||
| 2011-07-28 17:41 <cheche> db_host was localhost | ||
| 2011-07-28 17:41 <cheche> but the connection refuse is postgres... | ||
| 2011-07-28 17:42 <cheche> well, I have got the feeling that i did a install with 1.4 and after upgrade. it should work. | ||
| 2011-07-28 17:43 <cheche> but i touch so many files and i am going to purge... and try again | ||
| 2011-07-28 17:43 <cheche> aptitude purge tryton-server | ||
| 2011-07-28 17:54 <cheche> weird.... | ||
| 2011-07-28 17:54 <cheche> casa:/etc# netstat -an | grep postgres | ||
| 2011-07-28 17:54 <cheche> unix 2 [ ACC ] STREAM LISTENING 78816 /var/run/postgresql/.s.PGSQL.5433 | ||
| 2011-07-28 17:55 <cheche> wrong port number | ||
| 2011-07-28 17:55 <yangoon> cheche you have probably installed two postgres versions | ||
| 2011-07-28 17:55 <yangoon> cheche adjust the port number to point to the postgres server you want | ||
| 2011-07-28 17:58 <cheche> i think that it was postgres upgrade from 8.3 to 8.4 | ||
| 2011-07-28 18:04 -!- ecarreras(~under@unaffiliated/ecarreras) has joined #tryton | ||
| 2011-07-28 18:05 <cheche> shit... so sorry that i bother you witha local problem. thanks so much! | ||
| 2011-07-28 18:08 <udono> cheche: welcome | ||
| 2011-07-28 19:20 -!- ccomb1(~ccomb@94.122.88.122) has joined #tryton | ||
| 2011-07-28 20:02 -!- alimon(~alimon@189.154.61.121) has joined #tryton | ||
| 2011-07-28 20:16 -!- ccomb(~ccomb@94.122.112.236) has joined #tryton | ||
| 2011-07-28 20:39 -!- ccomb(~ccomb@94.122.119.54) has joined #tryton | ||
| 2011-07-28 21:07 -!- nicoe(~nicoe@2.90-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton | ||
| 2011-07-28 21:10 -!- lageekitude(~Senvara@24.106.58.138) has joined #tryton | ||
| 2011-07-28 21:13 -!- okko1(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-07-28 21:20 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2011-07-28 21:50 -!- rhubner(~rhubner@189.58.53.98.dynamic.adsl.gvt.net.br) has joined #tryton | ||
| 2011-07-28 22:05 -!- gremly(~gremly@200.106.218.64) has joined #tryton | ||
| 2011-07-28 22:13 -!- nicoe(~nicoe@2.90-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton | ||
| 2011-07-28 22:17 -!- nicoe(~nicoe@2.90-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton | ||
| 2011-07-28 22:38 -!- alimon(~alimon@189.154.61.121) has joined #tryton | ||
| 2011-07-28 22:40 -!- plantian(~ian@173-167-122-145-sfba.hfc.comcastbusiness.net) has joined #tryton | ||
| 2011-07-28 22:45 -!- heg(~heg@dyn.144-85-162-171.dsl.vtx.ch) has joined #tryton | ||
| 2011-07-28 23:28 -!- lageekitude(~Senvara@24.106.58.138) has joined #tryton |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!