Debian Codegraph @

mysql-test/suite/galera/t/galera_kill_nochanges.test

raw
1 #
2 # This test kill -9-s a slave while no updates have been performed on the master.
3 #
4
5 --source include/galera_cluster.inc
6
7 # Save original auto_increment_offset values.
8 --let $node_1=node_1
9 --let $node_2=node_2
10 --source include/auto_increment_offset_save.inc
11
12 --connection node_1
13 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
14 INSERT INTO t1 VALUES (1);
15
16 --connection node_2
17 --source include/kill_galera.inc
18
19 --connection node_1
20 SET SESSION wsrep_sync_wait = 0;
21 --let $wait_condition = SELECT VARIABLE_VALUE = 'non-Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status'
22 --source include/wait_condition.inc
23
24 SET SESSION wsrep_sync_wait = DEFAULT;
25
26 --connection node_2
27 --source include/start_mysqld.inc
28
29 --let $galera_connection_name = node_2a
30 --let $galera_server_number = 2
31 --source include/galera_connect.inc
32 --connection node_2a
33
34 SELECT COUNT(*) FROM t1;
35 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
36
37 --let $node_2=node_2a
38 --source include/auto_increment_offset_restore.inc
39
40 DROP TABLE t1;