-
Incident report
-
Resolution: Commercial support required
-
Trivial
-
None
-
6.0.6
-
None
-
postgres
Hello
we have a issu on migration zabbix server from 5.0.25 to 6.0.0 .
env : postrges 13
containers-zabbix-server-1 | 8:20220728:144807.483 Starting Zabbix Server. Zabbix 6.0.0 (revision 5203d2e).
containers-zabbix-server-1 | 8:20220728:144807.483 ****** Enabled features ******
containers-zabbix-server-1 | 8:20220728:144807.483 SNMP monitoring: YES
containers-zabbix-server-1 | 8:20220728:144807.483 IPMI monitoring: YES
containers-zabbix-server-1 | 8:20220728:144807.483 Web monitoring: YES
containers-zabbix-server-1 | 8:20220728:144807.483 VMware monitoring: YES
containers-zabbix-server-1 | 8:20220728:144807.483 SMTP authentication: YES
containers-zabbix-server-1 | 8:20220728:144807.483 ODBC: YES
containers-zabbix-server-1 | 8:20220728:144807.483 SSH support: YES
containers-zabbix-server-1 | 8:20220728:144807.483 IPv6 support: YES
containers-zabbix-server-1 | 8:20220728:144807.483 TLS support: YES
containers-zabbix-server-1 | 8:20220728:144807.483 ******************************
containers-zabbix-server-1 | 8:20220728:144807.483 using configuration file: /etc/zabbix/zabbix_server.conf
containers-zabbix-server-1 | 8:20220728:144807.638 current database version (mandatory/optional): 05000000/05000005
containers-zabbix-server-1 | 8:20220728:144807.638 required mandatory version: 06000000
containers-zabbix-server-1 | 8:20220728:144807.638 starting automatic database upgrade
containers-zabbix-server-1 | 8:20220728:144807.664 completed 0% of database upgrade
containers-zabbix-server-1 | 8:20220728:144807.765 completed 1% of database upgrade
containers-zabbix-server-1 | 8:20220728:144807.793 completed 2% of database upgrade
containers-zabbix-server-1 | 8:20220728:144807.815 completed 3% of database upgrade
containers-zabbix-server-1 | 8:20220728:144807.841 completed 4% of database upgrade
containers-zabbix-server-1 | 8:20220728:144807.875 completed 5% of database upgrade
containers-zabbix-server-1 | 8:20220728:144807.908 completed 6% of database upgrade
containers-zabbix-server-1 | 8:20220728:144807.965 completed 7% of database upgrade
containers-zabbix-server-1 | 8:20220728:144808.031 completed 8% of database upgrade
containers-zabbix-server-1 | 8:20220728:144808.148 completed 9% of database upgrade
containers-zabbix-server-1 | 8:20220728:144808.233 completed 10% of database upgrade
containers-zabbix-server-1 | 8:20220728:144810.392 completed 11% of database upgrade
containers-zabbix-server-1 | 8:20220728:144810.478 completed 12% of database upgrade
containers-zabbix-server-1 | 8:20220728:144810.667 completed 13% of database upgrade
containers-zabbix-server-1 | 8:20220728:144810.895 completed 14% of database upgrade
containers-zabbix-server-1 | 8:20220728:144810.970 completed 15% of database upgrade
containers-zabbix-server-1 | 8:20220728:144811.028 completed 16% of database upgrade
containers-zabbix-server-1 | 8:20220728:144811.087 completed 17% of database upgrade
containers-zabbix-server-1 | 8:20220728:144811.479 completed 18% of database upgrade
containers-zabbix-server-1 | 8:20220728:144811.529 completed 19% of database upgrade
containers-zabbix-server-1 | 8:20220728:144811.555 completed 20% of database upgrade
containers-zabbix-server-1 | 8:20220728:144811.605 completed 21% of database upgrade
containers-zabbix-server-1 | 8:20220728:144811.633 completed 22% of database upgrade
containers-zabbix-server-1 | 8:20220728:144811.695 completed 23% of database upgrade
containers-zabbix-server-1 | 8:20220728:144811.782 completed 24% of database upgrade
containers-zabbix-server-1 | 8:20220728:144811.833 completed 25% of database upgrade
containers-zabbix-server-1 | 8:20220728:144811.931 completed 26% of database upgrade
containers-zabbix-server-1 | 8:20220728:144811.992 completed 27% of database upgrade
containers-zabbix-server-1 | 8:20220728:144812.049 completed 28% of database upgrade
containers-zabbix-server-1 | 8:20220728:144812.073 empty valuemap 'APC Battery Status' was removed
containers-zabbix-server-1 | 8:20220728:144812.073 empty valuemap 'HP Insight System Status' was removed
containers-zabbix-server-1 | 8:20220728:144812.073 empty valuemap 'APC Battery Replacement Status' was removed
containers-zabbix-server-1 | 8:20220728:144812.073 empty valuemap 'Dell Open Manage System Status' was removed
containers-zabbix-server-1 | 8:20220728:144851.712 completed 29% of database upgrade
containers-zabbix-server-1 | 8:20220728:144851.762 completed 30% of database upgrade
containers-zabbix-server-1 | 8:20220728:144851.852 completed 31% of database upgrade
containers-zabbix-server-1 | 8:20220728:144851.879 completed 32% of database upgrade
containers-zabbix-server-1 | 8:20220728:144851.910 completed 33% of database upgrade
containers-zabbix-server-1 | 8:20220728:144852.242 completed 34% of database upgrade
containers-zabbix-server-1 | 8:20220728:144852.272 completed 35% of database upgrade
containers-zabbix-server-1 | 8:20220728:144852.294 completed 36% of database upgrade
containers-zabbix-server-1 | 8:20220728:144852.327 completed 37% of database upgrade
containers-zabbix-server-1 | 8:20220728:144852.370 completed 38% of database upgrade
containers-zabbix-server-1 | 8:20220728:144852.627 completed 39% of database upgrade
containers-zabbix-server-1 | 8:20220728:144852.678 completed 40% of database upgrade
containers-zabbix-web-1 | 194.5.108.192 - - [28{}}}{{{}/Jul/2022{}}}{{{}:14:48:52 +0000] "POST /zabbix.php?action=notifications.get&sid=b7e8c6662e1ca5e0&output=ajax HTTP/1.1" 200 1776 "http://31.44.217.46:8080/items.php?filter_set=1&filter_hostids%5B0%5D=18482" "Mozilla/5.0 (Windows NT 6.2; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36"
containers-zabbix-server-1 | 8:20220728:144852.954 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: insert or update on table "widget_field" violates foreign key constraint "c_widget_field_5"
containers-zabbix-server-1 | DETAIL: Key (value_graphid)=(2218) is not present in table "graphs".
containers-zabbix-server-1 | [insert into widget_field (widget_fieldid,widgetid,{}}}{{{}type{}}}{{{},name,value_int,value_str,value_itemid,value_graphid,value_groupid,value_hostid,value_sysmapid) values (1658,749,6,{}}}{{{}'graphid'{}}}{{{},0,{}}}{{{}''{}}}{{{},null,2218,null,null,null)]
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 73
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 79
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 90
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 91
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 92
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 99
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 84
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 85
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 89
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 98
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 87
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 97
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 101
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 77
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 86
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 108
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 83
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 71
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 67
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 112
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 88
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 69
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 106
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 68
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 75
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 70
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 117
containers-zabbix-server-1 | 8:20220728:144852.954 Cannot convert screen 103
containers-zabbix-server-1 | 8:20220728:144852.954 database upgrade failed
We have tried to truncate all the dashboard in the Zabbix GUI , but still have the same probleme .
the zabbix db has started in 1.4 .