[#ZBX-20165] Database upgrade failed, Zabbix v. 5.0. Specified key was too long; max key length is 767 bytes

Comment by Aleksey Volodin [ 2021 Nov 02 ]

The root cause of this issue is your old MySQL version.

767 bytes in MySQL version 5.6 (and prior versions), is the stated prefix limitation for InnoDB tables.

This limit has been increased to 3072 bytes In MySQL version 5.7 (and upwards).

So, please update your MySQL version to minimum 5.7

Best regards,

Aleksey

Comment by Krzysztof [ 2021 Nov 02 ]

Thank you Aleksey, so that's Inno DB limits. Shouldn't the upgrade notes be updated for Zabbix 5.0 version accordingly?

"Minimum required database versions

Minimum database versions required for Zabbix 5.0.0 have been upped to:

MySQL 5.5.62"

Comment by Krzysztof [ 2021 Nov 03 ]

mysql> SELECT `table_name`, `row_format` FROM `information_schema`.`tables` WHERE `table_schema`='zabbix';
--------------------------------------+

table_name

row_format

--------------------------------------+

acknowledges	Compact
actions	Compact
alerts	Compact
application_discovery	Compact
application_prototype	Compact
application_template	Compact
applications	Compact
auditlog	Compact
auditlog_details	Compact
autoreg_host	Compact
conditions	Compact
config	Compact
config_autoreg_tls	Compact
corr_condition	Compact
corr_condition_group	Compact
corr_condition_tag	Compact
corr_condition_tagpair	Compact
corr_condition_tagvalue	Compact
corr_operation	Compact
correlation	Compact
dashboard	Compact
dashboard_user	Compact
dashboard_usrgrp	Compact
dbversion	Compact
dchecks	Compact
dhosts	Compact
drules	Compact
dservices	Compact
escalations	Compact
event_recovery	Compact
event_suppress	Compact
event_tag	Compact
events	Compact
expressions	Compact
functions	Compact
globalmacro	Compact
globalvars	Compact
graph_discovery	Compact
graph_theme	Compact
graphs	Compact
graphs_items	Compact
group_discovery	Compact
group_prototype	Compact
history	Compact
history_log	Compact
history_str	Compact
history_text	Compact
history_uint	Compact
host_discovery	Compact
host_inventory	Compact
host_tag	Compact
hostmacro	Compact
hosts	Compact
hosts_groups	Compact
hosts_templates	Compact
housekeeper	Compact
hstgrp	Compact
httpstep	Compact
httpstep_field	Compact
httpstepitem	Compact
httptest	Compact
httptest_field	Compact
httptestitem	Compact
icon_map	Compact
icon_mapping	Compact
ids	Compact
images	Compact
interface	Compact
interface_discovery	Compact
item_application_prototype	Compact
item_condition	Compact
item_discovery	Compact
item_preproc	Compact
item_rtdata	Compact
items	Compact
items_applications	Compact
lld_macro_path	Compact
maintenance_tag	Compact
maintenances	Compact
maintenances_groups	Compact
maintenances_hosts	Compact
maintenances_windows	Compact
mappings	Compact
media	Compact
media_type	Compact
media_type_param	Compact
opcommand	Compact
opcommand_grp	Compact
opcommand_hst	Compact
opconditions	Compact
operations	Compact
opgroup	Compact
opinventory	Compact
opmessage	Compact
opmessage_grp	Compact
opmessage_usr	Compact
optemplate	Compact
problem	Compact
problem_tag	Compact
profiles	Compact
proxy_autoreg_host	Compact
proxy_dhistory	Compact
proxy_history	Compact
regexps	Compact
rights	Compact
screen_user	Compact
screen_usrgrp	Compact
screens	Compact
screens_items	Compact
scripts	Compact
service_alarms	Compact
services	Compact
services_links	Compact
services_times	Compact
sessions	Compact
slides	Compact
slideshow_user	Compact
slideshow_usrgrp	Compact
slideshows	Compact
sysmap_element_trigger	Compact
sysmap_element_url	Compact
sysmap_shape	Compact
sysmap_url	Compact
sysmap_user	Compact
sysmap_usrgrp	Compact
sysmaps	Compact
sysmaps_elements	Compact
sysmaps_link_triggers	Compact
sysmaps_links	Compact
tag_filter	Compact
task	Compact
task_acknowledge	Compact
task_check_now	Compact
task_close_problem	Compact
task_remote_command	Compact
task_remote_command_result	Compact
timeperiods	Compact
trends	Compact
trends_uint	Compact
trigger_depends	Compact
trigger_discovery	Compact
trigger_tag	Compact
triggers	Compact
users	Compact
users_groups	Compact
usrgrp	Compact
valuemaps	Compact
widget	Compact
widget_field	Compact

--------------------------------------+
149 rows in set (0.14 sec)

Additional info:
After upgrading MySQL to 5.7 version there was still a problem with the DB upgrade :

4290:20211102:193819.886 current database version (mandatory/optional): 04040000/04040002
4290:20211102:193819.886 required mandatory version: 05000000
4290:20211102:193819.886 optional patches were found
4290:20211102:193819.886 starting automatic database upgrade
4290:20211102:193819.903 completed 0% of database upgrade
4290:20211102:193819.912 completed 1% of database upgrade
4290:20211102:193819.917 completed 2% of database upgrade
4290:20211102:193819.924 [Z3005] query failed: [1709] Index column size too large. The maximum column size is 767 bytes. [create index items_1 on items (hostid,key_(1021))]
4290:20211102:193819.924 database upgrade failed

Finally it was +resolved +by changing the row_format type for each table in zabbix database to Dynamic.

Comment by Aleksey Volodin [ 2021 Nov 04 ]

Possible reason
If DB was created in old MySQL 5.6 InnoDB Row Format Compact was used by default.

https://dev.mysql.com/doc/refman/5.6/en/innodb-row-format.html

InnoDB limits for 5.6

https://dev.mysql.com/doc/refman/5.6/en/innodb-limits.html

InnoDB limits for 5.7

https://dev.mysql.com/doc/refman/5.7/en/innodb-limits.html

Possible solution

Activate innodb_large_prefix

https://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_large_prefix

set global innodb_large_prefix = 'ON';

Change MySQL configuration file

[mysqld]
innodb_file_format = Barracuda
innodb_large_prefix = 1
innodb_file_per_table = ON

And change row format for tables.

Commands for Zabbix 4.0:

ALTER TABLE acknowledges ROW_FORMAT=DYNAMIC;
ALTER TABLE actions ROW_FORMAT=DYNAMIC;
ALTER TABLE alerts ROW_FORMAT=DYNAMIC;
ALTER TABLE application_discovery ROW_FORMAT=DYNAMIC;
ALTER TABLE application_prototype ROW_FORMAT=DYNAMIC;
ALTER TABLE application_template ROW_FORMAT=DYNAMIC;
ALTER TABLE applications ROW_FORMAT=DYNAMIC;
ALTER TABLE auditlog ROW_FORMAT=DYNAMIC;
ALTER TABLE auditlog_details ROW_FORMAT=DYNAMIC;
ALTER TABLE autoreg_host ROW_FORMAT=DYNAMIC;
ALTER TABLE conditions ROW_FORMAT=DYNAMIC;
ALTER TABLE config ROW_FORMAT=DYNAMIC;
ALTER TABLE config_autoreg_tls ROW_FORMAT=DYNAMIC;
ALTER TABLE corr_condition ROW_FORMAT=DYNAMIC;
ALTER TABLE corr_condition_group ROW_FORMAT=DYNAMIC;
ALTER TABLE corr_condition_tag ROW_FORMAT=DYNAMIC;
ALTER TABLE corr_condition_tagpair ROW_FORMAT=DYNAMIC;
ALTER TABLE corr_condition_tagvalue ROW_FORMAT=DYNAMIC;
ALTER TABLE corr_operation ROW_FORMAT=DYNAMIC;
ALTER TABLE correlation ROW_FORMAT=DYNAMIC;
ALTER TABLE dashboard ROW_FORMAT=DYNAMIC;
ALTER TABLE dashboard_user ROW_FORMAT=DYNAMIC;
ALTER TABLE dashboard_usrgrp ROW_FORMAT=DYNAMIC;
ALTER TABLE dbversion ROW_FORMAT=DYNAMIC;
ALTER TABLE dchecks ROW_FORMAT=DYNAMIC;
ALTER TABLE dhosts ROW_FORMAT=DYNAMIC;
ALTER TABLE drules ROW_FORMAT=DYNAMIC;
ALTER TABLE dservices ROW_FORMAT=DYNAMIC;
ALTER TABLE escalations ROW_FORMAT=DYNAMIC;
ALTER TABLE event_recovery ROW_FORMAT=DYNAMIC;
ALTER TABLE event_suppress ROW_FORMAT=DYNAMIC;
ALTER TABLE event_tag ROW_FORMAT=DYNAMIC;
ALTER TABLE events ROW_FORMAT=DYNAMIC;
ALTER TABLE expressions ROW_FORMAT=DYNAMIC;
ALTER TABLE functions ROW_FORMAT=DYNAMIC;
ALTER TABLE globalmacro ROW_FORMAT=DYNAMIC;
ALTER TABLE globalvars ROW_FORMAT=DYNAMIC;
ALTER TABLE graph_discovery ROW_FORMAT=DYNAMIC;
ALTER TABLE graph_theme ROW_FORMAT=DYNAMIC;
ALTER TABLE graphs ROW_FORMAT=DYNAMIC;
ALTER TABLE graphs_items ROW_FORMAT=DYNAMIC;
ALTER TABLE group_discovery ROW_FORMAT=DYNAMIC;
ALTER TABLE group_prototype ROW_FORMAT=DYNAMIC;
ALTER TABLE history ROW_FORMAT=DYNAMIC;
ALTER TABLE history_log ROW_FORMAT=DYNAMIC;
ALTER TABLE history_str ROW_FORMAT=DYNAMIC;
ALTER TABLE history_text ROW_FORMAT=DYNAMIC;
ALTER TABLE history_uint ROW_FORMAT=DYNAMIC;
ALTER TABLE host_discovery ROW_FORMAT=DYNAMIC;
ALTER TABLE host_inventory ROW_FORMAT=DYNAMIC;
ALTER TABLE host_tag ROW_FORMAT=DYNAMIC;
ALTER TABLE hostmacro ROW_FORMAT=DYNAMIC;
ALTER TABLE hosts ROW_FORMAT=DYNAMIC;
ALTER TABLE hosts_groups ROW_FORMAT=DYNAMIC;
ALTER TABLE hosts_templates ROW_FORMAT=DYNAMIC;
ALTER TABLE housekeeper ROW_FORMAT=DYNAMIC;
ALTER TABLE hstgrp ROW_FORMAT=DYNAMIC;
ALTER TABLE httpstep ROW_FORMAT=DYNAMIC;
ALTER TABLE httpstep_field ROW_FORMAT=DYNAMIC;
ALTER TABLE httpstepitem ROW_FORMAT=DYNAMIC;
ALTER TABLE httptest ROW_FORMAT=DYNAMIC;
ALTER TABLE httptest_field ROW_FORMAT=DYNAMIC;
ALTER TABLE httptestitem ROW_FORMAT=DYNAMIC;
ALTER TABLE icon_map ROW_FORMAT=DYNAMIC;
ALTER TABLE icon_mapping ROW_FORMAT=DYNAMIC;
ALTER TABLE ids ROW_FORMAT=DYNAMIC;
ALTER TABLE images ROW_FORMAT=DYNAMIC;
ALTER TABLE interface ROW_FORMAT=DYNAMIC;
ALTER TABLE interface_discovery ROW_FORMAT=DYNAMIC;
ALTER TABLE item_application_prototype ROW_FORMAT=DYNAMIC;
ALTER TABLE item_condition ROW_FORMAT=DYNAMIC;
ALTER TABLE item_discovery ROW_FORMAT=DYNAMIC;
ALTER TABLE item_preproc ROW_FORMAT=DYNAMIC;
ALTER TABLE item_rtdata ROW_FORMAT=DYNAMIC;
ALTER TABLE items ROW_FORMAT=DYNAMIC;
ALTER TABLE items_applications ROW_FORMAT=DYNAMIC;
ALTER TABLE lld_macro_path ROW_FORMAT=DYNAMIC;
ALTER TABLE maintenance_tag ROW_FORMAT=DYNAMIC;
ALTER TABLE maintenances ROW_FORMAT=DYNAMIC;
ALTER TABLE maintenances_groups ROW_FORMAT=DYNAMIC;
ALTER TABLE maintenances_hosts ROW_FORMAT=DYNAMIC;
ALTER TABLE maintenances_windows ROW_FORMAT=DYNAMIC;
ALTER TABLE mappings ROW_FORMAT=DYNAMIC;
ALTER TABLE media ROW_FORMAT=DYNAMIC;
ALTER TABLE media_type ROW_FORMAT=DYNAMIC;
ALTER TABLE media_type_param ROW_FORMAT=DYNAMIC;
ALTER TABLE opcommand ROW_FORMAT=DYNAMIC;
ALTER TABLE opcommand_grp ROW_FORMAT=DYNAMIC;
ALTER TABLE opcommand_hst ROW_FORMAT=DYNAMIC;
ALTER TABLE opconditions ROW_FORMAT=DYNAMIC;
ALTER TABLE operations ROW_FORMAT=DYNAMIC;
ALTER TABLE opgroup ROW_FORMAT=DYNAMIC;
ALTER TABLE opinventory ROW_FORMAT=DYNAMIC;
ALTER TABLE opmessage ROW_FORMAT=DYNAMIC;
ALTER TABLE opmessage_grp ROW_FORMAT=DYNAMIC;
ALTER TABLE opmessage_usr ROW_FORMAT=DYNAMIC;
ALTER TABLE optemplate ROW_FORMAT=DYNAMIC;
ALTER TABLE problem ROW_FORMAT=DYNAMIC;
ALTER TABLE problem_tag ROW_FORMAT=DYNAMIC;
ALTER TABLE profiles ROW_FORMAT=DYNAMIC;
ALTER TABLE proxy_autoreg_host ROW_FORMAT=DYNAMIC;
ALTER TABLE proxy_dhistory ROW_FORMAT=DYNAMIC;
ALTER TABLE proxy_history ROW_FORMAT=DYNAMIC;
ALTER TABLE regexps ROW_FORMAT=DYNAMIC;
ALTER TABLE rights ROW_FORMAT=DYNAMIC;
ALTER TABLE screen_user ROW_FORMAT=DYNAMIC;
ALTER TABLE screen_usrgrp ROW_FORMAT=DYNAMIC;
ALTER TABLE screens ROW_FORMAT=DYNAMIC;
ALTER TABLE screens_items ROW_FORMAT=DYNAMIC;
ALTER TABLE scripts ROW_FORMAT=DYNAMIC;
ALTER TABLE service_alarms ROW_FORMAT=DYNAMIC;
ALTER TABLE services ROW_FORMAT=DYNAMIC;
ALTER TABLE services_links ROW_FORMAT=DYNAMIC;
ALTER TABLE services_times ROW_FORMAT=DYNAMIC;
ALTER TABLE sessions ROW_FORMAT=DYNAMIC;
ALTER TABLE slides ROW_FORMAT=DYNAMIC;
ALTER TABLE slideshow_user ROW_FORMAT=DYNAMIC;
ALTER TABLE slideshow_usrgrp ROW_FORMAT=DYNAMIC;
ALTER TABLE slideshows ROW_FORMAT=DYNAMIC;
ALTER TABLE sysmap_element_trigger ROW_FORMAT=DYNAMIC;
ALTER TABLE sysmap_element_url ROW_FORMAT=DYNAMIC;
ALTER TABLE sysmap_shape ROW_FORMAT=DYNAMIC;
ALTER TABLE sysmap_url ROW_FORMAT=DYNAMIC;
ALTER TABLE sysmap_user ROW_FORMAT=DYNAMIC;
ALTER TABLE sysmap_usrgrp ROW_FORMAT=DYNAMIC;
ALTER TABLE sysmaps ROW_FORMAT=DYNAMIC;
ALTER TABLE sysmaps_elements ROW_FORMAT=DYNAMIC;
ALTER TABLE sysmaps_link_triggers ROW_FORMAT=DYNAMIC;
ALTER TABLE sysmaps_links ROW_FORMAT=DYNAMIC;
ALTER TABLE tag_filter ROW_FORMAT=DYNAMIC;
ALTER TABLE task ROW_FORMAT=DYNAMIC;
ALTER TABLE task_acknowledge ROW_FORMAT=DYNAMIC;
ALTER TABLE task_check_now ROW_FORMAT=DYNAMIC;
ALTER TABLE task_close_problem ROW_FORMAT=DYNAMIC;
ALTER TABLE task_remote_command ROW_FORMAT=DYNAMIC;
ALTER TABLE task_remote_command_result ROW_FORMAT=DYNAMIC;
ALTER TABLE timeperiods ROW_FORMAT=DYNAMIC;
ALTER TABLE trendsDynamic| ROW_FORMAT=DYNAMIC;
ALTER TABLE trends_uint ROW_FORMAT=DYNAMIC;
ALTER TABLE trigger_depends ROW_FORMAT=DYNAMIC;
ALTER TABLE trigger_discovery ROW_FORMAT=DYNAMIC;
ALTER TABLE trigger_tag ROW_FORMAT=DYNAMIC;
ALTER TABLE triggers ROW_FORMAT=DYNAMIC;
ALTER TABLE users ROW_FORMAT=DYNAMIC;
ALTER TABLE users_groups ROW_FORMAT=DYNAMIC;
ALTER TABLE usrgrp ROW_FORMAT=DYNAMIC;
ALTER TABLE valuemaps ROW_FORMAT=DYNAMIC;
ALTER TABLE widget ROW_FORMAT=DYNAMIC;
ALTER TABLE widget_field ROW_FORMAT=DYNAMIC;

Also you can optimize your tables:

OPTIMIZE TABLE acknowledges;
OPTIMIZE TABLE actions;
OPTIMIZE TABLE alerts;
OPTIMIZE TABLE application_discovery;
OPTIMIZE TABLE application_prototype;
OPTIMIZE TABLE application_template;
OPTIMIZE TABLE applications;
OPTIMIZE TABLE auditlog;
OPTIMIZE TABLE auditlog_details;
OPTIMIZE TABLE autoreg_host;
OPTIMIZE TABLE conditions;
OPTIMIZE TABLE config;
OPTIMIZE TABLE config_autoreg_tls;
OPTIMIZE TABLE corr_condition;
OPTIMIZE TABLE corr_condition_group;
OPTIMIZE TABLE corr_condition_tag;
OPTIMIZE TABLE corr_condition_tagpair;
OPTIMIZE TABLE corr_condition_tagvalue;
OPTIMIZE TABLE corr_operation;
OPTIMIZE TABLE correlation;
OPTIMIZE TABLE dashboard;
OPTIMIZE TABLE dashboard_user;
OPTIMIZE TABLE dashboard_usrgrp;
OPTIMIZE TABLE dbversion;
OPTIMIZE TABLE dchecks;
OPTIMIZE TABLE dhosts;
OPTIMIZE TABLE drules;
OPTIMIZE TABLE dservices;
OPTIMIZE TABLE escalations;
OPTIMIZE TABLE event_recovery;
OPTIMIZE TABLE event_suppress;
OPTIMIZE TABLE event_tag;
OPTIMIZE TABLE events;
OPTIMIZE TABLE expressions;
OPTIMIZE TABLE functions;
OPTIMIZE TABLE globalmacro;
OPTIMIZE TABLE globalvars;
OPTIMIZE TABLE graph_discovery;
OPTIMIZE TABLE graph_theme;
OPTIMIZE TABLE graphs;
OPTIMIZE TABLE graphs_items;
OPTIMIZE TABLE group_discovery;
OPTIMIZE TABLE group_prototype;
OPTIMIZE TABLE history;
OPTIMIZE TABLE history_log;
OPTIMIZE TABLE history_str;
OPTIMIZE TABLE history_text;
OPTIMIZE TABLE history_uint;
OPTIMIZE TABLE host_discovery;
OPTIMIZE TABLE host_inventory;
OPTIMIZE TABLE host_tag;
OPTIMIZE TABLE hostmacro;
OPTIMIZE TABLE hosts;
OPTIMIZE TABLE hosts_groups;
OPTIMIZE TABLE hosts_templates;
OPTIMIZE TABLE housekeeper;
OPTIMIZE TABLE hstgrp;
OPTIMIZE TABLE httpstep;
OPTIMIZE TABLE httpstep_field;
OPTIMIZE TABLE httpstepitem;
OPTIMIZE TABLE httptest;
OPTIMIZE TABLE httptest_field;
OPTIMIZE TABLE httptestitem;
OPTIMIZE TABLE icon_map;
OPTIMIZE TABLE icon_mapping;
OPTIMIZE TABLE ids;
OPTIMIZE TABLE images;
OPTIMIZE TABLE interface;
OPTIMIZE TABLE interface_discovery;
OPTIMIZE TABLE item_application_prototype;
OPTIMIZE TABLE item_condition;
OPTIMIZE TABLE item_discovery;
OPTIMIZE TABLE item_preproc;
OPTIMIZE TABLE item_rtdata;
OPTIMIZE TABLE items;
OPTIMIZE TABLE items_applications;
OPTIMIZE TABLE lld_macro_path;
OPTIMIZE TABLE maintenance_tag;
OPTIMIZE TABLE maintenances;
OPTIMIZE TABLE maintenances_groups;
OPTIMIZE TABLE maintenances_hosts;
OPTIMIZE TABLE maintenances_windows;
OPTIMIZE TABLE mappings;
OPTIMIZE TABLE media;
OPTIMIZE TABLE media_type;
OPTIMIZE TABLE media_type_param;
OPTIMIZE TABLE opcommand;
OPTIMIZE TABLE opcommand_grp;
OPTIMIZE TABLE opcommand_hst;
OPTIMIZE TABLE opconditions;
OPTIMIZE TABLE operations;
OPTIMIZE TABLE opgroup;
OPTIMIZE TABLE opinventory;
OPTIMIZE TABLE opmessage;
OPTIMIZE TABLE opmessage_grp;
OPTIMIZE TABLE opmessage_usr;
OPTIMIZE TABLE optemplate;
OPTIMIZE TABLE problem;
OPTIMIZE TABLE problem_tag;
OPTIMIZE TABLE profiles;
OPTIMIZE TABLE proxy_autoreg_host;
OPTIMIZE TABLE proxy_dhistory;
OPTIMIZE TABLE proxy_history;
OPTIMIZE TABLE regexps;
OPTIMIZE TABLE rights;
OPTIMIZE TABLE screen_user;
OPTIMIZE TABLE screen_usrgrp;
OPTIMIZE TABLE screens;
OPTIMIZE TABLE screens_items;
OPTIMIZE TABLE scripts;
OPTIMIZE TABLE service_alarms;
OPTIMIZE TABLE services;
OPTIMIZE TABLE services_links;
OPTIMIZE TABLE services_times;
OPTIMIZE TABLE sessions;
OPTIMIZE TABLE slides;
OPTIMIZE TABLE slideshow_user;
OPTIMIZE TABLE slideshow_usrgrp;
OPTIMIZE TABLE slideshows;
OPTIMIZE TABLE sysmap_element_trigger;
OPTIMIZE TABLE sysmap_element_url;
OPTIMIZE TABLE sysmap_shape;
OPTIMIZE TABLE sysmap_url;
OPTIMIZE TABLE sysmap_user;
OPTIMIZE TABLE sysmap_usrgrp;
OPTIMIZE TABLE sysmaps;
OPTIMIZE TABLE sysmaps_elements;
OPTIMIZE TABLE sysmaps_link_triggers;
OPTIMIZE TABLE sysmaps_links;
OPTIMIZE TABLE tag_filter;
OPTIMIZE TABLE task;
OPTIMIZE TABLE task_acknowledge;
OPTIMIZE TABLE task_check_now;
OPTIMIZE TABLE task_close_problem;
OPTIMIZE TABLE task_remote_command;
OPTIMIZE TABLE task_remote_command_result;
OPTIMIZE TABLE timeperiods;
OPTIMIZE TABLE trendsDynamic|;
OPTIMIZE TABLE trends_uint;
OPTIMIZE TABLE trigger_depends;
OPTIMIZE TABLE trigger_discovery;
OPTIMIZE TABLE trigger_tag;
OPTIMIZE TABLE triggers;
OPTIMIZE TABLE users;
OPTIMIZE TABLE users_groups;
OPTIMIZE TABLE usrgrp;
OPTIMIZE TABLE valuemaps;
OPTIMIZE TABLE widget;
OPTIMIZE TABLE widget_field;

Comment by Marina Generalova [ 2021 Nov 10 ]

Added this to the documentation. It is now mentioned in Upgrade notes and Known issues.

[ZBX-20165] Database upgrade failed, Zabbix v. 5.0. Specified key was too long; max key length is 767 bytes Created: 2021 Nov 02 Updated: 2024 Apr 10 Resolved: 2021 Nov 30
Status:	Closed
Project:	ZABBIX BUGS AND ISSUES
Component/s:	Documentation (D)
Affects Version/s:	5.0.17
Fix Version/s:	6.0.0alpha7, 6.0 (plan)

[ZBX-20165] Database upgrade failed, Zabbix v. 5.0. Specified key was too long; max key length is 767 bytes Created: 2021 Nov 02 Updated: 2024 Apr 10 Resolved: 2021 Nov 30

"Minimum required database versions