SAP Knowledge Base Article - Preview

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

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.