Symptom
- A SELECT containing a large number of UNIONs fails.
- Errorlog contains an infected with singall 11 error followed by a stack trace
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
Keywords
union, query, signal , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview