Hey guys/gals, I'm having a problem with Observium gathering/showing OSPF information. I also noticed my DB.LOG is spamming entries such as this constantly:
[2016/11/11 16:16:36 -0600] poller.php(23134): Failed dbQuery (#1062 - Duplicate entry '4064' for key 'device_id'), Query: INSERT INTO `ospf_instances` (`device_id`,`ospf_instance_id`) VALUES ('4064','0') [2016/11/11 16:16:36 -0600] poller.php(23369): Failed dbQuery (#1062 - Duplicate entry '3049' for key 'device_id'), Query: INSERT INTO `ospf_instances` (`device_id`,`ospf_instance_id`) VALUES ('3049','0') [2016/11/11 16:16:37 -0600] poller.php(24466): Failed dbQuery (#1062 - Duplicate entry '3854' for key 'device_id'), Query: INSERT INTO `ospf_instances` (`device_id`,`ospf_instance_id`) VALUES ('3854','0') [2016/11/11 16:16:37 -0600] poller.php(24847): Failed dbQuery (#1062 - Duplicate entry '4117' for key 'device_id'), Query: INSERT INTO `ospf_instances` (`device_id`,`ospf_instance_id`) VALUES ('4117','0')
Configured for: $config['db_extension'] = 'mysqli';
Version Information Observium 0.16.9.8086 (9th September 2016) OS Linux 4.4.0-38-generic [amd64] (Ubuntu 16.04) Apache 2.4.18 (Ubuntu) PHP 7.0.8-0ubuntu0.16.04.3 (OPcache: ENABLED) Python 2.7.12 MySQL 5.7.16-0ubuntu0.16.04.1 (extension: mysqli 5.0.12-dev) SNMP NET-SNMP 5.7.3 RRDtool 1.6.0
mysql> SHOW COLUMNS FROM `ospf_instances`; +--------------------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------------+-------------+------+-----+---------+----------------+ | ospf_instance_id | int(11) | NO | PRI | NULL | auto_increment | | device_id | int(11) | NO | UNI | NULL | | | ospfRouterId | varchar(32) | NO | | NULL | | | ospfAdminStat | varchar(32) | NO | | NULL | | | ospfVersionNumber | varchar(32) | NO | | NULL | | | ospfAreaBdrRtrStatus | varchar(32) | NO | | NULL | | | ospfASBdrRtrStatus | varchar(32) | NO | | NULL | | | ospfExternLsaCount | int(11) | NO | | NULL | | | ospfExternLsaCksumSum | int(11) | NO | | NULL | | | ospfTOSSupport | varchar(32) | NO | | NULL | | | ospfOriginateNewLsas | int(11) | NO | | NULL | | | ospfRxNewLsas | int(11) | NO | | NULL | | | ospfExtLsdbLimit | int(11) | YES | | NULL | | | ospfMulticastExtensions | int(11) | YES | | NULL | | | ospfExitOverflowInterval | int(11) | YES | | NULL | | | ospfDemandExtensions | varchar(32) | YES | | NULL | | +--------------------------+-------------+------+-----+---------+----------------+ 16 rows in set (0.01 sec)
Any ideas? Thanks for your help!
[Description: Description: Description: Description: Description: Description: cid:image001.jpg@01CB9CF5.E087FC40]
Andrew Jones Sr. IM Technician, Network
Kiewit Corporation 12720 I st, Omaha, NE 68137 402-938-4402 402-214-2681 cell www.kiewit.comhttp://www.kiewit.com
