Zabbix database upgrade failed with newer version 3.2.4.

XMLWordPrintable

    • Type: Incident report
    • Resolution: Cannot Reproduce
    • Priority: Trivial
    • None
    • Affects Version/s: 3.0.16rc1
    • Component/s: Server (S)
    • None
    • Environment:
      POC.

      Hello Team

      We have a old setup of Zabbix running server version 2.0, it is quite old and i wanted to upgrade it. I installed a fresh Zabbix server version 3.2 (running postgres as a backend) and tried to restore the old DB to see if the upgrade the database as per its need. The DB restored and when i start the server it is giving me some database error.

      ERROR: insert or update on table "host_discovery" violates foreign key constraint "c_host_discovery_1"
      DETAIL: Key (hostid)=(10090) is not present in table "hosts".

      Is this because i am upgrading from 2.0 to directly 3.2?

      Please suggest how i should upgrade my Zabbix which is running on 2.0.3 to 3.2.4

      Thanks.
      Pratik S Chandrikapure.

            Assignee:
            Unassigned
            Reporter:
            Pratik Chandrikapure
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: