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 ONE Support launchpad (Login required).

Search for additional results

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