| 1 |
include/gtid_utils.inc |
| 2 |
include/gtid_step_reset.inc |
| 3 |
FLUSH LOGS; |
| 4 |
*** Crash right after 'CREATE TABLE t_2 (a int auto_increment primary key)' has been binary-logged before committed in the engine *** |
| 5 |
SET @@SESSION.debug="+d,crash_commit_after_log"; |
| 6 |
CREATE TABLE t_2 (a int auto_increment primary key); |
| 7 |
ERROR HY000: Lost connection to MySQL server during query |
| 8 |
# restart |
| 9 |
include/show_binlog_events.inc |
| 10 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 11 |
# # Query # # use `test`; CREATE TABLE t_2 (a int auto_increment primary key) /* XID # */ |
| 12 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 13 |
include/gtid_step_reset.inc |
| 14 |
FLUSH LOGS; |
| 15 |
*** Crash right after 'ALTER TABLE t_2 ADD COLUMN b INT NOT NULL, ALGORITHM=COPY, COMMENT 'Col b copy-added'' has been binary-logged before committed in the engine *** |
| 16 |
SET @@SESSION.debug="+d,crash_commit_after_log"; |
| 17 |
ALTER TABLE t_2 ADD COLUMN b INT NOT NULL, ALGORITHM=COPY, COMMENT 'Col b copy-added'; |
| 18 |
ERROR HY000: Lost connection to MySQL server during query |
| 19 |
# restart |
| 20 |
include/show_binlog_events.inc |
| 21 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 22 |
# # Query # # use `test`; ALTER TABLE t_2 ADD COLUMN b INT NOT NULL, ALGORITHM=COPY, COMMENT 'Col b copy-added' /* XID # */ |
| 23 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 24 |
include/gtid_step_reset.inc |
| 25 |
FLUSH LOGS; |
| 26 |
*** Crash right after 'ALTER TABLE t_2 ADD INDEX idx(b), ALGORITHM= INPLACE, COMMENT 'Index on b inplace-added'' has been binary-logged before committed in the engine *** |
| 27 |
SET @@SESSION.debug="+d,crash_commit_after_log"; |
| 28 |
ALTER TABLE t_2 ADD INDEX idx(b), ALGORITHM= INPLACE, COMMENT 'Index on b inplace-added'; |
| 29 |
ERROR HY000: Lost connection to MySQL server during query |
| 30 |
# restart |
| 31 |
include/show_binlog_events.inc |
| 32 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 33 |
# # Query # # use `test`; ALTER TABLE t_2 ADD INDEX idx(b), ALGORITHM= INPLACE, COMMENT 'Index on b inplace-added' /* XID # */ |
| 34 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 35 |
include/gtid_step_reset.inc |
| 36 |
FLUSH LOGS; |
| 37 |
*** Crash right after 'ALTER TABLE t_2 RENAME t_3' has been binary-logged before committed in the engine *** |
| 38 |
SET @@SESSION.debug="+d,crash_commit_after_log"; |
| 39 |
ALTER TABLE t_2 RENAME t_3; |
| 40 |
ERROR HY000: Lost connection to MySQL server during query |
| 41 |
# restart |
| 42 |
include/show_binlog_events.inc |
| 43 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 44 |
# # Query # # use `test`; ALTER TABLE t_2 RENAME t_3 /* XID # */ |
| 45 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 46 |
include/gtid_step_reset.inc |
| 47 |
FLUSH LOGS; |
| 48 |
*** Crash right after 'RENAME TABLE t_3 TO t_2 /* Name restored */' has been binary-logged before committed in the engine *** |
| 49 |
SET @@SESSION.debug="+d,crash_commit_after_log"; |
| 50 |
RENAME TABLE t_3 TO t_2 /* Name restored */; |
| 51 |
ERROR HY000: Lost connection to MySQL server during query |
| 52 |
# restart |
| 53 |
include/show_binlog_events.inc |
| 54 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 55 |
# # Query # # use `test`; RENAME TABLE t_3 TO t_2 /* Name restored */ /* XID # */ |
| 56 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 57 |
include/gtid_step_reset.inc |
| 58 |
FLUSH LOGS; |
| 59 |
*** Crash right after 'INSERT INTO t_2 SET a=1,b=1' has been binary-logged before committed in the engine *** |
| 60 |
SET @@SESSION.debug="+d,crash_commit_after_log"; |
| 61 |
INSERT INTO t_2 SET a=1,b=1; |
| 62 |
ERROR HY000: Lost connection to MySQL server during query |
| 63 |
# restart |
| 64 |
include/show_binlog_events.inc |
| 65 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 66 |
# # Query # # BEGIN |
| 67 |
# # Query # # use `test`; INSERT INTO t_2 SET a=1,b=1 |
| 68 |
# # Xid # # COMMIT /* XID */ |
| 69 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 70 |
include/gtid_step_reset.inc |
| 71 |
FLUSH LOGS; |
| 72 |
*** Crash right after 'TRUNCATE TABLE t_2' has been binary-logged before committed in the engine *** |
| 73 |
SET @@SESSION.debug="+d,crash_commit_after_log"; |
| 74 |
TRUNCATE TABLE t_2; |
| 75 |
ERROR HY000: Lost connection to MySQL server during query |
| 76 |
# restart |
| 77 |
include/show_binlog_events.inc |
| 78 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 79 |
# # Query # # use `test`; TRUNCATE TABLE t_2 /* XID # */ |
| 80 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 81 |
include/gtid_step_reset.inc |
| 82 |
FLUSH LOGS; |
| 83 |
*** Crash right after 'CREATE TABLESPACE ts_0 ADD DATAFILE 'ts_0.ibd'' has been binary-logged before committed in the engine *** |
| 84 |
SET @@SESSION.debug="+d,crash_commit_after_log"; |
| 85 |
CREATE TABLESPACE ts_0 ADD DATAFILE 'ts_0.ibd'; |
| 86 |
ERROR HY000: Lost connection to MySQL server during query |
| 87 |
# restart |
| 88 |
include/show_binlog_events.inc |
| 89 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 90 |
# # Query # # use `test`; CREATE TABLESPACE ts_0 ADD DATAFILE 'ts_0.ibd' /* XID # */ |
| 91 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 92 |
include/gtid_step_reset.inc |
| 93 |
FLUSH LOGS; |
| 94 |
*** Crash right after 'DROP TABLESPACE ts_0' has been binary-logged before committed in the engine *** |
| 95 |
SET @@SESSION.debug="+d,crash_commit_after_log"; |
| 96 |
DROP TABLESPACE ts_0; |
| 97 |
ERROR HY000: Lost connection to MySQL server during query |
| 98 |
# restart |
| 99 |
include/show_binlog_events.inc |
| 100 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 101 |
# # Query # # use `test`; DROP TABLESPACE ts_0 /* XID # */ |
| 102 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 103 |
include/gtid_step_reset.inc |
| 104 |
FLUSH LOGS; |
| 105 |
*** Crash right after 'CREATE DATABASE db_0 DEFAULT COLLATE latin1_general_ci' has been binary-logged before committed in the engine *** |
| 106 |
SET @@SESSION.debug="+d,crash_commit_after_log"; |
| 107 |
CREATE DATABASE db_0 DEFAULT COLLATE latin1_general_ci; |
| 108 |
ERROR HY000: Lost connection to MySQL server during query |
| 109 |
# restart |
| 110 |
include/show_binlog_events.inc |
| 111 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 112 |
# # Query # # CREATE DATABASE db_0 DEFAULT COLLATE latin1_general_ci /* XID # */ |
| 113 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 114 |
include/gtid_step_reset.inc |
| 115 |
FLUSH LOGS; |
| 116 |
*** Crash right after 'ALTER DATABASE db_0 DEFAULT COLLATE utf8mb3_general_ci' has been binary-logged before committed in the engine *** |
| 117 |
SET @@SESSION.debug="+d,crash_commit_after_log"; |
| 118 |
ALTER DATABASE db_0 DEFAULT COLLATE utf8mb3_general_ci; |
| 119 |
ERROR HY000: Lost connection to MySQL server during query |
| 120 |
# restart |
| 121 |
include/show_binlog_events.inc |
| 122 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 123 |
# # Query # # ALTER DATABASE db_0 DEFAULT COLLATE utf8mb3_general_ci /* XID # */ |
| 124 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 125 |
include/gtid_step_reset.inc |
| 126 |
FLUSH LOGS; |
| 127 |
*** Crash right after 'DROP DATABASE db_0' has been binary-logged before committed in the engine *** |
| 128 |
SET @@SESSION.debug="+d,crash_commit_after_log"; |
| 129 |
DROP DATABASE db_0; |
| 130 |
ERROR HY000: Lost connection to MySQL server during query |
| 131 |
# restart |
| 132 |
include/show_binlog_events.inc |
| 133 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 134 |
# # Query # # DROP DATABASE db_0 /* XID # */ |
| 135 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 136 |
include/gtid_step_reset.inc |
| 137 |
FLUSH LOGS; |
| 138 |
*** Crash right after 'DROP TABLE t_2' has been binary-logged before committed in the engine *** |
| 139 |
SET @@SESSION.debug="+d,crash_commit_after_log"; |
| 140 |
DROP TABLE t_2; |
| 141 |
ERROR HY000: Lost connection to MySQL server during query |
| 142 |
# restart |
| 143 |
include/show_binlog_events.inc |
| 144 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 145 |
# # Query # # use `test`; DROP TABLE `t_2` /* generated by server */ /* XID # */ |
| 146 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 147 |
include/gtid_utils_end.inc |