Comments - Troubleshooting Row Size Too Large Errors with InnoDB

4 years ago mike bayer

We have this issue with tables that we cannot change the format of; we have changed to "dynamic" but this still produces the warnings, so there seems to be no real solution here.

However we are unable to reproduce any actual issue. The above paragraphs state "Regardless of whether InnoDB strict mode is enabled, if a DML statement is executed that attempts to write a row that the table's InnoDB row format can't store, then InnoDB will raise an error with this message. ". We cannot reproduce any error upon DML even though our tables emit this message, and I wrote a script to test the above sample table with "col1-col198" to see if there is in fact any DML which fails; I've inserted tens of thousands of rows into the table with all combinations of varchar data and no DML statement fails, all rows can be SELECTed back with complete accuracy. So it's unclear what this error at the DDL level actually means, can a concrete example of what will cause actual functionality to fail be added here?

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.