Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3404

tpcds query #98 failed with an internal error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 1.2.5
    • 1.2.5
    • ExeMgr
    • None
    • 2019-06

    Description

      Build tested: 1.2.5-1 RC (2nd)

      server commit:
      f44f7d9
      engine commit:
      f2c2a30

      For tpcds test, query #98 returned an internal error. This query has been running successfully since 1.2.1-1 through 1.2.4-1.
      Jul 16 15:51:54 localhost ExeMgr[19213]: 54.310287 |527|0|0| D 16 CAL0041: Start SQL statement: select i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price ,sum(ss_ext_sales_price) as itemrevenue ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over (partition by i_class) as revenueratio from store_sales ,item ,date_dim where ss_item_sk = i_item_sk and i_category in ('Children', 'Women', 'Shoes') and ss_sold_date_sk = d_date_sk and (d_date between cast('2001-03-09' as date) and ADDDATE(cast('2001-03-09' as date),30)) group by i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price order by i_category ,i_class ,i_item_id ,i_item_desc ,revenueratio; |columnstoredb|
      Jul 16 15:51:55 localhost Calpont[19213]: 55.668670 |0|0|0| E 00 CAL0000: /data/buildbot/bb-worker/centos7/mariadb-columnstore-engine/utils/rowgroup/rowgroup.h@724: assertion '0' failed
      Jul 16 15:51:55 localhost joblist[19213]: 55.668842 |527|0|0| C 05 CAL0000: IDB-2035: An internal error occurred. Check the error log file & contact support.
      Jul 16 15:51:55 localhost ExeMgr[19213]: 55.669943 |527|0|0| D 16 CAL0042: End SQL statement

      crit.log and err.log has the same internal error msg

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            dleeyh Daniel Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.