Debian Codegraph @

mysql-test/suite/galera_3nodes/t/galera_certification_ccc.test

raw
1 #
2 # Test that a cluster configuration change during a transaction does not cause a failure
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 --let $galera_connection_name = node_3
9 --let $galera_server_number = 3
10 --source include/galera_connect.inc
11
12 # Save original auto_increment_offset values.
13 --let $node_1=node_1
14 --let $node_2=node_2
15 --let $node_3=node_3
16 --source ../galera/include/auto_increment_offset_save.inc
17
18 --connection node_1
19 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
20
21 SET AUTOCOMMIT=OFF;
22 START TRANSACTION;
23 INSERT INTO t1 VALUES (1);
24 SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
25
26 --connection node_3
27 --let $wsrep_cluster_address_orig = `SELECT @@wsrep_cluster_address`
28 SET GLOBAL wsrep_cluster_address = '';
29 --sleep 5
30
31 --connection node_1
32 INSERT INTO t1 VALUES (2);
33 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
34 COMMIT;
35
36 --connection node_2
37 SELECT COUNT(*) = 2 FROM t1;
38
39 --connection node_3
40 --disable_query_log
41 --eval SET GLOBAL wsrep_cluster_address = '$wsrep_cluster_address_orig';
42 --enable_query_log
43 --sleep 5
44 --source include/wait_until_ready.inc
45
46 --connection node_1
47 DROP TABLE t1;
48
49 # Restore original auto_increment_offset values.
50 --source ../galera/include/auto_increment_offset_restore.inc
51
52 --source include/galera_end.inc