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

SQL error when deleting host group attached to action

    Details

      Description

      Steps to reproduce:
      1. create new host group and action;
      2. in Actions -> Operations tab -> Operation type select Run remote command;
      3. assign that host group in target list;
      4. save and then try to delete host group.

      This results in SQL error message:

      Error in query [DELETE FROM groups WHERE groupid='162'] [Cannot delete or update a parent row: a foreign key constraint fails (`ivo_zabbix_2_4/opcommand_grp`, CONSTRAINT `c_opcommand_grp_2` FOREIGN KEY (`groupid`) REFERENCES `groups` (`groupid`))]
          SQL statement execution has failed "DELETE FROM groups WHERE groupid='162'" [hostgroups.php:240 ? CFrontendApiWrapper->delete() ? CApiWrapper->__call() ? CFrontendApiWrapper->callMethod() ? CApiWrapper->callMethod() ? CFrontendApiWrapper->callClientMethod() ? CLocalApiClient->callMethod() ? call_user_func_array() ? CHostGroup->delete() ? DB::delete() ? DB::exception() in C:\Development\zabbix-2.4\frontends\php\include\classes\db\DB.php:818]

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              iivs Ivo Kurzemnieks
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: