Good morning team!
After upgrading my zabbix server i'm having next problem on last step, automatic database upgrade.
My enviroment: Ubuntu Server 22.04, MariaDB 10.8.6, PHP 7.4.33
zabbix_server.log:
1562:20230110:085616.874 Starting Zabbix Server. Zabbix 6.2.6 (revision 6981d8b729a).
1562:20230110:085616.875 ****** Enabled features ******
1562:20230110:085616.875 SNMP monitoring: YES
1562:20230110:085616.875 IPMI monitoring: YES
1562:20230110:085616.875 Web monitoring: YES
1562:20230110:085616.875 VMware monitoring: YES
1562:20230110:085616.875 SMTP authentication: YES
1562:20230110:085616.875 ODBC: YES
1562:20230110:085616.875 SSH support: YES
1562:20230110:085616.875 IPv6 support: YES
1562:20230110:085616.875 TLS support: YES
1562:20230110:085616.875 ******************************
1562:20230110:085616.875 using configuration file: /etc/zabbix/zabbix_server.conf
1562:20230110:085616.889 current database version (mandatory/optional): 05050106/05050106
1562:20230110:085616.889 required mandatory version: 06020000
1562:20230110:085616.889 optional patches were found
1562:20230110:085616.889 starting automatic database upgrade
1562:20230110:085616.897 [Z3005] query failed: [1709] Index column size too large. The maximum column size is 767 bytes [create index items_1 on items (hostid,key_(764))]
1562:20230110:085616.898 database upgrade failed
I've try to disable innodb sctrict mode but anything changes.
Could anyone help me?
Thanks!
After upgrading my zabbix server i'm having next problem on last step, automatic database upgrade.
My enviroment: Ubuntu Server 22.04, MariaDB 10.8.6, PHP 7.4.33
zabbix_server.log:
1562:20230110:085616.874 Starting Zabbix Server. Zabbix 6.2.6 (revision 6981d8b729a).
1562:20230110:085616.875 ****** Enabled features ******
1562:20230110:085616.875 SNMP monitoring: YES
1562:20230110:085616.875 IPMI monitoring: YES
1562:20230110:085616.875 Web monitoring: YES
1562:20230110:085616.875 VMware monitoring: YES
1562:20230110:085616.875 SMTP authentication: YES
1562:20230110:085616.875 ODBC: YES
1562:20230110:085616.875 SSH support: YES
1562:20230110:085616.875 IPv6 support: YES
1562:20230110:085616.875 TLS support: YES
1562:20230110:085616.875 ******************************
1562:20230110:085616.875 using configuration file: /etc/zabbix/zabbix_server.conf
1562:20230110:085616.889 current database version (mandatory/optional): 05050106/05050106
1562:20230110:085616.889 required mandatory version: 06020000
1562:20230110:085616.889 optional patches were found
1562:20230110:085616.889 starting automatic database upgrade
1562:20230110:085616.897 [Z3005] query failed: [1709] Index column size too large. The maximum column size is 767 bytes [create index items_1 on items (hostid,key_(764))]
1562:20230110:085616.898 database upgrade failed
I've try to disable innodb sctrict mode but anything changes.
Could anyone help me?

Thanks!