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

Database upgrade to distributed monitoring mode failes

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Won't fix
    • Affects Version/s: 2.0.2
    • Fix Version/s: None
    • Component/s: Server (S)
    • Environment:
      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

      Description

      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:~#

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: