[Commits] 8d684b0: Update test results in galera, galera_3nodes suites.

Nirbhay Choubey nirbhay at mariadb.com
Tue Oct 4 00:03:03 EEST 2016


revision-id: 8d684b03d48a2ef43b29fe105721f834e20b3969 (mariadb-10.2.2-12-g8d684b0)
parent(s): 1a3c50f79a9d3c2dac513430f125be522ca66f91
author: Nirbhay Choubey
committer: Nirbhay Choubey
timestamp: 2016-10-03 17:03:02 -0400
message:

Update test results in galera, galera_3nodes suites.

---
 mysql-test/suite/galera/r/GAL-382.result                      |  1 +
 mysql-test/suite/galera/r/MW-252.result                       |  3 +++
 mysql-test/suite/galera/r/MW-44.result                        |  4 ++++
 mysql-test/suite/galera/r/enforce_storage_engine2.result      |  2 ++
 mysql-test/suite/galera/r/galera_as_slave_autoinc.result      |  8 ++++++++
 mysql-test/suite/galera/r/galera_kill_ddl.result              |  3 ---
 mysql-test/suite/galera/r/galera_pc_ignore_sb.result          |  2 ++
 mysql-test/suite/galera/r/galera_restart_nochanges.result     |  3 +++
 mysql-test/suite/galera/r/galera_roles.result                 |  2 ++
 mysql-test/suite/galera/r/galera_split_brain.result           |  6 ++++--
 mysql-test/suite/galera/r/galera_var_desync_on.result         |  1 +
 mysql-test/suite/galera/r/galera_var_dirty_reads.result       |  2 ++
 mysql-test/suite/galera/r/mdev_10518.result                   |  9 +++++++++
 mysql-test/suite/galera/r/mysql-wsrep#31.result               |  5 +++++
 .../suite/galera_3nodes/r/galera_certification_ccc.result     | 11 +++++++++++
 .../r/galera_certification_double_failure.result              |  4 ++++
 .../suite/galera_3nodes/r/galera_parallel_apply_3nodes.result |  6 ++++++
 17 files changed, 67 insertions(+), 5 deletions(-)

diff --git a/mysql-test/suite/galera/r/GAL-382.result b/mysql-test/suite/galera/r/GAL-382.result
index 0c7365f..fb7c229 100644
--- a/mysql-test/suite/galera/r/GAL-382.result
+++ b/mysql-test/suite/galera/r/GAL-382.result
@@ -1,3 +1,4 @@
+connection node_1;
 create table t1 (i int, j int, k int, primary key pk(i)) engine=innodb;
 insert into t1 values (1, 1, 1), (2, 2, 2), (3, 3, 3);
 create table t2 (i int, j int, k int, primary key pk(i, j, k), index idx(i, k, j)) engine=innodb;
diff --git a/mysql-test/suite/galera/r/MW-252.result b/mysql-test/suite/galera/r/MW-252.result
index c422edc..795d3ff 100644
--- a/mysql-test/suite/galera/r/MW-252.result
+++ b/mysql-test/suite/galera/r/MW-252.result
@@ -1,7 +1,10 @@
+connection node_1;
 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
 FLUSH TABLES WITH READ LOCK;
 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
 VARIABLE_VALUE = 2
 1
+connection node_2;
+connection node_1;
 UNLOCK TABLES;
 DROP TABLE t1;
diff --git a/mysql-test/suite/galera/r/MW-44.result b/mysql-test/suite/galera/r/MW-44.result
index 28a6f1a..c007779 100644
--- a/mysql-test/suite/galera/r/MW-44.result
+++ b/mysql-test/suite/galera/r/MW-44.result
@@ -1,5 +1,8 @@
+connection node_1;
 TRUNCATE TABLE mysql.general_log;
+connection node_2;
 TRUNCATE TABLE mysql.general_log;
+connection node_1;
 SET SESSION wsrep_osu_method=TOI;
 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
 SET SESSION wsrep_osu_method=RSU;
@@ -8,6 +11,7 @@ SET SESSION wsrep_osu_method=TOI;
 SELECT COUNT(*) = 2 FROM mysql.general_log WHERE argument LIKE 'CREATE%' OR argument LIKE 'ALTER%';
 COUNT(*) = 2
 1
+connection node_2;
 SELECT COUNT(*) = 0 FROM mysql.general_log WHERE argument NOT LIKE 'SELECT%';
 COUNT(*) = 0
 1
