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:

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:   

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&)

   Note: A complete stacktarce is avaialble under Attachments.

  • 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 for Me (Login required).

Search for additional results

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