// [ushastry@ushastry mysql-test]$ cat /etc/*release CentOS release 6.6 (Final) LSB_VERSION=base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch CentOS release 6.6 (Final) CentOS release 6.6 (Final) [ushastry@ushastry mysql-test]$ // https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.26.tar.gz // Built using steps provided in the report [ushastry@ushastry mysql-test]$ cmake --version cmake version 2.8.12.2 [ushastry@ushastry mysql-test]$ gcc --version gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-11) Copyright (C) 2010 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. [ushastry@ushastry mysql-test]$ cmake --version cmake version 2.8.12.2 [ushastry@ushastry mysql-test]$ gcc --version gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-11) Copyright (C) 2010 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. /// [ushastry@ushastry mysql-test]$ ./mtr --debug-server --parallel=auto --mysqld=--enforce-gtid-consistency --mysqld=--log-slave-updates --mysqld=--gtid-mode=on rpl.rpl_gtid_drop_table Logging: /home/ushastry/Downloads/mysql-5.6.26/mysql-test/mysql-test-run.pl --debug-server --parallel=auto --mysqld=--enforce-gtid-consistency --mysqld=--log-slave-updates --mysqld=--gtid-mode=on rpl.rpl_gtid_drop_table 2015-07-30 12:32:49 0 [Note] /home/ushastry/Downloads/mysql-5.6.26/bld_debug/sql/mysqld (mysqld 5.6.26-debug) starting as process 20244 ... 2015-07-30 12:32:49 20244 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2015-07-30 12:32:49 20244 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2015-07-30 12:32:49 20244 [Note] Plugin 'FEDERATED' is disabled. 2015-07-30 12:32:49 20244 [Note] Binlog end 2015-07-30 12:32:49 20244 [Note] Shutting down plugin 'CSV' 2015-07-30 12:32:49 20244 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.6.26 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... - adding combinations for rpl Removing old var directory... Creating var directory '/home/ushastry/Downloads/mysql-5.6.26/bld_debug/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 rpl.rpl_gtid_drop_table 'mix' [ pass ] 13571 rpl.rpl_gtid_drop_table 'row' [ pass ] 10544 rpl.rpl_gtid_drop_table 'stmt' [ pass ] 18777 -------------------------------------------------------------------------- The servers were restarted 2 times Spent 42.892 of 111 seconds executing testcases Completed: All 3 tests were successful. [ushastry@ushastry mysql-test]$ ./mtr --debug-server --parallel=auto --mysqld=--enforce-gtid-consistency --mysqld=--log-slave-updates --mysqld=--gtid-mode=on rpl.rpl_gtid_drop_table Logging: /home/ushastry/Downloads/mysql-5.6.26/mysql-test/mysql-test-run.pl --debug-server --parallel=auto --mysqld=--enforce-gtid-consistency --mysqld=--log-slave-updates --mysqld=--gtid-mode=on rpl.rpl_gtid_drop_table 2015-07-30 12:34:46 0 [Note] /home/ushastry/Downloads/mysql-5.6.26/bld_debug/sql/mysqld (mysqld 5.6.26-debug) starting as process 21377 ... 2015-07-30 12:34:46 21377 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2015-07-30 12:34:46 21377 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2015-07-30 12:34:46 21377 [Note] Plugin 'FEDERATED' is disabled. 2015-07-30 12:34:46 21377 [Note] Binlog end 2015-07-30 12:34:46 21377 [Note] Shutting down plugin 'CSV' 2015-07-30 12:34:46 21377 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.6.26 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... - adding combinations for rpl Checking leftover processes... Removing old var directory... Creating var directory '/home/ushastry/Downloads/mysql-5.6.26/bld_debug/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 rpl.rpl_gtid_drop_table 'mix' [ pass ] 17296 rpl.rpl_gtid_drop_table 'row' [ pass ] 12264 rpl.rpl_gtid_drop_table 'stmt' [ fail ] Test ended at 2015-07-30 12:36:15 CURRENT_TEST: rpl.rpl_gtid_drop_table mysqltest: In included file "./include/assert.inc": included from ./include/assert.inc at line 67: At line 66: Test assertion failed in assert.inc The result from queries just before the failure was: < snip > **** SHOW RELAYLOG EVENTS on server_1 **** relaylog_name = 'No such row' SHOW RELAYLOG EVENTS IN 'No such row'; Log_name Pos Event_type Server_id End_log_pos Info **** slave_relay_info on server_1 **** SELECT * FROM mysql.slave_relay_log_info; Number_of_lines Relay_log_name Relay_log_pos Master_log_name Master_log_pos Sql_delay Number_of_workers Id **** slave_master_info on server_1 **** SELECT * FROM mysql.slave_master_info; Number_of_lines Master_log_name Master_log_pos Host User_name User_password Port Connect_retry Enabled_ssl Ssl_ca Ssl_capath Ssl_cert Ssl_cipher Ssl_key Ssl_verify_server_cert Heartbeat Bind Ignored_server_ids Uuid Retry_count Ssl_crl Ssl_crlpath Enabled_auto_position rand_seed: '' _rand_state: '' extra debug info if any: '' connection slave; Assertion text: 'Slave_open_temp_tables should be 0' Assertion condition: '10 = 0' Assertion condition, interpolated: '10 = 0' Assertion result: '0' More results from queries before failure can be found in /home/ushastry/Downloads/mysql-5.6.26/bld_debug/mysql-test/var/log/rpl_gtid_drop_table.log - saving '/home/ushastry/Downloads/mysql-5.6.26/bld_debug/mysql-test/var/log/rpl.rpl_gtid_drop_table-stmt/' to '/home/ushastry/Downloads/mysql-5.6.26/bld_debug/mysql-test/var/log/rpl.rpl_gtid_drop_table-stmt/' -------------------------------------------------------------------------- The servers were restarted 2 times Spent 29.560 of 89 seconds executing testcases Completed: Failed 1/3 tests, 66.67% were successful. Failing test(s): rpl.rpl_gtid_drop_table 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 [ushastry@ushastry mysql-test]$ ./mtr --debug-server --parallel=auto --mysqld=--enforce-gtid-consistency --mysqld=--log-slave-updates --mysqld=--gtid-mode=on rpl.rpl_gtid_drop_table Logging: /home/ushastry/Downloads/mysql-5.6.26/mysql-test/mysql-test-run.pl --debug-server --parallel=auto --mysqld=--enforce-gtid-consistency --mysqld=--log-slave-updates --mysqld=--gtid-mode=on rpl.rpl_gtid_drop_table 2015-07-30 13:08:22 0 [Note] /home/ushastry/Downloads/mysql-5.6.26/bld_debug/sql/mysqld (mysqld 5.6.26-debug) starting as process 24384 ... 2015-07-30 13:08:22 24384 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2015-07-30 13:08:22 24384 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2015-07-30 13:08:22 24384 [Note] Plugin 'FEDERATED' is disabled. 2015-07-30 13:08:22 24384 [Note] Binlog end 2015-07-30 13:08:22 24384 [Note] Shutting down plugin 'CSV' 2015-07-30 13:08:22 24384 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.6.26 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... - adding combinations for rpl Checking leftover processes... Removing old var directory... Creating var directory '/home/ushastry/Downloads/mysql-5.6.26/bld_debug/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 rpl.rpl_gtid_drop_table 'mix' [ fail ] Test ended at 2015-07-30 13:08:51 CURRENT_TEST: rpl.rpl_gtid_drop_table mysqltest: In included file "./include/assert.inc": included from ./include/assert.inc at line 67: At line 66: Test assertion failed in assert.inc The result from queries just before the failure was: < snip > **** SHOW RELAYLOG EVENTS on server_1 **** relaylog_name = 'No such row' SHOW RELAYLOG EVENTS IN 'No such row'; Log_name Pos Event_type Server_id End_log_pos Info **** slave_relay_info on server_1 **** SELECT * FROM mysql.slave_relay_log_info; Number_of_lines Relay_log_name Relay_log_pos Master_log_name Master_log_pos Sql_delay Number_of_workers Id **** slave_master_info on server_1 **** SELECT * FROM mysql.slave_master_info; Number_of_lines Master_log_name Master_log_pos Host User_name User_password Port Connect_retry Enabled_ssl Ssl_ca Ssl_capath Ssl_cert Ssl_cipher Ssl_key Ssl_verify_server_cert Heartbeat Bind Ignored_server_ids Uuid Retry_count Ssl_crl Ssl_crlpath Enabled_auto_position rand_seed: '' _rand_state: '' extra debug info if any: '' connection slave; Assertion text: 'Slave_open_temp_tables should be 0' Assertion condition: '10 = 0' Assertion condition, interpolated: '10 = 0' Assertion result: '0' More results from queries before failure can be found in /home/ushastry/Downloads/mysql-5.6.26/bld_debug/mysql-test/var/log/rpl_gtid_drop_table.log - saving '/home/ushastry/Downloads/mysql-5.6.26/bld_debug/mysql-test/var/log/rpl.rpl_gtid_drop_table-mix/' to '/home/ushastry/Downloads/mysql-5.6.26/bld_debug/mysql-test/var/log/rpl.rpl_gtid_drop_table-mix/' Only 1 of 3 completed. mysql-test-run: *** ERROR: Not all tests completed [ushastry@ushastry mysql-test]$