627 lines
28 KiB
Plaintext
627 lines
28 KiB
Plaintext
include/gtid_utils.inc
|
|
CREATE TABLE t_1 (a int);
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE USER user1 IDENTIFIED WITH 'mysql_native_password'' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
CREATE USER user1 IDENTIFIED WITH 'mysql_native_password';
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE USER user1 IDENTIFIED WITH 'mysql_native_password'' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
CREATE USER user1 IDENTIFIED WITH 'mysql_native_password';
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'GRANT SELECT ON *.* TO user1' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
GRANT SELECT ON *.* TO user1;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'GRANT SELECT ON *.* TO user1' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
GRANT SELECT ON *.* TO user1;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'REVOKE SELECT ON *.* FROM user1' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
REVOKE SELECT ON *.* FROM user1;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'REVOKE SELECT ON *.* FROM user1' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
REVOKE SELECT ON *.* FROM user1;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER USER user1 IDENTIFIED BY '123456'' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
ALTER USER user1 IDENTIFIED BY '123456';
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER USER user1 IDENTIFIED BY '123456'' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
ALTER USER user1 IDENTIFIED BY '123456';
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'SET PASSWORD FOR user1='abcdef'' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
SET PASSWORD FOR user1='abcdef';
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'SET PASSWORD FOR user1='abcdef'' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
SET PASSWORD FOR user1='abcdef';
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'RENAME USER user1 TO user2' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
RENAME USER user1 TO user2;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'RENAME USER user1 TO user2' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
RENAME USER user1 TO user2;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE ROLE roleA,roleB' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
CREATE ROLE roleA,roleB;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE ROLE roleA,roleB' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
CREATE ROLE roleA,roleB;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'GRANT roleA TO roleB' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
GRANT roleA TO roleB;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'GRANT roleA TO roleB' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
GRANT roleA TO roleB;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'REVOKE roleA FROM roleB' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
REVOKE roleA FROM roleB;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'REVOKE roleA FROM roleB' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
REVOKE roleA FROM roleB;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'GRANT roleA TO user2' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
GRANT roleA TO user2;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'GRANT roleA TO user2' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
GRANT roleA TO user2;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER USER user2 DEFAULT ROLE roleA;' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
ALTER USER user2 DEFAULT ROLE roleA;;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER USER user2 DEFAULT ROLE roleA;' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
ALTER USER user2 DEFAULT ROLE roleA;;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP ROLE roleA,roleB' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
DROP ROLE roleA,roleB;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP ROLE roleA,roleB' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
DROP ROLE roleA,roleB;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP USER user2' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
DROP USER user2;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP USER user2' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
DROP USER user2;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
PREPARE stmt FROM 'CREATE USER user3';
|
|
DEALLOCATE PREPARE stmt;
|
|
PREPARE stmt FROM 'DROP USER user3';
|
|
DEALLOCATE PREPARE stmt;
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE TRIGGER tr_0 BEFORE INSERT ON t_1 FOR EACH ROW SET @a:=1' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
CREATE TRIGGER tr_0 BEFORE INSERT ON t_1 FOR EACH ROW SET @a:=1;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE TRIGGER tr_0 BEFORE INSERT ON t_1 FOR EACH ROW SET @a:=1' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
CREATE TRIGGER tr_0 BEFORE INSERT ON t_1 FOR EACH ROW SET @a:=1;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP TRIGGER tr_0' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
DROP TRIGGER tr_0;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP TRIGGER tr_0' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
DROP TRIGGER tr_0;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE FUNCTION f_0() RETURNS INT RETURN 5;' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
CREATE FUNCTION f_0() RETURNS INT RETURN 5;;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE FUNCTION f_0() RETURNS INT RETURN 5;' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
CREATE FUNCTION f_0() RETURNS INT RETURN 5;;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER FUNCTION f_0 COMMENT 'comment'' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
ALTER FUNCTION f_0 COMMENT 'comment';
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER FUNCTION f_0 COMMENT 'comment'' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
ALTER FUNCTION f_0 COMMENT 'comment';
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP FUNCTION f_0' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
DROP FUNCTION f_0;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP FUNCTION f_0' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
DROP FUNCTION f_0;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE PROCEDURE p_0() BEGIN END' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
CREATE PROCEDURE p_0() BEGIN END;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE PROCEDURE p_0() BEGIN END' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
CREATE PROCEDURE p_0() BEGIN END;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER PROCEDURE p_0 COMMENT 'comment'' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
ALTER PROCEDURE p_0 COMMENT 'comment';
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER PROCEDURE p_0 COMMENT 'comment'' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
ALTER PROCEDURE p_0 COMMENT 'comment';
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP PROCEDURE p_0' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
DROP PROCEDURE p_0;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP PROCEDURE p_0' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
DROP PROCEDURE p_0;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE EVENT e_0 ON SCHEDULE EVERY 2 DAY DO SELECT 2' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
CREATE EVENT e_0 ON SCHEDULE EVERY 2 DAY DO SELECT 2;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE EVENT e_0 ON SCHEDULE EVERY 2 DAY DO SELECT 2' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
CREATE EVENT e_0 ON SCHEDULE EVERY 2 DAY DO SELECT 2;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER EVENT e_0 ON SCHEDULE EVERY 2 day DO SELECT 1;' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
ALTER EVENT e_0 ON SCHEDULE EVERY 2 day DO SELECT 1;;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER EVENT e_0 ON SCHEDULE EVERY 2 day DO SELECT 1;' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
ALTER EVENT e_0 ON SCHEDULE EVERY 2 day DO SELECT 1;;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP EVENT e_0' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
DROP EVENT e_0;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP EVENT e_0' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
DROP EVENT e_0;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE VIEW v_0 AS SELECT * FROM t_1' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
CREATE VIEW v_0 AS SELECT * FROM t_1;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE VIEW v_0 AS SELECT * FROM t_1' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
CREATE VIEW v_0 AS SELECT * FROM t_1;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER VIEW v_0 AS SELECT * FROM t_1' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
ALTER VIEW v_0 AS SELECT * FROM t_1;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER VIEW v_0 AS SELECT * FROM t_1' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
ALTER VIEW v_0 AS SELECT * FROM t_1;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP VIEW v_0' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
DROP VIEW v_0;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP VIEW v_0' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
DROP VIEW v_0;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example_LIB'' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example_LIB';
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example_LIB'' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example_LIB';
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP FUNCTION metaphon;' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
DROP FUNCTION metaphon;;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP FUNCTION metaphon;' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
DROP FUNCTION metaphon;;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE TABLE test.t1(a int)' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
CREATE TABLE test.t1(a int);
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE TABLE test.t1(a int)' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
CREATE TABLE test.t1(a int);
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER TABLE test.t1 ADD COLUMN t1_new_col varchar(100);' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
ALTER TABLE test.t1 ADD COLUMN t1_new_col varchar(100);;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER TABLE test.t1 ADD COLUMN t1_new_col varchar(100);' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
ALTER TABLE test.t1 ADD COLUMN t1_new_col varchar(100);;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER TABLE test.t1 ADD index new_t1_idx(t1_new_col);' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
ALTER TABLE test.t1 ADD index new_t1_idx(t1_new_col);;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER TABLE test.t1 ADD index new_t1_idx(t1_new_col);' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
ALTER TABLE test.t1 ADD index new_t1_idx(t1_new_col);;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER TABLE test.t1 RENAME TO test.t2' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
ALTER TABLE test.t1 RENAME TO test.t2;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER TABLE test.t1 RENAME TO test.t2' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
ALTER TABLE test.t1 RENAME TO test.t2;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER TABLE test.t2 DROP COLUMN a;' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
ALTER TABLE test.t2 DROP COLUMN a;;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER TABLE test.t2 DROP COLUMN a;' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
ALTER TABLE test.t2 DROP COLUMN a;;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'TRUNCATE TABLE test.t2' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
TRUNCATE TABLE test.t2;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'TRUNCATE TABLE test.t2' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
TRUNCATE TABLE test.t2;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER TABLE test.t2 ADD fulltext index full_t2_idx(t1_new_col);' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
ALTER TABLE test.t2 ADD fulltext index full_t2_idx(t1_new_col);;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER TABLE test.t2 ADD fulltext index full_t2_idx(t1_new_col);' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
ALTER TABLE test.t2 ADD fulltext index full_t2_idx(t1_new_col);;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER TABLE test.t2 DROP index full_t2_idx;' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
ALTER TABLE test.t2 DROP index full_t2_idx;;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'ALTER TABLE test.t2 DROP index full_t2_idx;' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
ALTER TABLE test.t2 DROP index full_t2_idx;;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP TABLE test.t2' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
DROP TABLE test.t2;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP TABLE test.t2' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
DROP TABLE test.t2;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE TABLESPACE ts ADD DATAFILE 'ts_0.ibd'' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
CREATE TABLESPACE ts ADD DATAFILE 'ts_0.ibd';
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'CREATE TABLESPACE ts ADD DATAFILE 'ts_0.ibd'' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
CREATE TABLESPACE ts ADD DATAFILE 'ts_0.ibd';
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP TABLESPACE ts' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
DROP TABLESPACE ts;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=0]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP TABLESPACE ts' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
DROP TABLESPACE ts;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=0]
|
|
RESET MASTER;
|
|
include/gtid_step_reset.inc
|
|
include/gtid_step_assert.inc [count=1, only_count=1]
|
|
include/gtid_step_reset.inc
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP USER user1' has been prepared in the engine before being logged ***
|
|
SET @@SESSION.debug="+d,crash_commit_before_log";
|
|
DROP USER user1;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=0, only_count=1]
|
|
FLUSH LOGS;
|
|
*** Crash right after 'DROP USER user1' has been binary-logged before committed in the engine ***
|
|
SET @@SESSION.debug="+d,crash_commit_after_log";
|
|
DROP USER user1;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
include/gtid_step_assert.inc [count=1, only_count=1]
|
|
DROP TABLE t_1;
|
|
include/gtid_utils_end.inc
|