Debian Codegraph @

mysql-test/suite/galera/t/galera_gtid_server_id.test

raw
1 --source include/galera_cluster.inc
2
3 --connection node_1
4 select @@gtid_domain_id, @@server_id, @@wsrep_gtid_domain_id,@@wsrep_gtid_mode;
5 --connection node_2
6 call mtr.add_suppression("WSREP: Ignoring server id .* for non bootstrap node");
7 select @@gtid_domain_id, @@server_id, @@wsrep_gtid_domain_id,@@wsrep_gtid_mode;
8
9 --connection node_1
10 CREATE TABLE t1(id int not null primary key) engine=innodb;
11 INSERT INTO t1 values (1);
12 show global variables like '%gtid%';
13 --connection node_2
14 SET SESSION wsrep_sync_wait=15;
15 show global variables like '%gtid%';
16 # This should give error
17 --error ER_WRONG_VALUE_FOR_VAR
18 SET GLOBAL server_id=200;
19 SHOW WARNINGS;
20 # This should give error
21 --error ER_WRONG_VALUE_FOR_VAR
22 SET SESSION server_id=200;
23 SHOW WARNINGS;
24 INSERT INTO t1 values(2);
25 show global variables like '%gtid%';
26 --connection node_1
27 show global variables like '%gtid%';
28 DROP TABLE t1;