| chat.freenode.net #tryton log beginning Thu Feb 11 00:00:02 CET 2010 | ||
| 2010-02-11 00:00 <cedk> sharoon: SA branch that is developped since 4-5 months | ||
| 2010-02-11 00:00 <cedk> sharoon: did you see the last "improvement" of OpenERP | ||
| 2010-02-11 00:01 <cedk> sharoon: the grouped list | ||
| 2010-02-11 00:01 <sharoon> cedk: saw that | ||
| 2010-02-11 00:01 <sharoon> cedk: the layout imprvements look cool BTW | ||
| 2010-02-11 00:01 <sharoon> cedk: SA is such a f***ing idea | ||
| 2010-02-11 00:01 <sharoon> cedk: framework over a framework ??!@#$%^ | ||
| 2010-02-11 00:02 <cedk> sharoon: what is cool in the layout ? I find it uggly big buttons, too much functionnality on the same view | ||
| 2010-02-11 00:03 <cedk> sharoon: and I still don't understand how the "and" "or" works as there is no parenthesis | ||
| 2010-02-11 00:03 <sharoon> cedk: https://bugs.launchpad.net/bugs/519086 | ||
| 2010-02-11 00:04 <sharoon> cedk: read comment #2 | ||
| 2010-02-11 00:07 <sharoon> cedk: two issue Open ERP may never get over: Rounding trouble & this stupid workflow:https://bugs.launchpad.net/bugs/519034 (every customer eats my head, these days i have started printing this workflow as a design doc) | ||
| 2010-02-11 00:09 <cedk> sharoon: I think this will never happen into Tryton because we choose to have the purchase/sale as the master document that link to others | ||
| 2010-02-11 00:09 <sharoon> cedk: i liked that design | ||
| 2010-02-11 00:10 <cedk> sharoon: indeed it is linked on lines | ||
| 2010-02-11 00:10 <cedk> sharoon: per example the creation of the invoice is always made by the sale, for every kind of invoicing (picking, sale etc) | ||
| 2010-02-11 00:11 <sharoon> cedk: and it bounces back on us here again: https://bugs.launchpad.net/bugs/512756 with the magento erp connector and this was one of the first things i looked at when i reviewed tryton | ||
| 2010-02-11 00:11 <cedk> sharoon: so status (delivery, invoice etc) of the sale is always up todate because it is the sale that do the work | ||
| 2010-02-11 00:13 <cedk> sharoon: I don't understand why it needs to run the scheduler | ||
| 2010-02-11 00:15 <sharoon> cedk: the sale order line will remain at confirmed state till the scheduler runs.... | ||
| 2010-02-11 00:15 <sharoon> if (not line.procurement_id) or (line.procurement_id.state=='done'): | ||
| 2010-02-11 00:15 <sharoon> so if there's no procurement_id its ok, eg. services, if its there, then scheduler has to run | ||
| 2010-02-11 00:16 <cedk> sharoon: ha yes, it is for the services create task | ||
| 2010-02-11 00:17 <cedk> sharoon: I still don't know if it is the right way to handle this | ||
| 2010-02-11 00:17 <sharoon> cedk: big boss gave up, so now no alternative, just accept what we have | ||
| 2010-02-11 00:18 <sharoon> cedk: https://bugs.launchpad.net/openobject-addons/+bug/491375/comments/4 | ||
| 2010-02-11 00:18 <cedk> sharoon: I don't understand | ||
| 2010-02-11 00:19 <cedk> sharoon: funny, he finds normal that the system makes double lines :-) | ||
| 2010-02-11 00:20 <sharoon> cedk: sounds like microsoft to me where bugs are called features | ||
| 2010-02-11 00:21 <cedk> sharoon: and must be kept for compatiblity :-) | ||
| 2010-02-11 00:22 <sharoon> cedk: compare it to the funny little box where we enter the environment path! god its been like that from the first windows i ever saw | ||
| 2010-02-11 02:14 -!- rvalyi(~rvalyi@189.122.197.153) has joined #tryton | ||
| 2010-02-11 02:15 <rvalyi> is the Tryton awake? | ||
| 2010-02-11 02:15 <rvalyi> was a random test actually, will start investigating at Tryton myself as some people I trust recommend it to me... | ||
| 2010-02-11 03:03 -!- ikks_(~ikks@200.118.243.193) has joined #tryton | ||
| 2010-02-11 03:09 -!- rednul_(~rednul@host-98-127-6-7.bln-mt.client.bresnan.net) has joined #tryton | ||
| 2010-02-11 04:50 -!- arrakis(~arrakis@216.252.75.211) has joined #tryton | ||
| 2010-02-11 05:18 -!- yangoon(~mathiasb@p549F45C3.dip.t-dialin.net) has joined #tryton | ||
| 2010-02-11 05:52 -!- rvalyi(~rvalyi@189.122.197.153) has left #tryton | ||
| 2010-02-11 06:01 -!- arrakis(~arrakis@75-119-248-222.dsl.teksavvy.com) has joined #tryton | ||
| 2010-02-11 06:42 -!- vengfulsquirrel(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton | ||
| 2010-02-11 07:34 -!- mfladischer(~fladische@2001:5c0:1505:7e00:34c9:a7ff:fecc:2660) has joined #tryton | ||
| 2010-02-11 07:58 -!- Timitos(~timitos@88.217.184.172) has joined #tryton | ||
| 2010-02-11 08:34 -!- sharoon(~sharoonth@opg066b.halls.manchester.ac.uk) has joined #tryton | ||
| 2010-02-11 08:52 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2010-02-11 08:58 -!- fil(~phil@blue.hands.com) has joined #tryton | ||
| 2010-02-11 09:02 -!- paepke(~paepke@p4FEB4395.dip0.t-ipconnect.de) has joined #tryton | ||
| 2010-02-11 09:09 -!- enlightx(~enlightx@net203-184-079.mclink.it) has joined #tryton | ||
| 2010-02-11 09:09 -!- yangoon(~mathiasb@p549F45C3.dip.t-dialin.net) has joined #tryton | ||
| 2010-02-11 09:27 -!- bechamel(~user@host-85-201-159-186.brutele.be) has joined #tryton | ||
| 2010-02-11 09:40 -!- paepke_(~paepke@p4FEB15ED.dip0.t-ipconnect.de) has joined #tryton | ||
| 2010-02-11 09:54 -!- paepke__(~paepke@p4FEB14DE.dip0.t-ipconnect.de) has joined #tryton | ||
| 2010-02-11 11:36 -!- ikks_(~ikks@200.118.243.193) has joined #tryton | ||
| 2010-02-11 13:19 <sharoon> cedk: bechamel: is browse method not callable via xml-rpc? | ||
| 2010-02-11 13:19 <sharoon> cedk: bechamel: it returns Calling method browse on model party.party is not allowed! | ||
| 2010-02-11 13:19 <bechamel> sharoon: no | ||
| 2010-02-11 13:20 <cedk> sharoon: it is logical, BrowseRecord are python object | ||
| 2010-02-11 13:20 <bechamel> sharoon: xmlrpc support CRUD: read, write, create, delete | ||
| 2010-02-11 13:20 <cedk> sharoon: they are not translatable into XML-RPC | ||
| 2010-02-11 13:20 <sharoon> cedk: bechamel: ok | ||
| 2010-02-11 13:21 <bechamel> sharoon: and some extra | ||
| 2010-02-11 13:21 <sharoon> cedk: bechamel: also with tryton as a module i think i am getting an issue... it's locking records i think | ||
| 2010-02-11 13:21 <sharoon> TransactionRollbackError: could not serialize access due to concurrent update | ||
| 2010-02-11 13:21 <sharoon> CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."account_account" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x" | ||
| 2010-02-11 13:22 <sharoon> cedk: bechamel: any thoughts? | ||
| 2010-02-11 13:23 <bechamel> sharoon: what are you doing ? | ||
| 2010-02-11 13:23 <cedk> sharoon: who is doing this query? | ||
| 2010-02-11 13:24 <sharoon> cedk: bechamel: the query is done from a django module, which called invoice_print | ||
| 2010-02-11 13:25 <sharoon> cedk: bechamel: http://www.pastie.org/819859 | ||
| 2010-02-11 13:27 <cedk> sharoon: it is clear, you have something that update the record in parallel | ||
| 2010-02-11 13:27 <sharoon> cedk: issue resolved, when i changed to multi = true in config | ||
| 2010-02-11 13:28 <cedk> sharoon: multi=true is only for the cache to be clean | ||
| 2010-02-11 13:28 <sharoon> cedk: but not sure how it resolved this issue? | ||
| 2010-02-11 13:30 <cedk> sharoon: concurrent update may always happens in concurrency environment | ||
| 2010-02-11 13:30 <sharoon> cedk: ok | ||
| 2010-02-11 13:30 <sharoon> cedk: i think it could be this issue | ||
| 2010-02-11 13:30 <cedk> sharoon: you can simply try to not update too much at once to limit the possibility | ||
| 2010-02-11 13:30 <sharoon> cedk: ok | ||
| 2010-02-11 13:31 <cedk> sharoon: tryton use serial transaction mode because it requires to read data from a coherent state | ||
| 2010-02-11 13:32 <cedk> sharoon: but I seems that django read data with FOR SHARE clause which looks the rows | ||
| 2010-02-11 13:33 <sharoon> cedk: when opened as a module, does cursor get closed automatically or do we need to close manually? | ||
| 2010-02-11 13:33 <sharoon> cedk: what happens if many cursors exist? | ||
| 2010-02-11 13:33 <cedk> sharoon: don't understand | ||
| 2010-02-11 13:34 <sharoon> cedk: we open a db cursor when tryton is used as a module. | ||
| 2010-02-11 13:35 <cedk> sharoon: you are responsible of the cursor | ||
| 2010-02-11 13:35 <sharoon> cedk: looks like thats the issue here | ||
| 2010-02-11 13:35 <sharoon> cedk: too many open cursors | ||
| 2010-02-11 13:36 <cedk> sharoon: not sure | ||
| 2010-02-11 13:36 <cedk> sharoon: do you have django accessing directly the DB? | ||
| 2010-02-11 13:36 <sharoon> cedk: no | ||
| 2010-02-11 13:37 <sharoon> cedk: it accesses through the browse object | ||
| 2010-02-11 13:37 <cedk> sharoon: so I don't know from where the FOR UPDATE clause comes | ||
| 2010-02-11 13:37 <cedk> sharoon: we don't use it in Tryton | ||
| 2010-02-11 13:37 <sharoon> cedk: neither me, not sure | ||
| 2010-02-11 13:38 <cedk> sharoon: perhaps an internal pg stuff because of the serial transaction mode | ||
| 2010-02-11 13:39 <sharoon> cedk: possible | ||
| 2010-02-11 13:42 <cedk> sharoon: so leaving too much open cursors may be the issue | ||
| 2010-02-11 13:42 <cedk> sharoon: because locks are kept until commit | ||
| 2010-02-11 13:42 <sharoon> cedk: thinking of a possible way to close it | ||
| 2010-02-11 13:43 <sharoon> cedk: is there a timeout on cursors? | ||
| 2010-02-11 13:51 <cedk> sharoon: cursor.close() | ||
| 2010-02-11 13:58 <sharoon> cedk: we need to update the tryton as a module tutorial to say that the cursor has to be managed | ||
| 2010-02-11 14:18 -!- g0q(~g0q@142.176.238.66) has joined #tryton | ||
| 2010-02-11 14:19 <cedk> sharoon: ok, feel free to update | ||
| 2010-02-11 14:23 -!- enlightx(~enlightx@static-217-133-61-144.clienti.tiscali.it) has joined #tryton | ||
| 2010-02-11 15:20 -!- g0q(~g0q@142.176.238.66) has left #tryton | ||
| 2010-02-11 15:27 -!- juanfer(~juanfer@190.144.69.234) has joined #tryton | ||
| 2010-02-11 15:30 -!- mlhamel(~quassel@2607:fad8:4:0:222:19ff:fedf:7cd0) has joined #tryton | ||
| 2010-02-11 17:46 -!- petrus(~petrus@142.176.238.66) has joined #tryton | ||
| 2010-02-11 17:49 -!- rednul_(~rednul@host-98-127-6-7.bln-mt.client.bresnan.net) has joined #tryton | ||
| 2010-02-11 18:18 -!- FWiesing(~FWiesing@194-208-185-012.tele.net) has joined #tryton | ||
| 2010-02-11 19:17 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2010-02-11 19:33 -!- woakas(~woakas@190.144.69.234) has joined #tryton | ||
| 2010-02-11 19:50 -!- vengfulsquirrel(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton | ||
| 2010-02-11 20:10 -!- sharoon(~sharoonth@opg066b.halls.manchester.ac.uk) has joined #tryton | ||
| 2010-02-11 20:10 -!- sharkcz(~ndan@plz1-v-4-17.static.adsl.vol.cz) has joined #tryton | ||
| 2010-02-11 20:19 -!- tekknokrat(~gthielebe@dslb-188-103-022-099.pools.arcor-ip.net) has joined #tryton | ||
| 2010-02-11 20:27 -!- LucaSub1(~LucaSub@host191-178-dynamic.2-87-r.retail.telecomitalia.it) has joined #tryton | ||
| 2010-02-11 20:28 -!- LucaSub1(~LucaSub@host191-178-dynamic.2-87-r.retail.telecomitalia.it) has left #tryton | ||
| 2010-02-11 21:23 -!- juanfer(~juanfer@190.144.69.234) has joined #tryton | ||
| 2010-02-11 22:08 -!- vengfulsquirrel(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton | ||
| 2010-02-11 22:51 -!- paepke(~paepke@p54A2A37C.dip0.t-ipconnect.de) has joined #tryton |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!