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

foreign key constraint fails when proxy tries to delete groups

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Cannot Reproduce
    • Icon: Major Major
    • None
    • 2.0.0, 2.0.1
    • Proxy (P)
    • None
    • centos 5.8 X64
      apache+PHP+mysql(version: 5.0.95 )

      proxy server log

      4239:20120711:134729.555 Received configuration data from server. Datalen 45156
      4239:20120711:134729.655 [Z3005] query failed: [1451] Cannot delete or update a parent row: a foreign key constraint fails (`zabbix/opgroup`, CONSTRAINT `c_opgroup_2` FOREIGN KEY (`groupid`) REFERENCES `groups` (`groupid`)) [delete from groups where groupid in (1,2,4);
      delete from dchecks where dcheckid=2;
      delete from drules where druleid=2;
      delete from interface where interfaceid=1;
      delete from hosts where hostid in (10047,10056,10060,10065,10066,10067,10068,10069,10070,10071,10072,10073,10074,10075,10076,10077,10078,10079,10081,10082,10083,10084);
      ]
      4239:20120711:134729.655 failed to update local proxy cofiguration copy: database error

      and add zabbix_agentd server must restart proxy or clear the database resumed after the introduction.

            Unassigned Unassigned
            tom3000 Wesley
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: