-
Incident report
-
Resolution: Fixed
-
Major
-
2.0.14, 2.2.9, 2.4.5, 2.5.0
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]