IRC logs of #tryton for Monday, 2014-12-01

chat.freenode.net #tryton log beginning Mon Dec 1 00:00:02 CET 2014
2014-12-01 00:11 -!- digitalsatori(~Thunderbi@114.92.210.36) has joined #tryton
2014-12-01 00:25 -!- udono(~udono@ip-37-201-245-76.hsi13.unitymediagroup.de) has joined #tryton
2014-12-01 00:39 -!- digitalsatori(~Thunderbi@114.92.210.36) has joined #tryton
2014-12-01 00:49 -!- smarro_(~sebastian@190.105.93.196) has joined #tryton
2014-12-01 01:24 -!- Ayub_(60e71da5@gateway/web/freenode/ip.96.231.29.165) has joined #tryton
2014-12-01 01:25 <Ayub_> Pilou: I did not get a chance to thank you for your help the otherday
2014-12-01 01:25 <Ayub_> thanks
2014-12-01 01:33 <Pilou> did it work ?
2014-12-01 01:44 <svidela> hi there, anyone available with knowledge of the client implementation?
2014-12-01 02:36 -!- udono(~udono@ip-37-201-245-76.hsi13.unitymediagroup.de) has joined #tryton
2014-12-01 02:59 -!- digitalsatori(~Thunderbi@180.158.135.39) has joined #tryton
2014-12-01 04:26 -!- smarro_(~sebastian@190.105.93.196) has joined #tryton
2014-12-01 04:45 -!- digitalsatori(~Thunderbi@180.158.135.39) has joined #tryton
2014-12-01 05:01 -!- svidela(~sancho@189.221.150.129.cable.dyn.cableonline.com.mx) has joined #tryton
2014-12-01 05:08 -!- digitalsatori(~Thunderbi@180.158.135.39) has joined #tryton
2014-12-01 05:38 -!- svidela(~sancho@189.221.150.129.cable.dyn.cableonline.com.mx) has left #tryton
2014-12-01 06:01 -!- yangoon(~mathiasb@p549F3171.dip0.t-ipconnect.de) has joined #tryton
2014-12-01 06:08 -!- svidela(~sancho@189.221.150.129.cable.dyn.cableonline.com.mx) has joined #tryton
2014-12-01 06:12 -!- svidela(~sancho@189.221.150.129.cable.dyn.cableonline.com.mx) has joined #tryton
2014-12-01 06:16 -!- svidela(~sancho@189.221.150.129.cable.dyn.cableonline.com.mx) has joined #tryton
2014-12-01 06:16 -!- svidela(~sancho@189.221.150.129.cable.dyn.cableonline.com.mx) has left #tryton
2014-12-01 06:16 -!- svidela(~sancho@189.221.150.129.cable.dyn.cableonline.com.mx) has joined #tryton
2014-12-01 06:19 -!- horli(~gregor@chello084113024052.5.12.vie.surfer.at) has joined #tryton
2014-12-01 06:40 -!- frispete_(~frispete@p54A93A22.dip0.t-ipconnect.de) has joined #tryton
2014-12-01 07:17 -!- marius__(~marius@v100.nfq.lt) has joined #tryton
2014-12-01 07:47 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton
2014-12-01 08:21 -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton
2014-12-01 08:27 -!- digitalsatori(~Thunderbi@180.158.135.39) has joined #tryton
2014-12-01 08:33 -!- marius__(~marius@v100.nfq.lt) has joined #tryton
2014-12-01 08:43 -!- horli(~gregor@chello084113024052.5.12.vie.surfer.at) has joined #tryton
2014-12-01 09:08 -!- ytz(~ytz@opfw01.options-it.com) has joined #tryton
2014-12-01 09:21 -!- LordVan(~LordVan@gentoo/developer/LordVan) has joined #tryton
2014-12-01 09:26 -!- nicoe(~nicoe@2a02:a03f:301b:7c00:ee55:f9ff:fe7b:f7ac) has joined #tryton
2014-12-01 09:30 -!- vcardon(~vcardon@bureau-sdsl.tranquil.it) has joined #tryton
2014-12-01 09:34 -!- nicoe(~nicoe@2a02:a03f:301b:7c00:ee55:f9ff:fe7b:f7ac) has joined #tryton
2014-12-01 09:37 -!- bechamel(~Adium@62-197-96-189.teledisnet.be) has joined #tryton
2014-12-01 10:28 <marius__> where is multi_server in current trytond?
2014-12-01 10:28 <marius__> is it deprecated?
2014-12-01 10:29 -!- digitalsatori(~Thunderbi@180.158.135.39) has joined #tryton
2014-12-01 10:35 -!- jeancavallo(~giovanni@LPuteaux-656-1-230-52.w80-12.abo.wanadoo.fr) has joined #tryton
2014-12-01 10:55 <marius__> https://bugs.tryton.org/issue4373?@ok_message=msg%2019036%20created%0Aissue%204373%20messages%20edited%20ok&@template=item
2014-12-01 10:55 <marius__> any ideas anyone
2014-12-01 11:02 <pokoli> marius__: have you tryied with the SELECT .. FOR UPDATE?
2014-12-01 11:03 <marius__> pokoli, but products_by_location happens after the first one finishes
2014-12-01 11:03 <marius__> in both situations
2014-12-01 11:04 <marius__> [Mon Dec 01 09:47:27 2014] INFO:assign_try:139656558614272 -- STOCK STOP ASSIGN
2014-12-01 11:04 <marius__> is at the end of assign_try method
2014-12-01 11:05 <pokoli> marius__: https://bugs.tryton.org/msg18997
2014-12-01 11:05 <marius__> I don't understand this message
2014-12-01 11:05 <marius__> can you explain?
2014-12-01 11:06 <marius__> repeatble vs seriazable
2014-12-01 11:09 <pokoli> marius__: http://www.postgresql.org/docs/current/static/transaction-iso.html
2014-12-01 11:11 <marius__> I only see SET TRANSACTION READ ONLY
2014-12-01 11:12 <marius__> and LOCK IN EXCLUSIVE MODE
2014-12-01 11:13 <marius__> nothing about SERIALIZABLE / REPEATABLE in the log
2014-12-01 11:14 <marius__> pokoli, where do you suggest putting FOR UPDATE? into products_by_location query?
2014-12-01 11:16 <pokoli> marius__: about transactions http://hg.tryton.org/trytond/file/b8e46cc95a39/trytond/backend/postgresql/database.py#l77
2014-12-01 11:17 <pokoli> marius__: which was introduced on http://hg.tryton.org/trytond/changeset/0a4097cbe662
2014-12-01 11:18 -!- horli(~gregor@chello084113024052.5.12.vie.surfer.at) has joined #tryton
2014-12-01 11:19 <pokoli> marius__: for update you have to change two selects
2014-12-01 11:19 <pokoli> marius__: http://hg.tryton.org/modules/stock/file/b9947becd5e5/move.py#l1041
2014-12-01 11:20 <pokoli> marius__: and http://hg.tryton.org/modules/stock/file/b9947becd5e5/move.py#l1051
2014-12-01 11:21 <marius__> what about just http://hg.tryton.org/modules/stock/file/b9947becd5e5/move.py#l1079
2014-12-01 11:21 <marius__> or it won't work for union?
2014-12-01 11:22 <marius__> FOR UPDATE is not allowed in GROUP BY
2014-12-01 11:28 <pokoli> marius__: on last line will affect also the period table, which is not updated
2014-12-01 11:28 -!- corro(~robin@77-58-75-66.dclient.hispeed.ch) has joined #tryton
2014-12-01 11:33 <pokoli> marius__: I imagin you can remove the group_by of the partial queries (on which you have the FOR UPDATE) and it should work as they are grouped at the end from same keys
2014-12-01 11:34 <marius__> pokoli, what about doing something like
2014-12-01 11:34 <marius__> commit, lock, start transaction ... commit
2014-12-01 11:35 <marius__> instead of start transaction, lock .. commit
2014-12-01 11:35 <marius__> because as I understand it, it uses snapshot from transaction start?
2014-12-01 11:36 <pokoli> marius__: you will commit any data written previously of assign_try, which is not correct
2014-12-01 11:37 <pokoli> marius__: yes, it's reading the data from the transaction start
2014-12-01 11:37 <pokoli> marius__: AFAIU using serialized transaction will solve the issue
2014-12-01 11:42 <marius__> pokoli, what about starting it just after lock
2014-12-01 11:44 <pokoli> marius__: with which objective?
2014-12-01 11:44 <marius__> to "take" a new snapshot for transaction
2014-12-01 11:52 <pokoli> marius__: you will read the data at the begin of the transaction becaouse of repetable read
2014-12-01 11:52 <marius__> but removing group by clause seems like overkill
2014-12-01 12:01 -!- mariomop(~quassel@host30.186-109-104.telecom.net.ar) has joined #tryton
2014-12-01 12:02 -!- jeancavallo(~giovanni@LPuteaux-656-1-230-52.w80-12.abo.wanadoo.fr) has joined #tryton
2014-12-01 12:06 <pokoli> marius__: why overkill? they will be grouped at the end, so no need to regroup them
2014-12-01 12:09 <marius__> ok i'll check it if it solves the problem
2014-12-01 12:11 -!- kstenger(~karla@200.124.209.158) has joined #tryton
2014-12-01 12:15 <marius__> pokoli, it's not so easy because of SUM, etc fields
2014-12-01 12:15 <marius__> doesn't work without group by ;)
2014-12-01 12:16 <marius__> + FOR UPDATE doesn't work together inside UNION
2014-12-01 12:16 <marius__> i mean I get SQL syntax error
2014-12-01 12:17 <marius__> NotSupportedError: FOR UPDATE is not allowed with UNION/INTERSECT/EXCEPT
2014-12-01 12:17 <pokoli> marius__: yes, I understand you get the SQL error
2014-12-01 12:17 <pokoli> marius__: can you update the issue with what you have done and the errors?
2014-12-01 12:21 <marius__> pokoli, any ideas what's next?
2014-12-01 12:23 <pokoli> marius__: I imagine that the only solution is to use SERIALIZABLE TRANSACTION level
2014-12-01 12:23 <marius__> how would I do that>?
2014-12-01 12:24 <marius__> can I change it somethow inside assign_try or something?
2014-12-01 12:24 <pokoli> marius__: you have to change it for all the transactions :)
2014-12-01 12:25 <pokoli> marius__: basically its the reverse patch of http://hg.tryton.org/trytond/changeset/0a4097cbe662
2014-12-01 12:25 <marius__> can I do it like that but just for assign_try?
2014-12-01 12:26 <marius__> like Transaction().cursor.conn.set_isolation_level(..whatever..)
2014-12-01 12:30 <pokoli> marius__: set transcation isolation leel must be called before any query :)
2014-12-01 12:34 <marius__> i was unable to repeat the issue with serializable transaction level
2014-12-01 12:36 <marius__> pokoli, so are you suggesting reverting http://hg.tryton.org/trytond/changeset/0a4097cbe662
2014-12-01 12:36 <marius__> performance issues? etc?
2014-12-01 12:36 <marius__> sideeffects?
2014-12-01 12:38 -!- smarro(~sebastian@190.105.93.196) has joined #tryton
2014-12-01 12:43 <marius__> i'm still thinking about moving lock before transaction start, so that new snapshot is "taken" after getting lock
2014-12-01 12:47 <pokoli> marius__: so I think the issue will be the same as far as you use serializable
2014-12-01 12:48 <pokoli> marius__: I don't know why repeatable read was introduced, so i can not comment about it
2014-12-01 12:48 <pokoli> marius__: let's wait for ced's comments :)
2014-12-01 12:52 <yangoon> pokoli AFAIR repeatable read performed much better as strict serialization
2014-12-01 12:54 <pokoli> yangoon: that's what i imagine too, but I think consistency is more important that better performance
2014-12-01 13:14 -!- horli(~gregor@chello084113024052.5.12.vie.surfer.at) has joined #tryton
2014-12-01 13:27 -!- smarro(~sebastian@190.105.93.196) has joined #tryton
2014-12-01 13:27 <marius__> pokoli, so i'm submitting review for revert
2014-12-01 13:33 <pokoli> marius__: thanks for your efforts :)
2014-12-01 13:36 -!- marius__(~marius@v100.nfq.lt) has joined #tryton
2014-12-01 13:39 -!- meanmicio(~meanmicio@fsf/member/meanmicio) has joined #tryton
2014-12-01 14:20 -!- marius__(~marius@v100.nfq.lt) has joined #tryton
2014-12-01 14:22 <marius__> pokoli, do I have to bother about review bot http://codereview.tryton.org/9931002 ?
2014-12-01 14:24 <udono> marius__: hi, do not care the review bot in this case.
2014-12-01 14:25 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2014-12-01 14:46 -!- smarro(~sebastian@190.105.93.196) has joined #tryton
2014-12-01 14:47 -!- marius__(~marius@v100.nfq.lt) has joined #tryton
2014-12-01 15:04 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2014-12-01 15:19 -!- digitalsatori(~Thunderbi@114.92.210.36) has joined #tryton
2014-12-01 16:08 -!- smarro(~sebastian@190.105.93.196) has joined #tryton
2014-12-01 16:51 -!- marius__(~marius@112.185.140.82.static.lrtc.lt) has joined #tryton
2014-12-01 16:59 -!- TheCowboy(~TheCowboy@wsip-98-191-208-111.dc.dc.cox.net) has joined #tryton
2014-12-01 17:10 -!- newzen(~newzen@201.242.159.40) has joined #tryton
2014-12-01 17:36 <buxy> How I can I change the default date format to be YYYY-MM-DD for all customers marked as English speaking?
2014-12-01 17:36 <buxy> I didn't find any translatable string representing the default date format.
2014-12-01 17:37 <buxy> (I care about how the date are printed on reports, not about how they are displayed in the client FWIW)
2014-12-01 17:38 <buxy> Bah I found it.
2014-12-01 17:38 <buxy> I just add to go in the detailed view of the language.
2014-12-01 17:55 -!- hiaselhans(~Thunderbi@chello212186043057.408.14.vie.surfer.at) has joined #tryton
2014-12-01 18:42 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton
2014-12-01 18:48 -!- ytz(~ytz@opfw01.options-it.com) has joined #tryton
2014-12-01 19:02 -!- sunny_dealmeida(~quassel@210.89.41.97) has joined #tryton
2014-12-01 19:06 -!- Telesight(~anthony@4daedff9.ftth.telfortglasvezel.nl) has joined #tryton
2014-12-01 19:13 -!- udono(~udono@ip-37-201-245-76.hsi13.unitymediagroup.de) has joined #tryton
2014-12-01 19:21 <kstenger> do you know of any example of a tab beeing visible/invisible according to some conditions in the same form view?
2014-12-01 19:27 <bechamel> kstenger: iirc, there are some extra tabs on the invoice depending of the invoice type
2014-12-01 19:27 <kstenger> I just found one example :) thanks bechamel
2014-12-01 19:28 <kstenger> tryton keeps impressing me with it's simplicity
2014-12-01 19:28 <bechamel> kstenger: great :)
2014-12-01 20:00 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2014-12-01 20:17 -!- vcardon(~vcardon@bureau-sdsl.tranquil.it) has left #tryton
2014-12-01 20:21 -!- xrg_(~panos@130.43.55.131.dsl.dyn.forthnet.gr) has joined #tryton
2014-12-01 20:39 -!- hiaselhans(~Thunderbi@chello212186043057.408.14.vie.surfer.at) has joined #tryton
2014-12-01 21:31 -!- TheCowboy(~TheCowboy@ip68-98-183-236.dc.dc.cox.net) has joined #tryton
2014-12-01 22:27 -!- pilou`(~pilou@181.204.19.93.rev.sfr.net) has joined #tryton
2014-12-01 22:28 -!- sharkcz`(~sharkcz@2a01:8c00:ffb3:160:250:43ff:fe3c:3b5d) has joined #tryton
2014-12-01 22:28 -!- yangoon1(~mathiasb@p549F3171.dip0.t-ipconnect.de) has joined #tryton
2014-12-01 22:59 -!- Pilou(~pilou@pdpc/supporter/active/pilou) has joined #tryton

Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!