Debian Codegraph @

mysql-test/suite/galera/r/galera_gtid_server_id.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 select @@gtid_domain_id, @@server_id, @@wsrep_gtid_domain_id,@@wsrep_gtid_mode;
5 @@gtid_domain_id @@server_id @@wsrep_gtid_domain_id @@wsrep_gtid_mode
6 0 11 1 1
7 connection node_2;
8 call mtr.add_suppression("WSREP: Ignoring server id .* for non bootstrap node");
9 select @@gtid_domain_id, @@server_id, @@wsrep_gtid_domain_id,@@wsrep_gtid_mode;
10 @@gtid_domain_id @@server_id @@wsrep_gtid_domain_id @@wsrep_gtid_mode
11 0 12 1 1
12 connection node_1;
13 CREATE TABLE t1(id int not null primary key) engine=innodb;
14 INSERT INTO t1 values (1);
15 show global variables like '%gtid%';
16 Variable_name Value
17 binlog_gtid_index ON
18 binlog_gtid_index_page_size 4096
19 binlog_gtid_index_span_min 65536
20 gtid_binlog_pos 1-11-2
21 gtid_binlog_state 1-11-2
22 gtid_cleanup_batch_size 64
23 gtid_current_pos 1-11-2
24 gtid_domain_id 0
25 gtid_ignore_duplicates OFF
26 gtid_pos_auto_engines
27 gtid_slave_pos
28 gtid_strict_mode OFF
29 wsrep_gtid_domain_id 1
30 wsrep_gtid_mode ON
31 connection node_2;
32 SET SESSION wsrep_sync_wait=15;
33 show global variables like '%gtid%';
34 Variable_name Value
35 binlog_gtid_index ON
36 binlog_gtid_index_page_size 4096
37 binlog_gtid_index_span_min 65536
38 gtid_binlog_pos 0-12-1,1-11-2
39 gtid_binlog_state 0-12-1,1-11-2
40 gtid_cleanup_batch_size 64
41 gtid_current_pos 0-12-1
42 gtid_domain_id 0
43 gtid_ignore_duplicates OFF
44 gtid_pos_auto_engines
45 gtid_slave_pos
46 gtid_strict_mode OFF
47 wsrep_gtid_domain_id 1
48 wsrep_gtid_mode ON
49 SET GLOBAL server_id=200;
50 ERROR 42000: Variable 'server_id' can't be set to the value of '200'
51 SHOW WARNINGS;
52 Level Code Message
53 Warning 1231 Can't change server_id because wsrep and wsrep_gtid_mode is set. You can set server_id only with wsrep_new_cluster.
54 Error 1231 Variable 'server_id' can't be set to the value of '200'
55 SET SESSION server_id=200;
56 ERROR 42000: Variable 'server_id' can't be set to the value of '200'
57 SHOW WARNINGS;
58 Level Code Message
59 Warning 1231 Can't change server_id because wsrep and wsrep_gtid_mode is set. You can set server_id only with wsrep_new_cluster.
60 Error 1231 Variable 'server_id' can't be set to the value of '200'
61 INSERT INTO t1 values(2);
62 show global variables like '%gtid%';
63 Variable_name Value
64 binlog_gtid_index ON
65 binlog_gtid_index_page_size 4096
66 binlog_gtid_index_span_min 65536
67 gtid_binlog_pos 0-12-1,1-11-3
68 gtid_binlog_state 0-12-1,1-11-3
69 gtid_cleanup_batch_size 64
70 gtid_current_pos 0-12-1
71 gtid_domain_id 0
72 gtid_ignore_duplicates OFF
73 gtid_pos_auto_engines
74 gtid_slave_pos
75 gtid_strict_mode OFF
76 wsrep_gtid_domain_id 1
77 wsrep_gtid_mode ON
78 connection node_1;
79 show global variables like '%gtid%';
80 Variable_name Value
81 binlog_gtid_index ON
82 binlog_gtid_index_page_size 4096
83 binlog_gtid_index_span_min 65536
84 gtid_binlog_pos 1-11-3
85 gtid_binlog_state 1-11-3
86 gtid_cleanup_batch_size 64
87 gtid_current_pos 1-11-3
88 gtid_domain_id 0
89 gtid_ignore_duplicates OFF
90 gtid_pos_auto_engines
91 gtid_slave_pos
92 gtid_strict_mode OFF
93 wsrep_gtid_domain_id 1
94 wsrep_gtid_mode ON
95 DROP TABLE t1;