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

• 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

SAP Adaptive Server Enterprise (ASE) 15.7 SP100 and higher

(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 , ase , memory corruption , sigsegv , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed