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.
Aaron Mayfieldmailto:amayfield@neverfail.com 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):
[cid:part2.112AAFB8.38403747@observium.org]
_______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Mike Stupalov Observium Limited, http://observium.org
