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

foreign key constraint fails when updating global config

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 1.9.5 (alpha)
    • 1.9.7 (beta), 2.0.0
    • Frontend (F)

    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

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

            Dates

              Created:
              Updated:
              Resolved: