SQL query failed

[user413]

Hi,
    Iam getting the below error when a node is down (or) if at all there is any event happen,

SQL query failed (Query = "INSERT INTO event_log                                                                              (event_id,event_code,event_timestamp,event_source,event_severity,event_message,                                                                            root_event_id,user_tag) VALUES (133,15,1263203635,21,1,'Native agent is not resp                                                                            onding',0,'')"): Duplicate entry '133' for key 1

[11-Jan-2010 15:25:17] SQL query failed (Query = "INSERT INTO alarms (alarm_id,c                                                                            reation_time,last_change_time,source_object_id,source_event_code,message,origina                                                                            l_severity,current_severity,alarm_key,alarm_state,ack_by,hd_state,hd_ref,repeat_                                                                            count,term_by,timeout,timeout_event,source_event_id) VALUES (2,1263203717,126320                                                                            3717,21,28,'blr-noc-04',4,4,'NODE_DOWN_0x00000015',0,0,0,'',1,0,0,43,139)"): Dup                                                                            licate entry '2' for key 1

Can you please help me in this

Thanks,
Subbu

[victor]

Hi!

Looks like your database is somewhat broken. Could you please run netxmsd with -D 9 option (highest debug level) for a short time and post netxmsd log to [email protected]?

Best regards,
Victor

[user413]

Hi,
    Thanks for your Valuable help, I followed the steps and Sent the logs to [email protected]? . Please advice me what are the steps that i need to follow

Thanks & Regards,
Subbu