/usr/lib/mysql-testsuite/r/tc-heuristic-recover.result is in percona-server-test-5.6 5.6.22-rel71.0-0ubuntu4.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | CREATE TABLE t1 (a INT) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1);
BEGIN;
INSERT INTO t1 VALUES (2);
SET SESSION debug="d,crash_commit_after_prepare";
COMMIT;
Got one of the listed errors
Restarting with --tc-heuristic-recover=ROLLBACK
2 should be absent:
SELECT * FROM t1;
a
1
BEGIN;
INSERT INTO t1 VALUES (2);
SET SESSION debug="d,crash_commit_after_prepare";
COMMIT;
Got one of the listed errors
Restarting with --tc-heuristic-recover=COMMIT
2 should be present:
SELECT * FROM t1;
a
1
2
DROP TABLE t1;
|