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
|
include/only_with_option.inc [GLOBAL.log_bin = 0]
include/suppress_messages.inc
# Connection 1 suppresses message <Found .* prepared XA transactions>.
# Connection 1 suppresses message <.*Checksum mismatch in datafile.*>.
CREATE TABLE t1 (c1 INT PRIMARY KEY);
XA START X'78696431',X'',1;
INSERT INTO t1 VALUES (2);
XA END X'78696431',X'',1;
XA PREPARE X'78696431',X'',1;
XA COMMIT X'78696431',X'',1;
XA START X'78696431',X'',1;
INSERT INTO t1 VALUES (1);
XA END X'78696431',X'',1;
XA PREPARE X'78696431',X'',1;
include/execute_to_conditional_timestamp_sync_point.inc [before_commit_in_tc]
XA COMMIT X'78696431',X'',1;
# Kill the server
ERROR HY000: Lost connection to MySQL server during query
# restart
include/assert.inc [Found 1 log message(s) for "Successfully prepared 1 XA transaction"]
include/assert.inc [1 XA transaction(s) in PREPARED state]
include/assert.inc [XA transaction X'78696431',X'',1 is in PREPARED state]
include/assert.inc [Table 'test.t1' record count must be 1]
# restart
include/assert.inc [1 XA transaction(s) in PREPARED state]
include/assert.inc [XA transaction X'78696431',X'',1 is in PREPARED state]
XA COMMIT X'78696431',X'',1;
include/assert.inc [Table 'test.t1' record count must be 2]
DROP TABLE t1;
|
