Debian Codegraph @

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

raw
1
2 ############################################################
3 # 01. Setup source-replica
4 include/uninstall_group_replication_plugin.inc
5 include/master-slave.inc
6 Warnings:
7 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
8 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.
9 [connection master]
10
11 ############################################################
12 # 02. Setup replica as replica-cluster primary
13 [connection slave]
14 # restart:--group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_bootstrap_group=1 --group_replication_start_on_boot=1 --group_replication_single_primary_mode=1 --group_replication_enforce_update_everywhere_checks=0 --skip_slave_start=0
15 include/rpl_reconnect.inc
16 [connection slave]
17 include/gr_wait_for_member_state.inc
18
19 ############################################################
20 # 03. Initial setup on the source
21 [connection master]
22 CREATE TABLE t1(c1 INT PRIMARY KEY, c2 INT, INDEX(c2)) ENGINE = InnoDB;
23 INSERT INTO t1 VALUES
24 (1, NULL),
25 (2, 2),
26 (3, NULL),
27 (4, 4),
28 (5, NULL),
29 (6, 6);
30 CREATE TABLE t2(a INT PRIMARY KEY);
31 include/sync_slave_sql_with_master.inc
32 [connection slave]
33 include/stop_slave_sql.inc
34 set session sql_log_bin=0;
35 CALL mtr.add_suppression(".*Worker.*failed executing transaction.*at source log .*, end_log_pos.*Deadlock found when trying to get lock.*");
36 CALL mtr.add_suppression(".*Worker.*failed executing transaction.*at source log .*, end_log_pos.*Can not lock user management caches for processing.*");
37 CALL mtr.add_suppression(".*Worker.*failed executing transaction.*at source log .*, end_log_pos.*Replica worker has stopped after at least one previous worker.*");
38 CALL mtr.add_suppression(".*worker thread retried transaction.*time.*in vain, giving up.*");
39 CALL mtr.add_suppression(".*The replica coordinator and worker threads are stopped.*");
40 CALL mtr.add_suppression(".*Replica worker has stopped after at least one previous worker encountered an error when replica-preserve-commit-order was enabled.*");
41 set session sql_log_bin=1;
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 = 3;
46 SET GLOBAL replica_preserve_commit_order = ON;
47 SET GLOBAL replica_transaction_retries = REPLICA_TRANSACTION_RETRIES;
48 SET GLOBAL innodb_lock_wait_timeout = INNODB_LOCK_WAIT_TIMEOUT;
49 include/rpl_connect.inc [creating rpl_slave_connection_2]
50 include/rpl_connect.inc [creating rpl_slave_connection_3]
51
52 ############################################################
53 # 04. Generate commit_order_deadlock on replica-cluster
54 # primary so that transaction will be retried
55 [connection master]
56 INSERT INTO t1 VALUES(13, 13);
57 [connection slave]
58 [connection master]
59 # Adding debug point 'set_commit_parent_100' to @@GLOBAL.debug
60 SET GTID_NEXT = "aaaaaaaa-1111-bbbb-2222-cccccccccccc:1";
61 INSERT INTO t1 VALUES(14, NULL);
62 SET GTID_NEXT = AUTOMATIC;
63 SET GTID_NEXT = "aaaaaaaa-1111-bbbb-2222-cccccccccccc:2";
64 INSERT INTO t1 VALUES(15, NULL);
65 SET GTID_NEXT = AUTOMATIC;
66 # Removing debug point 'set_commit_parent_100' from @@GLOBAL.debug
67 [connection slave]
68 SET GTID_NEXT = "aaaaaaaa-1111-bbbb-2222-cccccccccccc:1";
69 BEGIN;
70 [connection rpl_slave_connection_2]
71 SET GTID_NEXT = "aaaaaaaa-1111-bbbb-2222-cccccccccccc:2";
72 BEGIN;
73 [connection slave1]
74 include/start_slave_sql.inc
75 include/assert.inc [Replica parallel type is LOGICAL_CLOCK]
76 include/assert.inc [MTS worker thread count is correct]
77 include/assert.inc [Replica preserve commit order is 1]
78 include/assert.inc [Replica transaction retries has correct configured value]
79 include/assert.inc [InnoDB lock wait timeout has correct configured value]
80 [connection rpl_slave_connection_2]
81 ROLLBACK;
82 SET GTID_NEXT = AUTOMATIC;
83 include/wait_condition.inc [First worker must wait on commit order]
84 [connection slave1]
85 SET GLOBAL read_only = ON;
86 [connection slave]
87 ROLLBACK;
88 SET GTID_NEXT = AUTOMATIC;
89 [connection slave1]
90 [connection slave1]
91 SET GLOBAL read_only = OFF;
92 [connection master]
93 include/sync_slave_sql_with_master.inc
94 include/rpl_diff.inc
95 [connection master]
96 include/sync_slave_sql_with_master.inc
97 include/stop_slave_sql.inc
98
99 ############################################################
100 # 05. Cleanup
101 # Kill and restart:--skip_slave_start=0
102 include/rpl_reconnect.inc
103 [connection slave]
104 include/start_slave_sql.inc
105 Warnings:
106 Note 3083 Replication thread(s) for channel '' are already runnning.
107 [connection master]
108 DROP TABLE t1;
109 DROP TABLE t2;
110 include/install_group_replication_plugin.inc
111 include/rpl_end.inc
112 [connection slave]
113 SET GLOBAL replica_parallel_type = 'SAVED_REPLICA_PARALLEL_TYPE';
114 Warnings:
115 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
116 SET GLOBAL replica_parallel_workers = SAVED_REPLICA_PARALLEL_WORKERS;
117 SET GLOBAL replica_preserve_commit_order = SAVED_REPLICA_PRESERVE_COMMIT_ORDER;
118 SET GLOBAL replica_transaction_retries = SAVED_REPLICA_TRANSACTION_RETRIES;
119 SET GLOBAL innodb_lock_wait_timeout = SAVED_INNODB_LOCK_WAIT_TIMEOUT;
120 SET GLOBAL read_only = SAVED_READ_ONLY;