Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
1.0.3
-
None
-
2016-22, 2016-23
Description
I am getting below error on performing cross engine query in mariadb columnstore.
ERROR 1815 (HY000): Internal error: fatal error executing query in crossengine client lib(17)(17)
My query is :-
SELECT a.id stoppage_id, a.machine stoppage_machine, MIN(kf.timestamp) stoppage_end FROM kpi_fact kf, ( SELECT sr.id, sr.machine, sr.start_time FROM stoppage_reason sr, stoppage_configuration sc WHERE sr.start_time BETWEEN '2016-10-13 16:05:15' AND '2016-10-13 16:05:15' AND sr.end_time IS NULL AND sc.machine = sr.machine AND sc.with_end_timestamp = false) a WHERE a.machine = kf.machine AND LOWER(kf.kpi_name) = 'machine_up_status' AND kf.kpi_value_integer = 1 AND kf.global_parameter = 0 AND kf.timestamp > a.start_time GROUP BY a.machine, a.id ;
In the above query there is cross engine join between :-
kpi_fact(Columnstore) ,stoppage_reason and stoppage_master(MyISAM)
I am getting ERROR 1815 (HY000): Internal error: fatal error executing query in crossengine client lib(17)(17) because inner select( SELECT sr.id, sr.machine, sr.start_time FROM stoppage_reason sr, stoppage_configuration sc WHERE sr.start_time BETWEEN '2016-10-13 16:05:15' AND '2016-10-13 16:05:15' AND sr.end_time IS NULL AND sc.machine = sr.machine AND sc.with_end_timestamp = false
results in empty set.
When i insert some dummy data in this table :- insert into stoppage_configuration values (1, 'Bleh',0,1,1,1,1);
Below Query Starts working fine
SELECT a.id stoppage_id, a.machine stoppage_machine, MIN(kf.timestamp) stoppage_end FROM kpi_fact kf, ( SELECT sr.id, sr.machine, sr.start_time FROM stoppage_reason sr, stoppage_configuration sc WHERE sr.start_time BETWEEN '2016-10-13 16:05:15' AND '2016-10-13 16:05:15' AND sr.end_time IS NULL AND sc.machine = sr.machine AND sc.with_end_timestamp = false) a WHERE a.machine = kf.machine AND LOWER(kf.kpi_name) = 'machine_up_status' AND kf.kpi_value_integer = 1 AND kf.global_parameter = 0 AND kf.timestamp > a.start_time GROUP BY a.machine, a.id ;
Thanks,
Saurav