3063195 - Signal 11 on showplan - SAP ASE

In a session with showplan enabled (ON), if the plan for a procedure that executes dynamic sql is not available (caused by a failing execution or error) then a stack trace with signal 11 on "showplan" can occur:

====

1> set showplan on
2> go
1> exec p02
2> go

QUERY PLAN FOR STATEMENT 1 (at line 1).
....
....
...
...
The query plan for spid '0' is unavailable. Possibly the query has not started or has finished executing.
...
ASE is terminating this process.

=====

The stack traces can be:

Current process (0x7390159) infected with signal 11 (SIGSEGV)
Current Process is running on Engine XX
server is using elf symbols for stack decoding (YYYYYY symbols found)
Address 0x0x0000000000fbc4ee (showplan+0x800), siginfo (code, address) = (1, 0x(nil))
...
...
pcstkwalk
ucstkgentrace
ucbacktrace
terminate_process
kisignal

Current process (0x1d000f) infected with signal 11 (SIGSEGV)
Current Process is running on Engine X
server is using elf symbols for stack decoding (YYYYYY symbols found)
Address 0x0x0000000000fbc4ee (showplan+0x800), siginfo (code, address) = (1, 0x(nil))
...
pcstkwalk
ucstkgentrace
ucbacktrace
terminate_process
kisignal
showplan
s_execute
sequencer
execproc
s_execute
sequencer
tdsrecv_language
conn_hdlr

• SAP ASE 16.0 SP04
• LINUX

procedure dynamic sql set showplan on session kisignal showplan s_execute sequencer execproc query plan for spid unavailable possibly the query has not started or has finished executing CR 824910 CR824910 CR 822390 CR822390 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed