Known Issue: ANA-386- createDimmTables() return error when rrddata_source processing

Problem Description

One of the steps in procedure createDimTables() is transforming odb_attributes into column name with assigning column types. In most cases, columns get VARCHAR(255), but some of them can get higher than VARCHAR(255).


Install Isilon ZenPack on a system with Analytics, allow a model batch to run, login to mysql on the analytics server, and do "call createDimTables();". The call will run for a bit and eventually fail on ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual.


  1. Download archive ANA-386-fix.tar.gz and then copy the file to the Analytics server host. This needs to be copied into /opt/zenoss_analytics/bin directory.
  2. Extract the contents of the fix archive file.
    tar -xzvf /opt/zenoss_analytics/bin/ANA-386-fix.tar.gz
  3. Execute the following command to give permissions
    chmod o+rx /opt/zenoss_analytics/bin/analytics_fix
  4. Start a shell as zenoss user.
    su - zenoss
  5. Go to the newly created directory
    cd /opt/zenoss_analytics/bin/analytics_fix
  6. Execute the script with
Was this article helpful?
0 out of 0 found this helpful


Powered by Zendesk