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.