ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacopo Cappellato <jacopo.cappell...@hotwaxmedia.com>
Subject Re: Locking While Placing Orders 12.04/13.07
Date Thu, 02 Oct 2014 05:17:06 GMT
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 <darrellofbiz@gmail.com> 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.


Mime
View raw message