[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

         Key: MNT-1405
         URL: http://bugs.osuosl.org/browse/MNT-1405
     Project: Maintain
        Type: Bug
  Components: Database  
    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 mailing list