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

Error in Cross Engine Join Query

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.0.3
    • Icebox
    • ExeMgr
    • 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

      Attachments

        1. userandhostconfiguredincrossjoin.png
          248 kB
          Kumar Saurav Sonu
        2. showgrantsforuseroutput.jpg
          115 kB
          Kumar Saurav Sonu
        3. showgrantqueryoutput.jpg
          100 kB
          Kumar Saurav Sonu
        4. FullScenario.png
          241 kB
          Kumar Saurav Sonu

        Activity

          People

            dthompson David Thompson (Inactive)
            kssonu4u Kumar Saurav Sonu
            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.