** Database-LockFailure-LockLost With Obj-Delete-By-Handle method
Getting ** Database-LockFailure-LockLost during commit operation which is happening after perform delete operation using Open-Delete-By-Handle method .
1) Collecting pzInskeys of the work history instances and iterate through them to delete each instance using obj-delete-by-handle.
2) Checked the Lock & Release on Commit for delete operation.
3) After deleting all objects then apply commit method ,but commit is successful for first 30 instances of system_lock after that system is using select query for a record which deleted just before to it and then it's started failing as Database-locklost.
***Edited by Moderator Marissa to update SR Details***
As per my observation,During lock acquisition on instances,the lockhandle in lock table is varies from actual pzInsKey of instance.Hence,The Lock table is ended up with same lock handles for multiple instances.
The value of pxLockHandle is HISTORY-MyOrg-App-WORK MyOrg-App-WORK L-13353!20190302T095757.603 GMT
PzInsKey of the history :HISTORY-MyOrg-App-WORK MyOrg-App-WORK L-13353!20190302T095757.602 GMT