[jira] [Assigned] (OFBIZ-9491) Deadlock on InventoryItem during load test

["Girish Vasmatkar (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OFBIZ-9491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Girish Vasmatkar reassigned OFBIZ-9491:
---------------------------------------

    Assignee: Girish Vasmatkar  (was: Arun Patidar)

Starting to look into this issue.

> Deadlock on InventoryItem during load test
> ------------------------------------------
>
>                 Key: OFBIZ-9491
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-9491
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: product
>    Affects Versions: Trunk
>            Reporter: Arun Patidar
>            Assignee: Girish Vasmatkar
>            Priority: Major
>         Attachments: OFBIZ-9491-console-logs.txt, jmeter-ofbiz-load-test-script.jmx
>
>
> 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. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)