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

error in query when deleting an active maintenance

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.9.7 (beta)
    • Fix Version/s: 1.9.7 (beta)
    • Component/s: Frontend (F)
    • Labels:
      None

      Description

      Inspired by ZBX-4227: in trunk, it is not possible to delete an active maintenance due to foreign key constraints:

      Error in query [DELETE FROM maintenances WHERE (maintenanceid IN ('2')) ] [Cannot delete or update a parent row: a foreign key constraint fails (`issue_dev_502`.`hosts`, CONSTRAINT `c_hosts_2` FOREIGN KEY (`maintenanceid`) REFERENCES `maintenances` (`maintenanceid`))]
      SQL statement execution has failed "DELETE FROM maintenances WHERE (maintenanceid IN ('2')) "

      Before deleting a maintenance, the GUI has to reset fields related to maintenance in the hosts table.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                asaveljevs Aleksandrs Saveljevs
              • Votes:
                1 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: