SAP Knowledge Base Article - Preview

2017684 - Signal 11 when 'enable deferred parallel' is configured - ASE

Symptom

  • User session terminates unexpectedly
  • ASE configuration parameter  'enable deferred parallel' is on (1)
  • Query executed contains a join on > 6 tables
  • Query executed is forcing an index
  • ASE errorlog contains an infected with 11 error sequence and stacktrace
  • There are a number of variations in the 'address' where signal 11 is encountered and in the stack trace that follows.

ResVector::getScalarSum()const
GtgGroup::GtSecondaryInit
GtuUnion::_GtcNTopPopsGenerate
GttTable::GttValidateFactTable

  • The stack trace is different for each of these 4 variations, most common elements of the stacktarce are:

PopReptnIndScan<ParallelCost, ParallelProps>::popGenCgp
PopDml<ParallelCost, ParallelProps>::decideOnHeuristicsForCl
EquivClass::eqcSelectCandidates
ApDerivedTab::_apHandleEqc
ApPlan::ApApply


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 SP100 and higher

Product

SAP Adaptive Server Enterprise 15.7

Keywords

(GttTable::GttValidateFactTable(OptBlock*)+0x9dbd)
PopReptnIndScan<ParallelCost, ParallelProps>::popGenCgp(OptMap<short, tree*, _STL::less<short> >*)
EquivClass::eqcSelectCandidates(OptList<CtrPtr<PopBase> >*)+0x7d1()
EquivClass::eqcSelectCandidates()+0x25()
ApDerivedTab::_apHandleEqc(EquivClass*)+0x2b()
GtuUnion::_GtcNTopPopsGenerate(TopLogProps0*, void (*)(OptList<CtrPtr<PopBase> >*, OptList<CtrPtr<PopBase> >*))+0x9baf()
PopDml<ParallelCost, ParallelProps>::decideOnHeuristicsForCl(Partitions*)+0x14e08()
(double ResVector::getScalarSum()const+0x1f)
ResVector::getScalarSum()const+0x1f
ApPlan::ApApply()+0x18b() , KBA , memory corruption , ase , sigsegv , 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.