Hi Darrell, I have a bad news and a good news. The bad news is that what you are experiencing is probably due to a limitation of the OFBiz inventory reservation engine: under heavy load there is a lot of db lock contention in the InventoryItem table especially if you are placing orders for the same product (that reserve the same inventory item). Unfortunately I don't have a fix for this issue but you could see if it is actually the problem you are facing by disabling inventory reservations (go to Catalog->Stores, select the store and set to No: Check Inventory, Require Inventory, Reserve Inventory, Balance Res On Order Creation): these settings should speed up your tests. The good news is that yesterday I faced (running a JMeter load test on order creation) a Java deadlock, caused by FOP, and I was able to fix it (this can happen, under unlucky timing, when two OFBiz threads generate two order confirmation emails): if you see that you system hangs you can get a Java thread dump (let me know if you don't know how to get it) and this should tell you if you are having such a deadlock; for this issue I have a fix (I have patched the fop1.1 distribution) and I can send you the jar file if you want to give it a try (however fop1.1. works only for the 13.07 and the trunk, if my memory serves).
Jacopo On Oct 2, 2014, at 4:30 PM, darrell73s <[email protected]> wrote: > Thanks Mike, I was seeing similar behavior with Derby so I was thinking that > the issue was database agnostic, but I will run pgTune on my instance to see > what sorts of settings I can experiment with. > > That's good to hear Jacopo, I'm available to do some testing, just let me > know how I can help. The next place I was going to investigate was the fact > that I'm using a configurable good vs. a finished good in my orders. In your > testing, has this variable been a factor in producing the issue? > > Thanks again, > Darrell > > > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Locking-While-Placing-Orders-12-04-13-07-tp4656365p4656409.html > Sent from the OFBiz - User mailing list archive at Nabble.com.
