[MCOL-3404] tpcds query #98 failed with an internal error Created: 2019-07-16  Updated: 2019-07-17  Resolved: 2019-07-17

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.2.5
Fix Version/s: 1.2.5

Type: Bug Priority: Critical
Reporter: Daniel Lee (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 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

 Comments   
Comment by David Hall (Inactive) [ 2019-07-16 ]

This is caused by a bit of code that was experimental for MCOL-3343 but mistakenly made it into the final product. Removing said code.

Comment by Daniel Lee (Inactive) [ 2019-07-17 ]

Build verified: 1.2.5-1 GitHub source

/root/ColumnStore/mariadb-columnstore-server
commit f44f7d9081d023a661d3f96945803127a55e05ad
Author: Ben Thompson <ben.thompson@mariadb.com>
Date: Mon Jun 17 12:32:22 2019 -0500

Update Version to 1.2.5

diff --git a/VERSION b/VERSION
index 30bf40d..a769327 100644
— a/VERSION
+++ b/VERSION
@@ -3,6 +3,6 @@ MYSQL_VERSION_MINOR=3
MYSQL_VERSION_PATCH=16
COLUMNSTORE_VERSION_MAJOR=1
COLUMNSTORE_VERSION_MINOR=2
-COLUMNSTORE_VERSION_PATCH=4
+COLUMNSTORE_VERSION_PATCH=5
COLUMNSTORE_VERSION_RELEASE=1
SERVER_MATURITY=stable
/root/ColumnStore/mariadb-columnstore-server/mariadb-columnstore-engine
commit 106250cbf0030235d85aa03dd1193cf7c5470c22
Merge: f2c2a30 c683b6b
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Wed Jul 17 08:07:08 2019 +0100

Merge pull request #806 from mariadb-corporation/MCOL-3404

MCOL-3404 Revert experimental changes from MCOL-3343

Built ColumnStore from the latest source. tpcds query #98 now returns results.

Generated at Thu Feb 08 02:42:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.