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
What is the actual problem?
Adam.
Sent from BlueMail
On 11 Nov 2016, 22:25, at 22:25, Andrew.Jones@kiewit.com wrote:
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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Fixed in r8112 (45 days ago).
On Sat, Nov 12, 2016 at 1:31 AM, Adam Armstrong adama@memetic.org wrote:
What is the actual problem?
Adam.
Sent from BlueMail http://www.bluemail.me/r
On 11 Nov 2016, at 22:25, Andrew.Jones@kiewit.com wrote:
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!
[image: 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.com
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Hi,
how about update?
cd /opt/observium; svn up; ./discovery.php -u
On Sat, Nov 12, 2016 at 1:25 AM, Andrew.Jones@kiewit.com wrote:
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!
[image: 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.com
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (3)
-
Adam Armstrong -
Andrew.Jones＠kiewit.com -
Mike Stupalov