Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_circular_for_4_hosts.result

raw
1 *** Set up circular replication on four servers ***
2 include/rpl_init.inc [topology=1->2->3->4->1]
3 Warnings:
4 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
5 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.
6 Warnings:
7 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
8 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.
9 Warnings:
10 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
11 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.
12 Warnings:
13 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
14 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.
15
16 [connection server_4]
17 SET auto_increment_increment= 4;
18 SET auto_increment_offset= 4;
19 [connection server_3]
20 SET auto_increment_increment= 4;
21 SET auto_increment_offset= 3;
22 [connection server_2]
23 SET auto_increment_increment= 4;
24 SET auto_increment_offset= 2;
25 [connection server_1]
26 SET auto_increment_increment= 4;
27 SET auto_increment_offset= 1;
28 *** Preparing data ***
29 CREATE TABLE t2 (a INT NOT NULL AUTO_INCREMENT, b VARCHAR(100), c INT NOT NULL, PRIMARY KEY(a)) ENGINE=InnoDB;
30 include/rpl_sync.inc
31 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
32 call mtr.add_suppression("Replica SQL: Coordinator thread of multi-threaded replica is exiting seeing a failed Worker to apply an event");
33 call mtr.add_suppression("Replica worker thread has failed to apply an event");
34 call mtr.add_suppression("Replica SQL.*Duplicate entry .6. for key t1.PRIMARY.* Error_code: MY-001062");
35
36 * Transactions with commits *
37 BEGIN;
38 BEGIN;
39 include/rpl_sync.inc
40 SELECT 'Master A',b,COUNT(*) FROM t2 WHERE c = 1 GROUP BY b ORDER BY b;
41 Master A b COUNT(*)
42 Master A A 100
43 Master A B 100
44 Master A C 100
45 Master A D 100
46 SELECT 'Master B',b,COUNT(*) FROM t2 WHERE c = 1 GROUP BY b ORDER BY b;
47 Master B b COUNT(*)
48 Master B A 100
49 Master B B 100
50 Master B C 100
51 Master B D 100
52 SELECT 'Master C',b,COUNT(*) FROM t2 WHERE c = 1 GROUP BY b ORDER BY b;
53 Master C b COUNT(*)
54 Master C A 100
55 Master C B 100
56 Master C C 100
57 Master C D 100
58 SELECT 'Master D',b,COUNT(*) FROM t2 WHERE c = 1 GROUP BY b ORDER BY b;
59 Master D b COUNT(*)
60 Master D A 100
61 Master D B 100
62 Master D C 100
63 Master D D 100
64
65 * Transactions with rollbacks *
66 BEGIN;
67 BEGIN;
68 include/rpl_sync.inc
69 SELECT 'Master A',b,COUNT(*) FROM t2 WHERE c = 2 GROUP BY b ORDER BY b;
70 Master A b COUNT(*)
71 Master A B 100
72 Master A D 100
73 SELECT 'Master B',b,COUNT(*) FROM t2 WHERE c = 2 GROUP BY b ORDER BY b;
74 Master B b COUNT(*)
75 Master B B 100
76 Master B D 100
77 SELECT 'Master C',b,COUNT(*) FROM t2 WHERE c = 2 GROUP BY b ORDER BY b;
78 Master C b COUNT(*)
79 Master C B 100
80 Master C D 100
81 SELECT 'Master D',b,COUNT(*) FROM t2 WHERE c = 2 GROUP BY b ORDER BY b;
82 Master D b COUNT(*)
83 Master D B 100
84 Master D D 100
85
86 *** Clean up ***
87 DROP TABLE t2;
88 include/rpl_end.inc