Debian Codegraph @

mysql-test/suite/rpl/r/rpl_gtid_mdev4484.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 include/stop_slave.inc
5 SET sql_log_bin=0;
6 ALTER TABLE mysql.gtid_slave_pos ENGINE=Aria;
7 SET sql_log_bin=1;
8 include/start_slave.inc
9 connection master;
10 CREATE TABLE t1 (i int) ENGINE=InnoDB;
11 connection slave;
12 *** MDEV-4484, incorrect error handling when entries in gtid_slave_pos not found. ***
13 TRUNCATE TABLE mysql.gtid_slave_pos;
14 connection master;
15 INSERT INTO t1 VALUES (1);
16 connection slave;
17 connection slave;
18 include/stop_slave.inc
19 SET @old_gtid_cleanup_batch_size= @@GLOBAL.gtid_cleanup_batch_size;
20 SET GLOBAL gtid_cleanup_batch_size= 2;
21 SET @old_dbug= @@GLOBAL.debug_dbug;
22 SET GLOBAL debug_dbug="+d,gtid_slave_pos_simulate_failed_delete";
23 SET sql_log_bin= 0;
24 CALL mtr.add_suppression("<DEBUG> Error deleting old GTID row");
25 SET sql_log_bin= 1;
26 include/start_slave.inc
27 connection master;
28 connection slave;
29 SELECT COUNT(*), MAX(seq_no) INTO @pre_count, @pre_max_seq_no
30 FROM mysql.gtid_slave_pos;
31 SELECT IF(@pre_count >= 20, "OK", CONCAT("Error: too few rows seen while errors injected: ", @pre_count));
32 IF(@pre_count >= 20, "OK", CONCAT("Error: too few rows seen while errors injected: ", @pre_count))
33 OK
34 SET GLOBAL debug_dbug= @old_dbug;
35 connection master;
36 connection slave;
37 connection slave;
38 SELECT IF(COUNT(*) >= 1, "OK", CONCAT("Error: too few rows seen after errors no longer injected: ", COUNT(*)))
39 FROM mysql.gtid_slave_pos
40 WHERE seq_no <= @pre_max_seq_no;
41 IF(COUNT(*) >= 1, "OK", CONCAT("Error: too few rows seen after errors no longer injected: ", COUNT(*)))
42 OK
43 connection master;
44 DROP TABLE t1;
45 connection slave;
46 SET GLOBAL gtid_cleanup_batch_size= @old_gtid_cleanup_batch_size;
47 include/rpl_end.inc