Debian Codegraph @

mysql-test/suite/group_replication/r/gr_start_stop_parallel_applier_database.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 include/assert.inc [Default slave parallel type must be LOGICAL_CLOCK]
7 include/assert.inc [Default slave parallel workers must be 4]
8 include/assert.inc [Default slave preserve commit order 1]
9 include/start_and_bootstrap_group_replication.inc
10 include/stop_group_replication.inc
11 SET @replica_parallel_type_saved= @@GLOBAL.REPLICA_PARALLEL_TYPE;
12 Warnings:
13 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
14 SET @replica_parallel_workers_saved= @@GLOBAL.REPLICA_PARALLEL_WORKERS;
15 SET @slave_preserver_commit_order_saved= @@GLOBAL.REPLICA_PRESERVE_COMMIT_ORDER;
16 SET GLOBAL REPLICA_PRESERVE_COMMIT_ORDER= OFF;
17
18 ############################################################
19 # 1. Test with REPLICA_PARALLEL_TYPE default value and
20 # parallel workers number set to 4.
21 STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
22 Warnings:
23 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
24 Note 3084 Replication thread(s) for channel 'group_replication_applier' are already stopped.
25 SET GLOBAL REPLICA_PARALLEL_WORKERS=4;
26 START SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
27 ERROR HY000: START REPLICA SQL_THREAD when REPLICA_PARALLEL_WORKERS > 0 and REPLICA_PARALLEL_TYPE != LOGICAL_CLOCK or REPLICA_PRESERVE_COMMIT_ORDER != ON cannot be performed on channel 'group_replication_applier'.
28
29 ############################################################
30 # 2. Test with REPLICA_PARALLEL_TYPE set to DATABASE and
31 # parallel workers number set to 4.
32 STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
33 Warnings:
34 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
35 Note 3084 Replication thread(s) for channel 'group_replication_applier' are already stopped.
36 SET @@GLOBAL.REPLICA_PARALLEL_TYPE= "DATABASE";
37 Warnings:
38 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
39 SET GLOBAL REPLICA_PARALLEL_WORKERS= 4;
40 START SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
41 ERROR HY000: START REPLICA SQL_THREAD when REPLICA_PARALLEL_WORKERS > 0 and REPLICA_PARALLEL_TYPE != LOGICAL_CLOCK or REPLICA_PRESERVE_COMMIT_ORDER != ON cannot be performed on channel 'group_replication_applier'.
42
43 ############################################################
44 # 3. Test with REPLICA_PARALLEL_TYPE set to LOGICAL_CLOCK and
45 # parallel workers number set to 4.
46 STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
47 Warnings:
48 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
49 Note 3084 Replication thread(s) for channel 'group_replication_applier' are already stopped.
50 SET @@GLOBAL.REPLICA_PARALLEL_TYPE= "LOGICAL_CLOCK";
51 Warnings:
52 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
53 SET GLOBAL REPLICA_PARALLEL_WORKERS= 4;
54 START SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
55 ERROR HY000: START REPLICA SQL_THREAD when REPLICA_PARALLEL_WORKERS > 0 and REPLICA_PARALLEL_TYPE != LOGICAL_CLOCK or REPLICA_PRESERVE_COMMIT_ORDER != ON cannot be performed on channel 'group_replication_applier'.
56
57 ############################################################
58 # 4. Test with REPLICA_PARALLEL_TYPE set to LOGICAL_CLOCK,
59 # parallel workers number set to 4 and
60 # REPLICA_PRESERVE_COMMIT_ORDER set to ON.
61 STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
62 Warnings:
63 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
64 Note 3084 Replication thread(s) for channel 'group_replication_applier' are already stopped.
65 SET @@GLOBAL.REPLICA_PARALLEL_TYPE= "LOGICAL_CLOCK";
66 Warnings:
67 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
68 SET GLOBAL REPLICA_PARALLEL_WORKERS= 4;
69 SET GLOBAL REPLICA_PRESERVE_COMMIT_ORDER= ON;
70 START SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
71 Warnings:
72 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
73
74 ############################################################
75 # 5. Test with REPLICA_PARALLEL_TYPE set to LOGICAL_CLOCK and
76 # parallel workers number set to 0.
77 STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
78 Warnings:
79 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
80 SET @@GLOBAL.REPLICA_PARALLEL_TYPE= "LOGICAL_CLOCK";
81 Warnings:
82 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
83 SET GLOBAL REPLICA_PARALLEL_WORKERS= 0;
84 Warnings:
85 Warning 1287 '0' is deprecated and will be removed in a future release. Please use 1 instead
86 START SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
87 Warnings:
88 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
89
90 ############################################################
91 # 6. Test with REPLICA_PARALLEL_TYPE default value and default
92 # parallel workers number.
93 STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
94 Warnings:
95 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
96 SET @@GLOBAL.REPLICA_PARALLEL_TYPE= @replica_parallel_type_saved;
97 Warnings:
98 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
99 SET @@GLOBAL.REPLICA_PARALLEL_WORKERS= @replica_parallel_workers_saved;
100 SET @@GLOBAL.REPLICA_PRESERVE_COMMIT_ORDER= @slave_preserver_commit_order_saved;
101 START SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
102 Warnings:
103 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
104 include/gr_stop_applier_sql_thread.inc
105 STOP REPLICA SQL_THREAD FOR CHANNEL "group_replication_applier";
106 include/group_replication_end.inc