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

foreign key constraint fails when updating global config

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.9.5 (alpha)
    • Fix Version/s: 1.9.7 (beta), 2.0.0
    • Component/s: Frontend (F)
    • Labels:

      Description

      open administration -> general, select some host group for discovered hosts. delete this group in another tab. attempt to save general settings :

      Error in query [update config set refresh_unsupported='600',alert_usrgrpid=7,discovery_groupid='77',severity_name_0='Not classified',severity_name_1='Information',severity_name_2='Warning',severity_name_3='Average',severity_name_4='High',severity_name_5='Disaster' where ((configid BETWEEN 000000000000000 AND 099999999999999))] [Cannot add or update a child row: a foreign key constraint fails (`zabbix_1_9`.`config`, CONSTRAINT `c_config_2` FOREIGN KEY (`discovery_groupid`) REFERENCES `groups` (`groupid`))]

      there is a check for user group there, but not for the host group.

      suspecting same would happen over the api.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              richlv richlv
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: