Debian Codegraph @

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

raw
1 include/group_replication.inc [rpl_server_count=2]
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 [connection server1]
7 SET @@SESSION.group_replication_consistency= BEFORE_ON_PRIMARY_FAILOVER;
8 include/start_and_bootstrap_group_replication.inc
9
10 # 1. Enable debug point that run an assert if command will be put on
11 # hold
12 [connection server1]
13 SET @debug_save= @@GLOBAL.DEBUG;
14 SET @@GLOBAL.DEBUG= '+d,launch_hook_trans_begin_assert_if_hold';
15
16 # 2. Validate SQL command SHOW will not block
17 SHOW GLOBAL VARIABLES LIKE 'group_replication_consistency';
18 Variable_name Value
19 group_replication_consistency EVENTUAL
20 SHOW PROCESSLIST;
21 SHOW STATUS;
22 SHOW ENGINE INNODB LOGS;
23 SHOW ENGINE INNODB STATUS;
24 SHOW ENGINE INNODB MUTEX;
25 SHOW MASTER STATUS;
26 SHOW REPLICA STATUS;
27 SHOW CHARACTER SET;
28 SHOW COLLATION;
29 SHOW BINARY LOGS;
30 SHOW OPEN TABLES;
31 SHOW REPLICAS;
32 SHOW BINLOG EVENTS;
33 SHOW WARNINGS;
34 SHOW ERRORS;
35 SHOW ENGINES;
36 SHOW PRIVILEGES;
37 SHOW PROCEDURE STATUS;
38 SHOW FUNCTION STATUS;
39 SHOW PLUGINS;
40 SHOW EVENTS;
41 SHOW PROFILE;
42 SHOW PROFILES;
43 SHOW RELAYLOG EVENTS;
44
45 # 3. Validate SQL command SET will not block
46 SET @@GLOBAL.group_replication_member_weight= DEFAULT;
47
48 # 4. Validate SQL command DO will not block
49 DO SLEEP(1);
50
51 # 5. Validate SQL command EMPTY will not block
52
53 # 6. Validate SQL command USE will not block
54 USE test;
55
56 # 7. Validate SQL command SELECT to performance_schema will not block
57 SELECT COUNT(*) from performance_schema.replication_group_members;
58 COUNT(*)
59 1
60
61 # 8. Validate SQL command SELECT to table PROCESSLIST from database
62 # infoschema will not block
63 SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE='debug sync point: now';
64 COUNT(*)=0
65 1
66 Warnings:
67 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
68
69 # 9. Validate SQL command SELECT from database syschema will not block
70 SELECT COUNT(*)=1 FROM sys.version;
71 COUNT(*)=1
72 1
73
74 # 10. Validate SQL command SELECT that don't use tables will not block
75 SELECT @@GLOBAL.GTID_EXECUTED;
76 @@GLOBAL.GTID_EXECUTED
77 GROUP_REPLICATION_GROUP_NAME:1
78
79 # 11. Validate SQL command RESET PERSIST will not block
80 RESET PERSIST;
81
82 # 12. Validate SQL command STOP GROUP_REPLICATION will not block
83 STOP GROUP_REPLICATION;
84
85 # 13. Reconnect server1 to group
86 [connection server1]
87 SET @@GLOBAL.DEBUG= '-d,launch_hook_trans_begin_assert_if_hold';
88 include/start_and_bootstrap_group_replication.inc
89
90 # 14. Validate SQL command SHUTDOWN will not block
91 SET @@GLOBAL.DEBUG= '+d,launch_hook_trans_begin_assert_if_hold';
92 SHUTDOWN;
93 include/rpl_reconnect.inc
94
95 # 15. Cleanup
96 SET @@GLOBAL.DEBUG= '-d,launch_hook_trans_begin_assert_if_hold';
97 SET GLOBAL group_replication_group_name= "GROUP_NAME";
98 SET GLOBAL group_replication_local_address= "GROUP_LOCAL_ADDRESS2";
99 SET GLOBAL group_replication_group_seeds= "GROUP_SEEDS_SERVER2";
100 SET GLOBAL group_replication_enforce_update_everywhere_checks= FALSE;;
101 SET GLOBAL group_replication_single_primary_mode= TRUE;;
102 SET @@SESSION.group_replication_consistency= DEFAULT;
103 include/group_replication_end.inc
104 Warnings:
105 Warning 3615 Variable group_replication_ip_allowlist does not exist in persisted config file