Symptom
SAP ASE database crashes and shuts down while using "Runtime Explain" option in DBACockpit, on systems running SAP applications.
For systems running custom applications, the error may occur while using the function: show_cached_plan_in_xml() to gather the query plan for cached statements
Following errors are received in the ASE errorlog, leading up to the shutdown of the ASE:
1.
Current process (0x76b07ce) infected with signal 11 (SIGSEGV)
Address 0x0x00000000015d801b (TraceOut::operator<<(char const*)+0x11b), siginfo (code, address) = (128, 0x(nil))
kernel ************************************
kernel SQL causing error : select show_cached_plan_in_xml(@@lwpid, 0)
kernel ************************************
SQL Text: select show_cached_plan_in_xml(@@lwpid, 0)
The accompanying stacktrace references functions:
terminate_process+0x549()
kisignal+0xa73()
TraceOut::operator<<(char const*)+0x11b()
ShowStmtHeader(int, TraceOut*)+0xd4()
2.
kernel Stack overflow detected: limit: 0x0x00007de98cb77f10, guardpage: 0x0x00007de98cb7cf10, sp: 0x0x00007de98cbe5b50
*** Stack guardword corrupted.
The accompanying stacktrace references functions:
ucstackcrash+0xa0()
keipanic+0x101()
open_user_table+0x79()
proc_get+0x9d2()
sqt_get_plan+0x80()
tdsrecv__xoltp_getplan+0x41e()
tdsrecv__dynexec_xoltp+0x350()
tdsrecv__dynexec+0x141()
tdsrecv_dynamic+0x222()
kernel *** Stack corrupted, server aborting.
kernel ueshutdown: exiting
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
"signal 11", crash, shutdown, "stack overflow", "stack guardword corrupted", show_cached_plan_in_xml, 826025, CR 826025, CR#826025, "Explain Plan", "Runtime Explain" , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.