2431691 - Signal 11 in OptGlobal::OptGlobal() and stacktrace raised by a query with multiple left joins - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2431691 - Signal 11 in OptGlobal::OptGlobal() and stacktrace raised by a query with multiple left joins - SAP ASE

Symptom

  • Signal 11 and an assertion error:
     
    Current process (0x1b000e) infected with signal 11 (SIGSEGV)
    Address 0x0x00000000008c90a7 (OptGlobal::OptGlobal(Node <Lop>*, tree*, OptPool*)+0x1742f), siginfo (code,address) = (1, 0x0x0000000000000008)
     
  • Raised by a query with multiple left joins, for example:
     
    SELECT
            c.comment_id,
            c.comment_text,
            c.id_number,
            c.comment_type,
            c.date_added,
            dp.title,
            ci.content_item_id AS post_content_item_id,
            ci2.content_item_id AS board_content_item_id,
            isnull(cat.display_name, cat.category_name) AS board_name,
            (Case when (upper(e.first_name) like '[A-Z].' OR upper(e.first_name) like '[A-Z]')
                        then e.first_name + ' ' + e.middle_name + ' ' + e.last_name
                else e.first_name + ' ' + e.last_name
            end) as author_name,
              isnull(t.total_replies, 0) AS new_replies,
              isnull(a.pg_organization,'') AS pg_org
        FROM s2_comments c
        LEFT JOIN s2_content_items ci ON c.content_item_id=ci.content_item_id AND ci.content_type_id
        IN (SELECT c.content_type_id
             FROM s2_content_types c LEFT JOIN s2_content_types cp ON c.parent_content_type_id = cp.content_type_id
             WHERE cp.parent_content_type_id=37)
             LEFT JOIN s2_discussion_posts dp ON ci.content_item_foreign_key=dp.discussion_post_id
             LEFT JOIN s2_discussions d ON dp.discussion_id = d.discussion_id
             LEFT JOIN s2_content_items ci2 ON ci2.content_item_foreign_key=d.discussion_id AND ci2.content_type_id
             IN ( SELECT content_type_id FROM s2_content_types WHERE parent_content_type_id=37)
                  LEFT JOIN s2_categories cat ON d.category_id=cat.category_id
                  LEFT JOIN entity e ON c.id_number = e.id_number
                  LEFT JOIN (
                   SELECT count(content_item_id)-1 AS total_replies, content_item_id FROM s2_comments
                   WHERE date_added<='2014-11-17 09:25:30.029'
                   GROUP BY content_item_id ) t ON c.content_item_id = t.content_item_id
                  LEFT JOIN s_association a ON ci2.qualifier_value_char = a.association_id
                     WHERE c.comment_id=46809
     
  • The stacktrace shows fucntions:
     
    OptGlobal::OptGlobal
    PopReptnIndScan<ParallelCost, ParallelProps>::popGenCgp
    CgpGlobal::CgpGenerate
    TpopTabScan::TpopTabScan
    CgpMergeJoin::_cgpInit

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP130 and higher
  • SAP Adaptive Server Enterprise (ASE) 16.0 GA PL03 and higher

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

 CR776404, 776404, CR#776404, OptGlobal, PopReptnIndScan, TpopTabScan, allrows_oltp_ase_default, allrows_oltp_ase_current, allrows_oltp_ase1503esd2, allrows_oltp_ase1503esd3 , 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.