Debian Codegraph @

mysql-test/suite/mariabackup/slave_provision_nolock.test

raw
1 --source include/have_innodb.inc
2 --source include/have_log_bin.inc
3 # Test does a lot of queries that take a lot of CPU under Valgrind.
4 --source include/not_valgrind.inc
5
6 call mtr.add_suppression("Can't init tc log");
7 call mtr.add_suppression("Aborting");
8
9 # Test provisioning a slave from an existing server, using mariabackup --no-lock
10 # and the binlog position recovered from InnoDB redo log.
11
12 # Update the InnoDB system tablespace to simulate a pre-10.3.5
13 # position in TRX_SYS. There was a bug that the wrong position could
14 # be recovered if the old filename in TRX_SYS compares newer than the
15 # newer filenames stored in rseg headers.
16 let MYSQLD_DATADIR=`select @@datadir`;
17 let INNODB_PAGE_SIZE=`select @@innodb_page_size`;
18
19 --source include/shutdown_mysqld.inc
20
21 --perl
22 use strict;
23 use warnings;
24 use Fcntl qw(:DEFAULT :seek);
25 do "$ENV{MTR_SUITE_DIR}/../innodb/include/crc32.pl";
26 do "$ENV{MTR_SUITE_DIR}/../innodb/include/innodb-util.pl";
27
28 my $ps = $ENV{INNODB_PAGE_SIZE};
29
30 sysopen IBD_FILE, "$ENV{MYSQLD_DATADIR}/ibdata1", O_RDWR
31 or die "Cannot open ibdata1: $!\n";
32
33 # Read the TRX_SYS page.
34 my $page;
35 sysseek(IBD_FILE, $ps * 5, SEEK_SET)
36 or die "Cannot seek ibdata1: $!\n";
37 sysread(IBD_FILE, $page, $ps)
38 or die "Cannot read ibdata1: $!\n";
39
40 # Put in an old binlog position that will compare larger than master-bin.000001
41 my $old_name= '~~~-bin.999999' . chr(0);
42 my $old_off= 0xffff0000;
43 my $old_magic= 873422344;
44 my $binlog_offset= $ps - 1000 + 38;
45 substr($page, $binlog_offset, 4)= pack('N', $old_magic);
46 substr($page, $binlog_offset + 4, 4)= pack('N', ($old_off >> 32));
47 substr($page, $binlog_offset + 8, 4)= pack('N', ($old_off & 0xffffffff));
48 substr($page, $binlog_offset + 12, length($old_name))= $old_name;
49
50 # Write back the modified page.
51 my $full_crc32= get_full_crc32(\*IBD_FILE);
52 $page= fix_page_crc($page, $full_crc32);
53 sysseek(IBD_FILE, $ps * 5, SEEK_SET)
54 or die "Cannot seek ibdata1: $!\n";
55 syswrite(IBD_FILE, $page, $ps) == $ps
56 or die "Cannot write ibdata1: $!\n";
57 close IBD_FILE;
58 EOF
59
60 --source include/start_mysqld.inc
61
62
63 let $basedir=$MYSQLTEST_VARDIR/tmp/backup;
64
65 RESET MASTER;
66 CREATE TABLE t1(a varchar(60) PRIMARY KEY, b VARCHAR(60)) ENGINE INNODB;
67 INSERT INTO t1 VALUES(1, NULL);
68 CREATE TABLE t2 (val INT) ENGINE=InnoDB;
69 INSERT INTO t2 VALUES (0);
70
71 --disable_query_log
72 --delimiter //
73 CREATE PROCEDURE gen_load()
74 MODIFIES SQL DATA
75 BEGIN
76 DECLARE i INT;
77 DECLARE flag TYPE OF t2.val;
78 SET i = 0;
79 load_loop: LOOP
80 SELECT val INTO flag FROM t2;
81 IF NOT (flag=0) THEN
82 LEAVE load_loop;
83 END IF;
84 START TRANSACTION;
85 INSERT INTO t1 VALUES (CONCAT("AbAdCaFe", LPAD(i, 6, "0")), @@SESSION.last_gtid);
86 COMMIT;
87 SET i = i + 1;
88 END LOOP;
89 END
90 //
91 --delimiter ;
92 --enable_query_log
93
94 connect (con1,localhost,root,,);
95 --echo *** Start a background load...
96 send CALL gen_load();
97
98 --connection default
99 --echo *** Doing backup...
100 --exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$basedir --no-lock
101 --echo *** Doing prepare...
102 --exec $XTRABACKUP --prepare --binlog-info=1 --target-dir=$basedir
103
104 --echo *** Stop the background load...
105 UPDATE t2 SET val=1;
106 --connection con1
107 reap;
108 --connection default
109 disconnect con1;
110 --let $count_master= `SELECT COUNT(*) FROM t1`
111
112 --echo *** Provision a new slave from the backup
113 --connect (server2,127.0.0.1,root,,,$SERVER_MYPORT_2)
114 --let $datadir_2= `SELECT @@datadir`
115
116 --echo *** Stopping provisioned server
117 --source include/shutdown_mysqld.inc
118
119 --echo *** Removing old datadir for provisioned server
120 --rmdir $datadir_2
121
122 --echo *** Provision new server from backup
123 --exec $XTRABACKUP --copy-back --datadir=$datadir_2 --target-dir=$basedir
124
125 # --no-lock backup might leave prepared xa transactions. rollback them.
126 --error 1
127 --exec $MYSQLD_LAST_CMD --tc-heuristic-recover=ROLLBACK
128 --source include/start_mysqld.inc
129
130 --echo *** Configure slave position from xtrabackup_binlog_pos_innodb
131 CREATE TABLE t3 (file VARCHAR(255), pos INT) ENGINE=InnoDB;
132 --replace_result $basedir BASEDIR
133 --disable_warnings
134 eval LOAD DATA LOCAL INFILE "$basedir/xtrabackup_binlog_pos_innodb"
135 INTO TABLE t3 FIELDS ESCAPED BY '' (file, pos);
136 --enable_warnings
137
138 # Remove leading ./ from filename (leading .\ on windows).
139 --let provision_master_file= `SELECT REGEXP_REPLACE(file, "^[.].", "") FROM t3`
140 --let provision_master_pos= `SELECT pos FROM t3`
141
142 --replace_result $SERVER_MYPORT_1 PORT $provision_master_file MASTER_FILE $provision_master_pos MASTER_POS
143 eval CHANGE MASTER TO
144 master_ssl_verify_server_cert=0,
145 master_port=$SERVER_MYPORT_1, master_host='127.0.0.1', master_user='root',
146 master_log_file= "$provision_master_file",
147 master_log_pos= $provision_master_pos;
148 START SLAVE;
149
150 --connection default
151 --save_master_pos
152
153 --connection server2
154 --sync_with_master
155 --let $count_slave= `SELECT COUNT(*) FROM t1`
156 if ($count_master != $count_slave) {
157 --echo *** ERROR: Table on master has $count_master rows, but table on provisioned slave has $count_slave rows
158 --die Row difference on provisioned slave.
159 }
160
161 # Cleanup
162
163 --connection server2
164 STOP SLAVE;
165 RESET SLAVE ALL;
166 DROP PROCEDURE gen_load;
167 DROP TABLE t1, t2, t3;
168
169 --connection default
170 DROP PROCEDURE gen_load;
171 DROP TABLE t1, t2;
172
173 rmdir $basedir;