For instances using a MySQL database, MySQL's InnoDB engine (Antelope version) is used for the tables the platform creates. This InnoDB engine version enables the definition of a table schema where the row size can theoretically surpass the 8126-byte limit.
Although all field types can contribute to the row size limit, usually any table with many large string (mediumtext) columns is more likely to be at risk.
Steps to Reproduce
- Create a new table extending task.
- Add 6 mediumtext fields (string fields with max_length > 4000) to the task table.
- Add 6 mediumtext fields to the new table.
- Create a new record in the new table, populating more than 768 characters into each of the 12 fields just created.
- Try to insert the record.
Note that the record insert is canceled, and the following error message is displayed:
... Row size too large ( > 8126). Changing some columns to TEXT or BLOB using ...
In some scenarios, the error logged will be "Got Error 139 From Storage Engine".
When this exception is encountered, open a case with Customer Support and reference the problem number PRB617735.
Related Problem: PRB617735