SAP Knowledge Base Article - Preview

2868079 - Signal 11 in StatsDesc::addStatsUpdateInfo() or SrtCtrId::SrtAssign() if "enable streamlined parallel" is 1 - SAP ASE

Symptom

  • The "enable streamlined parallel" configuration parameter is set to 1.
  •  An "infected with signal 11" error with a stack trace may be reported in the SAP ASE error log when you try to insert a row into a proxy table, for example:
     
    • (ASE 15.7 SP141)
      Current process (0x19000d) infected with signal 11 (SIGSEGV)
      Address 0x0x000000000091640d (StatsDesc::addStatsUpdateInfo(short*, int, _cs_datetime*)+0x19db3), siginfo (code, address) = (1, 0x0x000000000000001c)
       
    • (ASE 16.0 SP03 PL07)
      Current process (0x35001b) infected with signal 11 (SIGSEGV)
      Address 0x0x00000000018d1968 (SrtCtrId::SrtAssign(short, OptPool*)+0x68), siginfo (code, address) = (1, 0x0x000000000000001c)
       
  • Stack traces include the following functions respectively:
     
    • (ASE 15.7 SP141)
      StatsDesc::addStatsUpdateInfo(short*, int, _cs_datetime*)
      StatsDesc::addStatsUpdateInfo(short*, int, _cs_datetime*)
      StatsDesc::addStatsUpdateInfo(short*, int, _cs_datetime*)
      StatsDesc::addStatsUpdateInfo(short*, int, _cs_datetime*)
      StatsDesc::addStatsUpdateInfo(short*, int, _cs_datetime*)
      OptGlobal::_GblInitPopRules()
      OptGlobal::_GblSearchEngine(int*)
      OptGlobal::GblOptimize(int*)
      Optimize
    • (ASE 16.0 SP03 PL07)
      SrtCtrId::_ctrInc(OptPool*)               <--- this function may not be shown
      SrtCtrId::SrtAssign(short, OptPool*)
      SrtCtrId::operator=(short)
      PopSort<ParallelCost, ParallelProps>::PopSort(Pop<ParallelCost, ParallelProps>*, short)
      PartNljMatch::PartNljMatch(PopRuleMgr*)
      PartNljClMatch::PartNljClMatch(PopRuleMgr*)
      OptGlobal::_GblInitPopRules()
      OptGlobal::_GblSearchEngine(int*)
      OptGlobal::GblOptimize(int*)
      Optimize

 Note: Complete stack traces are available under Attachments.

  • The same problem occurs when you try to update or delete a row from a proxy table.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR820633, CR#820633, CIS, 820633, SEGV, segmentation, storage, access, violation, fault, segfault, kisignal, stacktrace, registers , 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.