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

cpimport a parquet file fails on a cluster setup

    XMLWordPrintable

Details

    • 2024-1, 2024-2

    Description

      test case mcol-5505-cpimport-parquet is about importing a parquet file. It fails when run on a cluster set up.

      Repro
      ------
      3-node CentOS 7 cluster

      1. ./mtr --exter socket=/var/lib/mysql/mysql.sock --suite=columnstore/basic mcol-5505-cpimport-parquet
        Logging: ./mtr --exter socket=/var/lib/mysql/mysql.sock --suite=columnstore/basic mcol-5505-cpimport-parquet
        VS config:
        vardir: /usr/share/mysql-test/var
        Checking supported features...
        MariaDB Version 10.6.18
      • skipping SSL, mysqld not compiled with SSL
        Collecting tests...

      ==============================================================================

      TEST RESULT TIME (ms) or COMMENT
      --------------------------------------------------------------------------

      worker[01] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
      worker[01] mysql-test-run: WARNING: running this script as root will cause some tests to be skipped
      columnstore/basic.mcol-5505-cpimport-parquet [ fail ]
      Test ended at 2024-05-31 09:50:33

      writeenginesplit[12669]: 31.386457 |0|0|0| E 33 CAL0000: Received a Cpimport Failure from PM2 %%10%%
      2024-05-31 09:50:31 (12669) ERR : Received a Cpimport Failure from PM2
      writeenginesplit[12669]: 31.386601 |0|0|0| E 33 CAL0087: BulkLoad Error: Received a Cpimport Failure from PM2
      writeenginesplit[12669]: 31.387021 |0|0|0| E 33 CAL0000: PM2 : Bulkload Read (thread 0) Failed for Table mcol_5505_cpimport_parquet.t1. Terminating this job. %%10%%
      2024-05-31 09:50:31 (12669) ERR : PM2 : Bulkload Read (thread 0) Failed for Table mcol_5505_cpimport_parquet.t1. Terminating this job.
      writeenginesplit[12669]: 31.387076 |0|0|0| E 33 CAL0087: BulkLoad Error: PM2 : Bulkload Read (thread 0) Failed for Table mcol_5505_cpimport_parquet.t1. Terminating this job.
      mysqltest: At line 55: exec of '/usr/bin/cpimport mcol_5505_cpimport_parquet t1 /usr/share/mysql-test/suite/columnstore/basic/../std_data/tests.parquet >/dev/null' failed, error: 256, status: 1, errno: 11
      Output from before failure:
      Create TABLE t1(
      col1 INT,
      col2 BIGINT,
      col3 FLOAT,
      col4 DOUBLE,
      col5 TIME(3),
      col6 VARCHAR(2),
      col7 VARCHAR(5),
      col8 VARCHAR(20),
      col9 CHAR(2),
      col10 CHAR(5),
      col11 CHAR(20),
      col12 TIMESTAMP(3),
      col13 DATE,
      col14 DATETIME(3),
      col15 SMALLINT,
      col16 TINYINT,
      col17 DECIMAL(9,3),
      col18 INT UNSIGNED,
      col19 SMALLINT UNSIGNED,
      col20 TINYINT UNSIGNED,
      col21 BIGINT UNSIGNED,
      col22 BOOLEAN,
      col23 DECIMAL(38,10),
      col24 TIME(6),
      col25 TIMESTAMP(6),
      col26 DATETIME(6),
      col27 CHAR(4),
      col28 CHAR(4)
      ) ENGINE=Columnstore;

      Attachments

        Activity

          People

            leonid.fedorov Leonid Fedorov
            susil.behera Susil Behera
            Kirill Perov Kirill Perov (Inactive)
            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.