SAP Knowledge Base Article - Preview

2052432 - Dataserver caught Signal 11 during execution of huge SQL Statement - SAP ASE

Symptom

You transaction might fail when your select contains a high amount of UNIONs and you will see a stacktrace like this:

kernel  Current process (...) infected with signal 11 (SIGSEGV)
kernel  Address ... (LeRetnCode LeScanOp::_LeOpOpen(ExeCtxt&)+0x24), siginfo (code, address) = (1, ...)
kernel  Saved signal context address ...

kernel  SQL causing error : <huge statement with several union operators>

Stacktrace containing the following functions:

pcstkwalk
ucstkgentrace
ucbacktrace
terminate_process+0x132c(0x0000000000007e70, 0x0000000000000000, 0x00000102f66d1c70, 0x0000000081c343a0, 0x0000000000009000)
kisignal+0x418(0x0000000000000058, 0x00000101d30eeb60, 0x00000101d30ee880, 0x00000101d30ee8c0, 0x000000000001adda)
LeRetnCode LeScanOp::_LeOpOpen(ExeCtxt&)
LeRetnCode LeNLJOp::_LeOpNext(ExeCtxt&) <this function is reported with serveral lines>
LeRetnCode LeRestrictOp::_LeOpNext(ExeCtxt&)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.0.X

Product

SAP Adaptive Server Enterprise 15.7

Keywords

union, query, signal , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.