Resolved Mariadb shows 2019-11-18 13:20:01 10 [Warning] InnoDB: Cannot add field `external_id` in table `psa`

[tkalfaoglu]

Mariadb shows this in its logs:
2019-11-18 13:20:01 10 [Warning] InnoDB: Cannot add field `external_id` in table `psa`.`clients` because after adding it, the row size is 8714 which is greater than maximum allowed size (8126) for a record on index leaf page.

Should I worry?

 

[moswak]

maybe you have upgraded mariadb 10.1 to 10.2 ?

Troubleshooting Row Size Too Large Errors with InnoDB

ALTER TABLE clients ROW_FORMAT=DYNAMIC;

should eliminate the warning.
always make a backup before