Symptom
- A long running delete spid was killed and the delete spid report the following error in ASE errorlog:
Error: 1265, Severity: 20, State: 1
An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family (lr=0x0x2ab1131b1160, lrmagic=f).
************************************
SQL causing error: delete from db..tab where id = nnnn
Stack includes:
lock_release
fgunlock
endscan
LeScanOp::_LeOpClose
LeDMLOp::_LeOpClose
LeEmittOp::_LeOpClose
LePlanRelease
s_cleanframe
s_handle
Error: 6103, Severity: 17, State: 1
Unable to do cleanup for the killed process; received Msg 1265. - Phantom lock also reported in sp_lock output.
- Other connections which re-use the above spid number may hit the signal 11 at ubffreef or kbfalloc . The stack includes:
memfreeheap
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.