[MCOL-18] Cross engine join hanging on even 1gb tpch joins, the first one finishes sometimes Created: 2016-05-03  Updated: 2016-06-11  Resolved: 2016-06-03

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

Type: Bug Priority: Major
Reporter: Dipti Joshi (Inactive) Assignee: David Hall (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

select count ( * ) from lineitem a, myisamdb.orders b where a.l_orderkey = b.o_orderkey and b.o_custkey = 1;

select count ( * ) from lineitem a, myisamdb.orders b where a.l_orderkey = b.o_orderkey and b.o_orderkey < 10 and substr(b.o_orderpriority,1,2) = '1-';

 Comments   
Comment by Dipti Joshi (Inactive) [ 2016-05-23 ]

dleeyh Can you retest this ? If it has cleared up - please close it

Comment by Daniel Lee (Inactive) [ 2016-05-31 ]

Build tested:

getsoftwareinfo Tue May 31 10:30:28 2016

Name : mariadb-columnstore-platform Relocations: (not relocatable)
Version : 1.0 Vendor: MariaDB Corporation Ab
Release : 0 Build Date: Fri 27 May 2016 04:07:53 PM EDT
Install Date: Mon 30 May 2016 11:32:15 AM EDT Build Host: srvbuilder

MariaDB [mytest]> create table t1 (nk int) engine=myisam;
Query OK, 0 rows affected (0.01 sec)

MariaDB [mytest]> insert into t1 values (1);
Query OK, 1 row affected (0.00 sec)

MariaDB [mytest]> insert into t1 values (25):

MariaDB [mytest]> select * from t1, nation where t1.nk = nation.n_nationkey;
ERROR 1815 (HY000): Internal error: fatal error in drizzle_con_connect()(15)(15)

Comment by Daniel Lee (Inactive) [ 2016-06-03 ]

Build tested:

mscadmin> getsoft
getsoftwareinfo Fri Jun 3 18:13:06 2016

Name : mariadb-columnstore-platform Relocations: (not relocatable)
Version : 1.0 Vendor: MariaDB Corporation Ab
Release : 0 Build Date: Thu 02 Jun 2016 08:46:52 PM EDT
Install Date: Fri 03 Jun 2016 06:00:39 PM EDT Build Host: srvbuilder
Group : Applications Source RPM: mariadb-columnstore-1.0-0.src.rpm

I tested this package mariadb-columnstore-1.0.0-centos6.x86_64.rpm.tar.gz on the following two configurations:

1) single server
2) 1UM and 2PMs

The test case about worked. I am not sure why since there was not supposed to be any fix for this issue yet.

Comment by Daniel Lee (Inactive) [ 2016-06-03 ]

Closing ticket per my last comment.

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