[ZBX-7980] SQL ERROR "Duplicate entry" in the Web scenarios page Created: 2014 Mar 21  Updated: 2022 Sep 09  Resolved: 2022 Sep 06

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

Type: Incident report Priority: Trivial
Reporter: Oleg Egorov (Inactive) Assignee: Unassigned
Resolution: Unsupported version Votes: 0
Labels: applications, duplicates, sql
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File multi.PNG    

 Description   

Web scenario edit page (I reproduce this issue in template, witch is linked to the other hosts)
Enter new application and double click on the save button.

Error in query [INSERT INTO applications (name,hostid,applicationid) VALUES ('CPUXX','10125','500')] [Duplicate entry '10125-CPUXX' for key 2]
SQL statement execution has failed "INSERT INTO applications (name,hostid,applicationid) VALUES ('CPUXX','10125','500')".
Cannot add new application "CPUXX".

 Comments   
Comment by Oleg Egorov (Inactive) [ 2014 Mar 21 ]

(1) Same problem in items

Error in query [INSERT INTO applications (name,hostid,applicationid) VALUES ('CPUXXX','10125','506')] [Duplicate entry '10125-CPUXXX' for key 2]
SQL statement execution has failed "INSERT INTO applications (name,hostid,applicationid) VALUES ('CPUXXX','10125','506')".

Comment by Oleg Egorov (Inactive) [ 2014 Mar 21 ]

(2) In items mass update, after double click, we have sql error and one new problem in multiselect.

Add new or existing applications: AAAA(new)
But application AAAA - exist.
And after re-saving
Application "AAAAA" already exists.

From application should be removed status "(new)".

Comment by Oleg Egorov (Inactive) [ 2014 Mar 21 ]

(3) Same problem in web checks

Comment by Oleg Egorov (Inactive) [ 2014 Mar 21 ]

Possible issue related to ZBX-3406 - api validation and host names duplicates

Comment by richlv [ 2014 Dec 30 ]

ZBX-8263 seems to be related

Comment by Ivo Kurzemnieks [ 2022 Sep 06 ]

Cannot reproduce on newer versions since applications have been removed since 5.4. Even more double clicking is not possible in massupdate, because the JS prevents it. And even 4.4-5.2 seems like this cannot be reproduced. I didn't get any errors.
Closing the issue.

Generated at Wed Apr 24 15:17:18 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.