Hello Taher, All, We are now able to proceed ahead with deadlock condition. Thanks Scott and Jacopo for discussing and suggesting solution.
We fixed it by acquiring all InventoryItem records that are going to affect by inventory reservation and item issuance process of order. Acquiring of record means that we performed delegator.storeByCondition() operation on all selected inventoryItem records before actual reservation and issuance. This solution is still an experiment. I believe that some refactoring and data model changes in inventory management process will require for getting proper fix. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd.www.hotwaxsystems.com On Thu, Jul 27, 2017 at 10:04 AM, Arun Patidar < arun.pati...@hotwaxsystems.com> wrote: > Hello Taher, All, > > I have added details on ticket regarding my test plan. Also, attached > Jmeter script which creates and fulfil sales orders. I am still working on > this and will share more updates. > > > > -- > Thanks & Regards > --- > Arun Patidar > Manager, Enterprise Software Development > > > HotWax Systems Pvt Ltd.www.hotwaxsystems.com > > > On Wed, Jul 12, 2017 at 6:23 PM, Arun Patidar <arun.patidar@hotwaxsystems. > com> wrote: > >> Hello Taher, >> >> Created a JIRA ticket OFBIZ-9491 >> <https://issues.apache.org/jira/browse/OFBIZ-9491> and added some more >> details. >> >> -- >> Thanks & Regards >> --- >> Arun Patidar >> Manager, Enterprise Software Development >> >> >> HotWax Systems Pvt Ltd.www.hotwaxsystems.com >> >> >> On Wed, Jul 12, 2017 at 5:45 PM, Arun Patidar < >> arun.pati...@hotwaxsystems.com> wrote: >> >>> Thanks Taher for showing interest. I will create a Jira issue with more >>> details and share it with you. >>> >>> -- >>> Thanks & Regards >>> --- >>> Arun Patidar >>> Manager, Enterprise Software Development >>> >>> >>> HotWax Systems Pvt Ltd.www.hotwaxsystems.com >>> >>> >>> On Wed, Jul 12, 2017 at 4:12 PM, Taher Alkhateeb < >>> slidingfilame...@gmail.com> wrote: >>> >>>> If there is a JIRA with exact repeat steps then I would be interested >>>> in working on this issue as it sounds like a good place to do some >>>> proper refactoring on many moving parts. >>>> >>>> On Wed, Jul 12, 2017 at 12:08 PM, Arun Patidar >>>> <arun.pati...@hotwaxsystems.com> wrote: >>>> > Hello All, >>>> > >>>> > I was trying to load test OFBiz with huge numbers of order creation >>>> and >>>> > fulfilment. During test, I found a deadlock on InventoryItem enttiy. >>>> > Current system, invoke 'UpdateInventoryItemFromDetail' service to >>>> update >>>> > InventoryItem QOH total and ATP total record. There is an Eca rule on >>>> > create/update of InventoryItemDetail entity record which triggers >>>> service >>>> > 'UpdateInventoryItemFromDetail'. So, with heavy load, InventoryItem >>>> record >>>> > get lock and create deadlock condition. >>>> > >>>> > I know that most of you are already aware with this issue. Please let >>>> me >>>> > know if someone worked on it and have any idea to avoid this type of >>>> > deadlock. >>>> > >>>> > -- >>>> > Thanks & Regards >>>> > --- >>>> > Arun Patidar >>>> > Manager, Enterprise Software Development >>>> > >>>> > >>>> > HotWax Systems Pvt Ltd.www.hotwaxsystems.com >>>> >>> >>> >> >
