Hi, I *may* have a solution for this, because yesterday I was able to recreate a similar issue and fix it. If you are available to do some tests with me let me know and I will share the details of the fix that I am testing at the moment.
Jacopo On Oct 1, 2014, at 11:30 PM, darrell73s <[email protected]> wrote: > Hi folks, > > I'm having an issue when placing multiple orders around the same time as > each other. To closely mimic my actual business process, I'm placing an > order for 1 configurable good, and since I'm using demo data, I'm using the > small PIZZA. This creates a production run after the order is placed. > > I've configured jMeter to place orders in the ecommerce store for > DemoCustomer which consist of a small PIZZA (quantity 1), and have > configured 10 worker threads (to simulate users) placing this order (I can > make the jMeter test available if desired). Within seconds of the first > orders being placed, I see locks on the InventoryItem entity (and > occasionally ProductCalculatedInfo), however these locks continue to build > up and never seem to release. This results in either none, or very few users > being able to place orders. Even after waiting for 2 minutes, the locks are > not released, and the users continue to wait. Ultimately, I've found that I > need to restart postgreSQL and OFBiz in order to clear the locks, and get to > a state where orders can be placed again. > > Interestingly, I've been able to trigger this behavior on 12.04.02, > 12.04.05, and 13.07. I also tested this out using the OOTB derby instance > also, and while I don't have a way to examine the locks explicitly, I was > seeing results in jMeter which aligned with what I was seeing when the locks > were occurring in PostgreSQL. > > With my setup, all of my configurations are default, out of the box unless > noted otherwise: > - out of box 12.04.02, 12.04.05, 13.07 instances loaded with demo data > (connection pool min pool size: 2, max pool size: 250) > - postgreSQL 9.3 with default configuration; increased max connections from > 100 to 1000 > > I'm wondering if any of you have run into this issue before, or have any > tips on how this could be addressed. > > Thanks! > > > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Locking-While-Placing-Orders-12-04-13-07-tp4656365.html > Sent from the OFBiz - User mailing list archive at Nabble.com.
