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!
Andrew Jones
Sr. IM Technician, Network
Kiewit Corporation
12720 I st, Omaha, NE 68137
402-938-4402 402-214-2681 cell