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

Cannot delete proxy - SQL statement execution has failed

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Do
    • Affects Version/s: 3.4.13
    • Fix Version/s: None
    • Component/s: Frontend (F)
    • Labels:
    • Environment:
      Debian 9 stretch amd64
      Installed via repo.zabbix.com

      Description

      Steps to reproduce:

      1. I created passive Proxys serveral years ago, must have been version 2.0
      2. Now I have to delete them.
      3. I navigate to Administration -> Proxys
      4. Try to delete Proxy, after no Hosts are configured with it.
      5. -> Error message

      Result:

      Error in query [DELETE FROM interface WHERE hostid='10085'] [Cannot delete or update a parent row: a foreign key constraint fails (`zabbix`.`items`, CONSTRAINT `c_items_4` FOREIGN KEY (`interfaceid`) REFERENCES `interface` (`interfaceid`))]
      SQL statement execution has failed "DELETE FROM interface WHERE hostid='10085'"

      Expected:
      Proxys gets deleted.

      Several more details in my Forum Post:
      https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/358661-cannot-delete-proxy-sql-statement-execution-has-failed

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            starko Marco Hofmann
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: