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

Symptons

MySQL or MariaDB databases refuses to create new column on 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 find all tables that may have the problem.

Resolution

The recommended fix is changing the row format:

alter table OKM_PROFILE ROW_FORMAT=DYNAMIC;

Properties