[ODE-632] Reduce db deadlocks by getting rid of delete statements that use index

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.3
• Component/s: BPEL Runtime
• Assignee: Sean Ahn
• Reporter: Sean Ahn
• Created: 30/Jun/09 00:29
• Updated: 13/Apr/10 12:49
• Resolved: 07/Jul/09 23:39

Description

Under real work load, the on-the-fly instance cleanup functionality dead-locks a lot due to the excessive sub-select statements that depends on index. Some dbms like mysql locks the whole index that are used in the nested select statements.

Split the delete queries into object id selection and deletion on the ids. Since we already batch up instance cleanup by number of instances(default is 10 instances), this is not a problem in scalability with big dataset.