SAP Knowledge Base Article - Preview

3063195 - Signal 11 on showplan - SAP ASE

Symptom

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


Read more...

Environment

  • SAP ASE 16.0 SP04
  • LINUX

Product

SAP Adaptive Server Enterprise 16.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.