Ad Widget

Collapse

Image ID problem in Zabbix DB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • beli
    Junior Member
    • Mar 2013
    • 12

    #1

    Image ID problem in Zabbix DB

    Hi there,
    I'm experiencing problems when creating new images. When I try to upload a new image in Zabbix frontend, I get an error from the database saying "Key (imageid)=(25) already exists.".
    I checked in the DB and yes, the first free imageid is 188. I tried to look into the PHP sources, but didn't find the place where the frontend generates IDs when creating a new images. Also there's no sequence or other generator in use on the database column imageid in table images. How can I make it use the correct next free ID?
    I'm running Zabbix 2.0.5rc1 on PostgreSQL 9.1. And I confess, I may have filled the images table in a non-standard way, when converting from MySQL to Postgres.
    Thanks in advance for any tips. Best regards.
  • heaje
    Senior Member
    Zabbix Certified Specialist
    • Sep 2009
    • 325

    #2
    Check the "ids" table in the database and verify that it has the correct "nextid" value for the images table. The "ids" table is what Zabbix uses to track ids.

    Comment

    • beli
      Junior Member
      • Mar 2013
      • 12

      #3
      That's it! How could I missed that.
      Thank you very much.

      Comment

      Working...