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

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

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

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