From d4011a614411e67633cc75a6233c74a22dd32ff5 Mon Sep 17 00:00:00 2001 From: Shivji Kumar Jha Date: Fri, 27 Sep 2013 01:24:16 +0530 Subject: BUG#16580366- MTR TESTS FAILING SPORADICALLY ON PB2 (5.5, 5.6 AND 5.7) DURING INNODB RECOVERY Problem: ======= The connection 'master' is dropped by mysqltest after rpl_end.inc. At this point, dropping temporary tables at the connection 'master' are not synced at slave. So, the temporary tables replicated from master remain on slave leading to an inconsistent close of the test. The following test thus complains about the presence of temporary table(s) left over from the previous test. Fix: === - Put explicit drop commands in replication tests so that the temporary tables are dropped at slave as well. - Added the check for Slave_open_temp_tables in mtr_check.sql to warn about the remaining temporary table, if any, at the close of a test. --- mysql-test/include/mtr_check.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'mysql-test/include/mtr_check.sql') diff --git a/mysql-test/include/mtr_check.sql b/mysql-test/include/mtr_check.sql index fbe5df632c6..9c51b333ec6 100644 --- a/mysql-test/include/mtr_check.sql +++ b/mysql-test/include/mtr_check.sql @@ -72,6 +72,8 @@ BEGIN mysql.time_zone_transition_type, mysql.user; + show status like 'slave_open_temp_tables'; + END|| -- -- cgit v1.2.1 From ebaac51c2f047892cdfc0e30415a4880df9de2e8 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Mon, 27 Jan 2014 12:10:53 +0100 Subject: mtr: check that tests clean up debug_sync. fix tests that didn't. --- mysql-test/include/mtr_check.sql | 3 +++ 1 file changed, 3 insertions(+) (limited to 'mysql-test/include/mtr_check.sql') diff --git a/mysql-test/include/mtr_check.sql b/mysql-test/include/mtr_check.sql index 7cca74d52f0..e0d4f407633 100644 --- a/mysql-test/include/mtr_check.sql +++ b/mysql-test/include/mtr_check.sql @@ -78,6 +78,9 @@ BEGIN -- verify that no plugin changed its disabled/enabled state SELECT * FROM INFORMATION_SCHEMA.PLUGINS; + select * from information_schema.session_variables + where variable_name = 'debug_sync'; + show status like 'slave_open_temp_tables'; END|| -- cgit v1.2.1