| 1 |
call mtr.add_suppression("ERROR 1118 \\(42000\\) at line 106: Row size too large \\(> 8126\\)"); |
| 2 |
# Stop DB server which was created by MTR default |
| 3 |
# create bootstrap file |
| 4 |
# Run the bootstrap command with page size 32k |
| 5 |
# Start the DB server with page size 32k |
| 6 |
# restart: --innodb_page_size=32K --datadir=MYSQLD_DATADIR1 |
| 7 |
USE test; |
| 8 |
SELECT @@innodb_page_size; |
| 9 |
@@innodb_page_size |
| 10 |
32768 |
| 11 |
CREATE TABLE tab1(col1 CHAR (255), col2 CHAR (255), col3 CHAR(255),col4 CHAR(255), col5 CHAR(255), |
| 12 |
col6 CHAR(255), col7 CHAR(255), col8 CHAR(255), col9 CHAR(255),col10 CHAR(255), col11 CHAR(255), |
| 13 |
col12 CHAR(255), col13 CHAR(255),col14 CHAR(255),col15 CHAR(255),col16 CHAR(255), col17 CHAR(255), |
| 14 |
col18 CHAR(255),col19 CHAR(255),col20 CHAR(255),col21 CHAR(255),col22 CHAR(255), col23 CHAR(255), |
| 15 |
col24 CHAR(255),col25 CHAR(255),col26 CHAR(255),col27 CHAR(255),col28 CHAR(255), col29 CHAR(255), |
| 16 |
col30 CHAR(255),col31 CHAR(255),col32 CHAR(255),col33 CHAR(255),col34 CHAR(255), col35 CHAR(255), |
| 17 |
col36 CHAR(255),col37 CHAR(255),col38 CHAR(255),col39 CHAR(255),col40 CHAR(255), col41 CHAR(255), |
| 18 |
col42 CHAR(255),col43 CHAR(255),col44 CHAR(255),col45 CHAR(255),col46 CHAR(255), col47 CHAR(255), |
| 19 |
col48 CHAR(255),col49 CHAR(255),col50 CHAR(255),col51 CHAR(255),col52 CHAR(255), col53 CHAR(255), |
| 20 |
col54 CHAR(255),col55 CHAR(255),col56 CHAR(255),col57 CHAR(255),col58 CHAR(255), col59 CHAR(255), |
| 21 |
col60 CHAR(255),col61 CHAR(255),col62 CHAR(255),col63 CHAR(255)) ENGINE = innodb ; |
| 22 |
INSERT INTO tab1 VALUES(repeat('a1',127),repeat('a2',127),repeat('a3',127),repeat('a4',127), |
| 23 |
repeat('a5',127),repeat('a6',127),repeat('a7',127),repeat('a8',127),repeat('a9',127),repeat('a10',62), |
| 24 |
repeat('a11',62),repeat('a12',62),repeat('a13',62),repeat('a14',62),repeat('a15',62),repeat('a16',62), |
| 25 |
repeat('a17',62),repeat('a18',62),repeat('a19',62),repeat('a20',62),repeat('a21',62), |
| 26 |
repeat('a22',62),repeat('a23',62),repeat('a24',62),repeat('a25',62),repeat('a26',62), |
| 27 |
repeat('a27',62),repeat('a28',62),repeat('a29',62),repeat('a30',62),repeat('a31',62), |
| 28 |
repeat('a32',62),repeat('a33',62),repeat('a34',62),repeat('a35',62),repeat('a36',62), |
| 29 |
repeat('a37',62),repeat('a38',62),repeat('a39',62),repeat('a40',62),repeat('a41',62), |
| 30 |
repeat('a42',62),repeat('a43',62),repeat('a44',62),repeat('a45',62),repeat('a46',62), |
| 31 |
repeat('a47',62),repeat('a48',62),repeat('a49',62),repeat('a50',62),repeat('a51',62), |
| 32 |
repeat('a52',62),repeat('a53',62),repeat('a54',62),repeat('a55',62),repeat('a56',62), |
| 33 |
repeat('a57',62),repeat('a58',62),repeat('a59',62),repeat('a60',62),repeat('a61',62), |
| 34 |
repeat('a62',62),repeat('a63',62)); |
| 35 |
SET innodb_strict_mode=OFF; |
| 36 |
CREATE TABLE tab2(col1 CHAR (255), col2 CHAR (255), col3 CHAR(255),col4 CHAR(255), col5 CHAR(255), |
| 37 |
col6 CHAR(255), col7 CHAR(255), col8 CHAR(255), col9 CHAR(255),col10 CHAR(255), col11 CHAR(255), |
| 38 |
col12 CHAR(255), col13 CHAR(255),col14 CHAR(255),col15 CHAR(255),col16 CHAR(255), col17 CHAR(255), |
| 39 |
col18 CHAR(255),col19 CHAR(255),col20 CHAR(255),col21 CHAR(255),col22 CHAR(255), col23 CHAR(255), |
| 40 |
col24 CHAR(255),col25 CHAR(255),col26 CHAR(255),col27 CHAR(255),col28 CHAR(255), col29 CHAR(255), |
| 41 |
col30 CHAR(255),col31 CHAR(255),col32 CHAR(255),col33 CHAR(255),col34 CHAR(255), col35 CHAR(255), |
| 42 |
col36 CHAR(255),col37 CHAR(255),col38 CHAR(255),col39 CHAR(255),col40 CHAR(255), col41 CHAR(255), |
| 43 |
col42 CHAR(255),col43 CHAR(255),col44 CHAR(255),col45 CHAR(255),col46 CHAR(255), col47 CHAR(255), |
| 44 |
col48 CHAR(255),col49 CHAR(255),col50 CHAR(255),col51 CHAR(255),col52 CHAR(255), col53 CHAR(255), |
| 45 |
col54 CHAR(255),col55 CHAR(255),col56 CHAR(255),col57 CHAR(255),col58 CHAR(255), col59 CHAR(255), |
| 46 |
col60 CHAR(255),col61 CHAR(255),col62 CHAR(255),col63 CHAR(255),col64 CHAR(255)) ENGINE=innodb ROW_FORMAT=COMPACT; |
| 47 |
Warnings: |
| 48 |
Warning 139 Row size too large (> 16318). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline. |
| 49 |
INSERT INTO tab2 VALUES(repeat('a1',127),repeat('a2',127),repeat('a3',127),repeat('a4',127), |
| 50 |
repeat('a5',127),repeat('a6',127),repeat('a7',127),repeat('a8',127),repeat('a9',127),repeat('a10',62), |
| 51 |
repeat('a11',62),repeat('a12',62),repeat('a13',62),repeat('a14',62),repeat('a15',62),repeat('a16',62), |
| 52 |
repeat('a17',62),repeat('a18',62),repeat('a19',62),repeat('a20',62),repeat('a21',62), |
| 53 |
repeat('a22',62),repeat('a23',62),repeat('a24',62),repeat('a25',62),repeat('a26',62), |
| 54 |
repeat('a27',62),repeat('a28',62),repeat('a29',62),repeat('a30',62),repeat('a31',62), |
| 55 |
repeat('a32',62),repeat('a33',62),repeat('a34',62),repeat('a35',62),repeat('a36',62), |
| 56 |
repeat('a37',62),repeat('a38',62),repeat('a39',62),repeat('a40',62),repeat('a41',62), |
| 57 |
repeat('a42',62),repeat('a43',62),repeat('a44',62),repeat('a45',62),repeat('a46',62), |
| 58 |
repeat('a47',62),repeat('a48',62),repeat('a49',62),repeat('a50',62),repeat('a51',62), |
| 59 |
repeat('a52',62),repeat('a53',62),repeat('a54',62),repeat('a55',62),repeat('a56',62), |
| 60 |
repeat('a57',62),repeat('a58',62),repeat('a59',62),repeat('a60',62),repeat('a61',62), |
| 61 |
repeat('a62',62),repeat('a63',63),repeat('a64',63)); |
| 62 |
ERROR 42000: Row size too large (> 16318). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline. |
| 63 |
CREATE TABLE tab3(col1 CHAR (255), col2 CHAR (255), col3 CHAR(255),col4 CHAR(255), col5 CHAR(255), |
| 64 |
col6 CHAR(255), col7 CHAR(255), col8 CHAR(255), col9 CHAR(255),col10 CHAR(255), col11 CHAR(255), |
| 65 |
col12 CHAR(255), col13 CHAR(255),col14 CHAR(255),col15 CHAR(255),col16 CHAR(255), col17 CHAR(255), |
| 66 |
col18 CHAR(255),col19 CHAR(255),col20 CHAR(255),col21 CHAR(255),col22 CHAR(255), col23 CHAR(255), |
| 67 |
col24 CHAR(255),col25 CHAR(255),col26 CHAR(255),col27 CHAR(255),col28 CHAR(255), col29 CHAR(255), |
| 68 |
col30 CHAR(255),col31 CHAR(255),col32 CHAR(255),col33 CHAR(255),col34 CHAR(255), col35 CHAR(255), |
| 69 |
col36 CHAR(255),col37 CHAR(255),col38 CHAR(255),col39 CHAR(255),col40 CHAR(255), col41 CHAR(255), |
| 70 |
col42 CHAR(255),col43 CHAR(255),col44 CHAR(255),col45 CHAR(255),col46 CHAR(255), col47 CHAR(255), |
| 71 |
col48 CHAR(255),col49 CHAR(255),col50 CHAR(255),col51 CHAR(255),col52 CHAR(255), col53 CHAR(255), |
| 72 |
col54 CHAR(255),col55 CHAR(255),col56 CHAR(255),col57 CHAR(255),col58 CHAR(255), col59 CHAR(255), |
| 73 |
col60 CHAR(255),col61 CHAR(255),col62 CHAR(255),col63 CHAR(255)) ENGINE = innodb ROW_FORMAT=COMPRESSED; |
| 74 |
Warnings: |
| 75 |
Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC. |
| 76 |
INSERT INTO tab3 VALUES(repeat('a1',127),repeat('a2',127),repeat('a3',127),repeat('a4',127), |
| 77 |
repeat('a5',127),repeat('a6',127),repeat('a7',127),repeat('a8',127),repeat('a9',127),repeat('a10',62), |
| 78 |
repeat('a11',62),repeat('a12',62),repeat('a13',62),repeat('a14',62),repeat('a15',62),repeat('a16',62), |
| 79 |
repeat('a17',62),repeat('a18',62),repeat('a19',62),repeat('a20',62),repeat('a21',62), |
| 80 |
repeat('a22',62),repeat('a23',62),repeat('a24',62),repeat('a25',62),repeat('a26',62), |
| 81 |
repeat('a27',62),repeat('a28',62),repeat('a29',62),repeat('a30',62),repeat('a31',62), |
| 82 |
repeat('a32',62),repeat('a33',62),repeat('a34',62),repeat('a35',62),repeat('a36',62), |
| 83 |
repeat('a37',62),repeat('a38',62),repeat('a39',62),repeat('a40',62),repeat('a41',62), |
| 84 |
repeat('a42',62),repeat('a43',62),repeat('a44',62),repeat('a45',62),repeat('a46',62), |
| 85 |
repeat('a47',62),repeat('a48',62),repeat('a49',62),repeat('a50',62),repeat('a51',62), |
| 86 |
repeat('a52',62),repeat('a53',62),repeat('a54',62),repeat('a55',62),repeat('a56',62), |
| 87 |
repeat('a57',62),repeat('a58',62),repeat('a59',62),repeat('a60',62),repeat('a61',62), |
| 88 |
repeat('a62',62),repeat('a63',62)); |
| 89 |
SELECT count(*) FROM tab1; |
| 90 |
count(*) |
| 91 |
1 |
| 92 |
SELECT count(*) FROM tab2; |
| 93 |
count(*) |
| 94 |
0 |
| 95 |
SELECT count(*) FROM tab3; |
| 96 |
count(*) |
| 97 |
1 |
| 98 |
DROP DATABASE test; |
| 99 |
# Run the bootstrap command with page size 16k |
| 100 |
# Start the DB server with page size 16k |
| 101 |
# restart: --innodb_page_size=16K --datadir=MYSQLD_DATADIR1 |
| 102 |
SELECT @@innodb_page_size; |
| 103 |
@@innodb_page_size |
| 104 |
16384 |
| 105 |
SELECT @@innodb_strict_mode; |
| 106 |
@@innodb_strict_mode |
| 107 |
1 |
| 108 |
Pattern "\[ERROR\] .*MY-\d+.* Cannot create the table `test`.`tab1` because the record size will exceed the maximum allowed size for a record." found |
| 109 |
Pattern "\[ERROR\] .*MY-\d+.* Cannot create the table `test`.`tab2` because the record size will exceed the maximum allowed size for a record." found |
| 110 |
USE test; |
| 111 |
SHOW TABLES; |
| 112 |
Tables_in_test |
| 113 |
SELECT count(*) FROM tab1; |
| 114 |
ERROR 42S02: Table 'test.tab1' doesn't exist |
| 115 |
SELECT count(*) FROM tab2; |
| 116 |
ERROR 42S02: Table 'test.tab2' doesn't exist |
| 117 |
SELECT count(*) FROM tab3; |
| 118 |
ERROR 42S02: Table 'test.tab3' doesn't exist |
| 119 |
DROP DATABASE test; |
| 120 |
# Run the bootstrap command with page size 64k |
| 121 |
# Start the DB server with page size 64k |
| 122 |
# restart: --innodb_page_size=64K --datadir=MYSQLD_DATADIR1 |
| 123 |
SELECT @@innodb_page_size; |
| 124 |
@@innodb_page_size |
| 125 |
65536 |
| 126 |
SELECT @@innodb_strict_mode; |
| 127 |
@@innodb_strict_mode |
| 128 |
1 |
| 129 |
USE test; |
| 130 |
SHOW TABLES; |
| 131 |
Tables_in_test |
| 132 |
tab1 |
| 133 |
tab2 |
| 134 |
tab3 |
| 135 |
SELECT count(*) FROM tab1; |
| 136 |
count(*) |
| 137 |
1 |
| 138 |
SELECT count(*) FROM tab2; |
| 139 |
count(*) |
| 140 |
0 |
| 141 |
SELECT count(*) FROM tab3; |
| 142 |
count(*) |
| 143 |
1 |
| 144 |
SET innodb_strict_mode=Default; |
| 145 |
# restart |