Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126

Symptoms

MySQL or MariaDB databases refuse to create a new column in the OKM_PROFILE table:

Cause

The root cause is that InnoDB has a maximum row size that is roughly equivalent to half of the value of the innodb_page_size system variable. 

Please read Troubleshooting Row Size Too Large Errors with InnoDB for more info. 

Diagnosis

You can find a script called rowsize.sh at Troubleshooting Row Size Too Large Errors with InnoDB which finds all tables that may have the problem.

Resolution

The recommended fix is changing the row format:

alter table OKM_PROFILE ROW_FORMAT=DYNAMIC;

Properties