Bug #95842 Test innodb.innodb_wl6326 from MySQL Test Suite fails
Submitted: 17 Jun 2019 14:53 Modified: 17 Jun 2019 18:00
Reporter: Zbigniew Romanowski Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:8.0.16 OS:Fedora (version 30)
Assigned to: CPU Architecture:x86 (Intel(R) Core(TM) i5-3230M CPU @ 2.60GHz)
Tags: test suite

[17 Jun 2019 14:53] Zbigniew Romanowski
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
[17 Jun 2019 18:00] MySQL Verification Team
Thank you for the bug report.