Debian Codegraph @

mysql-test/suite/group_replication/r/gr_gcs_psi_mutex_cond.result

raw
1 include/group_replication.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 server1]
6
7 ############################################################
8 # 1. Verify that no entries corresponding to the
9 # instrumented GCS mutexes and conds are in the
10 # setup_instruments table, as well as no corresponding
11 # instances are in the mutex_instances or cond_instances
12 # tables immediately after plugin installation (before
13 # starting the GR).
14 include/assert.inc ['There should be no GCS instrumented mutex entries in the mutex_instances table before starting the GR']
15 include/assert.inc ['There should be no GCS instrumented cond entries in the cond_instances table before starting the GR']
16
17 ############################################################
18 # 2. Start the GR
19 include/start_and_bootstrap_group_replication.inc
20
21 ############################################################
22 # 3. Verify that the entries corresponding to the
23 # instrumented GCS mutexes and conds are in the
24 # setup_instruments table, and that the corresponding
25 # instances are in the mutex_instances and
26 # cond_instances tables after starting the GR.
27 include/assert.inc ['There should be 21 GCS instrumented mutex and cond entries in the setup_instruments table after starting the GR']
28 SELECT * FROM performance_schema.setup_instruments WHERE (NAME LIKE "wait/synch/mutex/group_rpl/GCS_%" OR NAME LIKE "wait/synch/cond/group_rpl/GCS_%") ORDER BY NAME;
29 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
30 wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_cond YES YES singleton NULL 0 NULL
31 wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_wait_for_events_cond YES YES singleton NULL 0 NULL
32 wait/synch/cond/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_cond YES YES singleton NULL 0 NULL
33 wait/synch/cond/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_cond YES YES singleton NULL 0 NULL
34 wait/synch/cond/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_cond YES YES singleton NULL 0 NULL
35 wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_comms_status YES YES singleton NULL 0 NULL
36 wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_exit YES YES singleton NULL 0 NULL
37 wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_ready YES YES singleton NULL 0 NULL
38 wait/synch/cond/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_cond YES YES singleton NULL 0 NULL
39 wait/synch/mutex/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_mutex YES YES singleton NULL 0 NULL
40 wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_mutex YES YES singleton NULL 0 NULL
41 wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_parameters_mutex YES YES singleton NULL 0 NULL
42 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_mutex YES YES singleton NULL 0 NULL
43 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_group_management::m_nodes_mutex YES YES singleton NULL 0 NULL
44 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_mutex YES YES singleton NULL 0 NULL
45 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_comms_status YES YES singleton NULL 0 NULL
46 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_exit YES YES singleton NULL 0 NULL
47 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_ready YES YES singleton NULL 0 NULL
48 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_current_view_mutex YES YES singleton NULL 0 NULL
49 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_joining_leaving_mutex YES YES singleton NULL 0 NULL
50 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_mutex YES YES singleton NULL 0 NULL
51 include/assert.inc ['There should be 9 GCS instrumented cond entries in the cond_instances table after starting the GR']
52 SELECT NAME FROM performance_schema.cond_instances WHERE NAME LIKE "wait/synch/cond/group_rpl/GCS_%" ORDER BY NAME;
53 NAME
54 wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_cond
55 wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_wait_for_events_cond
56 wait/synch/cond/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_cond
57 wait/synch/cond/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_cond
58 wait/synch/cond/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_cond
59 wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_comms_status
60 wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_exit
61 wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_ready
62 wait/synch/cond/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_cond
63 include/assert.inc ['There should be 12 GCS instrumented mutex entries in the mutex_instances table after starting the GR']
64 SELECT NAME FROM performance_schema.mutex_instances WHERE NAME LIKE "wait/synch/mutex/group_rpl/GCS_%" ORDER BY NAME;
65 NAME
66 wait/synch/mutex/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_mutex
67 wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_mutex
68 wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_parameters_mutex
69 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_mutex
70 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_group_management::m_nodes_mutex
71 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_mutex
72 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_comms_status
73 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_exit
74 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_ready
75 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_current_view_mutex
76 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_joining_leaving_mutex
77 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_mutex
78
79 ############################################################
80 # 4. Stop the GR
81 include/stop_group_replication.inc
82
83 ############################################################
84 # 5. Verify that the entries corresponding to the
85 # instrumented GCS mutexes and conds remain in the
86 # setup_instruments table, and that no corresponding
87 # instances remain in the mutex_instances and
88 # cond_instances tables after stopping the GR.
89 include/assert.inc ['There should be the same 21 GCS instrumented mutex and cond entries in the setup_instruments table after stopping the GR']
90 SELECT * FROM performance_schema.setup_instruments WHERE (NAME LIKE "wait/synch/mutex/group_rpl/GCS_%" OR NAME LIKE "wait/synch/cond/group_rpl/GCS_%") ORDER BY NAME;
91 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
92 wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_cond YES YES singleton NULL 0 NULL
93 wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_wait_for_events_cond YES YES singleton NULL 0 NULL
94 wait/synch/cond/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_cond YES YES singleton NULL 0 NULL
95 wait/synch/cond/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_cond YES YES singleton NULL 0 NULL
96 wait/synch/cond/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_cond YES YES singleton NULL 0 NULL
97 wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_comms_status YES YES singleton NULL 0 NULL
98 wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_exit YES YES singleton NULL 0 NULL
99 wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_ready YES YES singleton NULL 0 NULL
100 wait/synch/cond/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_cond YES YES singleton NULL 0 NULL
101 wait/synch/mutex/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_mutex YES YES singleton NULL 0 NULL
102 wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_mutex YES YES singleton NULL 0 NULL
103 wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_parameters_mutex YES YES singleton NULL 0 NULL
104 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_mutex YES YES singleton NULL 0 NULL
105 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_group_management::m_nodes_mutex YES YES singleton NULL 0 NULL
106 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_mutex YES YES singleton NULL 0 NULL
107 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_comms_status YES YES singleton NULL 0 NULL
108 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_exit YES YES singleton NULL 0 NULL
109 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_ready YES YES singleton NULL 0 NULL
110 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_current_view_mutex YES YES singleton NULL 0 NULL
111 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_joining_leaving_mutex YES YES singleton NULL 0 NULL
112 wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_mutex YES YES singleton NULL 0 NULL
113 include/assert.inc ['There should be no GCS instrumented mutex entries in the mutex_instances table after stopping the GR']
114 include/assert.inc ['There should be no GCS instrumented cond entries in the cond_instances table after stopping the GR']
115
116 ############################################################
117 # 6. Test end.
118 include/group_replication_end.inc