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

deleting a proxy which is used in a discovery rule generates SQL error

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.2rc1
    • Fix Version/s: 2.0.2rc1, 2.1.0
    • Component/s: Frontend (F)
    • Labels:
    • Environment:
      trunk rev 28795

      Description

      Set "Discovery by proxy" to a proxy and try to delete the proxy:

      You will see an error:

      Error in query [DELETE FROM hosts WHERE (hostid IN ('10109')) ] [Cannot delete or update a parent row: a foreign key constraint fails (`zabbix`.`drules`, CONSTRAINT `c_drules_1` FOREIGN KEY (`proxy_hostid`) REFERENCES `hosts` (`hostid`))]
      SQL statement execution has failed "DELETE FROM hosts WHERE (hostid IN ('10109')) " [CProxy.delete -> DB.delete]

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            zalex_ua Oleksii Zagorskyi
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: