Debian Codegraph @

mysql-test/suite/rpl/r/rpl_perfschema_connect_status.result

raw
1 include/master-slave.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 master]
6 include/assert.inc [On master, the table should return an empty set.]
7 include/assert.inc [On slave, the group_name should be set NULL]
8
9 # Verify that SELECT works for every field and produces an output similar
10 # to the corresponding field in SHOW SLAVE STATUS(SSS). To verify the
11 # correctness of thread_id field, we check for the name of the thread.
12
13 include/assert.inc [Value returned by SSS and PS table for Source_UUID should be same.]
14 include/assert.inc [thread_name should should indicate io thread.]
15 include/assert.inc [SSS shows Slave_IO_Running as "Yes". So, Service_State from this PS table should be "ON".]
16 include/assert.inc [PS table should output 0000-00-00 00:00:00.000000 indicating no heartbeats have been received]
17 include/assert.inc [Value returned by SSS and PS table for Received_Transaction_Set should be same.]
18 include/assert.inc [Value returned by SSS and PS table for Last_Error_Number should be same.]
19 include/assert.inc [Value returned by SSS and PS table for Last_Error_Message should be same.]
20 include/assert.inc [Value returned by PS table for Last_Error_Timestamp should be 0000-00-00 00:00:00.000000.]
21 include/stop_slave.inc
22
23 # heartbeat count and last heartbeat timestamp are indeterministic so we
24 # can not test for their exact values. We will thus check for >0 number
25 # of heartbeats and last heartbeat timestamp!= zeros.
26
27 CHANGE REPLICATION SOURCE to SOURCE_HEARTBEAT_PERIOD= 0.5;
28 set @restore_replica_net_timeout= @@global.replica_net_timeout;
29 set @@global.replica_net_timeout= 10;
30 include/start_slave.inc
31
32 A heartbeat has been received by the slave
33
34 include/assert.inc [last_heartbeat_timestamp should NOT be zero]
35 set @@global.replica_net_timeout= @restore_replica_net_timeout;
36
37 # We now introduce an error in the IO thread and check for the correctness
38 # of error number, message and timestamp fields.
39
40 include/stop_slave.inc
41 CHANGE REPLICATION SOURCE to
42 SOURCE_USER='replssl',
43 SOURCE_PASSWORD='';
44 Warnings:
45 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
46 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.
47 start slave io_thread;
48 Warnings:
49 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
50 include/wait_for_slave_param.inc [Last_IO_Errno]
51
52 # Extract the error related fields from SSS and PS table and compare
53 # them for correctness.
54
55 include/assert.inc [Value returned by SSS and PS table for Last_Error_Number should be same.]
56 Value returned by SSS and PS table for Last_Error_Message is same.
57 include/assert.inc [Value returned by SSS and PS table for Last_Error_Timestamp should be same.]
58
59 # Verify that source_UUID and the error related fields are preserved
60 # after STOP SLAVE, thread_id changes to NULL and service_state to "off".
61
62 include/stop_slave.inc
63
64 # 1. Verify that thread_id changes to NULL and service_state to "off" on
65 # STOP SLAVE.
66
67 include/assert.inc [After STOP SLAVE, thread_id should be NULL]
68 include/assert.inc [SSS shows Slave_IO_Running as "No". So, Service_State from this PS table should be "OFF".]
69
70 # 2. Extract the source_UUID and the error related fields from SSS and PS
71 # table and compare them. These fields should preserve their values.
72
73 include/assert.inc [Value returned by SSS and PS table for Source_UUID should be same.]
74 include/assert.inc [Value returned by SSS and PS table for Last_Error_Number should be same.]
75 Value returned by SSS and PS table for Last_Error_Message is same.
76 include/assert.inc [Value returned by SSS and PS table for Last_Error_Timestamp should be same.]
77
78 # Restart the master and slave servers in gtid-mode=on, execute some
79 # transactions and verify the 'Received_Transaction_Set' field.
80
81 include/rpl_restart_server.inc [server_number=1 gtids=on]
82 include/rpl_restart_server.inc [server_number=2 gtids=on]
83 CHANGE REPLICATION SOURCE to
84 SOURCE_USER = 'root',
85 SOURCE_AUTO_POSITION= 1;
86 Warnings:
87 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
88 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.
89 include/start_slave.inc
90 use test;
91 create table t(a int);
92 insert into t values(1);
93 include/sync_slave_sql_with_master.inc
94 include/assert.inc [Value returned by SSS and PS table for Received_Transaction_Set should be same.]
95
96 # Verify that the value for 'Received_Transaction_Set' field is preserved
97 # after STOP SLAVE.
98
99 include/stop_slave.inc
100 include/assert.inc [Received_Transaction_Set should not have changed after STOP SLAVE]
101
102 # Verify that the value for 'Received_Transaction_Set' is cleared
103 # after RESET SLAVE.
104
105 RESET SLAVE;
106 Warnings:
107 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
108 include/assert.inc [Received_Transaction_Set should be empty after RESET SLAVE]
109 include/start_slave.inc
110 drop table t;
111 include/sync_slave_sql_with_master.inc
112 include/stop_slave.inc
113 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0 FOR CHANNEL '';
114 include/rpl_set_gtid_mode.inc
115 include/rpl_end.inc