Ad Widget

Collapse

Error in query when adding new host

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • clubbing80s
    Senior Member
    • Sep 2005
    • 109

    #1

    Error in query when adding new host

    Hi.
    I get the following error when I try to add a new host :

    Error in query [INSERT INTO auditlog (auditid,userid,clock,ip,action,resourcetype,resou rceid,resourcename) VALUES (35427,1,1360788575,'192.168.69.175',0,4,1361659,' ups01.demo.com')] [Duplicate entry '35427' for key 'PRIMARY']

    Any ideas ?

    Edit : added :
    when add a template I get :

    Error in query [INSERT INTO events (eventid, source, object, objectid, clock, value, acknowledged) VALUES (12447218,0,0,15788,1360789944,2,0)] [Duplicate entry '12447218' for key 'PRIMARY'

    I had a look in the database and the primary key is way passed "12447218" with the last record 12462652

    I would have expected it to use the next number ?? Something is broken or there is a bug ..
    Last edited by clubbing80s; 13-02-2013, 23:17. Reason: more information
  • heaje
    Senior Member
    Zabbix Certified Specialist
    • Sep 2009
    • 325

    #2
    To me this sounds like something happened to the "ids" table to cause it to lose track of the correct values to use for ids in other tables. Try modifying the nextid field in the "ids" table to what it should be for the tables giving you problems.

    Comment

    • clubbing80s
      Senior Member
      • Sep 2005
      • 109

      #3
      Thank you seems to have worked.

      Wander how these fields go out of sync.

      Comment

      Working...