"Row size too large" error thrown even when it's not.

[monty solomon]

We are experiencing the same problem described in MySQL bug 69336.

Does Percona have a fix for it?

Thanks.

Server version: 5.5.32-31.0-log Percona Server (GPL), Release rel31.0, Revision 549

[monty solomon (monty+launchpad)]

Here is the link to the MySQL bug

http://bugs.mysql.com/bug.php?id=69336

[Laurynas Biveinis (laurynas-biveinis)]

We don't have a fix for upstream #69336 at this moment.

[Valerii Kravchuk (valerii-kravchuk)]

PS 5.5.32 is affected:

[openxs@chief p5.5]$ bin/mysql --no-defaults -uroot test </tmp/m2b.sql
ERROR 1118 (42000) at line 239: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
[openxs@chief p5.5]$ tail /tmp/m2b.sql
, col221 text
, col222 text
, col223 text
, col224 text
, col225 text
, col226 text
, col227 text
, col228 text
) ENGINE=MyISAM;
alter table foo engine=innodb row_format=dynamic;
[openxs@chief p5.5]$ bin/mysql --no-defaults -uroot -e 'show variables like "version%"'
+-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| version | 5.5.32 |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+------------------------------+

As well as recent 5.6:

[openxs@chief p5.6]$ bin/mysql --no-defaults -uroot test </tmp/m2b.sql
ERROR 1118 (42000) at line 239: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
[openxs@chief p5.6]$ tail /tmp/m2b.sql
, col221 text
, col222 text
, col223 text
, col224 text
, col225 text
, col226 text
, col227 text
, col228 text
) ENGINE=MyISAM;
alter table foo engine=innodb row_format=dynamic;
[openxs@chief p5.6]$ bin/mysql --no-defaults -uroot -e 'show variables like "version%"'
+-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| version | 5.6.12 |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+------------------------------+

[Valerii Kravchuk (valerii-kravchuk)]

Same with PS 5.1 (set global innodb_file_format_max=Barracuda; is commented out in the test script):

[openxs@chief p5.1]$ bin/mysql --no-defaults -uroot test </tmp/m2b.sql
ERROR 1118 (42000) at line 239: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
[openxs@chief p5.1]$ bin/mysql --no-defaults -uroot -e 'show variables like "version%"'
+-------------------------+---------------------+
| Variable_name | Value |
+-------------------------+---------------------+
| version | 5.1.68 |
| version_comment | Source distribution |
| version_compile_machine | x86_64 |
| version_compile_os | unknown-linux-gnu |
+-------------------------+---------------------+

[monty solomon (monty+launchpad)]

Adding sql_mode = STRICT_TRANS_TABLES to a slave can cause replication to fail.

[ERROR] Slave SQL: Error 'Row size too large (> 8126). 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.' on query.

Percona Server 5.5.32-31.0-log Percona Server (GPL), Release rel31.0, Revision 54

[Laurynas Biveinis (laurynas-biveinis)]

Monty, do you agree with the upstream bug resolution?

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1404