diff --git a/mysql-test/suite/galera/r/enforce_storage_engine2.result b/mysql-test/suite/galera/r/enforce_storage_engine2.result
index 053c37d..128994e 100644
--- a/mysql-test/suite/galera/r/enforce_storage_engine2.result
+++ b/mysql-test/suite/galera/r/enforce_storage_engine2.result
@@ -2,10 +2,12 @@
 # MDEV-9312: storage engine not enforced during galera cluster
 # replication
 #
+connection node_1;
 CREATE TABLE t1(i INT) ENGINE=INNODB;
 CREATE TABLE t2(i INT) ENGINE=MYISAM;
 Warnings:
 Note	1266	Using storage engine InnoDB for table 't2'
+connection node_2;
 SHOW TABLES;
 Tables_in_test
 t1
diff --git a/mysql-test/suite/galera/r/galera_as_slave_autoinc.result b/mysql-test/suite/galera/r/galera_as_slave_autoinc.result
index b6314b8..ac01ea1 100644
--- a/mysql-test/suite/galera/r/galera_as_slave_autoinc.result
+++ b/mysql-test/suite/galera/r/galera_as_slave_autoinc.result
@@ -1,4 +1,7 @@
+connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
+connection node_2;
 START SLAVE;
+connection node_1;
 SET SESSION binlog_format='STATEMENT';
 CREATE TABLE t1 (
 i int(11) NOT NULL AUTO_INCREMENT,
@@ -40,6 +43,7 @@ Variable_name	Value
 auto_increment_increment	7
 auto_increment_offset	5
 wsrep_auto_increment_control	ON
+connection node_2;
 select * from t1;
 i	c
 1	dummy_text
@@ -58,6 +62,7 @@ binlog_format	ROW
 show variables like 'auto_increment_increment';
 Variable_name	Value
 auto_increment_increment	2
+connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
 select * from t1;
 i	c
 1	dummy_text
@@ -76,7 +81,10 @@ binlog_format	ROW
 show variables like 'auto_increment_increment';
 Variable_name	Value
 auto_increment_increment	2
+connection node_1;
 DROP TABLE t1;
+connection node_2;
 STOP SLAVE;
 RESET SLAVE ALL;
+connection node_1;
 RESET MASTER;
diff --git a/mysql-test/suite/galera/r/galera_kill_ddl.result b/mysql-test/suite/galera/r/galera_kill_ddl.result
index 9b15aae..aac316d 100644
--- a/mysql-test/suite/galera/r/galera_kill_ddl.result
+++ b/mysql-test/suite/galera/r/galera_kill_ddl.result
@@ -11,7 +11,4 @@ SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='t1';
 COUNT(*) = 2
 1
 connection node_1;
-SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
-VARIABLE_VALUE = 2
-1
 DROP TABLE t1;
diff --git a/mysql-test/suite/galera/r/galera_pc_ignore_sb.result b/mysql-test/suite/galera/r/galera_pc_ignore_sb.result
index e02ec0a..ee79d3c 100644
--- a/mysql-test/suite/galera/r/galera_pc_ignore_sb.result
+++ b/mysql-test/suite/galera/r/galera_pc_ignore_sb.result
@@ -16,3 +16,5 @@ VARIABLE_VALUE = 'ON'
 1
 SET GLOBAL wsrep_cluster_address = '';
 connection node_2;
+disconnect node_2;
+disconnect node_1;
diff --git a/mysql-test/suite/galera/r/galera_restart_nochanges.result b/mysql-test/suite/galera/r/galera_restart_nochanges.result
index 380a481..b35ae50 100644
--- a/mysql-test/suite/galera/r/galera_restart_nochanges.result
+++ b/mysql-test/suite/galera/r/galera_restart_nochanges.result
@@ -4,6 +4,7 @@ connection node_1;
 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
 INSERT INTO t1 VALUES (1);
 connection node_2;
+connection node_1;
 connection node_2a;
 SELECT COUNT(*) = 1 FROM t1;
 COUNT(*) = 1
@@ -12,3 +13,5 @@ SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_N
 VARIABLE_VALUE = 2
 1
 DROP TABLE t1;
+disconnect node_2;
+disconnect node_1;
diff --git a/mysql-test/suite/galera/r/galera_roles.result b/mysql-test/suite/galera/r/galera_roles.result
index f07cd81..bef89ac 100644
--- a/mysql-test/suite/galera/r/galera_roles.result
+++ b/mysql-test/suite/galera/r/galera_roles.result
@@ -171,6 +171,7 @@ DROP DATABASE test1;
 #
 
 # On node_1
+connection node_1;
 CREATE USER foo at localhost;
 CREATE ROLE role1;
 CREATE ROLE role2 WITH ADMIN CURRENT_USER;
@@ -189,6 +190,7 @@ root at localhost	role1	YES	NO
 root at localhost	role2	YES	NO
 
 # On node_2
+connection node_2;
 SELECT * FROM mysql.roles_mapping;
 Host	User	Role	Admin_option
 	role1	role4	Y
diff --git a/mysql-test/suite/galera/r/galera_split_brain.result b/mysql-test/suite/galera/r/galera_split_brain.result
index 9c5952c..e770f15 100644
--- a/mysql-test/suite/galera/r/galera_split_brain.result
+++ b/mysql-test/suite/galera/r/galera_split_brain.result
@@ -1,7 +1,7 @@
-call mtr.add_suppression("WSREP: TO isolation failed for: ");
-connection node_1;
 connection node_1;
 connection node_2;
+call mtr.add_suppression("WSREP: TO isolation failed for: ");
+connection node_1;
 connection node_2;
 Killing server ...
 connection node_1;
@@ -9,3 +9,5 @@ CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
 SET GLOBAL wsrep_cluster_address = '';
 connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
+disconnect node_2;
+disconnect node_1;
diff --git a/mysql-test/suite/galera/r/galera_var_desync_on.result b/mysql-test/suite/galera/r/galera_var_desync_on.result
index 54c3037..a26acbd 100644
--- a/mysql-test/suite/galera/r/galera_var_desync_on.result
+++ b/mysql-test/suite/galera/r/galera_var_desync_on.result
@@ -33,4 +33,5 @@ COUNT(*) = 11
 1
 CALL mtr.add_suppression("Protocol violation");
 DROP TABLE t1;
+connection node_1;
 CALL mtr.add_suppression("Protocol violation");
diff --git a/mysql-test/suite/galera/r/galera_var_dirty_reads.result b/mysql-test/suite/galera/r/galera_var_dirty_reads.result
index 6b3a3ec..e596e0f 100644
--- a/mysql-test/suite/galera/r/galera_var_dirty_reads.result
+++ b/mysql-test/suite/galera/r/galera_var_dirty_reads.result
@@ -1,3 +1,5 @@
+connection node_1;
+connection node_2;
 connection node_2;
 CREATE TABLE t1(i INT) ENGINE=INNODB;
 INSERT INTO t1 VALUES(1);
diff --git a/mysql-test/suite/galera/r/mdev_10518.result b/mysql-test/suite/galera/r/mdev_10518.result
index b2a3e0a..4ccd5fd 100644
--- a/mysql-test/suite/galera/r/mdev_10518.result
+++ b/mysql-test/suite/galera/r/mdev_10518.result
@@ -1,4 +1,5 @@
 # On node_1
+connection node_1;
 list of GTID variables :
 gtid_domain_id	1
 gtid_binlog_pos	
@@ -8,6 +9,7 @@ gtid_slave_pos
 wsrep_gtid_domain_id	4294967295
 wsrep_gtid_mode	1
 # On node_2
+connection node_2;
 list of GTID variables :
 gtid_domain_id	2
 gtid_binlog_pos	
@@ -17,6 +19,7 @@ gtid_slave_pos
 wsrep_gtid_domain_id	4294967295
 wsrep_gtid_mode	1
 # On node_1
+connection node_1;
 CREATE TABLE t1(i INT) ENGINE=INNODB;
 CREATE TABLE t2(i INT) ENGINE=MEMORY;
 INSERT INTO t1 VALUES(1);
@@ -34,6 +37,7 @@ gtid_slave_pos
 wsrep_gtid_domain_id	4294967295
 wsrep_gtid_mode	1
 # On node_2
+connection node_2;
 SELECT * FROM t1;
 i
 1
@@ -46,6 +50,7 @@ gtid_slave_pos
 wsrep_gtid_domain_id	4294967295
 wsrep_gtid_mode	1
 # On node_1
+connection node_1;
 INSERT INTO t2 VALUES(1);
 SELECT * FROM t2;
 i
@@ -59,6 +64,7 @@ gtid_slave_pos
 wsrep_gtid_domain_id	4294967295
 wsrep_gtid_mode	1
 # On node_2
+connection node_2;
 SELECT * FROM t2;
 i
 list of GTID variables :
@@ -70,5 +76,8 @@ gtid_slave_pos
 wsrep_gtid_domain_id	4294967295
 wsrep_gtid_mode	1
 # On node_1
+connection node_1;
 DROP TABLE t1, t2;
+disconnect node_2;
+disconnect node_1;
 # End of test
diff --git a/mysql-test/suite/galera/r/mysql-wsrep#31.result b/mysql-test/suite/galera/r/mysql-wsrep#31.result
index 973f115..1092f4d 100644
--- a/mysql-test/suite/galera/r/mysql-wsrep#31.result
+++ b/mysql-test/suite/galera/r/mysql-wsrep#31.result
@@ -1,4 +1,6 @@
 connection node_1;
+connection node_2;
+connection node_1;
 CREATE TABLE t1 (f1 CHAR(255)) ENGINE=InnoDB;
 INSERT INTO t1 VALUES('test');
 CREATE DATABASE db;
@@ -11,3 +13,6 @@ Using --wsrep-start-position when starting mysqld ...
 connection node_1;
 DROP TABLE t1;
 DROP DATABASE db;
+connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
+disconnect node_2;
+disconnect node_1;
diff --git a/mysql-test/suite/galera_3nodes/r/galera_certification_ccc.result b/mysql-test/suite/galera_3nodes/r/galera_certification_ccc.result
index 96a2bec..b1bbb14 100644
--- a/mysql-test/suite/galera_3nodes/r/galera_certification_ccc.result
+++ b/mysql-test/suite/galera_3nodes/r/galera_certification_ccc.result
@@ -1,3 +1,7 @@
+connection node_1;
+connection node_2;
+connection node_3;
+connection node_1;
 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
 SET AUTOCOMMIT=OFF;
 START TRANSACTION;
@@ -5,13 +9,20 @@ INSERT INTO t1 VALUES (1);
 SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
 VARIABLE_VALUE = 3
 1
+connection node_3;
 SET GLOBAL wsrep_cluster_address = '';
+connection node_1;
 INSERT INTO t1 VALUES (2);
 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
 VARIABLE_VALUE = 2
 1
 COMMIT;
+connection node_2;
 SELECT COUNT(*) = 2 FROM t1;
 COUNT(*) = 2
 1
+connection node_3;
+connection node_1;
 DROP TABLE t1;
+disconnect node_2;
+disconnect node_1;
diff --git a/mysql-test/suite/galera_3nodes/r/galera_certification_double_failure.result b/mysql-test/suite/galera_3nodes/r/galera_certification_double_failure.result
index 9dc735d..c2fdfc3 100644
--- a/mysql-test/suite/galera_3nodes/r/galera_certification_double_failure.result
+++ b/mysql-test/suite/galera_3nodes/r/galera_certification_double_failure.result
@@ -1,11 +1,15 @@
+connection node_1;
 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
 SET AUTOCOMMIT=OFF;
 START TRANSACTION;
 INSERT INTO t1 VALUES (1);
 INSERT INTO t2 VALUES (1);
+connection node_2;
 INSERT INTO t1 VALUES (1);
+connection node_3;
 INSERT INTO t2 VALUES (1);
+connection node_1;
 COMMIT;
 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
 DROP TABLE t1;
diff --git a/mysql-test/suite/galera_3nodes/r/galera_parallel_apply_3nodes.result b/mysql-test/suite/galera_3nodes/r/galera_parallel_apply_3nodes.result
index ec97d39..4f9951c 100644
--- a/mysql-test/suite/galera_3nodes/r/galera_parallel_apply_3nodes.result
+++ b/mysql-test/suite/galera_3nodes/r/galera_parallel_apply_3nodes.result
@@ -1,8 +1,14 @@
 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
 INSERT INTO t1 VALUES (1);
+connection node_3;
 SET GLOBAL wsrep_slave_threads = 2;
+connection node_1;
 UPDATE t1 SET f1 = f1 + 10;;
+connection node_2;
 UPDATE t1 SET f1 = f1 + 100;;
+connection node_1;
+connection node_2;
+connection node_3;
 SELECT f1 = 111 FROM t1;
 f1 = 111
 1


More information about the commits mailing list