Ad Widget

Collapse

Couldn't create an item

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • burgum
    Junior Member
    • Apr 2013
    • 15

    #1

    Couldn't create an item

    Hello,
    I've installed zabbix server using postgresql as DBserver. it's working fine, but I've got a problem, when I'm trying to create item to monitor I've got DB error

    pg_query(): Query failed: ERROR: duplicate key value violates unique constraint "items_applications_1"
    DETAIL: Key (applicationid, itemid)=(356, 23328) already exists. [include/db.inc.php:511]
    Error in query [INSERT INTO items_applications (applicationid,itemid,itemappid) VALUES ('356','23328','5525')] [ERROR: duplicate key value violates unique constraint "items_applications_1"
    DETAIL: Key (applicationid, itemid)=(356, 23328) already exists.]
    SQL statement execution has failed "INSERT INTO items_applications (applicationid,itemid,itemappid) VALUES ('356','23328','5525')".


    I've checked table items_applications but there is no records with that values
  • Heilig
    Senior Member
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Mar 2013
    • 366

    #2
    Which version of Zabbix you have installed? It was a setup from scratch or update?
    You are trying to create item via API or web interface?

    Comment

    • burgum
      Junior Member
      • Apr 2013
      • 15

      #3
      zabbix version 2.0.5, new installation from sources on Debian
      trying to create item from web interface

      Comment

      • Heilig
        Senior Member
        Zabbix Certified Trainer
        Zabbix Certified SpecialistZabbix Certified Professional
        • Mar 2013
        • 366

        #4
        Can you upgrade to 2.0.6 and check for this error there?

        Comment

        • burgum
          Junior Member
          • Apr 2013
          • 15

          #5
          Heilig, thank you

          On my second VM I installed 1.8.2 from debian repository & it works fine. So I'm using it now.
          Later I will try to update my problem server from 2.0.5 to 2.0.6 and post the result.

          Comment

          Working...