Debian Codegraph @

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

raw
1 #
2 # Test that autoincrement works correctly while the cluster membership
3 # is changing and SST takes place.
4 #
5 --source include/big_test.inc
6 --source include/galera_cluster.inc
7 --source include/have_mariabackup.inc
8 --source include/force_restart.inc
9
10 --let $node_1=node_1
11 --let $node_2=node_2
12 --source include/auto_increment_offset_save.inc
13
14 --connection node_1
15 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
16
17 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
18
19 # Kill and restart node #2
20 --connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2
21 --connection node_2a
22 --source include/kill_galera.inc
23 --remove_file $MYSQLTEST_VARDIR/mysqld.2/data/grastate.dat
24
25 --connection node_1
26 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
27 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
28 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
29 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
30 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
31 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
32 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
33 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
34 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
35 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
36
37 --connection node_2a
38 --source include/start_mysqld.inc
39 --source include/wait_until_connected_again.inc
40
41 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
42 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
43 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
44 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
45 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
46 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
47 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
48 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
49 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
50 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
51 INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
52
53 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
54 --connection node_1a
55 SELECT COUNT(*) FROM t1;
56
57 --connection node_2a
58 SELECT COUNT(*) FROM t1;
59
60 --connection node_1
61 DROP TABLE t1;
62
63 CALL mtr.add_suppression("gcs_caused\\(\\) returned -1 \\(Operation not permitted\\)");
64 CALL mtr.add_suppression("WSREP: Action message in non-primary configuration from member 0");
65
66 --let $node_1=node_1a
67 --let $node_2=node_2a
68 --source include/auto_increment_offset_restore.inc
69
70 --disconnect node_1a
71 --disconnect node_2a