Repairing Zabbix database character failed

XMLWordPrintable

    • Type: Problem report
    • Resolution: Commercial support required
    • Priority: Trivial
    • None
    • Affects Version/s: None
    • Component/s: None
    • None

      Hi,

      After zabbix 6.0 upgrade database utf8mb4 conversion failed with below error,

       

      mysql <your DB name> < utf8mb4_convert.sql

       

      Specified key was too long; max key length is 3072 bytes [alter table `items` modify `key_` varchar(2048) default '' not null]. 

            Assignee:
            Zabbix Support Team
            Reporter:
            Venky
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: