UM MySQL error file contains warning as row size is 8127, which is greater than maximum allowed size (8126)
Applies to
- OnCommand Unified Manager(OCUM ) 9.5 and below
- Active IQ Unified Manager(AIQUM) 9.6 +
- All OS Platforms
Issue
- AIQUM server gets unresponsive randomly
- A reboot of the server temporarily fix the issue before it comes back again
- Warning messages seen on MySQL error log (named {HOSTNAME}.err) just before application goes down:
[Warning] InnoDB: Cannot add field `XXXXXX__XXXXXXX_XXX` in table `temp`.`#sqlXXX_XXXX_XXX` because after adding it, the row size is 8127 which is greater than maximum allowed size (8126) for a record on index leaf page.