2275509 - Error 871: Process is trying to release a latch on buffer without holding a latch on the buffer - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2275509 - Error 871: Process is trying to release a latch on buffer without holding a latch on the buffer - SAP ASE

Symptom

  • Error 871 indicates a user process has attempted to release a latch buffer that it does not own. 
  • It may or may not be accompanied by a stacktrace. 
  • In all situations the process raising the error has exhausted a resource limit (i.e. batch time, io cost, tempdb space, etc.). 
  • These messages may not be adjacent to each other in the log depending upon how actively ASE is logging other information. 
  • Not all of the 'resource exceeded' messages are accompanied by Error 871 but all of the Error 871 messages will have the exceeded resource message, for example:
     
    Error message with a stack trace

User 'xxxxx', application '' exceeded elapsed batch time limit of 600.
Error: 871, Severity: 20, State: 2
Process 243 is trying to release a latch on buffer 0x62056b38 (dbid: 5, pageno: 232790955) without holding a latch on the buffer.

Stack trace includes the following modules:   
 
exc_raise
bufunkeep_cache         
getpage_with_validation
dol_bt_getnext          
getnext)                 
LeScanOp::_LeOpNext(ExeCtxt&)
LeRestrictOp::_LeOpNext(ExeCtxt&)
LeNaryNLJOp::_LeOpNext(ExeCtxt&)
LeDMLOp::LeOpPrint(ExeCtxt&)
LeMJOp::LeOpShowXMLPlan(ExeCtxt&)
LeMJOp::_LeOpNext(ExeCtxt&)
LeDMLOp::LeOpPrint(ExeCtxt&)
LeNLJOp::_LeOpNext(ExeCtxt&)
LeDMLOp::LeOpPrint(ExeCtxt&)
LeHashContext::GetNext(ExeCtxt&)
LeHashOp::_LeOpNext(ExeCtxt&)
LeRestrictOp::_LeOpNext(ExeCtxt&)
LeDMLOp::LeOpPrint(ExeCtxt&)
LeHashContext::GetNext(ExeCtxt&)
LeHashOp::_LeOpNext(ExeCtxt&)              

   Resource limit messages without Error 871

User 'prod', application 'prodx' exceeded tempdb space limit of 75000 pages.
User 'prod', application 'prodx' exceeded elapsed batch time limit of 600. 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.x
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

CR745786, CR#745786, 745786,  governor , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.