3138487 - ASE crash while retrieving query plan for cached statements - SAP ASE

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

• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP Adaptive Server Enterprise (ASE) 16.0

"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