[ZBX-4003] foreign key constraint fails when updating global config Created: 2011 Aug 02 Updated: 2017 May 30 Resolved: 2011 Sep 28 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Frontend (F) |
| Affects Version/s: | 1.9.5 (alpha) |
| Fix Version/s: | 1.9.7 (beta), 2.0.0 |
| Type: | Incident report | Priority: | Blocker |
| Reporter: | richlv | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | sql | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| 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. |
| Comments |
| Comment by richlv [ 2011 Aug 21 ] |
|
|
| Comment by Alexey Fukalov [ 2011 Sep 28 ] |
|
svn://svn.zabbix.com/branches/dev/ZBX-4003 |
| Comment by Aleksandrs Saveljevs [ 2011 Sep 29 ] |
|
Tested. Seems that updating config table over API is not possible. |
| Comment by Alexey Fukalov [ 2011 Sep 29 ] |
|
svn://svn.zabbix.com/trunk 22039 |