Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
23.10.1
-
None
-
None
-
https://github.com/mariadb-corporation/mariadb-columnstore-engine/commit/4608267
3-node CentOS 7 cluster
-
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
- ./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;