SAP Knowledge Base Article - Preview

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

Symptom

  • ST22 dump shows error 30046 Connection to the server has been lost:

    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".

  • ASE log reports Current process (0xxxxxxx) infected with signal 11 (SIGSEGV) with stack trace:         

        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

 


Read more...

Environment

  • 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

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

Keywords


CR 824730, CR#824730, 824730, ROWS LIMIT, SQL30046 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.