mirror of
https://github.com/MariaDB/server.git
synced 2025-04-19 05:35:33 +02:00
85 lines
1.9 KiB
Text
85 lines
1.9 KiB
Text
-- source include/have_innodb.inc
|
|
-- source include/have_tokudb.inc
|
|
-- source include/have_debug.inc
|
|
# Valgrind would report memory leaks on the intentional crashes
|
|
-- source include/not_valgrind.inc
|
|
# Embedded server does not support crashing
|
|
-- source include/not_embedded.inc
|
|
# Avoid CrashReporter popup on Mac
|
|
-- source include/not_crashrep.inc
|
|
|
|
--disable_warnings
|
|
drop table if exists t1, t2;
|
|
--enable_warnings
|
|
|
|
#
|
|
# bug lp:544173, xa crash with two 2pc-capable storage engines without binlog
|
|
#
|
|
|
|
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=innodb;
|
|
CREATE TABLE t2 (b INT PRIMARY KEY) ENGINE=tokudb;
|
|
BEGIN;
|
|
# verify that binlog is off
|
|
SELECT @@log_bin;
|
|
INSERT INTO t1 VALUES (1);
|
|
INSERT INTO t2 VALUES (2);
|
|
|
|
SET SESSION debug_dbug="d,crash_commit_before";
|
|
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
|
|
--error 2013
|
|
COMMIT;
|
|
|
|
--enable_reconnect
|
|
|
|
--source include/wait_until_connected_again.inc
|
|
select * from t1;
|
|
select * from t2;
|
|
|
|
drop table t1, t2;
|
|
|
|
|
|
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=innodb;
|
|
CREATE TABLE t2 (b INT PRIMARY KEY) ENGINE=tokudb;
|
|
BEGIN;
|
|
# verify that binlog is off
|
|
SELECT @@log_bin;
|
|
INSERT INTO t1 VALUES (1);
|
|
INSERT INTO t2 VALUES (2);
|
|
|
|
SET SESSION debug_dbug="d,crash_commit_after_prepare";
|
|
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
|
|
--error 2013
|
|
COMMIT;
|
|
|
|
--enable_reconnect
|
|
|
|
--source include/wait_until_connected_again.inc
|
|
select * from t1;
|
|
select * from t2;
|
|
|
|
drop table t1, t2;
|
|
|
|
|
|
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=innodb;
|
|
CREATE TABLE t2 (b INT PRIMARY KEY) ENGINE=tokudb;
|
|
BEGIN;
|
|
# verify that binlog is off
|
|
SELECT @@log_bin;
|
|
INSERT INTO t1 VALUES (1);
|
|
INSERT INTO t2 VALUES (2);
|
|
|
|
SET SESSION debug_dbug="d,crash_commit_after";
|
|
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
|
|
--error 2013
|
|
COMMIT;
|
|
|
|
--enable_reconnect
|
|
|
|
--source include/wait_until_connected_again.inc
|
|
select * from t1;
|
|
select * from t2;
|
|
|
|
drop table t1, t2;
|