Ad Widget

Collapse

Failed on automatic database upgrade

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pimpogu
    Junior Member
    • Jan 2023
    • 2

    #1

    Failed on automatic database upgrade

    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!
Working...