Symptom
- When a very long and complex query joins 7 or more tables
- ASE may report an "Infected with signal 11" error in the module j_searchspace():
Current process (0x270014) infected with signal 11 (SIGSEGV)
Address 0x0x000000000101888c (j_searchspace+0xd6), siginfo (code, address) = (128, 0x(nil))
- It is followed by the signal context messages with no stack trace:
**** Saved signal context (0x0x00000001447d37c0): ****
uc_flags: 0x0, uc_link: 0x(nil)
uc_sigmask: 0x416000 0xb 0x80 0x0
uc_stack: ss_sp: 0x(nil), ss_size: 0x0, ss_flags: 0x2
General Registers (uc_mcontext.gregs):
PC : 0x000000000101888c (j_searchspace+0xd6)
RAX : 0x4f594b0500000000 RBX : 0x000000000000001a
RCX : 0x000000000000001a RDX : (nil)
RBP : 0x00000001447d3c80 RSP : 0x00000001447d3c00
R8 : 0x0000000149f60650 R9 : 0x000000014a4b9508
R10 : 0x0000000000004d5a R11 : (nil)
R12 : 0x00000001447d3cb0 R13 : 0x000000014d5a0ce8
R14 : 0x0000000149f64800 R15 : (nil)
RDI : 0x000000014d5a0ce8 RSI : 0x0000000000004d5a
RIP : 0x000000000101888c CSGSFS : 0x0000000000000033
TRAPNO : 0x000000000000000d ERR : (nil)
EFL : 0x0000000000010202
**** end of signal context ****
- The process is not terminated.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.x
Product
Keywords
CR789204, CR#789204, 789204, alternative_greedy_search, alternative_, greedy. traceflag, trace, flag, 15363, SEGV, segmentation, storage, access, violation, fault, segfault , 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