Symptom
- ASE errorlog reports a signal 11 at address memfree
- Due to running of a trace query with a showplan function
- It may be preceded by a 'vectored exception handler' message:
The Adaptive Server will continue its execution as signal 11 is handled by vectored exception handler - A typical sequence includes below elements
- A full stack sequence is attached to this KBA in file : Full_Stack_Sequence.txt
Current process (0x5c71058e) infected with signal 11 (SIGSEGV)
Address 0x0x0000000001540aaa (memfree+0x2a) ....
SQL Text: select show_plan(@SPID@,show_plan(@SPID@,-1,-1,-1) ...
memfree
u_pretty_nary_tree
LeShowOpTree(ExeCtxt - ASE error log can also report this signal 11 at address sequencer when sp_showplan is executed (full stack attached to this KBA in file Full_stack_sequence2.txt):
Current process (0x60ad0320) infected with signal 11 (SIGSEGV)
Address 0x0x0000000001a85e72 (sequencer+0x1252), ...
...
SQL causing error :
Current Procedure: sp_showplan
...
sequencer
LeShowOpTree(ExeCtxt...
s_execute
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP04
- This pattern is reported on SP04 PL04
- But it could be expected on other PL releases as well and SP03 (ie SP03 PL11 HF1)
Product
SAP Adaptive Server Enterprise 16.0
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem
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.