Yeah, I upgraded and it is no longer doing it. Thanks!
From: Mike Stupalov <mike@stupalov.ru> on behalf of Mike Stupalov <mike@observium.org>
Date: Tuesday, August 21, 2018 at 7:29 AM
To: Observium System <observium@observium.org>, Aaron Mayfield <amayfield@neverfail.com>
Subject: Re: [Observium] db.log - Failed dbQuery
I think should be fixed in r9378.
21 August 2018 at 03:22
I recently noticed my db.log file had grown to 18GB in size (I noticed because it filled my drive). It is filled by entries like this:
[2018/08/20 14:11:56 -0500] poller.php(12451): Failed dbQuery (#1062 - Duplicate entry '88-2320-005056a94437-223078' for key 'dev_vlan_mac_port'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('88','2320','223078','005056a94437','')[2018/08/20 14:11:56 -0500] poller.php(12451): Failed dbQuery (#1062 - Duplicate entry '88-3004-005056a93130-223078' for key 'dev_vlan_mac_port'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('88','3004','223078','005056a93130','')
[2018/08/20 14:11:56 -0500] poller.php(12451): Failed dbQuery (#1062 - Duplicate entry '88-3031-0050565b341c-223078' for key 'dev_vlan_mac_port'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('88','3031','223078','0050565b341c','')
It continues to quickly grow and log entries all for different devices/mac addresses/vlans. Anyone else run into this recently?
Here is version info (I updated today to make sure there wasn’t a recent fix):
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
--
Mike Stupalov
Observium Limited, http://observium.org