Debian Codegraph @

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

raw
1 SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME";
2 #
3 # Test if binlog_format with the wrong value will fail.
4 #
5 SET GLOBAL binlog_format= STATEMENT;
6 Warnings:
7 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
8 START GROUP_REPLICATION;
9 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
10 SET GLOBAL binlog_format= "ROW";
11 Warnings:
12 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
13 SET GLOBAL binlog_transaction_dependency_tracking= COMMIT_ORDER;
14 Warnings:
15 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
16 SET GLOBAL transaction_write_set_extraction=OFF;
17 Warnings:
18 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
19 START GROUP_REPLICATION;
20 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
21 SET GLOBAL transaction_write_set_extraction= WRITE_SET_EXTRACTION_ALGORITHM;
22 Warnings:
23 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
24 SET GLOBAL binlog_transaction_dependency_tracking= BINLOG_TRANSACTION_DEPENDENCY_TRACKING;
25 Warnings:
26 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
27 #
28 # Test if parallel applier is enabled and that start
29 # Group Replication will fail.
30 #
31 SET @replica_parallel_type_saved= @@GLOBAL.REPLICA_PARALLEL_TYPE;
32 Warnings:
33 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
34 SET @replica_parallel_workers_saved= @@GLOBAL.REPLICA_PARALLEL_WORKERS;
35 SET @replica_preserve_commit_order= @@GLOBAL.REPLICA_PRESERVE_COMMIT_ORDER;
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 GROUP_REPLICATION;
41 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
42 SET @@GLOBAL.REPLICA_PARALLEL_TYPE= "LOGICAL_CLOCK";
43 Warnings:
44 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
45 SET GLOBAL REPLICA_PARALLEL_WORKERS= 4;
46 SET @@GLOBAL.REPLICA_PRESERVE_COMMIT_ORDER= OFF;
47 START GROUP_REPLICATION;
48 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
49 SET @@GLOBAL.REPLICA_PARALLEL_TYPE= @replica_parallel_type_saved;
50 Warnings:
51 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
52 SET @@GLOBAL.REPLICA_PARALLEL_WORKERS= @replica_parallel_workers_saved;
53 SET @@GLOBAL.REPLICA_PRESERVE_COMMIT_ORDER= @replica_preserve_commit_order;
54 call mtr.add_suppression("Binlog format should be ROW for Group Replication");
55 call mtr.add_suppression("Extraction of transaction write sets requires*");
56 call mtr.add_suppression("In order to use parallel applier on Group Replication, parameter replica-parallel-type must be set to 'LOGICAL_CLOCK'");
57 call mtr.add_suppression("Group Replication requires replica-preserve-commit-order to be set to ON when using more than 1 applier threads.");