## After patching(one provided by reporter in how to repeat), build - debug build ## If needed change binlog name to master-bin.000001 -- Observed with 5.7.20 and 5.7.21 src build - in version adding 5.7.20 since 5.7.21 is not yet GA -- build 5.7.21 - pulled from pb2 daily [umshastr@hod03]/export/umesh/server/source/bugs/src_build: md5sum 25873245.mysql-5.7-export-12149924.tar.gz 5fc8811dd1a4bb2e32667c2f0d1a3e76 25873245.mysql-5.7-export-12149924.tar.gz -- 5.7.20 src [umshastr@hod03]/export/umesh/server/source/bugs/src_build: md5sum mysql-boost-5.7.20.tar.gz 9536c324a7dc7ea5f41e351c30a86c4f mysql-boost-5.7.20.tar.gz [umshastr@hod03]/export/umesh/server/source/bugs/src_build/mysql-5.7-export-12149924/5.7/mysql-test: ./mtr r2 Logging: ./mtr r2 MySQL Version 5.7.21 Too long tmpdir path '/export/umesh/server/source/bugs/src_build/mysql-5.7-export-12149924/5.7/mysql-test/var/tmp' creating a shorter one... - using tmpdir: '/tmp/aARwB5Kjl6' Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/source/bugs/src_build/mysql-5.7-export-12149924/5.7/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 CREATE TABLE ti (c1 INT) ENGINE=INNODB; XA START 'x'; INSERT INTO ti VALUES(1); XA END 'x'; SET @@session.debug = '+d,crash_after_xa_prepare'; XA PREPARE 'x'; ERROR HY000: Lost connection to MySQL server during query # restart XA RECOVER; formatID gtrid_length bqual_length data show binlog events in 'master-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 4 Format_desc 1 123 Server ver: 5.7.21-debug-log, Binlog ver: 4 master-bin.000001 123 Previous_gtids 1 154 master-bin.000001 154 Anonymous_Gtid 1 219 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 219 Query 1 331 use `test`; CREATE TABLE ti (c1 INT) ENGINE=INNODB master-bin.000001 331 Anonymous_Gtid 1 396 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 396 Query 1 483 XA START X'78',X'',1 master-bin.000001 483 Table_map 1 528 table_id: 222 (test.ti) master-bin.000001 528 Write_rows 1 568 table_id: 222 flags: STMT_END_F master-bin.000001 568 Query 1 653 XA END X'78',X'',1 master-bin.000001 653 XA_prepare 1 690 XA PREPARE X'78',X'',1 main.r2 [ pass ] 1392 MTR's internal check of the test case 'main.r2' failed. This means that the test case does not preserve the state that existed before the test case was executed. Most likely the test case did not do a proper clean-up. It could also be caused by the previous test run by this thread, if the server wasn't restarted. This is the diff of the states of the servers before and after the test case was executed: mysqltest: Logging to '/export/umesh/server/source/bugs/src_build/mysql-5.7-export-12149924/5.7/mysql-test/var/tmp/check-mysqld_1.log'. mysqltest: Results saved in '/export/umesh/server/source/bugs/src_build/mysql-5.7-export-12149924/5.7/mysql-test/var/tmp/check-mysqld_1.result'. mysqltest: Connecting to server localhost:13000 (socket /tmp/aARwB5Kjl6/mysqld.1.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from './include/check-testcase.test' ... mysqltest: ... Done processing test commands. --- /export/umesh/server/source/bugs/src_build/mysql-5.7-export-12149924/5.7/mysql-test/var/tmp/check-mysqld_1.result 2017-11-20 12:37:57.614688413 +0300 +++ /export/umesh/server/source/bugs/src_build/mysql-5.7-export-12149924/5.7/mysql-test/var/tmp/check-mysqld_1.reject 2017-11-20 12:37:59.737735722 +0300 @@ -620,6 +620,7 @@ def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL tables_in_test +ti tables_in_mysql mysql.columns_priv mysql.db mysqltest: Result content mismatch not ok safe_process[32247]: Child process: 32248, exit: 1 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 1.392 of 8 seconds executing testcases Check of testcase failed for: main.r2 Completed: All 1 tests were successful. [umshastr@hod03]/export/umesh/server/source/bugs/src_build/mysql-5.7-export-12149924/5.7/mysql-test: ./mtr r1 Logging: ./mtr r1 MySQL Version 5.7.21 Too long tmpdir path '/export/umesh/server/source/bugs/src_build/mysql-5.7-export-12149924/5.7/mysql-test/var/tmp' creating a shorter one... - using tmpdir: '/tmp/PUdv2DAkTN' Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/source/bugs/src_build/mysql-5.7-export-12149924/5.7/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 include/master-slave.inc [connection master] CREATE TABLE ti (c1 INT) ENGINE=INNODB; XA START 'x'; INSERT INTO ti VALUES(1); XA END 'x'; SET @@session.debug = '+d,simulate_xa_failure_prepare'; XA PREPARE 'x'; ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back #Master XA RECOVER; formatID gtrid_length bqual_length data #Slave XA RECOVER; formatID gtrid_length bqual_length data 1 1 0 x main.r1 [ pass ] 196 MTR's internal check of the test case 'main.r1' failed. This means that the test case does not preserve the state that existed before the test case was executed. Most likely the test case did not do a proper clean-up. It could also be caused by the previous test run by this thread, if the server wasn't restarted. This is the diff of the states of the servers before and after the test case was executed: mysqltest: Logging to '/export/umesh/server/source/bugs/src_build/mysql-5.7-export-12149924/5.7/mysql-test/var/tmp/check-mysqld_2.log'. mysqltest: Results saved in '/export/umesh/server/source/bugs/src_build/mysql-5.7-export-12149924/5.7/mysql-test/var/tmp/check-mysqld_2.result'. mysqltest: Connecting to server localhost:13001 (socket /tmp/PUdv2DAkTN/mysqld.2.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from './include/check-testcase.test' ... mysqltest: ... Done processing test commands. --- /export/umesh/server/source/bugs/src_build/mysql-5.7-export-12149924/5.7/mysql-test/var/tmp/check-mysqld_2.result 2017-11-20 12:39:20.253482562 +0300 +++ /export/umesh/server/source/bugs/src_build/mysql-5.7-export-12149924/5.7/mysql-test/var/tmp/check-mysqld_2.reject 2017-11-20 12:39:21.056500494 +0300 @@ -1,4 +1,4 @@ -Slave_IO_State +Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port # @@ -8,8 +8,8 @@ Relay_Log_File # Relay_Log_Pos # Relay_Master_Log_File # -Slave_IO_Running No -Slave_SQL_Running No +Slave_IO_Running Yes +Slave_SQL_Running Yes Replicate_Do_DB # Replicate_Ignore_DB # Replicate_Do_Table # @@ -30,7 +30,7 @@ Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key -Seconds_Behind_Master NULL +Seconds_Behind_Master 0 Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error @@ -42,7 +42,7 @@ Master_Info_File # SQL_Delay 0 SQL_Remaining_Delay NULL -Slave_SQL_Running_State +Slave_SQL_Running_State Slave has read all relay log; waiting for more updates Master_Retry_Count # Master_Bind Last_IO_Error_Timestamp @@ -620,6 +620,7 @@ def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL tables_in_test +ti tables_in_mysql mysql.columns_priv mysql.db mysqltest: Result content mismatch not ok safe_process[32371]: Child process: 32373, exit: 1 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.196 of 15 seconds executing testcases Check of testcase failed for: main.r1 Completed: All 1 tests were successful. [umshastr@hod03]/export/umesh/server/source/bugs/src_build/mysql-5.7-export-12149924/5.7/mysql-test: