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

["Arun Patidar (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OFBIZ-9491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16083912#comment-16083912 ] 

Arun Patidar edited comment on OFBIZ-9491 at 7/12/17 12:43 PM:
---------------------------------------------------------------

Attached file 'OFBIZ 9491-console-logs.txt' 


was (Author: arunpati):
Attached file 'OFBIZ-9491-console-logs.txt' 

> 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: 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)