-- source include/master-slave.inc -- source include/have_debug.inc -- source include/have_innodb.inc call mtr.add_suppression("Attempting backtrace"); call mtr.add_suppression("allocated tablespace *., old maximum was 0"); call mtr.add_suppression("Error in Log_event::read_log_event()"); call mtr.add_suppression("Buffered warning: Performance schema disabled"); --disable_warnings CREATE TABLE t3 (c_01 TINYINT SIGNED, c_02 MEDIUMTEXT, c_03 TINYINT SIGNED NULL, c_04 TIMESTAMP, c_05 INT SIGNED NULL, c_06 TIMESTAMP, c_07 SMALLINT SIGNED) ENGINE=INNODB; CREATE TABLE t4 (c_01 VARCHAR(254) NOT NULL, c_02 TINYTEXT NULL, c_03 VARBINARY(254), c_04 TIME NULL, c_05 INT SIGNED, c_06 DATE NOT NULL, c_07 BIGINT SIGNED NULL, c_08 TIMESTAMP NOT NULL, c_09 TINYINT SIGNED NULL, c_10 TINYINT SIGNED NULL, c_11 DATE NULL, c_12 VARCHAR(254) NULL, c_13 DATE, c_14 SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (c_06)) ENGINE=INNODB; CREATE TABLE t6 (c_01 TINYTEXT NOT NULL, c_02 YEAR(4) NULL, c_03 MEDIUMINT UNSIGNED, c_04 TIMESTAMP, c_05 SMALLINT SIGNED NULL, c_06 BIGINT SIGNED NULL, c_07 TINYINT SIGNED NOT NULL, c_08 VARBINARY(254), c_09 SMALLINT SIGNED, c_10 CHAR(254), c_11 DATETIME, c_12 LONGBLOB NULL, c_13 DATE NULL, c_14 MEDIUMBLOB, PRIMARY KEY (c_07)) ENGINE=INNODB; REPLACE INTO t6 VALUES (REPEAT('E', 56180), '2066', 16751486, '1985-07-23 17:43:12', 0, 0, 67, 'c*', -16334, 'w', '9772-04-08 23:13:34', REPEAT('U', 41772), '6855-09-17', REPEAT('Z', 239)); REPLACE INTO t6 VALUES (REPEAT('X', 23365), '2081', 4566118, '1987-02-11 12:44:44', 15995, -7.44652087330605e+17, -107, ':MZ', 24403, '(D/', '4608-02-03 06:30:16', REPEAT('G', 13258), '2339-01-16', REPEAT('O', 14299)); INSERT INTO t6 VALUES (REPEAT('R', 5753), '1955', 15640861, '2012-07-14 14:00:56', NULL, -2.86683941699938e+18, -106, '+fg', 0, 'h', '8733-03-08 09:18:52', REPEAT('s', 51495), '7172-10-21', NULL); REPLACE INTO t6 VALUES (REPEAT('E', 29646), '1935', 11220689, '2028-06-22 18:07:05', 0, 0, -111, '|I}#cKPn7A!xr:dwW;Z=a2@Wc', 0, '|H]dTA=;5Epfzk~#.PFEmiH p}1.U#3kQ%xwaA updA6oeC%w?Y*J$!X=bq_t|ou]!!T ENonw-fLt$L c_!', '3593-04-05 02:54:41', REPEAT('o', 14368), '1791-10-06', REPEAT('Z', 36059)); ALTER TABLE t3 DROP c_03; DROP TABLE t3; CREATE TABLE t0 LIKE t4; RENAME TABLE t0 TO t3; SELECT COUNT(*) FROM test.t3; BEGIN; INSERT INTO t3 VALUES ('wu', 'r', 'fA', '545:33:50', 1612213645, '7739-03-18', 2.09300635941942e+18, '2035-04-28 08:03:13', -12, -102, '9942-08-13', '_Bn', '8053-09-10', 9692); -- exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect #SET SESSION debug="d,crash_commit_before"; SET SESSION debug="d,crash_commit_after_prepare"; #SET SESSION debug="d,crash_commit_after_log"; # Run the crashing query -- error 2013 COMMIT; -- source include/wait_until_disconnected.inc -- enable_reconnect -- echo # Restart the master server -- exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect -- source include/wait_until_connected_again.inc -- disable_reconnect --sync_slave_with_master --let $diff_tables= master:test.t3, slave:test.t3 --source include/diff_tables.inc DROP TABLE t3,t4,t6;