Debian Codegraph @

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

raw
1 # ###########################################################
2 # Prepare
3 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENGINE=InnoDB;
4 CREATE TABLE t1
5 (c1 VARCHAR(300), c2 TEXT)
6 ENGINE=InnoDB
7 ROW_FORMAT=REDUNDANT
8 TABLESPACE innodb_file_per_table;
9 # ###########################################################
10 # Inject error during bulk insert
11 SET debug = '+d,ddl_btree_build_too_big_record';
12 ALTER TABLE t1 TABLESPACE ts1;
13 ERROR 42000: Row size too large. The maximum row size for the used table type, not counting BLOBs, is #value#. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
14 SET debug = '-d,ddl_btree_build_too_big_record';
15 FLUSH TABLES;
16 # ###########################################################
17 # Inject error during bulk reserve space
18 SET debug = '+d,ddl_btree_build_oom';
19 ALTER TABLE t1 TABLESPACE ts1;
20 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
21 FLUSH TABLES;
22 SET debug = '-d,ddl_btree_build_oom';
23 # ###########################################################
24 # No error - check for final success
25 ALTER TABLE t1 TABLESPACE ts1;
26 FLUSH TABLES;
27 # ###########################################################
28 # Cleanup
29 DROP TABLE t1;
30 DROP TABLESPACE ts1;
31 # ###########################################################
32 # Prepare
33 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENGINE=InnoDB;
34 CREATE TABLE t1
35 (c1 VARCHAR(300), c2 TEXT)
36 ENGINE=InnoDB
37 ROW_FORMAT=COMPACT
38 TABLESPACE innodb_file_per_table;
39 # ###########################################################
40 # Inject error during bulk insert
41 SET debug = '+d,ddl_btree_build_too_big_record';
42 ALTER TABLE t1 TABLESPACE ts1;
43 ERROR 42000: Row size too large. The maximum row size for the used table type, not counting BLOBs, is #value#. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
44 SET debug = '-d,ddl_btree_build_too_big_record';
45 FLUSH TABLES;
46 # ###########################################################
47 # Inject error during bulk reserve space
48 SET debug = '+d,ddl_btree_build_oom';
49 ALTER TABLE t1 TABLESPACE ts1;
50 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
51 FLUSH TABLES;
52 SET debug = '-d,ddl_btree_build_oom';
53 # ###########################################################
54 # No error - check for final success
55 ALTER TABLE t1 TABLESPACE ts1;
56 FLUSH TABLES;
57 # ###########################################################
58 # Cleanup
59 DROP TABLE t1;
60 DROP TABLESPACE ts1;
61 # ###########################################################
62 # Prepare
63 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENGINE=InnoDB;
64 CREATE TABLE t1
65 (c1 VARCHAR(300), c2 TEXT)
66 ENGINE=InnoDB
67 ROW_FORMAT=DYNAMIC
68 TABLESPACE innodb_file_per_table;
69 # ###########################################################
70 # Inject error during bulk insert
71 SET debug = '+d,ddl_btree_build_too_big_record';
72 ALTER TABLE t1 TABLESPACE ts1;
73 ERROR 42000: Row size too large. The maximum row size for the used table type, not counting BLOBs, is #value#. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
74 SET debug = '-d,ddl_btree_build_too_big_record';
75 FLUSH TABLES;
76 # ###########################################################
77 # Inject error during bulk reserve space
78 SET debug = '+d,ddl_btree_build_oom';
79 ALTER TABLE t1 TABLESPACE ts1;
80 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
81 FLUSH TABLES;
82 SET debug = '-d,ddl_btree_build_oom';
83 # ###########################################################
84 # No error - check for final success
85 ALTER TABLE t1 TABLESPACE ts1;
86 FLUSH TABLES;
87 # ###########################################################
88 # Cleanup
89 DROP TABLE t1;
90 DROP TABLESPACE ts1;
91 # ###########################################################
92 # Prepare
93 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' FILE_BLOCK_SIZE=4096 ENGINE=InnoDB;
94 CREATE TABLE t1
95 (c1 VARCHAR(300), c2 TEXT)
96 ENGINE=InnoDB
97 ROW_FORMAT=COMPRESSED
98 KEY_BLOCK_SIZE=4
99 TABLESPACE innodb_file_per_table;
100 # ###########################################################
101 # Inject error during bulk insert
102 SET debug = '+d,ddl_btree_build_too_big_record';
103 ALTER TABLE t1 TABLESPACE ts1;
104 ERROR 42000: Row size too large. The maximum row size for the used table type, not counting BLOBs, is #value#. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
105 SET debug = '-d,ddl_btree_build_too_big_record';
106 FLUSH TABLES;
107 # ###########################################################
108 # Inject error during bulk reserve space
109 SET debug = '+d,ddl_btree_build_oom';
110 ALTER TABLE t1 TABLESPACE ts1;
111 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
112 FLUSH TABLES;
113 SET debug = '-d,ddl_btree_build_oom';
114 # ###########################################################
115 # No error - check for final success
116 ALTER TABLE t1 TABLESPACE ts1;
117 FLUSH TABLES;
118 # ###########################################################
119 # Cleanup
120 DROP TABLE t1;
121 DROP TABLESPACE ts1;