• Type: Incident report
• Resolution: Unsupported version
• Priority: Trivial
• Fix Version/s: None
• Affects Version/s: 2.2.2
• Component/s: Frontend (F)
• Labels:

  • applications
  • duplicates
  • sql

1. 

   multi.PNG

   25 kB

   2014 Mar 21 13:16

[ZBX-7980] SQL ERROR "Duplicate entry" in the Web scenarios page

Collapse comment: Oleg Egorov (Inactive) added a comment - 2014 Mar 21 11:44, Edited by Oleg Egorov - 2014 Mar 21 12:10

Oleg Egorov (Inactive) added a comment - 2014 Mar 21 11:44 - edited

(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')".

Expand comment: Oleg Egorov (Inactive) added a comment - 2014 Mar 21 11:44, Edited by Oleg Egorov - 2014 Mar 21 12:10

Oleg Egorov (Inactive) added a comment - 2014 Mar 21 11:44 - edited (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')".

Collapse comment: Oleg Egorov (Inactive) added a comment - 2014 Mar 21 12:14

Oleg Egorov (Inactive) added a comment - 2014 Mar 21 12:14

(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)".

Expand comment: Oleg Egorov (Inactive) added a comment - 2014 Mar 21 12:14

Oleg Egorov (Inactive) added a comment - 2014 Mar 21 12:14 (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)".

Collapse comment: Oleg Egorov (Inactive) added a comment - 2014 Mar 21 13:21

Oleg Egorov (Inactive) added a comment - 2014 Mar 21 13:21

(3) Same problem in web checks

Expand comment: Oleg Egorov (Inactive) added a comment - 2014 Mar 21 13:21

Oleg Egorov (Inactive) added a comment - 2014 Mar 21 13:21 (3) Same problem in web checks

Collapse comment: Oleg Egorov (Inactive) added a comment - 2014 Mar 21 13:26

Oleg Egorov (Inactive) added a comment - 2014 Mar 21 13:26

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

Expand comment: Oleg Egorov (Inactive) added a comment - 2014 Mar 21 13:26

Oleg Egorov (Inactive) added a comment - 2014 Mar 21 13:26 Possible issue related to ZBX-3406 - api validation and host names duplicates

Collapse comment: richlv added a comment - 2014 Dec 30 21:40

richlv added a comment - 2014 Dec 30 21:40

ZBX-8263 seems to be related

Expand comment: richlv added a comment - 2014 Dec 30 21:40

richlv added a comment - 2014 Dec 30 21:40 ZBX-8263 seems to be related

Collapse comment: Ivo Kurzemnieks added a comment - 2022 Sep 06 14:50

Ivo Kurzemnieks added a comment - 2022 Sep 06 14:50

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.

Expand comment: Ivo Kurzemnieks added a comment - 2022 Sep 06 14:50

Ivo Kurzemnieks added a comment - 2022 Sep 06 14:50 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.