SAP Knowledge Base Article - Preview

3203184 - Error: 873 and stack overflow during update statistics - SAP ASE

Symptom

ASE crashed due stack overflow after error 873 when running update statistics:

======

Error: 873, Severity: 20, State: 1                                                                                                                               
Process XXX is requesting shared latch on buffer 0xXXXXXXXXXXXX (dbid: X, pageno: XXXXXX) while holding X latches. A process can hold only X latches at a time.  
.....
Stack overflow detected: limit: XXXXXX, guardpage: YYYYY, sp: ZZZZZ
.....
.....
*** Stack corrupted, server aborting.

======

In the memory dump, we can see the following stack for the process:

=======

exc_raise
buf_get_latchedbuf_slot
bufsearch_cache_getlatch
getpage_with_validation
bt__getchildlatched
bt__traverse
bt__getstartpg
bt_getnext_no16FTR
dol_bt_getnext_no16FTR
getnext
sdes_scan_setup
obj_updrow
change_objschema
ups_main
s_execute

=======

DBCC's didn't report any error.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL11 HF1

Product

SAP Adaptive Server Enterprise all versions

Keywords

stack overflow detected error 873 requesting shared latch on buffer while holding  latches can hold only latches at a time buf_get_latchedbuf_slot bufsearch_cache_getlatch getpage_with_validation bt__getchildlatched bt__traverse bt__getstartpg bt_getnext_no16FTR dol_bt_getnext_no16FTR getnext sdes_scan_setup obj_updrow change_objschema ups_main  827666 CR 827666 CR827666 CR#827666 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.