1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
############################################################
# 1. Prepare the data for the test.
CREATE TABLE t1 (c1 INT PRIMARY KEY);
############################################################
# 2. Execute a XA PREPARE with id '1'.
XA START 'xid1';
INSERT INTO t1 VALUES (1);
XA END 'xid1';
XA PREPARE 'xid1';
# Waiting for the connection server1_conn2 disappeared on the server side
############################################################
# 3. Force a local failure in before_commit listener on the
# XA COMMIT.
# Wait until a record about a prepared XA transaction be found in output of XA RECOVER.
# Having two conditions satisfied (first one for disappeared connection server1_conn2
# and the second one for presence of the prepared XA transaction with xid value equaled xid1)
# guarantees that the connection server1_conn2 was really closed and a prepared XA transaction
# with xid1 was really placed into an internal server cache of prepared XA transactions.
# Output result of XA RECOVER into result file for sanity check.
XA RECOVER;
formatID gtrid_length bqual_length data
1 4 0 xid1
SET @debug_save= @@GLOBAL.DEBUG;
SET @@GLOBAL.DEBUG= '+d,simulate_failure_in_before_commit_hook';
XA COMMIT 'xid1';
ERROR HY000: Error on observer while running replication hook 'before_commit'.
SHOW ERRORS;
Level Code Message
Error 3100 Error on observer while running replication hook 'before_commit'.
SET @@GLOBAL.DEBUG= @debug_save;
############################################################
# 4. Clean up.
DROP TABLE t1;
# restart
CALL mtr.add_suppression("Found 1 prepared XA transactions");
XA ROLLBACK 'xid1';
|
