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

Error migration zabbix from 5.0.25 to 6.0.0

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Trivial
    • Resolution: Commercial support required
    • 6.0.6
    • None
    • Server (S)
    • None
    • postgres

    Description

      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 .

      Attachments

        Activity

          People

            zabbix.support Zabbix Support Team
            tid008 thierry regis
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: