| Server IP : 172.67.216.182 / Your IP : 162.158.107.15 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/innodb/r/ |
Upload File : |
call mtr.add_suppression("ERROR 1118 \\(42000\\) at line 106: Row size too large \\(> 8126\\)");
# Stop DB server which was created by MTR default
# create bootstrap file
# Run the bootstrap command with page size 32k
# Start the DB server with page size 32k
# restart: --innodb_page_size=32K --datadir=MYSQLD_DATADIR1 --innodb_log_file_size=5M --innodb_log_files_in_group=2 --innodb_undo_tablespaces=0
USE test;
SELECT @@innodb_page_size;
@@innodb_page_size
32768
CREATE TABLE tab1(col1 CHAR (255), col2 CHAR (255), col3 CHAR(255),col4 CHAR(255), col5 CHAR(255),
col6 CHAR(255), col7 CHAR(255), col8 CHAR(255), col9 CHAR(255),col10 CHAR(255), col11 CHAR(255),
col12 CHAR(255), col13 CHAR(255),col14 CHAR(255),col15 CHAR(255),col16 CHAR(255), col17 CHAR(255),
col18 CHAR(255),col19 CHAR(255),col20 CHAR(255),col21 CHAR(255),col22 CHAR(255), col23 CHAR(255),
col24 CHAR(255),col25 CHAR(255),col26 CHAR(255),col27 CHAR(255),col28 CHAR(255), col29 CHAR(255),
col30 CHAR(255),col31 CHAR(255),col32 CHAR(255),col33 CHAR(255),col34 CHAR(255), col35 CHAR(255),
col36 CHAR(255),col37 CHAR(255),col38 CHAR(255),col39 CHAR(255),col40 CHAR(255), col41 CHAR(255),
col42 CHAR(255),col43 CHAR(255),col44 CHAR(255),col45 CHAR(255),col46 CHAR(255), col47 CHAR(255),
col48 CHAR(255),col49 CHAR(255),col50 CHAR(255),col51 CHAR(255),col52 CHAR(255), col53 CHAR(255),
col54 CHAR(255),col55 CHAR(255),col56 CHAR(255),col57 CHAR(255),col58 CHAR(255), col59 CHAR(255),
col60 CHAR(255),col61 CHAR(255),col62 CHAR(255),col63 CHAR(255)) ENGINE = innodb ;
INSERT INTO tab1 VALUES(repeat('a1',127),repeat('a2',127),repeat('a3',127),repeat('a4',127),
repeat('a5',127),repeat('a6',127),repeat('a7',127),repeat('a8',127),repeat('a9',127),repeat('a10',62),
repeat('a11',62),repeat('a12',62),repeat('a13',62),repeat('a14',62),repeat('a15',62),repeat('a16',62),
repeat('a17',62),repeat('a18',62),repeat('a19',62),repeat('a20',62),repeat('a21',62),
repeat('a22',62),repeat('a23',62),repeat('a24',62),repeat('a25',62),repeat('a26',62),
repeat('a27',62),repeat('a28',62),repeat('a29',62),repeat('a30',62),repeat('a31',62),
repeat('a32',62),repeat('a33',62),repeat('a34',62),repeat('a35',62),repeat('a36',62),
repeat('a37',62),repeat('a38',62),repeat('a39',62),repeat('a40',62),repeat('a41',62),
repeat('a42',62),repeat('a43',62),repeat('a44',62),repeat('a45',62),repeat('a46',62),
repeat('a47',62),repeat('a48',62),repeat('a49',62),repeat('a50',62),repeat('a51',62),
repeat('a52',62),repeat('a53',62),repeat('a54',62),repeat('a55',62),repeat('a56',62),
repeat('a57',62),repeat('a58',62),repeat('a59',62),repeat('a60',62),repeat('a61',62),
repeat('a62',62),repeat('a63',62));
SET innodb_strict_mode=OFF;
CREATE TABLE tab2(col1 CHAR (255), col2 CHAR (255), col3 CHAR(255),col4 CHAR(255), col5 CHAR(255),
col6 CHAR(255), col7 CHAR(255), col8 CHAR(255), col9 CHAR(255),col10 CHAR(255), col11 CHAR(255),
col12 CHAR(255), col13 CHAR(255),col14 CHAR(255),col15 CHAR(255),col16 CHAR(255), col17 CHAR(255),
col18 CHAR(255),col19 CHAR(255),col20 CHAR(255),col21 CHAR(255),col22 CHAR(255), col23 CHAR(255),
col24 CHAR(255),col25 CHAR(255),col26 CHAR(255),col27 CHAR(255),col28 CHAR(255), col29 CHAR(255),
col30 CHAR(255),col31 CHAR(255),col32 CHAR(255),col33 CHAR(255),col34 CHAR(255), col35 CHAR(255),
col36 CHAR(255),col37 CHAR(255),col38 CHAR(255),col39 CHAR(255),col40 CHAR(255), col41 CHAR(255),
col42 CHAR(255),col43 CHAR(255),col44 CHAR(255),col45 CHAR(255),col46 CHAR(255), col47 CHAR(255),
col48 CHAR(255),col49 CHAR(255),col50 CHAR(255),col51 CHAR(255),col52 CHAR(255), col53 CHAR(255),
col54 CHAR(255),col55 CHAR(255),col56 CHAR(255),col57 CHAR(255),col58 CHAR(255), col59 CHAR(255),
col60 CHAR(255),col61 CHAR(255),col62 CHAR(255),col63 CHAR(255),col64 CHAR(255)) ENGINE=innodb ROW_FORMAT=COMPACT;
Warnings:
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.
INSERT INTO tab2 VALUES(repeat('a1',127),repeat('a2',127),repeat('a3',127),repeat('a4',127),
repeat('a5',127),repeat('a6',127),repeat('a7',127),repeat('a8',127),repeat('a9',127),repeat('a10',62),
repeat('a11',62),repeat('a12',62),repeat('a13',62),repeat('a14',62),repeat('a15',62),repeat('a16',62),
repeat('a17',62),repeat('a18',62),repeat('a19',62),repeat('a20',62),repeat('a21',62),
repeat('a22',62),repeat('a23',62),repeat('a24',62),repeat('a25',62),repeat('a26',62),
repeat('a27',62),repeat('a28',62),repeat('a29',62),repeat('a30',62),repeat('a31',62),
repeat('a32',62),repeat('a33',62),repeat('a34',62),repeat('a35',62),repeat('a36',62),
repeat('a37',62),repeat('a38',62),repeat('a39',62),repeat('a40',62),repeat('a41',62),
repeat('a42',62),repeat('a43',62),repeat('a44',62),repeat('a45',62),repeat('a46',62),
repeat('a47',62),repeat('a48',62),repeat('a49',62),repeat('a50',62),repeat('a51',62),
repeat('a52',62),repeat('a53',62),repeat('a54',62),repeat('a55',62),repeat('a56',62),
repeat('a57',62),repeat('a58',62),repeat('a59',62),repeat('a60',62),repeat('a61',62),
repeat('a62',62),repeat('a63',63),repeat('a64',63));
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.
CREATE TABLE tab3(col1 CHAR (255), col2 CHAR (255), col3 CHAR(255),col4 CHAR(255), col5 CHAR(255),
col6 CHAR(255), col7 CHAR(255), col8 CHAR(255), col9 CHAR(255),col10 CHAR(255), col11 CHAR(255),
col12 CHAR(255), col13 CHAR(255),col14 CHAR(255),col15 CHAR(255),col16 CHAR(255), col17 CHAR(255),
col18 CHAR(255),col19 CHAR(255),col20 CHAR(255),col21 CHAR(255),col22 CHAR(255), col23 CHAR(255),
col24 CHAR(255),col25 CHAR(255),col26 CHAR(255),col27 CHAR(255),col28 CHAR(255), col29 CHAR(255),
col30 CHAR(255),col31 CHAR(255),col32 CHAR(255),col33 CHAR(255),col34 CHAR(255), col35 CHAR(255),
col36 CHAR(255),col37 CHAR(255),col38 CHAR(255),col39 CHAR(255),col40 CHAR(255), col41 CHAR(255),
col42 CHAR(255),col43 CHAR(255),col44 CHAR(255),col45 CHAR(255),col46 CHAR(255), col47 CHAR(255),
col48 CHAR(255),col49 CHAR(255),col50 CHAR(255),col51 CHAR(255),col52 CHAR(255), col53 CHAR(255),
col54 CHAR(255),col55 CHAR(255),col56 CHAR(255),col57 CHAR(255),col58 CHAR(255), col59 CHAR(255),
col60 CHAR(255),col61 CHAR(255),col62 CHAR(255),col63 CHAR(255)) ENGINE = innodb ROW_FORMAT=COMPRESSED;
Warnings:
Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC.
INSERT INTO tab3 VALUES(repeat('a1',127),repeat('a2',127),repeat('a3',127),repeat('a4',127),
repeat('a5',127),repeat('a6',127),repeat('a7',127),repeat('a8',127),repeat('a9',127),repeat('a10',62),
repeat('a11',62),repeat('a12',62),repeat('a13',62),repeat('a14',62),repeat('a15',62),repeat('a16',62),
repeat('a17',62),repeat('a18',62),repeat('a19',62),repeat('a20',62),repeat('a21',62),
repeat('a22',62),repeat('a23',62),repeat('a24',62),repeat('a25',62),repeat('a26',62),
repeat('a27',62),repeat('a28',62),repeat('a29',62),repeat('a30',62),repeat('a31',62),
repeat('a32',62),repeat('a33',62),repeat('a34',62),repeat('a35',62),repeat('a36',62),
repeat('a37',62),repeat('a38',62),repeat('a39',62),repeat('a40',62),repeat('a41',62),
repeat('a42',62),repeat('a43',62),repeat('a44',62),repeat('a45',62),repeat('a46',62),
repeat('a47',62),repeat('a48',62),repeat('a49',62),repeat('a50',62),repeat('a51',62),
repeat('a52',62),repeat('a53',62),repeat('a54',62),repeat('a55',62),repeat('a56',62),
repeat('a57',62),repeat('a58',62),repeat('a59',62),repeat('a60',62),repeat('a61',62),
repeat('a62',62),repeat('a63',62));
SELECT count(*) FROM tab1;
count(*)
1
SELECT count(*) FROM tab2;
count(*)
0
SELECT count(*) FROM tab3;
count(*)
1
DROP DATABASE test;
# Run the bootstrap command with page size 16k
# Start the DB server with page size 16k
# restart: --innodb_page_size=16K --datadir=MYSQLD_DATADIR1 --innodb_log_file_size=5M --innodb_log_files_in_group=2 --innodb_undo_tablespaces=0
SELECT @@innodb_page_size;
@@innodb_page_size
16384
SELECT @@innodb_strict_mode;
@@innodb_strict_mode
1
USE test;
SHOW TABLES;
Tables_in_test
SELECT count(*) FROM tab1;
ERROR 42S02: Table 'test.tab1' doesn't exist
SELECT count(*) FROM tab2;
ERROR 42S02: Table 'test.tab2' doesn't exist
SELECT count(*) FROM tab3;
ERROR 42S02: Table 'test.tab3' doesn't exist
DROP DATABASE test;
# Run the bootstrap command with page size 64k
# Start the DB server with page size 64k
# restart: --innodb_page_size=64K --datadir=MYSQLD_DATADIR1 --innodb_log_file_size=5M --innodb_log_files_in_group=2 --innodb_undo_tablespaces=0
SELECT @@innodb_page_size;
@@innodb_page_size
65536
SELECT @@innodb_strict_mode;
@@innodb_strict_mode
1
USE test;
SHOW TABLES;
Tables_in_test
tab1
tab2
SELECT count(*) FROM tab1;
count(*)
1
SELECT count(*) FROM tab2;
count(*)
0
SELECT count(*) FROM tab3;
ERROR 42S02: Table 'test.tab3' doesn't exist
SET innodb_strict_mode=Default;
# restart