Description:
The MySQL Test Suite fails executed as follows
./mysql-test-run.pl --do-test=innodb
results in the following error message:
Logging: /home/romz/oracle/mysql-server/mysql-test/mysql-test-run.pl --do-test=innodb
MySQL Version 8.0.16
Checking supported features
- Binaries are debug compiled
Using suite(s): audit_null,auth_sec,binlog,binlog_gtid,binlog_nogtid,collations,connection_control,encryption,engines,engines/funcs,engines/iuds,engines/rr_trx,federated,funcs_1,funcs_2,gcol,gis,group_replication,innodb,innodb_fts,innodb_gis,innodb_stress,innodb_undo,innodb_zip,interactive_utilities,jp,json,large_tests,main,max_parts,memcached,network_namespace,opt_trace,parts,parts/special_tests,perfschema,query_rewrite_plugins,rpl,rpl_gtid,rpl_nogtid,secondary_engine,service_status_var_registration,service_sys_var_registration,service_udf_registration,special,stress,sys_vars,sysschema,test_service_sql_api,test_services,x
Collecting tests
Removing old var directory
Creating var directory '/home/romz/oracle/mysql-server-build-clang-8.0.0/mysql-test/var'
Installing system database
Using parallel: 1
==============================================================================
TEST NAME RESULT TIME (ms) COMMENT
------------------------------------------------------------------------------
[ 9%] innodb.innodb [ pass ] 108883
[ 10%] innodb.innodb_misc1 [ pass ] 54098
[ 10%] innodb.innodb_ctype_ldml [ pass ] 8718
[ 10%] innodb.innodb-2byte-collation [ pass ] 5424
[ 10%] innodb.innodb-autoinc-44030 [ pass ] 6106
[ 10%] innodb.innodb-autoinc [ pass ] 41228
[ 11%] innodb.innodb_i_s_multi_file_tablespace [ pass ] 12
[ 11%] innodb.innodb_64k [ pass ] 9413
[ 11%] innodb.innodb-blob [ pass ] 14149
[ 11%] innodb.innodb_buffer_pool_dump_pct [ pass ] 2550
[ 12%] innodb.innodb_prefix_index_restart_server [ pass ] 25946
[ 12%] innodb.innodb_stats_auto_recalc [ pass ] 10408
[ 12%] innodb.innodb_stats_fetch [ pass ] 1500
[ 12%] innodb.innodb_stats_sample_pages [ pass ] 2520
[ 12%] innodb.innodb_wl6326 [ pass ] 6876
worker[1] Trying to dump core for [mysqltest - pid: 9479, winpid: 9479]
worker[1] Trying to dump core for [mysqld.1 - pid: 9391, winpid: 9391]
[ 13%] large_tests.innodb_innochecksum_3gb [ fail ] timeout after 900 seconds
Test ended at 2019-06-17 16:40:02
Test case timeout after 900 seconds
mysqltest: At line 59: LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/input.dat' IGNORE INTO TABLE tab2
== /home/romz/oracle/mysql-server-build-clang-8.0.0/mysql-test/var/log/innodb_innochecksum_3gb.log ==
DROP TABLE IF EXISTS tab2;
SHOW variables like '%innodb_checksum_algorithm%';
Variable_name Value
innodb_checksum_algorithm crc32
SELECT @@default_storage_engine;
@@default_storage_engine
InnoDB
CREATE TABLE tab2(col_1 CHAR (255) ,
col_2 VARCHAR (255), col_3 longtext,
col_4 longtext,col_5 BLOB,
col_6 LONGBLOB , col_7 bigint)
engine = innodb ;
CREATE INDEX idx1 ON tab2(col_3(10));
CREATE INDEX idx2 ON tab2(col_4(10));
CREATE INDEX idx3 ON tab2(col_5(10));
# Generate a input text file for loading the table
# check whether file exist
# load the data into the table
== /home/romz/oracle/mysql-server-build-clang-8.0.0/mysql-test/var/tmp/analyze-timeout-mysqld.1.err ==
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/home/romz/oracle/mysql-server-build-clang-8.0.0/mysql-test/var/tmp/mysqld.1.sock' (111)
safe_process[9627]: Child process: 9628, exit: 1
- the logfile can be found in '/home/romz/oracle/mysql-server-build-clang-8.0.0/mysql-test/var/log/large_tests.innodb_innochecksum_3gb/innodb_innochecksum_3gb.log'
Only 60 of 455 completed.
mysql-test-run: *** ERROR: Not all tests completed
How to repeat:
1. Take source code form https://github.com/mysql/mysql-server version 8.0.16
2. Run cmake:
cmake ../mysql-server -DCMAKE_CXX_COMPILER=clang++ -DCMAKE_C_COMPILER=clang -DCMAKE_BUILD_TYPE=Debug
3. Compile:
make
4. Run the MySQL Test Suite:
./mysql-test-run.pl --do-test=innodb
Description: The MySQL Test Suite fails executed as follows ./mysql-test-run.pl --do-test=innodb results in the following error message: Logging: /home/romz/oracle/mysql-server/mysql-test/mysql-test-run.pl --do-test=innodb MySQL Version 8.0.16 Checking supported features - Binaries are debug compiled Using suite(s): audit_null,auth_sec,binlog,binlog_gtid,binlog_nogtid,collations,connection_control,encryption,engines,engines/funcs,engines/iuds,engines/rr_trx,federated,funcs_1,funcs_2,gcol,gis,group_replication,innodb,innodb_fts,innodb_gis,innodb_stress,innodb_undo,innodb_zip,interactive_utilities,jp,json,large_tests,main,max_parts,memcached,network_namespace,opt_trace,parts,parts/special_tests,perfschema,query_rewrite_plugins,rpl,rpl_gtid,rpl_nogtid,secondary_engine,service_status_var_registration,service_sys_var_registration,service_udf_registration,special,stress,sys_vars,sysschema,test_service_sql_api,test_services,x Collecting tests Removing old var directory Creating var directory '/home/romz/oracle/mysql-server-build-clang-8.0.0/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ [ 9%] innodb.innodb [ pass ] 108883 [ 10%] innodb.innodb_misc1 [ pass ] 54098 [ 10%] innodb.innodb_ctype_ldml [ pass ] 8718 [ 10%] innodb.innodb-2byte-collation [ pass ] 5424 [ 10%] innodb.innodb-autoinc-44030 [ pass ] 6106 [ 10%] innodb.innodb-autoinc [ pass ] 41228 [ 11%] innodb.innodb_i_s_multi_file_tablespace [ pass ] 12 [ 11%] innodb.innodb_64k [ pass ] 9413 [ 11%] innodb.innodb-blob [ pass ] 14149 [ 11%] innodb.innodb_buffer_pool_dump_pct [ pass ] 2550 [ 12%] innodb.innodb_prefix_index_restart_server [ pass ] 25946 [ 12%] innodb.innodb_stats_auto_recalc [ pass ] 10408 [ 12%] innodb.innodb_stats_fetch [ pass ] 1500 [ 12%] innodb.innodb_stats_sample_pages [ pass ] 2520 [ 12%] innodb.innodb_wl6326 [ pass ] 6876 worker[1] Trying to dump core for [mysqltest - pid: 9479, winpid: 9479] worker[1] Trying to dump core for [mysqld.1 - pid: 9391, winpid: 9391] [ 13%] large_tests.innodb_innochecksum_3gb [ fail ] timeout after 900 seconds Test ended at 2019-06-17 16:40:02 Test case timeout after 900 seconds mysqltest: At line 59: LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/input.dat' IGNORE INTO TABLE tab2 == /home/romz/oracle/mysql-server-build-clang-8.0.0/mysql-test/var/log/innodb_innochecksum_3gb.log == DROP TABLE IF EXISTS tab2; SHOW variables like '%innodb_checksum_algorithm%'; Variable_name Value innodb_checksum_algorithm crc32 SELECT @@default_storage_engine; @@default_storage_engine InnoDB CREATE TABLE tab2(col_1 CHAR (255) , col_2 VARCHAR (255), col_3 longtext, col_4 longtext,col_5 BLOB, col_6 LONGBLOB , col_7 bigint) engine = innodb ; CREATE INDEX idx1 ON tab2(col_3(10)); CREATE INDEX idx2 ON tab2(col_4(10)); CREATE INDEX idx3 ON tab2(col_5(10)); # Generate a input text file for loading the table # check whether file exist # load the data into the table == /home/romz/oracle/mysql-server-build-clang-8.0.0/mysql-test/var/tmp/analyze-timeout-mysqld.1.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/home/romz/oracle/mysql-server-build-clang-8.0.0/mysql-test/var/tmp/mysqld.1.sock' (111) safe_process[9627]: Child process: 9628, exit: 1 - the logfile can be found in '/home/romz/oracle/mysql-server-build-clang-8.0.0/mysql-test/var/log/large_tests.innodb_innochecksum_3gb/innodb_innochecksum_3gb.log' Only 60 of 455 completed. mysql-test-run: *** ERROR: Not all tests completed How to repeat: 1. Take source code form https://github.com/mysql/mysql-server version 8.0.16 2. Run cmake: cmake ../mysql-server -DCMAKE_CXX_COMPILER=clang++ -DCMAKE_C_COMPILER=clang -DCMAKE_BUILD_TYPE=Debug 3. Compile: make 4. Run the MySQL Test Suite: ./mysql-test-run.pl --do-test=innodb