Debian Codegraph @

mysql-test/suite/rpl/t/rpl_mysqldump_gtid_slave_pos.test

raw
1 --source include/have_innodb.inc
2 --source include/master-slave.inc
3
4 --echo # Initialize
5 --connection slave
6 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
7
8 --echo # Setup data
9 --connection master
10 CREATE TABLE t1 (a int PRIMARY KEY, b INT) ENGINE=InnoDB;
11 --source include/save_master_gtid.inc
12
13 --connection slave
14 --source include/sync_with_master_gtid.inc
15
16 # The following test proves fixes to
17 # MDEV-15393 gtid_slave_pos duplicate key errors after mysqldump restore
18 #
19 --echo # 1. run some replication load that adds records to gtid_slave_pos table
20 --echo # 2. stop slave, remove loaded data (it will be replicated), delete from
21 --echo # gtid_slave_pos as the table is going to be restored
22 --echo # 3. take dump from slave (master has an empty gtid_slave_pos)
23 --echo # with --gtid and for the default value of both
24 --echo # --dump-slave and --master-data
25 --echo # and in loop for the two options do:
26 --echo # 4. reset the slave state to install some initial state
27 --echo # 5. restart slave server, restore the dump
28 --echo # 6. check the final state which must be equal to the dump's one
29 --echo # 7. start replication to see no error => Q.E.D.
30 --echo # unless the test runs on a buggy version in which case set $FIXED to zero.
31
32 # set to ZERO when run with mysqldump of buggy version
33 --let $FIXED= 1
34
35 --echo # 1.
36 --source include/stop_slave.inc
37 delete from mysql.gtid_slave_pos;
38
39 --connection master
40 --let $trx_number = 5
41 --let $i = $trx_number
42 while ($i)
43 {
44 eval insert into t1 set a = $i;
45 --dec $i
46 }
47 --source include/save_master_gtid.inc
48
49 --connection slave
50 # enforce determistic SELECT * from mysql.gtid_slave_pos
51 --let $old_gtid_cleanup_batch_size = `select @@GLOBAL.gtid_cleanup_batch_size`
52 # the number of generated transactions on master must not exceed this value:
53 --let $val= 2147483647
54 --evalp SET @@global.gtid_cleanup_batch_size = $val
55
56 # due to MDEV-19801 on 10+.10+
57 CHANGE MASTER TO master_use_gtid= no;
58 --source include/start_slave.inc
59 --source include/sync_with_master_gtid.inc
60 # Prior tests in a mtr batch could leave the min value of sub_id column with
61 # arbtirary value. Therefore before dumping let's
62 # adjust mysql.gtid_slave_pos to have sub_id growing deterministically.
63 # The value of 2 is choosen.
64 --disable_query_log
65 set statement sql_log_bin = 0 for update mysql.gtid_slave_pos set sub_id = sub_id - (select min(sub_id) from mysql.gtid_slave_pos) + 2;
66 --enable_query_log
67 select * from mysql.gtid_slave_pos;
68 select @@global.gtid_slave_pos as "after initial slave got in sync";
69
70 --echo # 2.
71 --source include/stop_slave.inc
72
73 --echo # 3. A
74 # Two dumps prepared to be restored in the following loop
75 --exec $MYSQL_DUMP_SLAVE --no-autocommit=0 --dump-slave --gtid mysql gtid_slave_pos > $MYSQLTEST_VARDIR/tmp/dump_2.sql
76
77 --exec $MYSQL_DUMP_SLAVE --no-autocommit=0 --master-data --gtid mysql gtid_slave_pos > $MYSQLTEST_VARDIR/tmp/dump_1.sql
78
79 --let $i=2
80 while ($i)
81 {
82 --disable_warnings
83 --source include/stop_slave.inc
84 --enable_warnings
85 --echo # 4.
86 set statement sql_log_bin=0 for delete from mysql.gtid_slave_pos;
87 # setup a new gtid/sub_id state as complication for future backup restore.
88 # After the restore the new state must be a union of the backup state
89 # and this one.
90 --eval insert into mysql.gtid_slave_pos values (99 + $i, 1, 1, 1)
91
92 --echo # 5.
93 --let $rpl_server_number= 2
94 --source include/rpl_restart_server.inc
95 --evalp SET @@global.gtid_cleanup_batch_size = $val
96 select * from mysql.gtid_slave_pos;
97 select @@global.gtid_slave_pos as "before dump restore";
98 --let $dump=dump_$i.sql
99 --exec $MYSQL_SLAVE mysql -e "source $MYSQLTEST_VARDIR/tmp/$dump"
100
101 --echo # 6.
102 select * from mysql.gtid_slave_pos;
103 select @@global.gtid_slave_pos as "after dump restore";
104
105 --echo # 7.
106 reset slave;
107 select @@global.gtid_slave_pos;
108 change master to master_use_gtid=no;
109
110 --connection master
111 eval insert into t1 select 1+max(a),$i from t1;
112 --source include/save_master_gtid.inc
113
114 --connection slave
115 if ($FIXED)
116 {
117 --source include/start_slave.inc
118 --source include/sync_with_master_gtid.inc
119 }
120 if (!$FIXED)
121 {
122 start slave;
123 --let $slave_sql_errno= 1942
124 --source include/wait_for_slave_sql_error.inc
125
126 --die
127 }
128 select * from mysql.gtid_slave_pos;
129 select @@global.gtid_slave_pos as "after slave got in sync";
130
131 --dec $i
132 }
133 --echo #
134 --echo # Cleanup
135 --echo #
136 --connection master
137 DROP TABLE t1;
138 --source include/save_master_gtid.inc
139
140 --connection slave
141 --evalp SET @@global.gtid_cleanup_batch_size= $old_gtid_cleanup_batch_size
142 --remove_files_wildcard $MYSQLTEST_VARDIR/tmp dump_*.sql
143 --source include/sync_with_master_gtid.inc
144
145 --source include/rpl_end.inc