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

failed to update local proxy configuration copy: database erro

    XMLWordPrintable

    Details

      Description

      problem appears when we change host templates or add new hosts

      this is part of the proxy log

         355:20130612:121907.675 Received configuration data from server. Datalen 24521
         355:20130612:121907.791 [Z3005] query failed: [1451] Cannot delete or update a parent row: a foreign key constraint fails (`zabbix);
      delete from dchecks where dcheckid=2;
      delete from drules where druleid=2;
      delete from interface where interfaceid=1;
      delete from hosts where (hostid between 10065 and 10079 or hostid in (10047,10056,10060,10081,10082,10083,10084));
      ]
         355:20130612:121907.791 failed to update local proxy configuration copy: database error                                           
      

      Proxy:

      [root@ip-243-11-440-17 ~]# zabbix_proxy --version
      Zabbix proxy v2.0.6 (revision 35158) (22 April 2013)
      Compilation time: May 7 2013 21:39:09

      Server:
      Zabbix 2.0 Appliance

      Zabbix 2.0.6

      Database structure were imported in order as you instructed

      currently zabbix is our pilot installation, we're trying to see how that will work for us
      mentioned problem is being solved by dropping database and creating empty one each time we change configuration

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            sergey.d Sergey D.
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: