Aaron Mayfield

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