Debian Codegraph @

mysql-test/suite/group_replication/r/gr_gtid_assignment_blocks_near_gno_exhaustion.result

raw
1 include/group_replication.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 server1]
6 [connection server1]
7 SET SESSION sql_log_bin = 0;
8 call mtr.add_suppression("The integer component of the GTID number is high.");
9 SET SESSION sql_log_bin = 1;
10 [connection server2]
11 SET SESSION sql_log_bin = 0;
12 call mtr.add_suppression("The integer component of the GTID number is high.");
13 SET SESSION sql_log_bin = 1;
14
15 ############################################################
16 # 1. Start server 1.
17 [connection server1]
18 SET GLOBAL GTID_PURGED= "297aeabb-1ef1-11e6-97b4-00212844d44e:1-9223372036854775800";
19 include/assert.inc [GTID_EXECUTED must be UUID:1-9223372036854775800]
20 include/start_and_bootstrap_group_replication.inc
21 include/assert.inc [GTID_EXECUTED must be UUID:1-9223372036854775801]
22
23 ############################################################
24 # 2. Start server 2.
25 [connection server2]
26 SET GLOBAL GTID_PURGED= "297aeabb-1ef1-11e6-97b4-00212844d44e:1-9223372036854775800";
27 include/assert.inc [GTID_EXECUTED must be UUID:1-9223372036854775800]
28 include/start_group_replication.inc
29 include/assert.inc [GTID_EXECUTED must be UUID:1-9223372036854775802]
30
31 ############################################################
32 # 3. Create a table on server 1.
33 [connection server1]
34 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
35 include/assert.inc [GTID_EXECUTED must be UUID:1-9223372036854775803]
36 include/rpl_sync.inc
37
38 ############################################################
39 # 4. Execute a transaction on server 2.
40 # Server 2 GTID block will adapt to available GNOs.
41 [connection server2]
42 INSERT INTO t1 VALUES (1);
43 include/assert.inc [GTID_EXECUTED must be UUID:1-9223372036854775804]
44
45 ############################################################
46 # 5. Clean up.
47 DROP TABLE t1;
48 include/group_replication_end.inc