[Commits] dc0613edc41: MDEV-15809: Test failure on galera.MW-44

jan jan.lindstrom at mariadb.com
Thu Apr 26 12:25:24 EEST 2018


revision-id: dc0613edc41590a03a75b5b75e7200c11435ad1a (mariadb-10.1.32-69-gdc0613edc41)
parent(s): 779343235b0c33d6d661387456859d623d7f8781
author: Jan Lindström
committer: Jan Lindström
timestamp: 2018-04-26 12:23:19 +0300
message:

MDEV-15809: Test failure on galera.MW-44

Disable general log while truncating mysql.general_log to
avoid queries to be inserted there.

---
 mysql-test/suite/galera/disabled.def   |  2 +-
 mysql-test/suite/galera/r/MW-44.result | 14 ++++++++++----
 mysql-test/suite/galera/t/MW-44.test   |  9 +++++++--
 3 files changed, 18 insertions(+), 7 deletions(-)

diff --git a/mysql-test/suite/galera/disabled.def b/mysql-test/suite/galera/disabled.def
index 4d83e2ba2ce..4c0a5c7fd9f 100644
--- a/mysql-test/suite/galera/disabled.def
+++ b/mysql-test/suite/galera/disabled.def
@@ -30,4 +30,4 @@ galera.MW-328A : have_deadlocks test not stable
 galera_var_retry_autocommit : MDEV-15794 Test failure on galera.galera_var_retry_autocommit
 galera_var_auto_inc_control_on : MDEV-15803 Test failure on galera.galera_var_auto_inc_control_on
 query_cache : MDEV-15805 Test failure on galera.query_cache
-galera.MW-44 : MDEV-15809 Test failure on galera.MW-44
+
diff --git a/mysql-test/suite/galera/r/MW-44.result b/mysql-test/suite/galera/r/MW-44.result
index 03de2205772..459a61030a4 100644
--- a/mysql-test/suite/galera/r/MW-44.result
+++ b/mysql-test/suite/galera/r/MW-44.result
@@ -1,12 +1,18 @@
-SET @@global.wsrep_replicate_myisam=OFF;
+SET GLOBAL general_log='OFF';
 TRUNCATE TABLE mysql.general_log;
 SELECT COUNT(*) from mysql.general_log;
 COUNT(*)
-1
+0
+SELECT * FROM mysql.general_log;
+event_time	user_host	thread_id	server_id	command_type	argument
+SET GLOBAL general_log='OFF';
 TRUNCATE TABLE mysql.general_log;
 SELECT COUNT(*) from mysql.general_log;
 COUNT(*)
-1
+0
+SELECT * FROM mysql.general_log;
+event_time	user_host	thread_id	server_id	command_type	argument
+SET GLOBAL general_log='ON';
 SELECT COUNT(*) from mysql.general_log;
 COUNT(*)
 1
@@ -18,8 +24,8 @@ SET SESSION wsrep_osu_method=TOI;
 SELECT COUNT(*) = 2 FROM mysql.general_log WHERE argument LIKE 'CREATE%' OR argument LIKE 'ALTER%';
 COUNT(*) = 2
 1
+SET GLOBAL general_log='ON';
 SELECT COUNT(*) = 0 FROM mysql.general_log WHERE argument NOT LIKE 'SELECT%';
 COUNT(*) = 0
 1
 DROP TABLE t1;
-SET @@global.wsrep_replicate_myisam=Default;
diff --git a/mysql-test/suite/galera/t/MW-44.test b/mysql-test/suite/galera/t/MW-44.test
index b0e58e2bafd..09f444fdff4 100644
--- a/mysql-test/suite/galera/t/MW-44.test
+++ b/mysql-test/suite/galera/t/MW-44.test
@@ -5,16 +5,20 @@
 --source include/galera_cluster.inc
 --source include/have_innodb.inc
 
-SET @@global.wsrep_replicate_myisam=OFF;
 --connection node_1
+SET GLOBAL general_log='OFF';
 TRUNCATE TABLE mysql.general_log;
 SELECT COUNT(*) from mysql.general_log;
+SELECT * FROM mysql.general_log;
 
 --connection node_2
+SET GLOBAL general_log='OFF';
 TRUNCATE TABLE mysql.general_log;
 SELECT COUNT(*) from mysql.general_log;
+SELECT * FROM mysql.general_log;
 
 --connection node_1
+SET GLOBAL general_log='ON';
 SELECT COUNT(*) from mysql.general_log;
 SET SESSION wsrep_osu_method=TOI;
 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
@@ -25,6 +29,7 @@ SET SESSION wsrep_osu_method=TOI;
 SELECT COUNT(*) = 2 FROM mysql.general_log WHERE argument LIKE 'CREATE%' OR argument LIKE 'ALTER%';
 
 --connection node_2
+SET GLOBAL general_log='ON';
 SELECT COUNT(*) = 0 FROM mysql.general_log WHERE argument NOT LIKE 'SELECT%';
 DROP TABLE t1;
-SET @@global.wsrep_replicate_myisam=Default;
+


More information about the commits mailing list