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

Zabbix Upgrade 3.2 to 3.4 - database upgrade failed

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Workaround proposed
    • Icon: Blocker Blocker
    • None
    • 3.4.4
    • Server (S)
    • None
    • Debian 8

      Hi Everyone,

      i have upaded my Zabbix version 3.2 to 3.4 with the help of the official documentation https://www.zabbix.com/documentation/3.4/manual/installation/upgrade_packages/debian_ubuntu.

      When i'm starting the Zabbix-Server service, in the log i get error for the database upgrade.

      1264:20171207:141259.346 Starting Zabbix Server. Zabbix 3.4.4 (revision 74338).
        1264:20171207:141259.346 ****** Enabled features ******
        1264:20171207:141259.346 SNMP monitoring:           YES
        1264:20171207:141259.346 IPMI monitoring:           YES
        1264:20171207:141259.346 Web monitoring:            YES
        1264:20171207:141259.346 VMware monitoring:         YES
        1264:20171207:141259.346 SMTP authentication:       YES
        1264:20171207:141259.346 Jabber notifications:      YES
        1264:20171207:141259.346 Ez Texting notifications:  YES
        1264:20171207:141259.346 ODBC:                      YES
        1264:20171207:141259.346 SSH2 support:              YES
        1264:20171207:141259.346 IPv6 support:              YES
        1264:20171207:141259.346 TLS support:               YES
        1264:20171207:141259.346 ******************************
        1264:20171207:141259.346 using configuration file: /etc/zabbix/zabbix_server.conf
        1264:20171207:141259.348 current database version (mandatory/optional): 03030004/03030004
        1264:20171207:141259.348 required mandatory version: 03040000
        1264:20171207:141259.348 optional patches were found
        1264:20171207:141259.348 starting automatic database upgrade
        1264:20171207:141259.375 [Z3005] query failed: [1025] Error on rename of './zabbix/dservices' to './zabbix/#sql2-376-32' (errno: 152) [alter table dservices drop foreign key c_dservices_2]
        1264:20171207:141259.375 database upgrade failed
      

      Have got any solution, please ?

      Thank you in advance for your time.

            Unassigned Unassigned
            tcarcail Carcaillon Thibault
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: