[ZBX-5317] Map editor creates duplicate entries in sysmaps_link_triggers table Created: 2012 Jul 12 Updated: 2017 May 30 Resolved: 2012 Sep 02 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Frontend (F) |
Affects Version/s: | 2.0.1 |
Fix Version/s: | 2.0.3rc1, 2.1.0 |
Type: | Incident report | Priority: | Major |
Reporter: | Igor Novg | Assignee: | Unassigned |
Resolution: | Fixed | Votes: | 0 |
Labels: | linkindicators, maps | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified | ||
Environment: |
Linux, MySQL |
Attachments: | zabbix.png | ||||||||
Issue Links: |
|
Description |
We have a map. It has some hosts with links. Some links are bound to 4 or more triggers. I close the map, open it (unsaved), add the same trigger again, press Apply, Save Map and voila, it's successfully saved. Sometimes it helps to do all changes again, sometime it doesn't, i can't seem to figure out the cause. The DB was upgraded from 1.8 version, maybe it's related somehow. |
Comments |
Comment by Igor Novg [ 2012 Jul 12 ] |
PS: I've checked the indices, and the color isn't in an unique index, so it seems very strange. |
Comment by richlv [ 2012 Jul 12 ] |
reproducible with trunk rev 28831. steps that result in a failure for me : there might be a more simple scenario to reproduce it, but i didn't manage to find any yet output from trunk with debug enabled : error: Error in query [INSERT INTO sysmaps_link_triggers (triggerid,linktriggerid,drawtype,color,linkid) VALUES ('16537','237','3','DD0000','124')] [Duplicate entry '124-16537' for key 'sysmaps_link_triggers_1'] |
Comment by Alexey Fukalov [ 2012 Jul 26 ] |
dev branch: svn://svn.zabbix.com/branches/dev/ZBX-5317 |
Comment by Pavels Jelisejevs (Inactive) [ 2012 Aug 20 ] |
TESTED. |
Comment by Alexey Fukalov [ 2012 Aug 20 ] |
Fixed in pre-2.0.3rc1 29651, pre-2.1.0rc1 29652 |
Comment by Oleksii Zagorskyi [ 2012 Sep 02 ] |
Reopen to fix Fix version - 2.0.4 is wrong |
Comment by Oleksii Zagorskyi [ 2012 Sep 02 ] |
Closed again, including 2.1.0 |