1include/gtid_utils.inc 2CREATE TABLE t_1 (a int); 3include/gtid_step_reset.inc 4FLUSH LOGS; 5*** Crash right after 'CREATE USER user1 IDENTIFIED WITH 'mysql_native_password'' has been prepared in the engine before being logged *** 6SET @@SESSION.debug="+d,crash_commit_before_log"; 7CREATE USER user1 IDENTIFIED WITH 'mysql_native_password'; 8ERROR HY000: Lost connection to MySQL server during query 9# restart 10include/gtid_step_assert.inc [count=0, only_count=0] 11FLUSH LOGS; 12*** Crash right after 'CREATE USER user1 IDENTIFIED WITH 'mysql_native_password'' has been binary-logged before committed in the engine *** 13SET @@SESSION.debug="+d,crash_commit_after_log"; 14CREATE USER user1 IDENTIFIED WITH 'mysql_native_password'; 15ERROR HY000: Lost connection to MySQL server during query 16# restart 17include/gtid_step_assert.inc [count=1, only_count=0] 18include/gtid_step_reset.inc 19FLUSH LOGS; 20*** Crash right after 'GRANT SELECT ON *.* TO user1' has been prepared in the engine before being logged *** 21SET @@SESSION.debug="+d,crash_commit_before_log"; 22GRANT SELECT ON *.* TO user1; 23ERROR HY000: Lost connection to MySQL server during query 24# restart 25include/gtid_step_assert.inc [count=0, only_count=0] 26FLUSH LOGS; 27*** Crash right after 'GRANT SELECT ON *.* TO user1' has been binary-logged before committed in the engine *** 28SET @@SESSION.debug="+d,crash_commit_after_log"; 29GRANT SELECT ON *.* TO user1; 30ERROR HY000: Lost connection to MySQL server during query 31# restart 32include/gtid_step_assert.inc [count=1, only_count=0] 33include/gtid_step_reset.inc 34FLUSH LOGS; 35*** Crash right after 'REVOKE SELECT ON *.* FROM user1' has been prepared in the engine before being logged *** 36SET @@SESSION.debug="+d,crash_commit_before_log"; 37REVOKE SELECT ON *.* FROM user1; 38ERROR HY000: Lost connection to MySQL server during query 39# restart 40include/gtid_step_assert.inc [count=0, only_count=0] 41FLUSH LOGS; 42*** Crash right after 'REVOKE SELECT ON *.* FROM user1' has been binary-logged before committed in the engine *** 43SET @@SESSION.debug="+d,crash_commit_after_log"; 44REVOKE SELECT ON *.* FROM user1; 45ERROR HY000: Lost connection to MySQL server during query 46# restart 47include/gtid_step_assert.inc [count=1, only_count=0] 48include/gtid_step_reset.inc 49FLUSH LOGS; 50*** Crash right after 'ALTER USER user1 IDENTIFIED BY '123456'' has been prepared in the engine before being logged *** 51SET @@SESSION.debug="+d,crash_commit_before_log"; 52ALTER USER user1 IDENTIFIED BY '123456'; 53ERROR HY000: Lost connection to MySQL server during query 54# restart 55include/gtid_step_assert.inc [count=0, only_count=0] 56FLUSH LOGS; 57*** Crash right after 'ALTER USER user1 IDENTIFIED BY '123456'' has been binary-logged before committed in the engine *** 58SET @@SESSION.debug="+d,crash_commit_after_log"; 59ALTER USER user1 IDENTIFIED BY '123456'; 60ERROR HY000: Lost connection to MySQL server during query 61# restart 62include/gtid_step_assert.inc [count=1, only_count=0] 63include/gtid_step_reset.inc 64FLUSH LOGS; 65*** Crash right after 'SET PASSWORD FOR user1='abcdef'' has been prepared in the engine before being logged *** 66SET @@SESSION.debug="+d,crash_commit_before_log"; 67SET PASSWORD FOR user1='abcdef'; 68ERROR HY000: Lost connection to MySQL server during query 69# restart 70include/gtid_step_assert.inc [count=0, only_count=0] 71FLUSH LOGS; 72*** Crash right after 'SET PASSWORD FOR user1='abcdef'' has been binary-logged before committed in the engine *** 73SET @@SESSION.debug="+d,crash_commit_after_log"; 74SET PASSWORD FOR user1='abcdef'; 75ERROR HY000: Lost connection to MySQL server during query 76# restart 77include/gtid_step_assert.inc [count=1, only_count=0] 78include/gtid_step_reset.inc 79FLUSH LOGS; 80*** Crash right after 'RENAME USER user1 TO user2' has been prepared in the engine before being logged *** 81SET @@SESSION.debug="+d,crash_commit_before_log"; 82RENAME USER user1 TO user2; 83ERROR HY000: Lost connection to MySQL server during query 84# restart 85include/gtid_step_assert.inc [count=0, only_count=0] 86FLUSH LOGS; 87*** Crash right after 'RENAME USER user1 TO user2' has been binary-logged before committed in the engine *** 88SET @@SESSION.debug="+d,crash_commit_after_log"; 89RENAME USER user1 TO user2; 90ERROR HY000: Lost connection to MySQL server during query 91# restart 92include/gtid_step_assert.inc [count=1, only_count=0] 93include/gtid_step_reset.inc 94FLUSH LOGS; 95*** Crash right after 'CREATE ROLE roleA,roleB' has been prepared in the engine before being logged *** 96SET @@SESSION.debug="+d,crash_commit_before_log"; 97CREATE ROLE roleA,roleB; 98ERROR HY000: Lost connection to MySQL server during query 99# restart 100include/gtid_step_assert.inc [count=0, only_count=0] 101FLUSH LOGS; 102*** Crash right after 'CREATE ROLE roleA,roleB' has been binary-logged before committed in the engine *** 103SET @@SESSION.debug="+d,crash_commit_after_log"; 104CREATE ROLE roleA,roleB; 105ERROR HY000: Lost connection to MySQL server during query 106# restart 107include/gtid_step_assert.inc [count=1, only_count=0] 108include/gtid_step_reset.inc 109FLUSH LOGS; 110*** Crash right after 'GRANT roleA TO roleB' has been prepared in the engine before being logged *** 111SET @@SESSION.debug="+d,crash_commit_before_log"; 112GRANT roleA TO roleB; 113ERROR HY000: Lost connection to MySQL server during query 114# restart 115include/gtid_step_assert.inc [count=0, only_count=0] 116FLUSH LOGS; 117*** Crash right after 'GRANT roleA TO roleB' has been binary-logged before committed in the engine *** 118SET @@SESSION.debug="+d,crash_commit_after_log"; 119GRANT roleA TO roleB; 120ERROR HY000: Lost connection to MySQL server during query 121# restart 122include/gtid_step_assert.inc [count=1, only_count=0] 123include/gtid_step_reset.inc 124FLUSH LOGS; 125*** Crash right after 'REVOKE roleA FROM roleB' has been prepared in the engine before being logged *** 126SET @@SESSION.debug="+d,crash_commit_before_log"; 127REVOKE roleA FROM roleB; 128ERROR HY000: Lost connection to MySQL server during query 129# restart 130include/gtid_step_assert.inc [count=0, only_count=0] 131FLUSH LOGS; 132*** Crash right after 'REVOKE roleA FROM roleB' has been binary-logged before committed in the engine *** 133SET @@SESSION.debug="+d,crash_commit_after_log"; 134REVOKE roleA FROM roleB; 135ERROR HY000: Lost connection to MySQL server during query 136# restart 137include/gtid_step_assert.inc [count=1, only_count=0] 138include/gtid_step_reset.inc 139FLUSH LOGS; 140*** Crash right after 'GRANT roleA TO user2' has been prepared in the engine before being logged *** 141SET @@SESSION.debug="+d,crash_commit_before_log"; 142GRANT roleA TO user2; 143ERROR HY000: Lost connection to MySQL server during query 144# restart 145include/gtid_step_assert.inc [count=0, only_count=0] 146FLUSH LOGS; 147*** Crash right after 'GRANT roleA TO user2' has been binary-logged before committed in the engine *** 148SET @@SESSION.debug="+d,crash_commit_after_log"; 149GRANT roleA TO user2; 150ERROR HY000: Lost connection to MySQL server during query 151# restart 152include/gtid_step_assert.inc [count=1, only_count=0] 153include/gtid_step_reset.inc 154FLUSH LOGS; 155*** Crash right after 'ALTER USER user2 DEFAULT ROLE roleA;' has been prepared in the engine before being logged *** 156SET @@SESSION.debug="+d,crash_commit_before_log"; 157ALTER USER user2 DEFAULT ROLE roleA;; 158ERROR HY000: Lost connection to MySQL server during query 159# restart 160include/gtid_step_assert.inc [count=0, only_count=0] 161FLUSH LOGS; 162*** Crash right after 'ALTER USER user2 DEFAULT ROLE roleA;' has been binary-logged before committed in the engine *** 163SET @@SESSION.debug="+d,crash_commit_after_log"; 164ALTER USER user2 DEFAULT ROLE roleA;; 165ERROR HY000: Lost connection to MySQL server during query 166# restart 167include/gtid_step_assert.inc [count=1, only_count=0] 168include/gtid_step_reset.inc 169FLUSH LOGS; 170*** Crash right after 'DROP ROLE roleA,roleB' has been prepared in the engine before being logged *** 171SET @@SESSION.debug="+d,crash_commit_before_log"; 172DROP ROLE roleA,roleB; 173ERROR HY000: Lost connection to MySQL server during query 174# restart 175include/gtid_step_assert.inc [count=0, only_count=0] 176FLUSH LOGS; 177*** Crash right after 'DROP ROLE roleA,roleB' has been binary-logged before committed in the engine *** 178SET @@SESSION.debug="+d,crash_commit_after_log"; 179DROP ROLE roleA,roleB; 180ERROR HY000: Lost connection to MySQL server during query 181# restart 182include/gtid_step_assert.inc [count=1, only_count=0] 183include/gtid_step_reset.inc 184FLUSH LOGS; 185*** Crash right after 'DROP USER user2' has been prepared in the engine before being logged *** 186SET @@SESSION.debug="+d,crash_commit_before_log"; 187DROP USER user2; 188ERROR HY000: Lost connection to MySQL server during query 189# restart 190include/gtid_step_assert.inc [count=0, only_count=0] 191FLUSH LOGS; 192*** Crash right after 'DROP USER user2' has been binary-logged before committed in the engine *** 193SET @@SESSION.debug="+d,crash_commit_after_log"; 194DROP USER user2; 195ERROR HY000: Lost connection to MySQL server during query 196# restart 197include/gtid_step_assert.inc [count=1, only_count=0] 198PREPARE stmt FROM 'CREATE USER user3'; 199DEALLOCATE PREPARE stmt; 200PREPARE stmt FROM 'DROP USER user3'; 201DEALLOCATE PREPARE stmt; 202include/gtid_step_reset.inc 203FLUSH LOGS; 204*** 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 *** 205SET @@SESSION.debug="+d,crash_commit_before_log"; 206CREATE TRIGGER tr_0 BEFORE INSERT ON t_1 FOR EACH ROW SET @a:=1; 207ERROR HY000: Lost connection to MySQL server during query 208# restart 209include/gtid_step_assert.inc [count=0, only_count=0] 210FLUSH LOGS; 211*** 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 *** 212SET @@SESSION.debug="+d,crash_commit_after_log"; 213CREATE TRIGGER tr_0 BEFORE INSERT ON t_1 FOR EACH ROW SET @a:=1; 214ERROR HY000: Lost connection to MySQL server during query 215# restart 216include/gtid_step_assert.inc [count=1, only_count=0] 217include/gtid_step_reset.inc 218FLUSH LOGS; 219*** Crash right after 'DROP TRIGGER tr_0' has been prepared in the engine before being logged *** 220SET @@SESSION.debug="+d,crash_commit_before_log"; 221DROP TRIGGER tr_0; 222ERROR HY000: Lost connection to MySQL server during query 223# restart 224include/gtid_step_assert.inc [count=0, only_count=0] 225FLUSH LOGS; 226*** Crash right after 'DROP TRIGGER tr_0' has been binary-logged before committed in the engine *** 227SET @@SESSION.debug="+d,crash_commit_after_log"; 228DROP TRIGGER tr_0; 229ERROR HY000: Lost connection to MySQL server during query 230# restart 231include/gtid_step_assert.inc [count=1, only_count=0] 232include/gtid_step_reset.inc 233FLUSH LOGS; 234*** Crash right after 'CREATE FUNCTION f_0() RETURNS INT RETURN 5;' has been prepared in the engine before being logged *** 235SET @@SESSION.debug="+d,crash_commit_before_log"; 236CREATE FUNCTION f_0() RETURNS INT RETURN 5;; 237ERROR HY000: Lost connection to MySQL server during query 238# restart 239include/gtid_step_assert.inc [count=0, only_count=0] 240FLUSH LOGS; 241*** Crash right after 'CREATE FUNCTION f_0() RETURNS INT RETURN 5;' has been binary-logged before committed in the engine *** 242SET @@SESSION.debug="+d,crash_commit_after_log"; 243CREATE FUNCTION f_0() RETURNS INT RETURN 5;; 244ERROR HY000: Lost connection to MySQL server during query 245# restart 246include/gtid_step_assert.inc [count=1, only_count=0] 247include/gtid_step_reset.inc 248FLUSH LOGS; 249*** Crash right after 'ALTER FUNCTION f_0 COMMENT 'comment'' has been prepared in the engine before being logged *** 250SET @@SESSION.debug="+d,crash_commit_before_log"; 251ALTER FUNCTION f_0 COMMENT 'comment'; 252ERROR HY000: Lost connection to MySQL server during query 253# restart 254include/gtid_step_assert.inc [count=0, only_count=0] 255FLUSH LOGS; 256*** Crash right after 'ALTER FUNCTION f_0 COMMENT 'comment'' has been binary-logged before committed in the engine *** 257SET @@SESSION.debug="+d,crash_commit_after_log"; 258ALTER FUNCTION f_0 COMMENT 'comment'; 259ERROR HY000: Lost connection to MySQL server during query 260# restart 261include/gtid_step_assert.inc [count=1, only_count=0] 262include/gtid_step_reset.inc 263FLUSH LOGS; 264*** Crash right after 'DROP FUNCTION f_0' has been prepared in the engine before being logged *** 265SET @@SESSION.debug="+d,crash_commit_before_log"; 266DROP FUNCTION f_0; 267ERROR HY000: Lost connection to MySQL server during query 268# restart 269include/gtid_step_assert.inc [count=0, only_count=0] 270FLUSH LOGS; 271*** Crash right after 'DROP FUNCTION f_0' has been binary-logged before committed in the engine *** 272SET @@SESSION.debug="+d,crash_commit_after_log"; 273DROP FUNCTION f_0; 274ERROR HY000: Lost connection to MySQL server during query 275# restart 276include/gtid_step_assert.inc [count=1, only_count=0] 277include/gtid_step_reset.inc 278FLUSH LOGS; 279*** Crash right after 'CREATE PROCEDURE p_0() BEGIN END' has been prepared in the engine before being logged *** 280SET @@SESSION.debug="+d,crash_commit_before_log"; 281CREATE PROCEDURE p_0() BEGIN END; 282ERROR HY000: Lost connection to MySQL server during query 283# restart 284include/gtid_step_assert.inc [count=0, only_count=0] 285FLUSH LOGS; 286*** Crash right after 'CREATE PROCEDURE p_0() BEGIN END' has been binary-logged before committed in the engine *** 287SET @@SESSION.debug="+d,crash_commit_after_log"; 288CREATE PROCEDURE p_0() BEGIN END; 289ERROR HY000: Lost connection to MySQL server during query 290# restart 291include/gtid_step_assert.inc [count=1, only_count=0] 292include/gtid_step_reset.inc 293FLUSH LOGS; 294*** Crash right after 'ALTER PROCEDURE p_0 COMMENT 'comment'' has been prepared in the engine before being logged *** 295SET @@SESSION.debug="+d,crash_commit_before_log"; 296ALTER PROCEDURE p_0 COMMENT 'comment'; 297ERROR HY000: Lost connection to MySQL server during query 298# restart 299include/gtid_step_assert.inc [count=0, only_count=0] 300FLUSH LOGS; 301*** Crash right after 'ALTER PROCEDURE p_0 COMMENT 'comment'' has been binary-logged before committed in the engine *** 302SET @@SESSION.debug="+d,crash_commit_after_log"; 303ALTER PROCEDURE p_0 COMMENT 'comment'; 304ERROR HY000: Lost connection to MySQL server during query 305# restart 306include/gtid_step_assert.inc [count=1, only_count=0] 307include/gtid_step_reset.inc 308FLUSH LOGS; 309*** Crash right after 'DROP PROCEDURE p_0' has been prepared in the engine before being logged *** 310SET @@SESSION.debug="+d,crash_commit_before_log"; 311DROP PROCEDURE p_0; 312ERROR HY000: Lost connection to MySQL server during query 313# restart 314include/gtid_step_assert.inc [count=0, only_count=0] 315FLUSH LOGS; 316*** Crash right after 'DROP PROCEDURE p_0' has been binary-logged before committed in the engine *** 317SET @@SESSION.debug="+d,crash_commit_after_log"; 318DROP PROCEDURE p_0; 319ERROR HY000: Lost connection to MySQL server during query 320# restart 321include/gtid_step_assert.inc [count=1, only_count=0] 322include/gtid_step_reset.inc 323FLUSH LOGS; 324*** Crash right after 'CREATE EVENT e_0 ON SCHEDULE EVERY 2 DAY DO SELECT 2' has been prepared in the engine before being logged *** 325SET @@SESSION.debug="+d,crash_commit_before_log"; 326CREATE EVENT e_0 ON SCHEDULE EVERY 2 DAY DO SELECT 2; 327ERROR HY000: Lost connection to MySQL server during query 328# restart 329include/gtid_step_assert.inc [count=0, only_count=0] 330FLUSH LOGS; 331*** Crash right after 'CREATE EVENT e_0 ON SCHEDULE EVERY 2 DAY DO SELECT 2' has been binary-logged before committed in the engine *** 332SET @@SESSION.debug="+d,crash_commit_after_log"; 333CREATE EVENT e_0 ON SCHEDULE EVERY 2 DAY DO SELECT 2; 334ERROR HY000: Lost connection to MySQL server during query 335# restart 336include/gtid_step_assert.inc [count=1, only_count=0] 337include/gtid_step_reset.inc 338FLUSH LOGS; 339*** Crash right after 'ALTER EVENT e_0 ON SCHEDULE EVERY 2 day DO SELECT 1;' has been prepared in the engine before being logged *** 340SET @@SESSION.debug="+d,crash_commit_before_log"; 341ALTER EVENT e_0 ON SCHEDULE EVERY 2 day DO SELECT 1;; 342ERROR HY000: Lost connection to MySQL server during query 343# restart 344include/gtid_step_assert.inc [count=0, only_count=0] 345FLUSH LOGS; 346*** Crash right after 'ALTER EVENT e_0 ON SCHEDULE EVERY 2 day DO SELECT 1;' has been binary-logged before committed in the engine *** 347SET @@SESSION.debug="+d,crash_commit_after_log"; 348ALTER EVENT e_0 ON SCHEDULE EVERY 2 day DO SELECT 1;; 349ERROR HY000: Lost connection to MySQL server during query 350# restart 351include/gtid_step_assert.inc [count=1, only_count=0] 352include/gtid_step_reset.inc 353FLUSH LOGS; 354*** Crash right after 'DROP EVENT e_0' has been prepared in the engine before being logged *** 355SET @@SESSION.debug="+d,crash_commit_before_log"; 356DROP EVENT e_0; 357ERROR HY000: Lost connection to MySQL server during query 358# restart 359include/gtid_step_assert.inc [count=0, only_count=0] 360FLUSH LOGS; 361*** Crash right after 'DROP EVENT e_0' has been binary-logged before committed in the engine *** 362SET @@SESSION.debug="+d,crash_commit_after_log"; 363DROP EVENT e_0; 364ERROR HY000: Lost connection to MySQL server during query 365# restart 366include/gtid_step_assert.inc [count=1, only_count=0] 367include/gtid_step_reset.inc 368FLUSH LOGS; 369*** Crash right after 'CREATE VIEW v_0 AS SELECT * FROM t_1' has been prepared in the engine before being logged *** 370SET @@SESSION.debug="+d,crash_commit_before_log"; 371CREATE VIEW v_0 AS SELECT * FROM t_1; 372ERROR HY000: Lost connection to MySQL server during query 373# restart 374include/gtid_step_assert.inc [count=0, only_count=0] 375FLUSH LOGS; 376*** Crash right after 'CREATE VIEW v_0 AS SELECT * FROM t_1' has been binary-logged before committed in the engine *** 377SET @@SESSION.debug="+d,crash_commit_after_log"; 378CREATE VIEW v_0 AS SELECT * FROM t_1; 379ERROR HY000: Lost connection to MySQL server during query 380# restart 381include/gtid_step_assert.inc [count=1, only_count=0] 382include/gtid_step_reset.inc 383FLUSH LOGS; 384*** Crash right after 'ALTER VIEW v_0 AS SELECT * FROM t_1' has been prepared in the engine before being logged *** 385SET @@SESSION.debug="+d,crash_commit_before_log"; 386ALTER VIEW v_0 AS SELECT * FROM t_1; 387ERROR HY000: Lost connection to MySQL server during query 388# restart 389include/gtid_step_assert.inc [count=0, only_count=0] 390FLUSH LOGS; 391*** Crash right after 'ALTER VIEW v_0 AS SELECT * FROM t_1' has been binary-logged before committed in the engine *** 392SET @@SESSION.debug="+d,crash_commit_after_log"; 393ALTER VIEW v_0 AS SELECT * FROM t_1; 394ERROR HY000: Lost connection to MySQL server during query 395# restart 396include/gtid_step_assert.inc [count=1, only_count=0] 397include/gtid_step_reset.inc 398FLUSH LOGS; 399*** Crash right after 'DROP VIEW v_0' has been prepared in the engine before being logged *** 400SET @@SESSION.debug="+d,crash_commit_before_log"; 401DROP VIEW v_0; 402ERROR HY000: Lost connection to MySQL server during query 403# restart 404include/gtid_step_assert.inc [count=0, only_count=0] 405FLUSH LOGS; 406*** Crash right after 'DROP VIEW v_0' has been binary-logged before committed in the engine *** 407SET @@SESSION.debug="+d,crash_commit_after_log"; 408DROP VIEW v_0; 409ERROR HY000: Lost connection to MySQL server during query 410# restart 411include/gtid_step_assert.inc [count=1, only_count=0] 412include/gtid_step_reset.inc 413FLUSH LOGS; 414*** Crash right after 'CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example_LIB'' has been prepared in the engine before being logged *** 415SET @@SESSION.debug="+d,crash_commit_before_log"; 416CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example_LIB'; 417ERROR HY000: Lost connection to MySQL server during query 418# restart 419include/gtid_step_assert.inc [count=0, only_count=0] 420FLUSH LOGS; 421*** Crash right after 'CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example_LIB'' has been binary-logged before committed in the engine *** 422SET @@SESSION.debug="+d,crash_commit_after_log"; 423CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example_LIB'; 424ERROR HY000: Lost connection to MySQL server during query 425# restart 426include/gtid_step_assert.inc [count=1, only_count=0] 427include/gtid_step_reset.inc 428FLUSH LOGS; 429*** Crash right after 'DROP FUNCTION metaphon;' has been prepared in the engine before being logged *** 430SET @@SESSION.debug="+d,crash_commit_before_log"; 431DROP FUNCTION metaphon;; 432ERROR HY000: Lost connection to MySQL server during query 433# restart 434include/gtid_step_assert.inc [count=0, only_count=0] 435FLUSH LOGS; 436*** Crash right after 'DROP FUNCTION metaphon;' has been binary-logged before committed in the engine *** 437SET @@SESSION.debug="+d,crash_commit_after_log"; 438DROP FUNCTION metaphon;; 439ERROR HY000: Lost connection to MySQL server during query 440# restart 441include/gtid_step_assert.inc [count=1, only_count=0] 442include/gtid_step_reset.inc 443FLUSH LOGS; 444*** Crash right after 'CREATE TABLE test.t1(a int)' has been prepared in the engine before being logged *** 445SET @@SESSION.debug="+d,crash_commit_before_log"; 446CREATE TABLE test.t1(a int); 447ERROR HY000: Lost connection to MySQL server during query 448# restart 449include/gtid_step_assert.inc [count=0, only_count=0] 450FLUSH LOGS; 451*** Crash right after 'CREATE TABLE test.t1(a int)' has been binary-logged before committed in the engine *** 452SET @@SESSION.debug="+d,crash_commit_after_log"; 453CREATE TABLE test.t1(a int); 454ERROR HY000: Lost connection to MySQL server during query 455# restart 456include/gtid_step_assert.inc [count=1, only_count=0] 457include/gtid_step_reset.inc 458FLUSH LOGS; 459*** Crash right after 'ALTER TABLE test.t1 ADD COLUMN t1_new_col varchar(100);' has been prepared in the engine before being logged *** 460SET @@SESSION.debug="+d,crash_commit_before_log"; 461ALTER TABLE test.t1 ADD COLUMN t1_new_col varchar(100);; 462ERROR HY000: Lost connection to MySQL server during query 463# restart 464include/gtid_step_assert.inc [count=0, only_count=0] 465FLUSH LOGS; 466*** Crash right after 'ALTER TABLE test.t1 ADD COLUMN t1_new_col varchar(100);' has been binary-logged before committed in the engine *** 467SET @@SESSION.debug="+d,crash_commit_after_log"; 468ALTER TABLE test.t1 ADD COLUMN t1_new_col varchar(100);; 469ERROR HY000: Lost connection to MySQL server during query 470# restart 471include/gtid_step_assert.inc [count=1, only_count=0] 472include/gtid_step_reset.inc 473FLUSH LOGS; 474*** Crash right after 'ALTER TABLE test.t1 ADD index new_t1_idx(t1_new_col);' has been prepared in the engine before being logged *** 475SET @@SESSION.debug="+d,crash_commit_before_log"; 476ALTER TABLE test.t1 ADD index new_t1_idx(t1_new_col);; 477ERROR HY000: Lost connection to MySQL server during query 478# restart 479include/gtid_step_assert.inc [count=0, only_count=0] 480FLUSH LOGS; 481*** Crash right after 'ALTER TABLE test.t1 ADD index new_t1_idx(t1_new_col);' has been binary-logged before committed in the engine *** 482SET @@SESSION.debug="+d,crash_commit_after_log"; 483ALTER TABLE test.t1 ADD index new_t1_idx(t1_new_col);; 484ERROR HY000: Lost connection to MySQL server during query 485# restart 486include/gtid_step_assert.inc [count=1, only_count=0] 487include/gtid_step_reset.inc 488FLUSH LOGS; 489*** Crash right after 'ALTER TABLE test.t1 RENAME TO test.t2' has been prepared in the engine before being logged *** 490SET @@SESSION.debug="+d,crash_commit_before_log"; 491ALTER TABLE test.t1 RENAME TO test.t2; 492ERROR HY000: Lost connection to MySQL server during query 493# restart 494include/gtid_step_assert.inc [count=0, only_count=0] 495FLUSH LOGS; 496*** Crash right after 'ALTER TABLE test.t1 RENAME TO test.t2' has been binary-logged before committed in the engine *** 497SET @@SESSION.debug="+d,crash_commit_after_log"; 498ALTER TABLE test.t1 RENAME TO test.t2; 499ERROR HY000: Lost connection to MySQL server during query 500# restart 501include/gtid_step_assert.inc [count=1, only_count=0] 502include/gtid_step_reset.inc 503FLUSH LOGS; 504*** Crash right after 'ALTER TABLE test.t2 DROP COLUMN a;' has been prepared in the engine before being logged *** 505SET @@SESSION.debug="+d,crash_commit_before_log"; 506ALTER TABLE test.t2 DROP COLUMN a;; 507ERROR HY000: Lost connection to MySQL server during query 508# restart 509include/gtid_step_assert.inc [count=0, only_count=0] 510FLUSH LOGS; 511*** Crash right after 'ALTER TABLE test.t2 DROP COLUMN a;' has been binary-logged before committed in the engine *** 512SET @@SESSION.debug="+d,crash_commit_after_log"; 513ALTER TABLE test.t2 DROP COLUMN a;; 514ERROR HY000: Lost connection to MySQL server during query 515# restart 516include/gtid_step_assert.inc [count=1, only_count=0] 517include/gtid_step_reset.inc 518FLUSH LOGS; 519*** Crash right after 'TRUNCATE TABLE test.t2' has been prepared in the engine before being logged *** 520SET @@SESSION.debug="+d,crash_commit_before_log"; 521TRUNCATE TABLE test.t2; 522ERROR HY000: Lost connection to MySQL server during query 523# restart 524include/gtid_step_assert.inc [count=0, only_count=0] 525FLUSH LOGS; 526*** Crash right after 'TRUNCATE TABLE test.t2' has been binary-logged before committed in the engine *** 527SET @@SESSION.debug="+d,crash_commit_after_log"; 528TRUNCATE TABLE test.t2; 529ERROR HY000: Lost connection to MySQL server during query 530# restart 531include/gtid_step_assert.inc [count=1, only_count=0] 532include/gtid_step_reset.inc 533FLUSH LOGS; 534*** 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 *** 535SET @@SESSION.debug="+d,crash_commit_before_log"; 536ALTER TABLE test.t2 ADD fulltext index full_t2_idx(t1_new_col);; 537ERROR HY000: Lost connection to MySQL server during query 538# restart 539include/gtid_step_assert.inc [count=0, only_count=0] 540FLUSH LOGS; 541*** 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 *** 542SET @@SESSION.debug="+d,crash_commit_after_log"; 543ALTER TABLE test.t2 ADD fulltext index full_t2_idx(t1_new_col);; 544ERROR HY000: Lost connection to MySQL server during query 545# restart 546include/gtid_step_assert.inc [count=1, only_count=0] 547include/gtid_step_reset.inc 548FLUSH LOGS; 549*** Crash right after 'ALTER TABLE test.t2 DROP index full_t2_idx;' has been prepared in the engine before being logged *** 550SET @@SESSION.debug="+d,crash_commit_before_log"; 551ALTER TABLE test.t2 DROP index full_t2_idx;; 552ERROR HY000: Lost connection to MySQL server during query 553# restart 554include/gtid_step_assert.inc [count=0, only_count=0] 555FLUSH LOGS; 556*** Crash right after 'ALTER TABLE test.t2 DROP index full_t2_idx;' has been binary-logged before committed in the engine *** 557SET @@SESSION.debug="+d,crash_commit_after_log"; 558ALTER TABLE test.t2 DROP index full_t2_idx;; 559ERROR HY000: Lost connection to MySQL server during query 560# restart 561include/gtid_step_assert.inc [count=1, only_count=0] 562include/gtid_step_reset.inc 563FLUSH LOGS; 564*** Crash right after 'DROP TABLE test.t2' has been prepared in the engine before being logged *** 565SET @@SESSION.debug="+d,crash_commit_before_log"; 566DROP TABLE test.t2; 567ERROR HY000: Lost connection to MySQL server during query 568# restart 569include/gtid_step_assert.inc [count=0, only_count=0] 570FLUSH LOGS; 571*** Crash right after 'DROP TABLE test.t2' has been binary-logged before committed in the engine *** 572SET @@SESSION.debug="+d,crash_commit_after_log"; 573DROP TABLE test.t2; 574ERROR HY000: Lost connection to MySQL server during query 575# restart 576include/gtid_step_assert.inc [count=1, only_count=0] 577include/gtid_step_reset.inc 578FLUSH LOGS; 579*** Crash right after 'CREATE TABLESPACE ts ADD DATAFILE 'ts_0.ibd'' has been prepared in the engine before being logged *** 580SET @@SESSION.debug="+d,crash_commit_before_log"; 581CREATE TABLESPACE ts ADD DATAFILE 'ts_0.ibd'; 582ERROR HY000: Lost connection to MySQL server during query 583# restart 584include/gtid_step_assert.inc [count=0, only_count=0] 585FLUSH LOGS; 586*** Crash right after 'CREATE TABLESPACE ts ADD DATAFILE 'ts_0.ibd'' has been binary-logged before committed in the engine *** 587SET @@SESSION.debug="+d,crash_commit_after_log"; 588CREATE TABLESPACE ts ADD DATAFILE 'ts_0.ibd'; 589ERROR HY000: Lost connection to MySQL server during query 590# restart 591include/gtid_step_assert.inc [count=1, only_count=0] 592include/gtid_step_reset.inc 593FLUSH LOGS; 594*** Crash right after 'DROP TABLESPACE ts' has been prepared in the engine before being logged *** 595SET @@SESSION.debug="+d,crash_commit_before_log"; 596DROP TABLESPACE ts; 597ERROR HY000: Lost connection to MySQL server during query 598# restart 599include/gtid_step_assert.inc [count=0, only_count=0] 600FLUSH LOGS; 601*** Crash right after 'DROP TABLESPACE ts' has been binary-logged before committed in the engine *** 602SET @@SESSION.debug="+d,crash_commit_after_log"; 603DROP TABLESPACE ts; 604ERROR HY000: Lost connection to MySQL server during query 605# restart 606include/gtid_step_assert.inc [count=1, only_count=0] 607include/gtid_step_reset.inc 608FLUSH LOGS; 609*** Crash right after 'CREATE TABLE test.t1(a int)' has been prepared in the engine before being logged *** 610SET @@SESSION.debug="+d,crash_commit_before_log"; 611CREATE TABLE test.t1(a int); 612ERROR HY000: Lost connection to MySQL server during query 613# restart 614include/gtid_step_assert.inc [count=0, only_count=0] 615FLUSH LOGS; 616*** Crash right after 'CREATE TABLE test.t1(a int)' has been binary-logged before committed in the engine *** 617SET @@SESSION.debug="+d,crash_commit_after_log"; 618CREATE TABLE test.t1(a int); 619ERROR HY000: Lost connection to MySQL server during query 620# restart 621include/gtid_step_assert.inc [count=1, only_count=0] 622include/gtid_step_reset.inc 623FLUSH LOGS; 624*** Crash right after 'CREATE TABLE test.t2 AS SELECT * FROM t1;' has been prepared in the engine before being logged *** 625SET @@SESSION.debug="+d,crash_commit_before_log"; 626CREATE TABLE test.t2 AS SELECT * FROM t1;; 627ERROR HY000: Lost connection to MySQL server during query 628# restart 629include/gtid_step_assert.inc [count=0, only_count=0] 630FLUSH LOGS; 631*** Crash right after 'CREATE TABLE test.t2 AS SELECT * FROM t1;' has been binary-logged before committed in the engine *** 632SET @@SESSION.debug="+d,crash_commit_after_log"; 633CREATE TABLE test.t2 AS SELECT * FROM t1;; 634ERROR HY000: Lost connection to MySQL server during query 635# restart 636include/gtid_step_assert.inc [count=1, only_count=0] 637include/gtid_step_reset.inc 638FLUSH LOGS; 639*** Crash right after 'DROP TABLE test.t1' has been prepared in the engine before being logged *** 640SET @@SESSION.debug="+d,crash_commit_before_log"; 641DROP TABLE test.t1; 642ERROR HY000: Lost connection to MySQL server during query 643# restart 644include/gtid_step_assert.inc [count=0, only_count=0] 645FLUSH LOGS; 646*** Crash right after 'DROP TABLE test.t1' has been binary-logged before committed in the engine *** 647SET @@SESSION.debug="+d,crash_commit_after_log"; 648DROP TABLE test.t1; 649ERROR HY000: Lost connection to MySQL server during query 650# restart 651include/gtid_step_assert.inc [count=1, only_count=0] 652include/gtid_step_reset.inc 653FLUSH LOGS; 654*** Crash right after 'DROP TABLE test.t2' has been prepared in the engine before being logged *** 655SET @@SESSION.debug="+d,crash_commit_before_log"; 656DROP TABLE test.t2; 657ERROR HY000: Lost connection to MySQL server during query 658# restart 659include/gtid_step_assert.inc [count=0, only_count=0] 660FLUSH LOGS; 661*** Crash right after 'DROP TABLE test.t2' has been binary-logged before committed in the engine *** 662SET @@SESSION.debug="+d,crash_commit_after_log"; 663DROP TABLE test.t2; 664ERROR HY000: Lost connection to MySQL server during query 665# restart 666include/gtid_step_assert.inc [count=1, only_count=0] 667RESET MASTER; 668include/gtid_step_reset.inc 669include/gtid_step_assert.inc [count=1, only_count=1] 670include/gtid_step_reset.inc 671FLUSH LOGS; 672*** Crash right after 'DROP USER user1' has been prepared in the engine before being logged *** 673SET @@SESSION.debug="+d,crash_commit_before_log"; 674DROP USER user1; 675ERROR HY000: Lost connection to MySQL server during query 676# restart 677include/gtid_step_assert.inc [count=0, only_count=1] 678FLUSH LOGS; 679*** Crash right after 'DROP USER user1' has been binary-logged before committed in the engine *** 680SET @@SESSION.debug="+d,crash_commit_after_log"; 681DROP USER user1; 682ERROR HY000: Lost connection to MySQL server during query 683# restart 684include/gtid_step_assert.inc [count=1, only_count=1] 685DROP TABLE t_1; 686include/gtid_utils_end.inc 687