ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacques Le Roux <jacques.le.r...@les7arts.com>
Subject Re: Locking While Placing Orders 12.04/13.07
Date Tue, 03 Feb 2015 14:22:29 GMT
I believe the best answer to this issue is Scott's
http://mail-archives.apache.org/mod_mbox/ofbiz-dev/201410.mbox/%3C0DF5FBE0-BA9F-43BF-AF93-33B0F84608C8@hotwaxmedia.com%3E

Jacques

Le 20/01/2015 10:28, darrell73s a écrit :
> Apologies for reviving such an old thread, but I've been monitoring one of my
> systems, and have some new information on this...
>
> Thanks for that Jacopo, I read the issue you posted in the FOP JIRA, and my
> thread dump doesn't appear to show any indications of FOP being an issue.
>
> However, I was doing some more thorough checking of my thread dump taken the
> last time a similar type of issue occurred in my system. Using the
> PostgreSQL monitoring tool, I can see multiple transactions waiting for the
> ProductCalculatedInfo table with one connection in "idle in transaction"
> state.
>
> Thread dump confirms that they are all waiting during order creation, when
> the "countProductQuantityOrdered" service is called and is trying to perform
> the update.
>
> A quick search showed this JIRA issue:
> https://issues.apache.org/jira/browse/OFBIZ-5065 which indicates that the
> poster experienced deadlock on ProductCalculatedInfo when invoking the
> 'storeOrder' service. Workaround is said to be to add
> "require-new-transaction=true" to the service definition. I noticed that
> this service is there in 13.07 (with same definition as in 12.04), but the
> service does not appear to exist in the trunk version of ofbiz. Because the
> issue presents itself seemingly randomly (no issue for 2 weeks, or sometimes
> only a day) my thought was that it could be a timing issue of some sort.
>
> I wanted to get a sense of whether or not anyone other than the reporter has
> run into this issue, and if it was able to be solved other than to use the
> posted workaround -- as, from my understanding, creating a new transaction
> runs the risk of incorrect product counts (i.e. higher than actual) should
> the parent transaction be rolled back for some reason after the new
> transaction is committed. I'll defer to you folks for confirmation on this
> however.
>
> Thanks!
> Darrell
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Locking-While-Placing-Orders-12-04-13-07-tp4656365p4662053.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

Mime
View raw message