Details
-
Incident report
-
Status: Open
-
Trivial
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Steps to reproduce:
- Install new version
- Start server 6.0 last (6.0.5)
- 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