3054992 - Signal 11 in PopDistinct<ParallelCost, ParallelProps>::_popConsGroupOrdering() for query with ROWS LIMIT - SAP ASE for BS

•  ST22 dump shows Error 30046:

Category Resource bottleneck
Runtime Errors DBIF_REPO_SQL_ERROR
Date and Time 06.04.2021 11:28:26
Short Text
SQL error 30046 while accessing program "CX_SY_SQL_ERROR===============CP
" part "LOAD".

• Connection to the server has been lost.
• ASE log reports an "infected with signal 11" error in the function PopDistinct<ParallelCost, ParallelProps>::_popConsGroupOrdering() together with a stack trace:

Current process (0x6ba50325) infected with signal 11 (SIGSEGV)
Address 0x0x0000000001a4fb90 (PopDistinct<ParallelCost, ParallelProps>::_popConsGroupOrdering()+0x2a0), siginfo (code, address) = (1, 0x(nil))

• Stack trace contains the following functions:

PopDistinct<ParallelCost, ParallelProps>::_popConsGroupOrdering()
Pop1<ParallelCost, ParallelProps>::_popMatchOrdering()
Pop<ParallelCost, ParallelProps>::popMatchProperties()
GtcChildOptBlock::_GtcExpandMatchTopPops()
GtcChildOptBlock1::_Gtc1TopPopsGenerate()
GtcChildOptBlock::GtGenScanPops()

• The involved query has ROWS LIMIT like following:

SELECT SUM( ... )  FROM ... WHERE "MANDT" = '100' GROUP BY ... ORDER BY ... ROWS LIMIT 2147483647 

• SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL08 HF1 for Business Suite
• SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL08 HF1
• SAP NetWeaver (NW) - All versions

CR 824730, CR#824730, 824730, SQL30046, SEGV, segmentation, storage, access, violation, segfault, kisignal, stacktrace , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed