Bug #120356 ERROR 1118 Row size too large (> 8126) on 8.0.46
Submitted: 27 Apr 14:52 Modified: 27 Apr 17:21
Reporter: Samuel Claeys Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: DDL Severity:S2 (Serious)
Version:8.0.46 OS:Linux (Debian 12)
Assigned to: CPU Architecture:x86

[27 Apr 14:52] Samuel Claeys 
Description:
Since the update of 8.0.46 we get the Error "ERROR 1118 (42000) at line xxx: Row size too large (> 8126).". Even we have the default innodb_default_row_format to "dynamic". Yes, our Table is large (>12000) but as longer values should be  off-paged (https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html#innodb-row-format-dynamic) this should not be an issue, we didn't had any issues the last years.

How to repeat:
I created a docker container with 8.0.45 and with 8.0.46. I dumped a fullbackup on both DBs. 8.0.45 went without error. 8.0.46 stopped with the error. 

One table has many varchars (1000, 500, 255).

Suggested fix:
When disabling strict Mode the error becomes a warning. But this is only a workaround not a fix.
[27 Apr 17:21] MySQL Verification Team 
Please follow the bug:
https://bugs.mysql.com/bug.php?id=120323