Details
-
Fix
-
Status: Released (View Workflow)
-
Major
-
Resolution: Fixed
-
1.11.3
-
None
Description
Current Situation
Sometimes when running the fact plugin an error occured
[ERROR] - execute: java.lang.Exception: executeFacts: java.lang.Exception: process: java.lang.Exception: synchronizeOrders: java.lang.Exception: synchronizeOrderHistory: java.lang.Exception: error on getInventoryOrderInfoByJobChain: com.sos.hibernate.exceptions.SOSHibernateQueryException: could not extract ResultSet: 1205 Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [select ijc.[NAME] ,ijc.[TITLE] ,io.[IS_RUNTIME_DEFINED] from INVENTORY_ORDERS io ,INVENTORY_JOB_CHAINS ijc ,INVENTORY_INSTANCES ii where io.[INSTANCE_ID]=ii.[ID] and ijc.[INSTANCE_ID]=ii.[ID] and io.[JOB_CHAIN_NAME]=ijc.[NAME] and ii.[SCHEDULER_ID]= :schedulerId and upper(ii.[HOSTNAME])= :schedulerHostname and ii.[PORT]= :schedulerHttpPort and io.[ORDER_ID]= :orderId and io.[JOB_CHAIN_NAME]= :jobChainName]
Desired Behavior
The error should not occurr
Attachments
Issue Links
- relates to
-
JITL-336 When executing the fact plugin sometimes an LockAcquisitionException occurs
- Released