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

Automatic DB upgrade failed

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Commercial support required
    • Icon: Trivial Trivial
    • None
    • 6.0.5
    • None

      Steps to reproduce:

      1. Made a smaller copy of the Zabbix db 4.4.9
      2. Install Zabbix 6.0
      3. Start Zabbic 6.0
      4. Automatic udate starts and goes well til 55%
      5. a foreign key constraint fails

      Result:

      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)
       ]

      Expected:

      Finish the upgrade

            zabbix.support Zabbix Support Team
            gustavo.guido@custos.uy Gustavo Guido
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: