SAP Knowledge Base Article - Preview

2681394 - Stored Procedure fails with Segmentation Violation with case statement in group by clause

Symptom

  • The server was upgraded from ASE 15.7 SP110 to 16.0 SP03 PL03
     
  • It was a cross platform migration from HPIA to Linux 7
     
  • Randomly stored procedure execution raises a signal 11 (SIGSEGV) stacktrace.
     
  • The message, "Current process infected with signal 11 " followed by a stack trace that includes the modules 'bt__col_cmp_noopt', 'bt__nonlfrow_cmp', may be reported in the SAP ASE error log when a group by clause contains expressions.

    kernel Current process (0xf3007a) infected with signal 11 (SIGSEGV)
    kernel Address 0x0x0000000001b59e4a (bt__col_cmp_noopt+0x1ba), siginfo (code, address) = (1, 0x0x0000000000000003)
    bt__col_cmp_noopt
    bt__nonlfrow_cmp
    bt__srch_nlpage
    bt__srchpage
    bt__getchildlatched
    bt__traverse
    bt__getstartpg
    bt_getnext
    dol_bt_getnext
    getnext
    LeScanOp::_LeOpNext(ExeCtxt&)
    LeRestrictOp::_LeOpNext(ExeCtxt&)
    LeNaryNLJOp::_LeOpNext(ExeCtxt&)
    LeDMLOp::printXMLCostMetrics(ExeCtxt&) const
    LeNLJOp::_LeOpNext(ExeCtxt&) +0x4d()
    LeDMLOp::printXMLCostMetrics(ExeCtxt&) const
    LeNLJOp::_LeOpNext(ExeCtxt&)
    LeRestrictOp::_LeOpNext(ExeCtxt&)
    LeDMLOp::printXMLCostMetrics(ExeCtxt&) const
    LeHashContext::GetNext(ExeCtxt&)
    LeHashOp::_LeOpNext(ExeCtxt&)
    LeInsertOp::_LeOpNext(ExeCtxt&)
    LeEmitNoSndOp::_LeOpNext(ExeCtxt&)
    LePlanNext
    exec_lava
    kernel end of stack trace

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL03

Product

SAP Adaptive Server Enterprise 16.0

Keywords

group by, case, bt__col_cmp_noopt, bt__nonlfrow_cmp , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.