Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2,1->3]
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 Warnings:
6 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
7 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.
8 CALL mtr.add_suppression(".*Got an error reading communication packets.*");
9 #
10 # Semisync master's status should be OFF if
11 # rpl_semi_sync_source_wait_no_replica is set to 0 at starting server.
12 #
13 include/assert.inc [Semisync master is off]
14 CREATE TABLE t1(c1 INT);
15 include/assert.inc [rpl_semi_sync_source_tx_waits should be 0]
16 #
17 # Semisync's status should still be OFF, because there is only one slave
18 #
19 [connection server_2]
20 include/install_semisync_replica.inc
21 [connection server_1]
22 include/assert.inc [ should be 2]
23 INSERT INTO t1 VALUES(1);
24 include/assert.inc [Semisync master is off]
25 #
26 # Verify 'SET GLOBAL rpl_semi_sync_source_enabled= ON' sets semisync
27 # master's status correctly when there are enough semisync slaves.
28 #
29 [connection server_3]
30 include/install_semisync_replica.inc
31 [connection server_1]
32 SET GLOBAL rpl_semi_sync_source_enabled= OFF;
33 include/assert.inc [Semisync master is off]
34 SET GLOBAL rpl_semi_sync_source_enabled= ON;
35 include/assert.inc [Semisync master is on]
36 DROP TABLE t1;
37 #
38 # Verify ack_receiver thread is created
39 #
40 include/assert.inc [ack receiver thread is created;]
41 CREATE TABLE t1(c1 INT);
42 include/rpl_sync.inc
43 #
44 # Verify semisync replication works well
45 #
46 [connection server_1]
47 include/assert.inc [Semisync master is on]
48 DROP TABLE t1;
49 include/rpl_sync.inc
50 [connection server_2]
51 include/uninstall_semisync_replica.inc
52 [connection server_3]
53 include/uninstall_semisync_replica.inc
54 include/rpl_end.inc