Active IQ Unified Manager MySQL error file contains warning "... row size is 8127, which is greater than maximum allowed size (8126)..."
Applies to
- OnCommand Unified Manager 7.3P1 ( UM )
- OnCommand Unified Manager 9.4 ( UM )
- OnCommand Unified Manager 9.4P1 ( UM )
- OnCommand Unified Manager 9.5 ( UM )
- OnCommand Unified Manager 9.5P1 ( UM )
- Active IQ Unified Manager 9.6 ( AIQUM )
- Active IQ Unified Manager 9.6P1 ( AIQUM )
Issue
Warning messages seen on MySQL error log (named {HOSTNAME}.err) on a server running Active IQ Unified Manager:
[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.