IRC logs of #tryton for Wednesday, 2014-05-14

chat.freenode.net #tryton log beginning Wed May 14 00:00:01 CEST 2014
-!- cedk(~ced@23.33-67-87.adsl-dyn.isp.belgacom.be) has joined #tryton01:03
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton01:03
-!- digitalsatori(~Thunderbi@116.234.181.110) has joined #tryton02:01
-!- asoleh(~asoleh@36.70.82.7) has joined #tryton06:23
-!- frispete(~frispete@p54A93A45.dip0.t-ipconnect.de) has joined #tryton06:44
-!- sharoonthomas(~sharoonth@118.91.181.250) has joined #tryton06:55
-!- yangoon1(~mathiasb@p549F0ECF.dip0.t-ipconnect.de) has joined #tryton07:02
-!- sharoonthomas(~sharoonth@122.177.186.220) has joined #tryton07:30
-!- pobsteta(~Thunderbi@LPuteaux-656-01-248-71.w217-128.abo.wanadoo.fr) has joined #tryton07:45
-!- rpit(~ralf@dslb-178-011-040-234.pools.arcor-ip.net) has joined #tryton07:48
-!- sharoonthomas(~sharoonth@122.177.186.220) has joined #tryton08:02
-!- sharoonthomas_(~sharoonth@122.177.47.13) has joined #tryton08:15
-!- vernichon(~Thunderbi@gex01-1-78-234-55-95.fbx.proxad.net) has joined #tryton08:18
-!- asoleh(~asoleh@36.70.82.7) has joined #tryton08:18
-!- bechamel(~Adium@62-197-96-189.teledisnet.be) has joined #tryton08:27
-!- sharoonthomas(~sharoonth@122.177.47.13) has joined #tryton08:35
-!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has joined #tryton09:09
-!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has left #tryton09:09
-!- bechamel(~Adium@cismwks02-virtual1.cism.ucl.ac.be) has joined #tryton09:13
-!- sharoonthomas(~sharoonth@118.91.181.250) has joined #tryton09:24
-!- nicoe(~nicoe@209.102-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton09:32
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton09:50
-!- sharoonthomas(~sharoonth@118.91.181.250) has joined #tryton09:59
-!- digitalsatori(~Thunderbi@114.94.153.137) has joined #tryton10:05
-!- digitalsatori(~Thunderbi@114.94.153.137) has joined #tryton10:11
-!- pokoli(~pokoli@unaffiliated/pokoli) has joined #tryton10:24
-!- rpit(~ralf@dslb-178-011-040-234.pools.arcor-ip.net) has joined #tryton10:48
-!- asoleh(~asoleh@36.70.82.7) has joined #tryton11:07
-!- nicoe(~nicoe@2001:6f8:3aa:0:b699:baff:fe56:2328) has joined #tryton11:10
-!- digitalsatori(~Thunderbi@114.94.153.137) has joined #tryton11:12
-!- nicoe(~nicoe@2001:6f8:3aa:0:b699:baff:fe56:2328) has joined #tryton11:16
-!- digitalsatori(~Thunderbi@114.94.153.137) has joined #tryton11:26
-!- digitalsatori(~Thunderbi@114.94.153.137) has joined #tryton11:30
-!- corro(~corro@46.22.23.85) has joined #tryton11:34
yangoon1cedk: I have a question wrt to tests: running python setup.py test on trytond in virtualenv fails with http://pastebin.com/8ga1aqWg, while  trytond/tests/run-tests.py just runs fine.11:52
yangoon1cedk: is there a way to make python setup.py test work?11:52
cedkyangoon1: you must set DB_NAME11:54
yangooncedk: thx, will try11:55
cedkyangoon: in the environment11:58
-!- sharoonthomas(~sharoonth@118.91.181.250) has joined #tryton11:58
yangooncedk: is there any possibilty to set db_type via environment?12:09
cedkyangoon: not yet but it should be part of the refectoring of configuration12:12
cedkit will be even better when multi-db support will be dropped12:13
yangoonyes, I know your concerns about multi-db, but that's really killing a great and widely used feature12:18
cedkyangoon: nobody ever explains a real usage of it12:19
cedkit just the usual crying about chnages12:20
yangooncedk: What would be the alternative? How would be the way to easily launch several databases? Would there be a way to restart the server from the client with a different database?12:24
cedkyangoon: no12:24
cedkyangoon: what is your usage???12:25
cedkI don't care about losing functionnality that nobody uses12:25
cedkindeed, it is for me a good motivation to remove them12:25
yangooncedk: I am accessing different databases all the time12:26
cedkyangoon: so what12:26
yangooncedk: AFAIS I would have to launch a dedicated server for each one each time I want to access one12:27
cedkyangoon: please explain your use case?12:28
pokoliACTION listening to this nice conversation 12:28
yangooncedk: having a production and a test database is a simple setup12:29
cedkyangoon: that's the worst configuration ever12:29
cedksomeone running his tests server on the same one as the production is just a fool12:30
yangooncedk: ok, bad example12:30
yangoonwhile developing/testing you create a lot of databases, that you want to access immediately without reconfiguration of the server12:32
cedkyangoon: creating DB will be done per command line and so you have to setup the server12:33
cedkand indeed, you don't create so often a database when developping because it is the tests that does it for you12:33
yangoonand how to access those different databases easily?12:34
cedkyou start the server with the right database12:35
pokoliyangoon: I usually have several trytond servers while developing, because each server has diferent modules12:36
cedkwhen developping one feature, you need only one database12:36
cedkso still no real example of the need of multi-db12:37
pokolicedk: you plan to add db_name to config file or only commandline?12:38
cedkpokoli: probably both but it will be a uri12:40
pokolicedk: like sqlalchemy one?12:41
cedkpokoli: yeps12:41
pokolicedk: nice :D12:41
pokolicedk: and I will be in favour of having both options12:42
-!- asoleh(~asoleh@36.70.82.7) has joined #tryton12:45
-!- nicoe(~nicoe@85.26.36.239) has joined #tryton13:11
corrocedk: our use case for multi db is having a pool of trytond instances, handling requests for several databases13:12
cedkcorro: nothing prevent to have a pool of pool of trytond13:13
cedkcorro: it will even be better because if one database is overloaded it doesn't affect the others13:13
cedkas I said previously, it is a infrastructure problem and solving at the software level is wrong13:14
cedkit is wrong but also inefficient13:14
pokolicorro: currently you have a pool of trytond listening to all databases?13:16
corropokoli: yes13:16
pokolicorro: and how the tryton cache behave? As AFAIU each trytond will have a cache for each database13:17
corropokoli: it works fine, but the cache is not shared, that's true. I tried using a memcached server, but my attempts failed13:19
corroI saw there was this idea of using memcached before (GSoC IIRC), it would definitely be an improvement for large scale installations13:22
cedkcorro: no there are almost nothing that can be cashed outside a transaction13:22
cedkalso I don't see the point to cache something in memcache instead of postgresql13:23
cedkjust tune your prostgresql configuration and/or add a replication pool of server for read13:24
pokolicorro: i thought so too, but seems that it's not correct13:27
pokolicedk: If cache is shared between all of the instances, you can cache all values and invalidate on writes13:27
cedkpokoli: nothing can be cached outside a transaction13:28
pokolicedk: sorry but don't understand why13:28
cedkpokoli: because it is transaction13:28
cedkpokoli: http://www.postgresql.org/docs/current/static/tutorial-transactions.html13:29
-!- sharoonthomas(~sharoonth@118.91.181.250) has joined #tryton13:29
pokolicedk: so you can cache on commit, and then read from cache on the start of the transaction13:30
cedkindeed in Tryton, there are very few things that are cached outside the transaction but it is so small that there are no benefit to share them outside the process memory13:30
cedkpokoli: no. What about other transactions13:31
cedkpokoli: also I don't want to rewrite postresql in Python13:31
pokolicedk: but maybe we need two-phase commit to do this, and i don't know if it's too complex13:31
cedkpostgresql is already a cache13:31
cedkthere are no need for a second external cache13:32
pokolicedk: makes sense13:32
-!- LordVan(~LordVan@gentoo/developer/LordVan) has joined #tryton13:33
-!- pobsteta(~Thunderbi@37.162.245.190) has joined #tryton14:19
-!- sharoonthomas(~sharoonth@118.91.181.250) has joined #tryton14:22
-!- vernichon(~Thunderbi@gex01-1-78-234-55-95.fbx.proxad.net) has joined #tryton14:55
-!- sharoonthomas(~sharoonth@118.91.181.250) has joined #tryton15:04
-!- buxy(~rhertzog@mail.vm.ouaza.com) has joined #tryton15:19
-!- gpodessta(bed26cf1@gateway/web/freenode/ip.190.210.108.241) has joined #tryton16:18
-!- alisonken1lap3(~alisonken@18.18.ultimate-int.uia.net) has joined #tryton16:24
-!- rhowe(~rhowe@87-127-165-237.static.enta.net) has joined #tryton16:44
-!- digitalsatori(~Thunderbi@116.234.181.110) has joined #tryton16:49
-!- mariomop(~quassel@host123.186-108-160.telecom.net.ar) has joined #tryton17:09
-!- pobsteta(~Thunderbi@pha75-11-82-236-85-232.fbx.proxad.net) has joined #tryton17:14
-!- Telesight(~anthony@77-175-159-159.FTTH.ispfabriek.nl) has joined #tryton17:52
-!- littlebit(~Thunderbi@ulmg-5d84dbbf.pool.mediaWays.net) has joined #tryton18:07
-!- gremly(~gremly@190.85.36.58) has joined #tryton18:11
-!- corro(~robin@77-58-75-66.dclient.hispeed.ch) has joined #tryton18:54
-!- pobsteta(~Thunderbi@pha75-11-82-236-85-232.fbx.proxad.net) has joined #tryton19:02
-!- pobsteta(~Thunderbi@pha75-11-82-236-85-232.fbx.proxad.net) has joined #tryton19:08
-!- pobsteta(~Thunderbi@pha75-11-82-236-85-232.fbx.proxad.net) has joined #tryton19:19
-!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has joined #tryton20:20
-!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has left #tryton20:25
-!- pablovannini(~pablo@host126.186-109-85.telecom.net.ar) has left #tryton20:51
-!- uranus(~uranus@ool-182fa854.dyn.optonline.net) has joined #tryton21:51
-!- asoleh(~asoleh@36.70.82.7) has joined #tryton23:17

Generated by irclog2html.py 2.11.0 by Marius Gedminas - find it at mg.pov.lt!