Locking While Placing Orders 12.04/13.07

2014-10-01 Thread darrell73s
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 place

Re: Locking While Placing Orders 12.04/13.07

2014-10-01 Thread Mike
Download "pgtune", run it against your postgresql configuration file, and make the recommended adjustments. Ofbiz has over 800 tables which is not supported well by defaults. On Wed, Oct 1, 2014 at 2:30 PM, darrell73s wrote: > Hi folks, > > I'm having an issue when placing multiple orders aroun

Re: Locking While Placing Orders 12.04/13.07

2014-10-01 Thread Jacopo Cappellato
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 wrote:

Re: Locking While Placing Orders 12.04/13.07

2014-10-02 Thread darrell73s
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

Re: Locking While Placing Orders 12.04/13.07

2014-10-02 Thread Jacopo Cappellato
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

Re: Locking While Placing Orders 12.04/13.07

2014-10-02 Thread darrell73s
Hi Jacopo, Thanks for the quick responses. I believe you hit the nail right on the head with the inventory recommendation! I turned the fields off which you mentioned and now there appears to be no issue inputting orders at the volume I mention above. Interestingly, I haven't come across the fop i

Re: Locking While Placing Orders 12.04/13.07

2014-10-06 Thread darrell73s
Jacopo, all, I checked into the "quick ship" feature and confirmed my thought earlier: it appears that quick ship will not work without the store having the "Reserve Inventory" set to "Y". As I mentioned previously, I'm using the PIZZA, a configurable good, which creates a Production Run on order

Re: Locking While Placing Orders 12.04/13.07

2014-10-06 Thread Jacopo Cappellato
Hi Darrell, sorry for the late response, please see inline: On Oct 6, 2014, at 4:20 PM, darrell73s wrote: > Jacopo, all, > > I checked into the "quick ship" feature and confirmed my thought earlier: it > appears that quick ship will not work without the store having the "Reserve > Inventory" s

Re: Locking While Placing Orders 12.04/13.07

2014-10-07 Thread Jacques Le Roux
Le 07/10/2014 07:10, Jacopo Cappellato a écrit : Hi Darrell, sorry for the late response, please see inline: On Oct 6, 2014, at 4:20 PM, darrell73s wrote: Jacopo, all, I checked into the "quick ship" feature and confirmed my thought earlier: it appears that quick ship will not work without

Re: Locking While Placing Orders 12.04/13.07

2014-10-10 Thread Jacopo Cappellato
On Oct 2, 2014, at 5:13 PM, Jacopo Cappellato wrote: > 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 > confir

Re: Locking While Placing Orders 12.04/13.07

2015-01-20 Thread darrell73s
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 doi

Re: Locking While Placing Orders 12.04/13.07

2015-01-20 Thread Jacopo Cappellato
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, 2

Re: Locking While Placing Orders 12.04/13.07

2015-02-03 Thread Jacques Le Roux
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-33b0f8460...@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

Re: Locking While Placing Orders 12.04/13.07

2015-02-04 Thread darrell73s
Thanks Jacopo and Jacques... Because this happens intermittently in my system, I would suspect a timing-related scenario in line with what Scott mentions in his mail. I will continue to monitor my system, and if the problem presents itself again, and I'm able to isolate the issue to the count serv