[ZBX-11200] SQL error when adding a link between elements in maps Created: 2016 Sep 13  Updated: 2017 May 30  Resolved: 2016 Sep 14

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 3.0.3
Fix Version/s: None

Type: Incident report Priority: Trivial
Reporter: Ilya Rudometov Assignee: Unassigned
Resolution: Won't fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

web-server ubuntu 16.04
PHP 7.0.8
Apache/2.4.18

Client ubuntu 16.04
Browsers -Chromium 52


Attachments: JPEG File zbx.jpg    

 Description   

map update fails, after adding connection



 Comments   
Comment by Aleksandrs Saveljevs [ 2016 Sep 13 ]

Could you please elaborate a bit on the necessary steps to reproduce the error?

Comment by Ilya Rudometov [ 2016 Sep 13 ]

Create new map -> added two elements -> added link between the elements and click update map.
From the error text it is seen that the link id already exists in the database. What can be done to zabiks indexed base for free link id?

ps Sorry for my english

Comment by Aleksandrs Saveljevs [ 2016 Sep 14 ]

Tried with both PHP 5.6.24 and PHP 7.0.8, but the issue did not manifest. Can you reproduce the problem on a fresh database (e.g., by creating a fresh installation, importing some hosts and maps required, and then trying the described scenario)?

Comment by Ilya Rudometov [ 2016 Sep 14 ]

There are new details. The base change was made manually via mysql two hosts are added, and the link between them. As I understand zabbix "thinks" that there is no such link and adding a link via a web interface receives an error.

Comment by richlv [ 2016 Sep 14 ]

sounds like no bug in zabbix then - your direct database modifications apparently have been incorrect

Comment by Ilya Rudometov [ 2016 Sep 14 ]


Hosts and links that have been made by changing base, on the map displayed correctly. There is no test available in zabbix free checking id link there or not? Where from takes information about id link when creates a new link?

Comment by richlv [ 2016 Sep 14 ]

please see http://zabbix.org/wiki/Getting_help for support options.

in this specific case, you might have forgotten to update the 'ids' table

Comment by Ilya Rudometov [ 2016 Sep 14 ]

Ок, thanks for the help.

Comment by Ilya Rudometov [ 2016 Sep 14 ]

It is necessary to update zabbix.ids

Comment by Aleksandrs Saveljevs [ 2016 Sep 14 ]

Reopening to set the correct resolution...

Comment by Aleksandrs Saveljevs [ 2016 Sep 14 ]

Closing as "Won't fix" as per richlv's comments above.

Generated at Wed Apr 16 21:46:40 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.