Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_ps_worker_retry_skipped_trx.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 [connection slave]
7 CALL mtr.add_suppression(".* Could not execute Write_rows event on table test.*");
8 SET @saved_innodb_lock_wait_timeout = @@GLOBAL.innodb_lock_wait_timeout;
9 SET @saved_replica_transaction_retries = @@GLOBAL.replica_transaction_retries;
10 SET @@GLOBAL.replica_transaction_retries = 10;
11 SET @@GLOBAL.innodb_lock_wait_timeout = 2;
12 [connection master]
13 CREATE TABLE t1 (a INT UNIQUE);
14 include/sync_slave_sql_with_master.inc
15 BEGIN;
16 INSERT INTO t1 VALUES (1);
17 [connection master]
18 SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
19 INSERT INTO t1 VALUES (1);
20 SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
21 [connection slave]
22 include/wait_for_slave_sql_to_stop.inc
23 include/assert.inc [The master transaction should not be in the slave GTID_EXECUTED set]
24 COMMIT;
25 SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
26 COMMIT;
27 SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
28 include/start_slave_sql.inc
29 [connection master]
30 include/sync_slave_sql_with_master.inc
31 include/assert.inc [The master transaction should be in the slave GTID_EXECUTED set]
32 include/assert.inc [The GTID information about the last applied transaction was not changed]
33 include/assert.inc [The OCT information about the last applied transaction was not changed]
34 include/assert.inc [The ICT information about the last applied transaction was not changed]
35 include/assert.inc [The start apply timestamp information about the last applied transaction was not changed]
36 include/assert.inc [The end apply timestamp information about the last applied transaction was not changed]
37 include/assert.inc [The retries count information about the last applied transaction was not changed]
38 include/assert.inc [The last transient error number information about the last applied transaction was not changed]
39 include/assert.inc [The last transient error message information about the last applied transaction was not changed]
40 include/assert.inc [The last transient error timestamp information about the last applied transaction was not changed]
41 SET @@GLOBAL.innodb_lock_wait_timeout = @saved_innodb_lock_wait_timeout;
42 SET @@GLOBAL.replica_transaction_retries = @saved_replica_transaction_retries;
43 [connection master]
44 DROP TABLE t1;
45 include/sync_slave_sql_with_master.inc
46 include/rpl_end.inc