## Source pulled from https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.24.tar.gz ushastry@BionicBeaver:~/Downloads/mysql-5.7.24/bld/mysql-test$ cat /etc/*release DISTRIB_ID=Ubuntu DISTRIB_RELEASE=18.04 DISTRIB_CODENAME=bionic DISTRIB_DESCRIPTION="Ubuntu 18.04 LTS" NAME="Ubuntu" VERSION="18.04 LTS (Bionic Beaver)" ID=ubuntu ID_LIKE=debian PRETTY_NAME="Ubuntu 18.04 LTS" VERSION_ID="18.04" HOME_URL="https://www.ubuntu.com/" SUPPORT_URL="https://help.ubuntu.com/" BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/" PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy" VERSION_CODENAME=bionic UBUNTU_CODENAME=bionic ushastry@BionicBeaver:~/Downloads/mysql-5.7.24/bld/mysql-test$ cmake --version cmake version 3.10.2 CMake suite maintained and supported by Kitware (kitware.com/cmake). ushastry@BionicBeaver:~/Downloads/mysql-5.7.24/bld/mysql-test$ gcc --version gcc (Ubuntu 7.3.0-16ubuntu3) 7.3.0 Copyright (C) 2017 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. mkdir bld && cd bld cmake .. -DWITH_ASAN=ON -DWITH_ASAN_SCOPE=ON -DWITH_BOOST=../boost/ -DCMAKE_BUILD_TYPE=Debug -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_EMBEDDED_SERVER=OFF -DCMAKE_INSTALL_PREFIX=/home/ushastry/Downloads/mysql-5.7.24/bld make -j8 make install ushastry@BionicBeaver:~/Downloads/mysql-5.7.24/bld$ cd mysql-test/ ushastry@BionicBeaver:~/Downloads/mysql-5.7.24/bld/mysql-test$ ./mtr --debug-server innodb.innodb-wl6045-linux Logging: ./mtr --debug-server innodb.innodb-wl6045-linux 2018-11-13T08:10:08.450159Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-11-13T08:10:08.450642Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) MySQL Version 5.7.24 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Removing old var directory... Creating var directory '/home/ushastry/Downloads/mysql-5.7.24/bld/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 [100%] innodb.innodb-wl6045-linux [ pass ] 10588 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 10.588 of 25 seconds executing testcases Completed: All 1 tests were successful. ushastry@BionicBeaver:~/Downloads/mysql-5.7.24/bld/mysql-test$ ./mtr --debug-server innodb.log_file_name Logging: ./mtr --debug-server innodb.log_file_name 2018-11-13T08:10:51.169605Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-11-13T08:10:51.170138Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) MySQL Version 5.7.24 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/home/ushastry/Downloads/mysql-5.7.24/bld/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 [100%] innodb.log_file_name [ pass ] 24117 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 24.117 of 41 seconds executing testcases Completed: All 1 tests were successful. ## 5.7.23 ushastry@BionicBeaver:~/Downloads/mysql-5.7.23/bld$ cd mysql-test/ ushastry@BionicBeaver:~/Downloads/mysql-5.7.23/bld/mysql-test$ ./mtr --debug-server innodb.innodb-wl6045-linux Logging: ./mtr --debug-server innodb.innodb-wl6045-linux 2018-11-13T08:47:58.216038Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-11-13T08:47:58.216598Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) MySQL Version 5.7.23 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Removing old var directory... Creating var directory '/home/ushastry/Downloads/mysql-5.7.23/bld/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 innodb.innodb-wl6045-linux [ fail ] Test ended at 2018-11-13 03:48:17 CURRENT_TEST: innodb.innodb-wl6045-linux mysqltest: At line 394: command "$INNOCHECKSUM $MYSQLD_DATADIR/test/t1.ibd 2> $SEARCH_FILE" failed with wrong error: 42 The result from queries just before the failure was: < snip > page::#; log sequence number:first = #; second = # page::#; old style: calculated = #; recorded checksum = # page::#; new style: calculated = #; recorded checksum = # page::#; log sequence number:first = #; second = # page::#; old style: calculated = #; recorded checksum = # page::#; new style: calculated = #; recorded checksum = # page::#; log sequence number:first = #; second = # Page::# is empty and uncorrupted page::#; log sequence number:first = #; second = # Page::# is empty and uncorrupted # Replace the t.ibd with the newly created a.ibd having "innodb" checksum. # Start the server to validate the t1.ibd having "innodb" checksum. # restart select * from t1; c1 c2 1 Innochecksum InnoDB 2 Innochecksum CRC32 # Test[4] End # Test[5] for lock. # Test Scenario: As mysqld is running, & then start the innochecksum which must fail. safe_process[4747]: Child process: 4748, exit: 1 - the logfile can be found in '/home/ushastry/Downloads/mysql-5.7.23/bld/mysql-test/var/log/innodb.innodb-wl6045-linux/innodb-wl6045-linux.log' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 20 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): innodb.innodb-wl6045-linux The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html mysql-test-run: *** ERROR: there were failing test cases shastry@BionicBeaver:~/Downloads/mysql-5.7.23/bld/mysql-test$ more var/log/my_restart.err Error: Unable to lock file:: /home/ushastry/Downloads/mysql-5.7.23/bld/mysql-test/var/mysqld.1/data//test/t1.ibd fcntl: Resource temporarily unavailable ================================================================= ==5486==ERROR: LeakSanitizer: detected memory leaks Direct leak of 131072 byte(s) in 1 object(s) allocated from: #0 0x7fad8c83db50 in __interceptor_malloc (/usr/lib/x86_64-linux-gnu/libasan.so.4+0xdeb50) #1 0x55672688c443 in main /home/ushastry/Downloads/mysql-5.7.23/extra/innochecksum.cc:1173 #2 0x7fad8b82cb96 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x21b96) SUMMARY: AddressSanitizer: 131072 byte(s) leaked in 1 allocation(s). ###### ushastry@BionicBeaver:~/Downloads/mysql-5.7.23/bld/mysql-test$ ./mtr --debug-server innodb.log_file_name Logging: ./mtr --debug-server innodb.log_file_name 2018-11-13T08:51:27.196973Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-11-13T08:51:27.197497Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) MySQL Version 5.7.23 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/home/ushastry/Downloads/mysql-5.7.23/bld/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 innodb.log_file_name [ fail ] Test ended at 2018-11-13 03:51:42 CURRENT_TEST: innodb.log_file_name mysqltest: At line 39: command "$mysqld" failed with wrong error: 42 The result from queries just before the failure was: SET GLOBAL innodb_file_per_table=ON; CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB; CREATE TABLE t3(a INT PRIMARY KEY) ENGINE=InnoDB; BEGIN; INSERT INTO t3 VALUES (33101),(347); INSERT INTO t1 VALUES (42),(9),(101); RENAME TABLE t1 TO t2; UPDATE t2 SET a=347 where a=42; COMMIT; # Kill the server # Fault 0 (no real fault): Orphan file with duplicate space_id. # Fault 1: Two dirty files with the same space_id. safe_process[4978]: Child process: 4979, exit: 1 - the logfile can be found in '/home/ushastry/Downloads/mysql-5.7.23/bld/mysql-test/var/log/innodb.log_file_name/log_file_name.log' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 16 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): innodb.log_file_name The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html mysql-test-run: *** ERROR: there were failing test cases ==5193==ERROR: LeakSanitizer: detected memory leaks . Direct leak of 144 byte(s) in 1 object(s) allocated from: #0 0x7f269d0f9b50 in __interceptor_malloc (/usr/lib/x86_64-linux-gnu/libasan.so.4+0xdeb50) #1 0x55f03b160112 in ut_allocator::allocate(unsigned long, unsigned char const*, char const*, bool, bool) (/home/ushastry/Downloads/mysql-5.7.23/bld/sql/mysqld-debug+0x2a2c112) #2 0x55f03b5a2b1f in sync_latch_meta_init /home/ushastry/Downloads/mysql-5.7.23/storage/innobase/sync/sync0debug.cc:1486 #3 0x55f03b5bd55c in sync_check_init() /home/ushastry/Downloads/mysql-5.7.23/storage/innobase/sync/sync0debug.cc:1800 #4 0x55f03b53d2fa in srv_general_init() /home/ushastry/Downloads/mysql-5.7.23/storage/innobase/srv/srv0srv.cc:1085