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