Hi Darrell, thanks for the further information, I am sure that it will be useful to others and I am sure you are not the only one experiencing this. I don't have a solution but I have posted some comments to the Jira ticket you have mentioned in your last mail (OFBIZ-5065).
Jacopo On Jan 20, 2015, at 10:28 AM, darrell73s <darrellof...@gmail.com> wrote: > 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.