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

SQL Upgrade from 2.4.4 to 3.2.0 failed

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • None
    • 3.2.0
    • Server (S)
    • None

      Attempting to start server v3.2.0 but it fails during the database upgrade stage. Previous version was 2.4.4. Using PostgreSQL.

      Had a look at ZBX-11177 but the error is slightly different and the issue does not appear to be resolve.

      Many thanks for any advice!

       23811:20160923:151713.469 Starting Zabbix Server. Zabbix 3.2.0 (revision 62485).
       23811:20160923:151713.470 ****** Enabled features ******
       23811:20160923:151713.470 SNMP monitoring:           YES
       23811:20160923:151713.470 IPMI monitoring:           YES
       23811:20160923:151713.470 Web monitoring:            YES
       23811:20160923:151713.470 VMware monitoring:         YES
       23811:20160923:151713.470 SMTP authentication:       YES
       23811:20160923:151713.470 Jabber notifications:      YES
       23811:20160923:151713.470 Ez Texting notifications:  YES
       23811:20160923:151713.470 ODBC:                      YES
       23811:20160923:151713.470 SSH2 support:              YES
       23811:20160923:151713.470 IPv6 support:              YES
       23811:20160923:151713.470 TLS support:               YES
       23811:20160923:151713.470 ******************************
       23811:20160923:151713.470 using configuration file: /etc/zabbix/zabbix_server.conf
       23811:20160923:151713.485 current database version (mandatory/optional): 03010020/03010020
       23811:20160923:151713.486 required mandatory version: 03020000
       23811:20160923:151713.486 starting automatic database upgrade
       23811:20160923:151713.632 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  insert or update on table "event_recovery" violates foreign key constraint "c_event_recovery_1"
      DETAIL:  Key (eventid)=(6830565) is not present in table "events".
      

            Unassigned Unassigned
            ryan.armstrong Ryan Armstrong
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: