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