Hi list We had few devices that sent a lot of traps to Spectrum (we had "A TRAP STORM HAS BEEN DETECTED" alarms). We have already stopped the snmp agent of those devices and spectrum doesn't receive traps from them anymore. The problem we have now is that the 'event' table of the archive manager is full. I've already increased the parameter max_event_records in the .vnmrc file but I don't manage to restart it. The log file ARCHMGR.OUT shows:
************************************************************************** The following output is intended to facilitate debugging, please forward to CA technical support. The files listed are not part of the customer installation of SPECTRUM. ************************************************************************** Jul 06 14:50:01 ERROR at ModelArchDBImp.cc(6056): doSqlQuery/mysql_query: Failure executing query: INSERT IGNORE INTO event(model_h, utime, counter, clk_seq, version, node_id, user_key, type, severity, vardata_string) VALUES(17579333,1246883647,829331,990,1,'\0€BH',1,68875,50,'') - The table 'event' is full ModelArchDb ERROR at DDMDbIf2.cc(2530): Generic Error: 1, commitTransaction/doSqlQuery/mysql_query: Failure executing query: INSERT IGNORE INTO event(model_h, utime, counter, clk_seq, version, node_id, user_key, type, severity, vardata_string) VALUES(17579333,1246883647,829331,990,1,'\0€BH',1,68875,50,'') Native Error: 1114, The table 'event' is full Jul 06 14:50:01 ERROR at CsEventMgr.cc(1398): Event Log Manager: Error attempting to end transaction. Jul 06 14:50:01 ERROR at CsEventMgr.cc(1419): Fatal Event Log Manager Error. Scheduling ArchMgr shutdown. Jul 06 14:50:01 : Closing all client connections... Jul 06 14:50:01 : closing database Jul 06 14:52:23 : ArchMgr is shutting down... Jul 06 14:52:23 : ArchMgr has successfully shut down. Has anyone any idea how to solve it? thanks in advance --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
