Debian Codegraph @

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

raw
1 #
2 # Set up masters server_1 and server_3 with server_2 being a slave.
3 #
4 include/rpl_init.inc [topology=1->2,3->2]
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 Warnings:
9 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
10 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.
11 #
12 # Test case 1: Create multiple sources and make sure that
13 # number of sources= number of rows in all the performance schema tables.
14 # On master, where replication is not setup, it shall show 0 rows.
15 [connection server_1]
16 include/assert.inc [Number of rows = 0 on master for repliation_connection_configuration table.]
17 include/assert.inc [Number of rows = 0 on master for repliation_connection_status table.]
18 include/assert.inc [Number of rows = 0 on master for repliation_applier_configuration table.]
19 include/assert.inc [Number of rows = 0 on master for repliation_applier_status table.]
20 include/assert.inc [Number of rows = 0 on master for replication_applier_status_by coordinator table.]
21 include/assert.inc [Number of rows = 0 on master for replication_applier_status_by_worker table.]
22 #
23 # Test case 2: On the slave, number of rows should be zero for a non existent channel
24 #
25 [connection server_2]
26 include/assert.inc [Number of rows= 0 on slave for a non existent channel for repliation_connection_configuration table.]
27 include/assert.inc [Number of rows= 0 on slave for a non existent channel for repliation_connection_status table.]
28 include/assert.inc [Number of rows= 0 on slave for a non existent channel for repliation_applier_configuration table.]
29 include/assert.inc [Number of rows= 0 on slave for a non existent channel for repliation_applier_status table.]
30 include/assert.inc [Number of rows= 0 on slave for a non existent channel for repliation_applier_status_by_coordinaotor table.]
31 include/assert.inc [Number of rows= 0 on slave for a non existent channel for replication_applier_status_by_worker table.]
32 #
33 # Test case 3: Rows on multi sourced slave, shall be 2. In workers table it should be
34 # 2*@@global.replica_parallel_workers
35 USE performance_schema;
36 include/assert.inc [there shall be 2 rows for replication_connection_configuration]
37 include/assert.inc [there shall be 2 rows for replication_connection_status]
38 include/assert.inc [there shall be 2 rows for replication_applier_configuration]
39 include/assert.inc [there shall be 2 rows for replication_applier_status]
40 include/assert.inc [there shall be 2 rows for replication_connection_configuration]
41 include/assert.inc [there shall be 2*global.replica_parallel_workers rows for 2 configured channels.]
42 #
43 # Test case 4: Verify that selects work on named channels
44 # Do this verification by comparing with some known data
45 #
46 include/assert.inc [pfs query shall return the correct query value of the channel_3 port.]
47 include/assert.inc [service state of receiver thread shall be ON.]
48 include/assert.inc [Value returned by SSS and PS table for Desired_Delay should be same.]
49 include/assert.inc [service state shall be ON]
50 include/assert.inc [service state of coordinator shall be ON]
51 #
52 # Stop the slave on channel_1 and verify that rows are still instact
53 #
54 include/stop_slave.inc [FOR CHANNEL 'channel_1']
55 #
56 # Test case 5: Verify that selects work on named channels even
57 # after a channel is stopped. test that service state is OFF
58 #
59 include/assert.inc [After stop slave for channel, replication_connection_configuration is intact]
60 include/assert.inc [After stop slave for channel, service state is OFF for connection_status table.]
61 include/assert.inc [After stop slave for channel, service state is OFF for applier_status table.]
62 include/assert.inc [After stop slave for channel, service state is OFF by replication_applier_status_by_worker table.]
63 #
64 # Test case 6): Do a sanity check that joins can be performed as replication tables
65 # contain multiple rows now.
66 CHANNEL_NAME channel_1
67 GROUP_NAME
68 SOURCE_UUID #
69 THREAD_ID #
70 SERVICE_STATE OFF
71 COUNT_RECEIVED_HEARTBEATS #
72 LAST_HEARTBEAT_TIMESTAMP #
73 RECEIVED_TRANSACTION_SET
74 LAST_ERROR_NUMBER 0
75 LAST_ERROR_MESSAGE
76 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
77 CHANNEL_NAME channel_1
78 THREAD_ID #
79 SERVICE_STATE OFF
80 LAST_ERROR_NUMBER 0
81 LAST_ERROR_MESSAGE
82 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
83 CHANNEL_NAME channel_3
84 GROUP_NAME
85 SOURCE_UUID #
86 THREAD_ID #
87 SERVICE_STATE ON
88 COUNT_RECEIVED_HEARTBEATS #
89 LAST_HEARTBEAT_TIMESTAMP #
90 RECEIVED_TRANSACTION_SET
91 LAST_ERROR_NUMBER 0
92 LAST_ERROR_MESSAGE
93 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
94 CHANNEL_NAME channel_3
95 THREAD_ID #
96 SERVICE_STATE ON
97 LAST_ERROR_NUMBER 0
98 LAST_ERROR_MESSAGE
99 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
100 #
101 # Test case 7: Delete channel_3 and count the number of rows in each table.
102 #
103 include/stop_slave.inc [FOR CHANNEL 'channel_3']
104 RESET SLAVE ALL FOR CHANNEL 'channel_3';
105 Warnings:
106 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
107 include/assert.inc [there shall be 1 in replication connection_configuration table after a channel is deleted.]
108 include/assert.inc [there shall be 1 in replication connection_status table after a channel is deleted.]
109 include/assert.inc [there shall be 1 in replication applier_config table after a channel is deleted.]
110 include/assert.inc [there shall be 1 in replication applier_status table after a channel is deleted.]
111 include/assert.inc [there shall be 1 applier after a channel is deleted.]
112 include/assert.inc [there shall be global.replica_parallel_workers rows after a channel is deleted.]
113 #
114 # Test case 8: Do a complete delete and see if the number of rows are zero
115 #
116 RESET SLAVE ALL;
117 Warnings:
118 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
119 include/assert.inc [there shall be 0 rows after all channels are deleted.]
120 include/assert.inc [there shall be 0 rows after all channels are deleted.]
121 include/assert.inc [there shall be 0 rows after all channels are deleted.]
122 include/assert.inc [there shall be 0 rows after all channels are deleted.]
123 include/assert.inc [there shall be 0 rows after all channels are deleted.]
124 include/assert.inc [there shall be 0 rows after all channels are deleted.]
125 include/rpl_end.inc