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