SAP Knowledge Base Article - Preview

1958368 - Signal 11 in (LeScanOp::_LeOpShowBloomFilterInfo(char*) - SAP ASE

Symptom

When viewing the plan for semi join using bloom filter, a signal 11 in (LeScanOp::_LeOpShowBloomFilterInfo(char*) routine may occur.

This will result in the client connection being terminated. At times, it is not possible to fully clean up after the terminating client connection which results in a warning and error 6103 following the singal 11.

In the ASE error log, the following messages appear where the address may vary depending on ASE version and plaform along with the SQL causing the error:

kernel Current process (0x120300a5) infected with signal 11 (SIGSEGV)
kernel Address 0x0000000080d1e994 (next_root+0x64), siginfo (code, address) = (1, 0x0000000130000000)
kernel Saved signal context address 0x000001001d12ebe0
kernel SQL causing error : 1, Param12, DisplayedMessage, InternalMessage, FlushInterval, ClientID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
kernel ************************************
server SQL Text: 1, Param12, DisplayedMessage, InternalMessage, FlushInterval, ClientID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
kernel curdb = 4 tempdb = 2 pstat = 0x10000
kernel lasterror = 7712 preverror = 7712 transtate = 1
kernel curcmd = 224 program =
pcstkwalk+0x24(0x000001001d12d900,
ucstkgentrace+0x1d0(0x000001009a6a
ucbacktrace+0xb4(0x000000000000000
terminate_process+0x1354(0x0000000
kisignal+0x418(0x0000000000000058,
next_root+0x64(0x00000100b1da0800,
_$o1cexlH0.proc_get+0x74(0x0000000
s_getTreeOrPlan+0xc4(0x00000000000
execproc+0x1e8(0x00000000826f2800,
_$o1cexoN0.s_execute+0xa5c(0x00000
080ccdfd8 hdl_stack installed by th
0 s_handle installed by the followi
sequencer+0x254(0x0000000000007b60
tdsrecv__dynexec+0xd4(0x0000000000
tdsrecv_dynamic+0x21c(0x0000000000
end of stack trace, spid 661, kpid 302186661, suid 90
WARNING: Pss 0x000001009a6a4688 found with open sdes. pspid 661, psuid 90, pcurdb 4, system table entry 0, sdesp 0x0000010032a0c5b8, objid -43319297.
Error: 6103, Severity: 17, State: 1
Unable to do cleanup for the killed process; received Msg 8203.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7  All Versions

Product

SAP Adaptive Server Enterprise 15.7

Keywords

showplan , KBA , showplan , 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.