3426914 - Signal 11 at memfree or sequencer due to running showplan - SAP ASE

• 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 
  

• 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)
        

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem