SAP Knowledge Base Article - Preview

3318103 - Error 1265 left phantom locks and infected process - SAP ASE

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.