/usr/lib/mysql-testsuite/t/tc-heuristic-recover.test 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 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 | --source include/not_embedded.inc
--source include/not_valgrind.inc
--source include/have_debug.inc
--source include/have_innodb.inc
--source include/have_log_bin.inc
let $restart_file= $MYSQLTEST_VARDIR/tmp/mysqld.1.expect;
let $restart_log= $MYSQLTEST_VARDIR/log/mysqld.1.restart.err;
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";
--exec echo "wait" > $restart_file
--error 2006, 2013
COMMIT;
--source include/wait_until_disconnected.inc
--echo Restarting with --tc-heuristic-recover=ROLLBACK
--error 1
--exec $MYSQLD_CMD --tc-heuristic-recover=ROLLBACK --console > $restart_log 2>&1
--exec echo "restart" > $restart_file
--enable_reconnect
--source include/wait_until_connected_again.inc
--echo 2 should be absent:
SELECT * FROM t1;
BEGIN;
INSERT INTO t1 VALUES (2);
SET SESSION debug="d,crash_commit_after_prepare";
--exec echo "wait" > $restart_file
--error 2006, 2013
COMMIT;
--source include/wait_until_disconnected.inc
--echo Restarting with --tc-heuristic-recover=COMMIT
--error 1
--exec $MYSQLD_CMD --tc-heuristic-recover=COMMIT --console >> $restart_log 2>&1
--exec echo "restart" > $restart_file
--enable_reconnect
--source include/wait_until_connected_again.inc
--echo 2 should be present:
SELECT * FROM t1;
DROP TABLE t1;
|