Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-21312

Automatic DB upgrade failed 5.0.3 to 6.0.5

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • None
    • Server (S)
    • None

      Steps to reproduce:

      1. Install new version
      2. Start server 6.0 last (6.0.5)
      3. Look at the log

      Result:
      192453:20220707:120920.415 Starting Zabbix Server. Zabbix 6.0.5 (revision 8da3e1f8419).
      192453:20220707:120920.415 ****** Enabled features ******
      192453:20220707:120920.415 SNMP monitoring: YES
      192453:20220707:120920.415 IPMI monitoring: YES
      192453:20220707:120920.415 Web monitoring: YES
      192453:20220707:120920.415 VMware monitoring: YES
      192453:20220707:120920.415 SMTP authentication: YES
      192453:20220707:120920.415 ODBC: YES
      192453:20220707:120920.415 SSH support: YES
      192453:20220707:120920.415 IPv6 support: YES
      192453:20220707:120920.415 TLS support: YES
      192453:20220707:120920.415 ******************************
      192453:20220707:120920.415 using configuration file: /etc/zabbix/zabbix_server.conf
      192453:20220707:120920.426 Zabbix supports only "utf8,utf8mb3,utf8mb4" character set(s). Database "zabbix_v2_4" has default character set "latin1"
      192453:20220707:120920.426 Zabbix supports only "utf8_bin,utf8mb3_bin,utf8mb4_bin" collation(s). Database "zabbix_v2_4" has default collation "latin1_swedish_ci"
      192453:20220707:120920.440 character set name or collation name that is not supported by Zabbix found in 40 column(s) of database "zabbix_v2_4"
      192453:20220707:120920.440 only character set(s) "utf8,utf8mb3,utf8mb4" and corresponding collation(s) "utf8_bin,utf8mb3_bin,utf8mb4_bin" should be used in database
      192453:20220707:120920.450 current database version (mandatory/optional): 05030094/05030094
      192453:20220707:120920.450 required mandatory version: 06000000
      192453:20220707:120920.450 optional patches were found
      192453:20220707:120920.450 starting automatic database upgrade
      192453:20220707:120925.702 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_v2_4`.`widget_field`, CONSTRAINT `c_widget_field_5` FOREIGN KEY (`value_graphid`) REFERENCES `graphs` (`graphid`) ON DELETE CASCADE ON UPDATE RESTRICT) [insert into widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_itemid,value_graphid,value_groupid,value_hostid,value_sysmapid) values (3369,1463,6,'graphid',0,'',null,39629,null,null,null)]
      192453:20220707:120925.792 database upgrade failed
      192463:20220707:120935.982 Starting Zabbix Server. Zabbix 6.0.5 (revision 8da3e1f8419).
      192463:20220707:120935.982 ****** Enabled features ******
      192463:20220707:120935.982 SNMP monitoring: YES
      192463:20220707:120935.982 IPMI monitoring: YES
      192463:20220707:120935.982 Web monitoring: YES
      192463:20220707:120935.982 VMware monitoring: YES
      192463:20220707:120935.982 SMTP authentication: YES
      192463:20220707:120935.982 ODBC: YES
      192463:20220707:120935.982 SSH support: YES
      192463:20220707:120935.982 IPv6 support: YES
      192463:20220707:120935.982 TLS support: YES
      192463:20220707:120935.982 ******************************
      192463:20220707:120935.982 using configuration file: /etc/zabbix/zabbix_server.conf
      192463:20220707:120935.991 Zabbix supports only "utf8,utf8mb3,utf8mb4" character set(s). Database "zabbix_v2_4" has default character set "latin1"
      192463:20220707:120935.991 Zabbix supports only "utf8_bin,utf8mb3_bin,utf8mb4_bin" collation(s). Database "zabbix_v2_4" has default collation "latin1_swedish_ci"
      192463:20220707:120936.005 character set name or collation name that is not supported by Zabbix found in 40 column(s) of database "zabbix_v2_4"
      192463:20220707:120936.005 only character set(s) "utf8,utf8mb3,utf8mb4" and corresponding collation(s) "utf8_bin,utf8mb3_bin,utf8mb4_bin" should be used in database
      192463:20220707:120936.014 current database version (mandatory/optional): 05030094/05030094
      192463:20220707:120936.014 required mandatory version: 06000000
      192463:20220707:120936.014 optional patches were found
      192463:20220707:120936.014 starting automatic database upgrade
      192463:20220707:120941.328 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_v2_4`.`widget_field`, CONSTRAINT `c_widget_field_5` FOREIGN KEY (`value_graphid`) REFERENCES `graphs` (`graphid`) ON DELETE CASCADE ON UPDATE RESTRICT) [insert into widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_itemid,value_graphid,value_groupid,value_hostid,value_sysmapid) values (3369,1463,6,'graphid',0,'',null,39629,null,null,null)]
      192463:20220707:120941.415 Got signal [signal:15(SIGTERM),sender_pid:192466,sender_uid:0,reason:0]. Exiting ...
      192463:20220707:120941.415 Zabbix Server stopped. Zabbix 6.0.5 (revision 8da3e1f8419).
      Expected:
      Finish the automatica upgrade

            jroas Jose Roas
            gustavo.guido@custos.uy Gustavo Guido
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: