[
https://issues.apache.org/jira/browse/OFBIZ-9491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16084595#comment-16084595 ]
Taher Alkhateeb commented on OFBIZ-9491:
----------------------------------------
Hi Arun,
Is it possible to share how you did the testing? Did you use a certain framework? or just wrote a script? How did you generate the high volume and what were the repeat steps if possible?
> 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)