Cannot delete proxy - SQL statement execution has failed

XMLWordPrintable

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

      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

        1. error-message.png
          error-message.png
          44 kB

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

              Created:
              Updated:
              Resolved: