[Maintain-dev] [JIRA] Created: (MNT-1405) MySQL Key size too large
Danny Robert (JIRA)
jira at osuosl.org
Wed Feb 1 18:02:02 PST 2006
MySQL Key size too large
Versions: 2.4.0, 2.6
Environment: MySQL 4.1+ with UTF-8 Encoding
Reporter: Danny Robert
Assigned to: Michael Clay
Fix For: 2.6
The MySQL schema used in Maintain is invalid when the default tables are UTF-8 encoded. Since UTF-8 characters can be up to three bytes, the 1000-byte key limit is reached much more quickly. From an IRC conversation:
maintain.sql: line 115: #1071 - Specified key was too long; max key length is 1000 bytes
This is from the HOST table import, most likely due to this key:
KEY `ha` (`ha`,`os`,`serial`,`last_seen`,`other_id`)
Other keys should be checked as well.
A temporary "solution" for this bug is to tell users to use latin encoding.
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
If you want more information on JIRA, or have a bug to report see:
More information about the Maintain-dev