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

Database upgrade to distributed monitoring mode failes

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Major Major
    • None
    • 2.0.2
    • Server (S)
    • Debian server
      Linux XXX.XXX.co.uk 2.6.32-5-686-bigmem #1 SMP Sun May 6 04:39:05 UTC 2012 i686 GNU/Linux

      when upgrading with the command
      root@monitoring:~# zabbix_server -n 2 -c /etc/zabbix/zabbix_server.conf
      the upgrade fails with
      Dropping foreign keys zabbix_server [26224]: Error: [Z3005] query failed: [1025] Error on rename of './zabbix/hosts' to './zabbix/#sql2-43d-97663' (errno: 152) [ALTER TABLE `hosts` DROP FOREIGN KEY `c_hosts_1`]
      ......................................................................................................................... done.
      Converting tables .......................................................................................................Conversion failed.
      root@monitoring:~#

            Unassigned Unassigned
            cyberjacob Jacob Mansfield
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: