Debian Codegraph @

mysql-test/suite/innodb/r/ddl_log_error.result

raw
1 # Setup
2 CREATE TABLE t1 (c1 INT);
3 CREATE TABLESPACE my_ts ADD DATAFILE "my_ts.ibd";
4 SET SESSION DEBUG="+d,ddl_log_return_error_from_insert";
5 # Run few DDLs. All DDLs should give error now.
6 ALTER TABLE t1 RENAME to t2;
7 ERROR HY000: Error on rename of './test/t1' to './test/t2' (errno: 168 - Unknown (generic) error from engine)
8 ALTER TABLE t1 ADD COLUMN c2 INT, ALGORITHM=COPY;
9 ERROR HY000: Got error 168 - 'Unknown (generic) error from engine' from storage engine
10 ALTER TABLE t1 ADD COLUMN c2 INT, ALGORITHM=INPLACE;
11 ERROR HY000: Got error 11 - 'InnoDB error' from storage engine
12 DROP TABLE t1;
13 ERROR HY000: Storage engine can't drop table 'test.t1'
14 SET SESSION DEBUG="-d,ddl_log_return_error_from_insert";
15 # Restart with keyring plugin
16 SET SESSION DEBUG="+d,ddl_log_return_error_from_insert";
17 ALTER TABLESPACE my_ts ENCRYPTION='Y';
18 ERROR HY000: Failed to alter: TABLESPACE my_ts
19 SET SESSION DEBUG="-d,ddl_log_return_error_from_insert";
20 # Cleanup
21 DROP TABLESPACE my_ts;
22 DROP TABLE t1;
23 # Restarting server without keyring to restore server state
24 # restart:
25 #
26 # Bug #32716838 ALTER TABLE MAY CRASH IF DDL LOG LOSE,
27 # IN NON-FILE-PER-TABLE MODE
28 #
29 SET @innodb_file_per_table_orig=@@innodb_file_per_table;
30 SET GLOBAL innodb_file_per_table = 0;
31 SELECT @@innodb_file_per_table;
32 @@innodb_file_per_table
33 0
34 # Setup
35 CREATE TABLE t1 (c1 INT);
36 SET SESSION DEBUG="+d,ddl_log_return_error_from_insert";
37 # Run few DDLs. All DDLs should give error now.
38 ALTER TABLE t1 ADD COLUMN c2 INT, ALGORITHM=COPY;
39 ERROR HY000: Got error 168 - 'Unknown (generic) error from engine' from storage engine
40 ALTER TABLE t1 ADD COLUMN c2 INT, ALGORITHM=INPLACE;
41 ERROR HY000: Got error 11 - 'InnoDB error' from storage engine
42 DROP TABLE t1;
43 ERROR HY000: Storage engine can't drop table 'test.t1'
44 SET SESSION DEBUG="-d,ddl_log_return_error_from_insert";
45 # Cleanup
46 DROP TABLE t1;
47 SET GLOBAL innodb_file_per_table=@innodb_file_per_table_orig;