Debian Codegraph @

mysql-test/suite/binlog/r/binlog_half_crash_safe_ddl.result

raw
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