Skip to content

Row size too large#

Problem#

During an i-doit update, an error message like "Row size too large" appears:

Problem

Problem

Solution#

Make sure you already have a backup (this should exist before every update). Then change the ROW_FORMAT of the affected table and run the update again:

  1. Log in to MySQL:

    1
        mysql -uroot -p

  2. Select the affected database:

    1
        USE idoit_data;

    With multiple tenants, you must repeat this step for each affected database.

  3. Set the ROW_FORMAT of the affected table from FIXED to DYNAMIC:

    1
        ALTER TABLE isys_cats_person_list ROW_FORMAT=DYNAMIC;