Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 SET GLOBAL BINLOG_CHECKSUM=NONE;
5 connection slave;
6 SET GLOBAL BINLOG_CHECKSUM=NONE;
7 *** Test MDEV-6120, output of current GTID when a replication error is logged to the errorlog ***
8 connection master;
9 CREATE TABLE t1(a INT PRIMARY KEY);
10 connection slave;
11 connection slave;
12 include/stop_slave.inc
13 CHANGE MASTER TO master_use_gtid=slave_pos;
14 connection master;
15 INSERT INTO t1 VALUES (1);
16 SET gtid_seq_no=100;
17 INSERT INTO t1 VALUES (2);
18 INSERT INTO t1 VALUES (3);
19 INSERT INTO t1 VALUES (4);
20 connection slave;
21 SET sql_log_bin=0;
22 INSERT INTO t1 VALUES (2);
23 SET sql_log_bin=1;
24 START SLAVE;
25 include/wait_for_slave_sql_error.inc [errno=1062]
26 include/wait_for_slave_io_to_start.inc
27 include/stop_slave_io.inc
28 SET GLOBAL gtid_slave_pos= "0-1-100";
29 include/start_slave.inc
30 SELECT * FROM t1 ORDER BY a;
31 a
32 1
33 2
34 3
35 4
36 connection master;
37 SET @dbug_save= @@debug_dbug;
38 SET debug_dbug= '+d,incident_database_resync_on_replace';
39 REPLACE INTO t1 VALUES (5);
40 SET debug_dbug= @dbug_save;
41 connection slave;
42 include/wait_for_slave_sql_error.inc [errno=1590]
43 include/stop_slave_io.inc
44 SET sql_slave_skip_counter=1;
45 include/start_slave.inc
46 SELECT * FROM t1 ORDER BY a;
47 a
48 1
49 2
50 3
51 4
52 5
53 FOUND 1 /Slave SQL: Error 'Duplicate entry .* on query\. .*Query: '.*', Gtid 0-1-100, Internal MariaDB error code:|Slave SQL: Could not execute Write_rows.*table test.t1; Duplicate entry.*, Gtid 0-1-100, Internal MariaDB error/ in mysqld.2.err
54 FOUND 1 /Slave SQL: The incident LOST_EVENTS occurred on the master\. Message: <none>, Internal MariaDB error code: 1590/ in mysqld.2.err
55 connection master;
56 DROP TABLE t1;
57 connection master;
58 SET GLOBAL BINLOG_CHECKSUM=default;
59 connection slave;
60 SET GLOBAL BINLOG_CHECKSUM=default;
61 connection master;
62 include/rpl_end.inc