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

[Nicolas Malin (Jira)]

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

Arun Patidar updated OFBIZ-9491:
--------------------------------
    Attachment: jmeter-ofbiz-load-test-script.jmx

Hello [~taher]

Attaching Jmeter script  to get idea about my process.

> 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: Arun Patidar
>         Attachments: jmeter-ofbiz-load-test-script.jmx, OFBIZ-9491-console-logs.txt
>
>
> 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
(v6.4.14#64029)