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

mcs4010_autopilot_cross_engine_join, mcs7238_regression_MCOL-830 fails randomly

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None
    • 2025-11

    Description

      https://server-test.mariadb.net/?mtr_ids=38&product_ids=2&show_skipped_results=false&only_last_commits=false&time_interval=-2&dates=2025-12-05T22%3A00%3A00.000Z&dates=2025-12-05T22%3A00%3A00.000Z&test_name=&commit_id=&columnstore_commit_id=&target_name=10.6-23.10-via-maxscale-dec04&runs_with_additional_tools=false&currentTestCaseId=17709&currentTargetBuildId=15502&currentTestResultId=407610605

      https://server-test.mariadb.net/?mtr_ids=38&product_ids=2&show_skipped_results=false&only_last_commits=false&time_interval=-2&dates=2025-12-05T22%3A00%3A00.000Z&dates=2025-12-05T22%3A00%3A00.000Z&test_name=&commit_id=&columnstore_commit_id=&target_name=10.6-23.10-via-maxscale-dec04&runs_with_additional_tools=false&currentTestResultId=407610606&currentTestCaseId=21057&currentTargetBuildId=15502

       
      mysqltest: At line 50: query 'select count(*) from nation n, region r where n.n_regionkey = r.r_regionkey and r.r_regionkey = 2' failed: ER_INTERNAL_ERROR (1815): Internal error: CrossEngineStep::execute() Set or verify credentials in CrossEngineSupport section of Columnstore.xml. (2006) (Server has gone away)
       
      The result from queries just before the failure was:
      < snip >
        `n_name` char(25) DEFAULT NULL,
        `n_regionkey` int(11) DEFAULT NULL,
        `n_comment` varchar(152) DEFAULT NULL
      ) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/nation.tbl' INTO TABLE nation FIELDS TERMINATED BY '|';
      create table region (
      r_regionkey int,
      r_name char (25),
      r_comment varchar (152)
      ) engine=innodb;
      SHOW CREATE TABLE region;
      Table	Create Table
      region	CREATE TABLE `region` (
        `r_regionkey` int(11) DEFAULT NULL,
        `r_name` char(25) DEFAULT NULL,
        `r_comment` varchar(152) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
      insert into region values (1, 'AMERICA', 'hs use ironic, even requests. s');
      insert into region values (2, 'ASIA', 'ges. thinly even pinto beans ca');
      select count(*) from nation n, region r where n.n_regionkey = r.r_regionkey and r.r_regionkey = 2;
       
      More results from queries before failure can be found in /var/tmp/mtr/log/mcs4010_autopilot_cross_engine_join.log
       
      Warnings from just before the error:
      Error 1815 Internal error: CrossEngineStep::execute() Set or verify credentials in CrossEngineSupport section of Columnstore.xml. (2006) (Server has gone away)
      

      logs https://mdbe-ci-repo.mariadb.net/bb-logs/MariaDBEnterprise/10.6-23.10-via-maxscale-dec04/debian_bookworm_gcp/mtr-columnstore-test/10485/

      Attachments

        Issue Links

          Activity

            People

              tturenko Timofey Turenko
              tturenko Timofey Turenko
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.