Hi,
We have same issue. After Zabbix upgrade from 3.4.9 to 6.0.18 database conversion failed with below error,
[Z3005] query failed: [1071] Specified key was too long; max key length is 3072 bytes [alter table `items` modify `key_` varchar(2048) default '' not null].
We have default database schema is latin1_swedish_ci. We have directly upgraded Zabbix from 3.4.9 to 6.0.18 without any issue. After Zabbix upgrade tried to execute utf8mb4 conversion but table conversion failed with above error,
[Z3005] query failed: [1071] Specified key was too long; max key length is 3072 bytes [alter table `items` modify `key_` varchar(2048) default '' not null].
https://www.zabbix.com/documentation...b_charset_coll
Any help appreciated.
Mysql version 8.0.33
zabbix version 6.0.18
Edit Delete
We have same issue. After Zabbix upgrade from 3.4.9 to 6.0.18 database conversion failed with below error,
[Z3005] query failed: [1071] Specified key was too long; max key length is 3072 bytes [alter table `items` modify `key_` varchar(2048) default '' not null].
We have default database schema is latin1_swedish_ci. We have directly upgraded Zabbix from 3.4.9 to 6.0.18 without any issue. After Zabbix upgrade tried to execute utf8mb4 conversion but table conversion failed with above error,
[Z3005] query failed: [1071] Specified key was too long; max key length is 3072 bytes [alter table `items` modify `key_` varchar(2048) default '' not null].
https://www.zabbix.com/documentation...b_charset_coll
Any help appreciated.
Mysql version 8.0.33
zabbix version 6.0.18
Edit Delete