Question

** 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 .

Steps:-

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***

Group Tags

Comments

Keep up to date on this post and subscribe to comments

Pega
June 17, 2019 - 3:10am

Hello Brahmesh,

Can you attach the tracer file here for our review?

Does the commit always is successful for 30 instances or this number variates?

Thank you,
Pawan

June 18, 2019 - 4:27am
Response to pa1singh

Attached the tracer results .

yes..the number variates ..no specific pattern for this.

June 18, 2019 - 10:18am

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

 

June 18, 2019 - 11:10am

SR-D23771 has been submitted for further investigation .