Debian Codegraph @

mysql-test/suite/innodb/t/builder_error_case.test

raw
1 --source include/have_debug.inc
2 # Bug scenario:
3 # When DDL is on-going and hits an error (for example when row log is full or
4 # duplicate key entry is found); it must rollback and cleanup correctly.
5 # The error handling code must call m_btr_load->finish and ensure that all pages
6 # buffer fixed are released.
7
8 --echo # Create big enough table to ensure another call to Builder::insert_direct
9 CREATE TABLE t1 (c1 INT);
10
11 --disable_query_log
12 DELIMITER |;
13 CREATE PROCEDURE populate_t1(IN BASE INT, IN SIZE INT)
14 BEGIN
15 DECLARE i INT DEFAULT BASE;
16 WHILE (i + 10 <= SIZE) DO
17 INSERT INTO t1 values (i), (i+1), (i+2), (i+3), (i+4), (i+5), (i+6), (i+7), (i+8), (i+9);
18 SET i = i + 10;
19 END WHILE;
20 END|
21 DELIMITER ;|
22
23 # Note that inserting anything less than 10700 doesn't cause key_buffer to
24 # overflow on 32 bit platforms - this causes a single call to
25 # Builder::insert_direct. In case of 64 bit platforms, this number is 9892. The
26 # reason for this difference is because of different values for sizeof the
27 # Key_sort_buffer::m_dtuples on different architecture. Kept at 11000 just to be
28 # ensure second call to Builder::insert_direct
29 CALL populate_t1(0, 11000);
30 DROP PROCEDURE populate_t1;
31 --enable_query_log
32
33 SELECT COUNT(*) FROM t1;
34
35 --echo # Builder::insert_direct returns DB_ONLINE_LOG_TOO_BIG
36 SET DEBUG="+d,builder_insert_direct_trigger_error";
37 --error ER_INNODB_ONLINE_LOG_TOO_BIG
38 ALTER TABLE t1 ADD COLUMN c2 INT DEFAULT 20, ALGORITHM=INPLACE;
39 SET DEBUG="-d,builder_insert_direct_trigger_error";
40
41 --echo # Builder::add_row returns DB_ONLINE_LOG_TOO_BIG
42 SET DEBUG="+d,builder_add_row_trigger_error";
43 --error ER_INNODB_ONLINE_LOG_TOO_BIG
44 ALTER TABLE t1 ADD COLUMN c2 INT DEFAULT 20, ALGORITHM=INPLACE;
45 SET DEBUG="-d,builder_add_row_trigger_error";
46
47 call mtr.add_suppression("\\[InnoDB\\] DDL failed as Builder is already freed");
48
49 --echo # Builder::bulk_add_row returns DB_DUPLICATE_KEY
50 SET DEBUG="+d,builder_bulk_add_row_trigger_error_1";
51 OPTIMIZE TABLE t1;
52 SET DEBUG="-d,builder_bulk_add_row_trigger_error_1";
53
54 --echo # Builder::bulk_add_row returns DB_INVALID_NULL
55 SET DEBUG="+d,builder_bulk_add_row_trigger_error_2";
56 OPTIMIZE TABLE t1;
57 SET DEBUG="-d,builder_bulk_add_row_trigger_error_2";
58
59 --echo # Builder::bulk_add_row returns DB_IO_ERROR
60 SET DEBUG="+d,builder_bulk_add_row_trigger_error_3";
61 OPTIMIZE TABLE t1;
62 SET DEBUG="-d,builder_bulk_add_row_trigger_error_3";
63
64 --echo # ddl::pwrite returns DB_IO_ERROR
65 SET DEBUG="+d,builder_bulk_add_row_trigger_error_4";
66 OPTIMIZE TABLE t1;
67 SET DEBUG="-d,builder_bulk_add_row_trigger_error_4";
68
69 --echo # Pages still buffer fixed should assert during shutdown
70 --source include/shutdown_mysqld.inc
71 --source include/start_mysqld.inc
72
73 --echo # Cleanup
74 DROP TABLE t1;