Unable to create a new index on a tableIssue When attempting to create a new index on a table you never receive a confirmation email saying the index was created successfully, or the index does not appear on the table as expected.CauseIt's possible that the table on which you are creating the new index already has 64 indexes, which is the maximum number of indexes that can be applied on a table in MySQL/MariaDB (see: InnoDB Limits). Index creation fails straight away with the following error in the system logs. Syntax Error or Access Rule Violation detected by database (Too many keys specified; max 64 keys allowed) at com.glide.db.DBIError.wrapAndThrow(DBIError.java:126) at com.glide.db.DBIError.handleException(DBIError.java:79) at com.glide.db.DBI.executeStatement(DBI.java:1080) at com.glide.db.DBI.executeStatement(DBI.java:1019) at com.glide.db.DBI.executeStatement(DBI.java:1007) at com.glide.db.ddl.DBIndexCreator.createIndexesMySQL(DBIndexCreator.java:101) at com.glide.db.ddl.DBIndexCreator.createIndexes0(DBIndexCreator.java:75) at com.glide.db.ddl.DBIndexCreator.createIndexes(DBIndexCreator.java:69) at com.glide.db.ddl.DBIndex.rawCreateWithoutSpecifyingName(DBIndex.java:736) at com.glide.db.ddl.DBOnlineAlter.createIndexes0(DBOnlineAlter.java:110) ResolutionPlease contact Technical Support, we will help you find a solution to this issue, which might involve identifying an unused index that can be dropped, so that you can create the new index.