Debian Codegraph @

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

raw
1 include/group_replication.inc [rpl_server_count=3]
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 include/suppress_messages.inc
8 # Connection 1 suppresses message <Found .* prepared XA transactions>.
9 # Connection 1 suppresses message <.*Checksum mismatch in datafile.*>.
10 # Connection 2 suppresses message <Found .* prepared XA transactions>.
11 # Connection 2 suppresses message <.*Checksum mismatch in datafile.*>.
12 # Connection 3 suppresses message <Found .* prepared XA transactions>.
13 # Connection 3 suppresses message <.*Checksum mismatch in datafile.*>.
14 [connection server1]
15 include/start_and_bootstrap_group_replication.inc
16 CREATE TABLE t1 (c1 INT PRIMARY KEY);
17 XA START X'78696431',X'',1;
18 INSERT INTO t1 VALUES (2);
19 XA END X'78696431',X'',1;
20 XA PREPARE X'78696431',X'',1;
21 XA COMMIT X'78696431',X'',1;
22 [connection server2]
23 include/save_sysvars.inc [ "GLOBAL.group_replication_member_expel_timeout" ]
24 SET GLOBAL group_replication_member_expel_timeout = 0;
25 include/start_group_replication.inc
26 include/save_binlog_position.inc
27 [connection server3]
28 include/save_sysvars.inc [ "GLOBAL.group_replication_member_expel_timeout" ]
29 SET GLOBAL group_replication_member_expel_timeout = 0;
30 include/start_group_replication.inc
31 [connection server1]
32 include/save_binlog_position.inc
33 XA START X'78696431',X'',1;
34 INSERT INTO t1 VALUES (1);
35 XA END X'78696431',X'',1;
36 [connection server1]
37 include/rpl_sync.inc
38 include/execute_to_conditional_timestamp_sync_point.inc [before_invoke_before_commit_hook]
39 XA PREPARE X'78696431',X'',1;
40 # Kill the server
41 ERROR HY000: Lost connection to MySQL server during query
42 [connection server2]
43 include/rpl_gr_wait_for_number_of_members.inc
44 # restart:--group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --group_replication_start_on_boot=OFF --group_replication_single_primary_mode=TRUE --group_replication_enforce_update_everywhere_checks=FALSE
45 include/rpl_reconnect.inc
46 [connection server1]
47 include/assert.inc [Found 1 log message(s) for "((Successfully rolled back 1 XA transaction)|(Rolling back trx with id ([0-9]+), 1 rows to undo))"]
48 include/assert_binlog_events.inc [()]
49 include/assert.inc [GTID_EXECUTED has not been updated]
50 include/assert.inc [No XA transactions in PREPARED state]
51 include/assert.inc [Table 'test.t1' record count must be 1]
52 [connection server2]
53 include/assert_binlog_events.inc [Gtid # Query/BEGIN # View_change # Query/COMMIT]
54 include/assert.inc [No XA transactions in PREPARED state]
55 include/assert.inc [Table 'test.t1' record count must be 1]
56 [connection server1]
57 include/save_binlog_position.inc
58 include/start_group_replication.inc
59 [connection server2]
60 include/rpl_gr_wait_for_number_of_members.inc
61 [connection server1]
62 include/assert_binlog_events.inc [Gtid # Query/BEGIN # View_change # Query/COMMIT]
63 include/assert.inc [No XA transactions in PREPARED state]
64 include/assert.inc [Table 'test.t1' record count must be 1]
65 include/gr_find_a_primary.inc
66 DROP TABLE t1;
67 [connection server2]
68 include/restore_sysvars.inc
69 [connection server3]
70 include/restore_sysvars.inc
71 include/group_replication_end.inc