Submit a ticketCall us

Cloud Workloads: Meet Your New Hybrid IT Reality
Have you found yourself in that evolving, hybrid IT grey area and wondering if cloud workloads are now part of your purview? And if so, will monitoring cloud workloads require a new set of dedicated cloud monitoring tools? Your answers: yes, they should be, and no, they don’t.

Find out how SolarWinds® Server & Application Monitor (SAM) can help you monitor your cloud workloads side by side with your on-premises workloads. Register Now.

Home > Success Center > Web Help Desk (WHD) > WHD upgrade error: Too many keys specified. Max 64 keys allowed

WHD upgrade error: Too many keys specified. Max 64 keys allowed

Updated December 22, 2016

Overview

This article describes how to fix the following MySQL error message displayed when upgrading WHD:

Too many keys specified. Max 32 keys allowed

Environment

  • All WHD versions
  • MySQL 5.x

Cause 

MySQL allows a maximum of 64 indexes per table.  The issue is caused by duplicate indexes created on columns in the JOB_TICKET table by a previous WHD update(s).  When the database update attempts to add additional indexes, the total number is increased past 64, and the error is triggered. 

Resolution

Delete the duplicate indexes in the JOB_TICKET table.  The duplicate indexes will have a 2 at the end of their keyname. Refer to the screenshot of what the indexes should look like -- in this case using phpMyAdmin.  You can use phpMyAdmin to delete the duplicates. 



You can also use the MySQL Command-Line tool and use show index from JOB_TICKET.  After you have identified the duplicate index keynames, you can delete the duplicate indexes by doing drop index [index keyname] on JOB_TICKET. Repeat this for each of the duplicate indexes. 

When all of the duplicate indexes are removed, the database update should proceed as normal.

 

 

 

Last modified

Tags

Classifications

Public