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

Sporadic Internal error: TreeNode::getDecimalVal: decimal overflow is returned when execute query consecutively several times

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.2.4
    • Icebox
    • ExeMgr
    • None
    • 1UM-1PM ; mcs deployed on CentOS7

    Description

      Sporadic Internal error: TreeNode::getDecimalVal: decimal overflow is returned when execute query consecutively several times

      note : that error was not observed before

      Repeat several times
      the query below against 1TB loaded tpc-ds schema .
      It's returned Sporadically Internal error: TreeNode::getDecimalVal: decimal overflow

      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 ('Sports', 'Books', 'Home')
              and ss_sold_date_sk = d_date_sk
              and (d_date between cast('1999-02-22' as date)
                                      and ADDDATE(cast('1999-02-22' 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;
       
      
      

      May 29 20:12:51 um1 ExeMgr[26289]: 51.513860 |450|0|0| D 16 CAL0042: End SQL statement
      May 29 20:12:51 um1 ExeMgr[26289]: 51.626946 |2147484099|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||
      May 29 20:12:51 um1 ExeMgr[26289]: 51.646476 |2147484099|0|0| D 16 CAL0042: End SQL statement
      May 29 20:12:51 um1 ExeMgr[26289]: 51.647466 |2147484099|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||
      May 29 20:12:51 um1 ExeMgr[26289]: 51.663927 |2147484099|0|0| D 16 CAL0042: End SQL statement
      May 29 20:12:51 um1 ExeMgr[26289]: 51.665530 |2147484099|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||
      May 29 20:12:51 um1 ExeMgr[26289]: 51.683973 |2147484099|0|0| D 16 CAL0042: End SQL statement
      May 29 20:12:51 um1 ExeMgr[26289]: 51.726845 |451|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 ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' 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; |tpcds_1000|
      May 29 20:14:10 um1 joblist[26289]: 10.407905 |451|0|0| C 05 CAL0000: TreeNode::getDecimalVal: decimal overflow.
      May 29 20:14:10 um1 ExeMgr[26289]: 10.410256 |451|0|0| D 16 CAL0042: End SQL statement
      May 29 20:14:10 um1 ExeMgr[26289]: 10.430170 |2147484100|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||
      May 29 20:14:10 um1 ExeMgr[26289]: 10.449719 |2147484100|0|0| D 16 CAL0042: End SQL statement
      May 29 20:14:10 um1 ExeMgr[26289]: 10.450637 |2147484100|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||
      May 29 20:14:10 um1 ExeMgr[26289]: 10.469135 |2147484100|0|0| D 16 CAL0042: End SQL statement
      May 29 20:14:10 um1 ExeMgr[26289]: 10.470357 |2147484100|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||
      May 29 20:14:10 um1 ExeMgr[26289]: 10.488802 |2147484100|0|0| D 16 CAL0042: End SQL statement
      May 29 20:14:10 um1 ExeMgr[26289]: 10.530894 |452|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 ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' 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; |tpcds_1000|
      May 29 20:15:29 um1 joblist[26289]: 29.247175 |452|0|0| C 05 CAL0000: TreeNode::getDecimalVal: decimal overflow.
      May 29 20:15:29 um1 ExeMgr[26289]: 29.248608 |452|0|0| D 16 CAL0042: End SQL statement
      May 29 20:15:29 um1 ExeMgr[26289]: 29.269247 |2147484101|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||
      May 29 20:15:29 um1 ExeMgr[26289]: 29.289813 |2147484101|0|0| D 16 CAL0042: End SQL statement
      May 29 20:15:29 um1 ExeMgr[26289]: 29.291432 |2147484101|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||
      May 29 20:15:29 um1 ExeMgr[26289]: 29.307878 |2147484101|0|0| D 16 CAL0042: End SQL statement
      May 29 20:15:29 um1 ExeMgr[26289]: 29.308646 |2147484101|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||
      May 29 20:15:29 um1 ExeMgr[26289]: 29.325046 |2147484101|0|0| D 16 CAL0042: End SQL statement
      May 29 20:15:29 um1 ExeMgr[26289]: 29.364723 |453|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 ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' 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; |tpcds_1000|
      May 29 20:16:48 um1 ExeMgr[26289]: 48.793878 |453|0|0| D 16 CAL0042: End SQL statement
      May 29 20:16:48 um1 ExeMgr[26289]: 48.921942 |2147484102|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||
      May 29 20:16:48 um1 ExeMgr[26289]: 48.942661 |2147484102|0|0| D 16 CAL0042: End SQL statement
      May 29 20:16:48 um1 ExeMgr[26289]: 48.943526 |2147484102|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||
      May 29 20:16:48 um1 ExeMgr[26289]: 48.959742 |2147484102|0|0| D 16 CAL0042: End SQL statement
      May 29 20:16:48 um1 ExeMgr[26289]: 48.960964 |2147484102|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||
      May 29 20:16:48 um1 ExeMgr[26289]: 48.977554 |2147484102|0|0| D 16 CAL0042: End SQL statement
      May 29 20:16:49 um1 ExeMgr[26289]: 49.020009 |454|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 ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' 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; |tpcds_1000|
      May 29 20:18:07 um1 ExeMgr[26289]: 07.763479 |454|0|0| D 16 CAL0042: End SQL statement
      May 29 20:18:07 um1 ExeMgr[26289]: 07.893421 |2147484103|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||
      May 29 20:18:07 um1 ExeMgr[26289]: 07.913936 |2147484103|0|0| D 16 CAL0042: End SQL statement
      May 29 20:18:07 um1 ExeMgr[26289]: 07.915448 |2147484103|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||
      May 29 20:18:07 um1 ExeMgr[26289]: 07.933593 |2147484103|0|0| D 16 CAL0042: End SQL statement
      May 29 20:18:07 um1 ExeMgr[26289]: 07.934678 |2147484103|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||
      May 29 20:18:07 um1 ExeMgr[26289]: 07.953227 |2147484103|0|0| D 16 CAL0042: End SQL statement
      May 29 20:18:07 um1 ExeMgr[26289]: 07.996806 |455|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 ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' 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; |tpcds_1000|
      May 29 20:19:26 um1 ExeMgr[26289]: 26.846870 |455|0|0| D 16 CAL0042: End SQL statement
      May 29 20:19:26 um1 ExeMgr[26289]: 26.976437 |2147484104|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||
      May 29 20:19:26 um1 ExeMgr[26289]: 26.993869 |2147484104|0|0| D 16 CAL0042: End SQL statement
      May 29 20:19:26 um1 ExeMgr[26289]: 26.994749 |2147484104|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||
      May 29 20:19:27 um1 ExeMgr[26289]: 27.011223 |2147484104|0|0| D 16 CAL0042: End SQL statement
      May 29 20:19:27 um1 ExeMgr[26289]: 27.012249 |2147484104|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||
      May 29 20:19:27 um1 ExeMgr[26289]: 27.028430 |2147484104|0|0| D 16 CAL0042: End SQL statement
      May 29 20:19:27 um1 ExeMgr[26289]: 27.068939 |456|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 ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' 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; |tpcds_1000|
      May 29 20:20:45 um1 joblist[26289]: 45.631282 |456|0|0| C 05 CAL0000: TreeNode::getDecimalVal: decimal overflow.
      May 29 20:20:45 um1 ExeMgr[26289]: 45.633407 |456|0|0| D 16 CAL0042: End SQL statement
      May 29 20:20:45 um1 ExeMgr[26289]: 45.653294 |2147484105|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||
      May 29 20:20:45 um1 ExeMgr[26289]: 45.673191 |2147484105|0|0| D 16 CAL0042: End SQL statement
      May 29 20:20:45 um1 ExeMgr[26289]: 45.674150 |2147484105|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||
      May 29 20:20:45 um1 ExeMgr[26289]: 45.693596 |2147484105|0|0| D 16 CAL0042: End SQL statement
      May 29 20:20:45 um1 ExeMgr[26289]: 45.694679 |2147484105|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||
      May 29 20:20:45 um1 ExeMgr[26289]: 45.710976 |2147484105|0|0| D 16 CAL0042: End SQL statement
      May 29 20:20:45 um1 ExeMgr[26289]: 45.752904 |457|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 ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' 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; |tpcds_1000|
      May 29 20:22:05 um1 ExeMgr[26289]: 05.094629 |457|0|0| D 16 CAL0042: End SQL statement
      May 29 20:22:05 um1 ExeMgr[26289]: 05.225847 |2147484106|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||
      May 29 20:22:05 um1 ExeMgr[26289]: 05.245745 |2147484106|0|0| D 16 CAL0042: End SQL statement
      May 29 20:22:05 um1 ExeMgr[26289]: 05.246811 |2147484106|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||
      May 29 20:22:05 um1 ExeMgr[26289]: 05.265204 |2147484106|0|0| D 16 CAL0042: End SQL statement
      May 29 20:22:05 um1 ExeMgr[26289]: 05.266676 |2147484106|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||
      May 29 20:22:05 um1 ExeMgr[26289]: 05.285188 |2147484106|0|0| D 16 CAL0042: End SQL statement
      May 29 20:22:05 um1 ExeMgr[26289]: 05.328757 |458|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 ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' 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; |tpcds_1000|
      May 29 20:23:24 um1 ExeMgr[26289]: 24.036184 |458|0|0| D 16 CAL0042: End SQL statement
      May 29 20:23:24 um1 ExeMgr[26289]: 24.158223 |2147484107|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||
      May 29 20:23:24 um1 ExeMgr[26289]: 24.179274 |2147484107|0|0| D 16 CAL0042: End SQL statement
      May 29 20:23:24 um1 ExeMgr[26289]: 24.181141 |2147484107|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||
      May 29 20:23:24 um1 ExeMgr[26289]: 24.199670 |2147484107|0|0| D 16 CAL0042: End SQL statement
      May 29 20:23:24 um1 ExeMgr[26289]: 24.200682 |2147484107|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||
      May 29 20:23:24 um1 ExeMgr[26289]: 24.218214 |2147484107|0|0| D 16 CAL0042: End SQL statement
      May 29 20:23:24 um1 ExeMgr[26289]: 24.266591 |459|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 ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' 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; |tpcds_1000|
      May 29 20:24:42 um1 ExeMgr[26289]: 42.969892 |459|0|0| D 16 CAL0042: End SQL statement
      May 29 20:24:43 um1 ExeMgr[26289]: 43.091080 |2147484108|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||
      May 29 20:24:43 um1 ExeMgr[26289]: 43.109631 |2147484108|0|0| D 16 CAL0042: End SQL statement
      May 29 20:24:43 um1 ExeMgr[26289]: 43.110467 |2147484108|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||
      May 29 20:24:43 um1 ExeMgr[26289]: 43.130503 |2147484108|0|0| D 16 CAL0042: End SQL statement
      May 29 20:24:43 um1 ExeMgr[26289]: 43.131545 |2147484108|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||
      May 29 20:24:43 um1 ExeMgr[26289]: 43.148413 |2147484108|0|0| D 16 CAL0042: End SQL statement
      May 29 20:24:43 um1 ExeMgr[26289]: 43.189728 |460|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 ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' 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; |tpcds_1000|
      May 29 20:26:02 um1 ExeMgr[26289]: 02.236975 |460|0|0| D 16 CAL0042: End SQL statement
      May 29 20:26:02 um1 ExeMgr[26289]: 02.369458 |2147484109|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||
      May 29 20:26:02 um1 ExeMgr[26289]: 02.389062 |2147484109|0|0| D 16 CAL0042: End SQL statement
      May 29 20:26:02 um1 ExeMgr[26289]: 02.390131 |2147484109|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||
      May 29 20:26:02 um1 ExeMgr[26289]: 02.408854 |2147484109|0|0| D 16 CAL0042: End SQL statement
      May 29 20:26:02 um1 ExeMgr[26289]: 02.409731 |2147484109|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||
      May 29 20:26:02 um1 ExeMgr[26289]: 02.428261 |2147484109|0|0| D 16 CAL0042: End SQL statement
      May 29 20:26:02 um1 ExeMgr[26289]: 02.472087 |461|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 ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' 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; |tpcds_1000|
      May 29 20:27:21 um1 ExeMgr[26289]: 21.515018 |461|0|0| D 16 CAL0042: End SQL statement
      May 29 20:27:21 um1 ExeMgr[26289]: 21.636896 |2147484110|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||
      May 29 20:27:21 um1 ExeMgr[26289]: 21.656428 |2147484110|0|0| D 16 CAL0042: End SQL statement
      May 29 20:27:21 um1 ExeMgr[26289]: 21.657549 |2147484110|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||
      May 29 20:27:21 um1 ExeMgr[26289]: 21.675852 |2147484110|0|0| D 16 CAL0042: End SQL statement
      May 29 20:27:21 um1 ExeMgr[26289]: 21.676847 |2147484110|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||
      May 29 20:27:21 um1 ExeMgr[26289]: 21.695481 |2147484110|0|0| D 16 CAL0042: End SQL statement
      May 29 20:27:21 um1 ExeMgr[26289]: 21.739996 |462|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 ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' 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; |tpcds_1000|
      May 29 20:28:40 um1 ExeMgr[26289]: 40.494806 |462|0|0| D 16 CAL0042: End SQL statement
      May 29 20:28:40 um1 ExeMgr[26289]: 40.617971 |2147484111|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||
      May 29 20:28:40 um1 ExeMgr[26289]: 40.639483 |2147484111|0|0| D 16 CAL0042: End SQL statement
      May 29 20:28:40 um1 ExeMgr[26289]: 40.640626 |2147484111|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||
      May 29 20:28:40 um1 ExeMgr[26289]: 40.659087 |2147484111|0|0| D 16 CAL0042: End SQL statement
      May 29 20:28:40 um1 ExeMgr[26289]: 40.660126 |2147484111|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||
      May 29 20:28:40 um1 ExeMgr[26289]: 40.676683 |2147484111|0|0| D 16 CAL0042: End SQL statement
      May 29 20:28:40 um1 ExeMgr[26289]: 40.717700 |463|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 ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' 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; |tpcds_1000|
      May 29 20:29:59 um1 joblist[26289]: 59.775084 |463|0|0| C 05 CAL0000: TreeNode::getDecimalVal: decimal overflow.
      May 29 20:29:59 um1 ExeMgr[26289]: 59.776352 |463|0|0| D 16 CAL0042: End SQL statement
      
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              winstone Zdravelina Sokolovska (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.