Great! That fixed it… the alerts.inc.php had 1 line not remarked (the dbQuery). I have one other db error I see in the logs, do you also know how to fix that one?
[2015/11/22 11:51:34 +0100] poller.php(40744): Failed dbQuery (#1062 - Duplicate entry '55-60-00807756f88a-4870' for key 'dev_vlan_mac_port'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`)
V
ALUES ('55','60','4870','00807756f88a','learned')
[2015/11/22 11:51:34 +0100] poller.php(40744): Failed dbQuery (#1062 - Duplicate entry '55-60-008077cae91f-4870' for key 'dev_vlan_mac_port'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`)
V
ALUES ('55','60','4870','008077cae91f','learned')
[2015/11/22 11:51:34 +0100] poller.php(40744): Failed dbQuery (#1062 - Duplicate entry '55-88-001ebe8b4280-4870' for key 'dev_vlan_mac_port'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`)
V
ALUES ('55','88','4870','001ebe8b4280','learned')
[2015/11/22 11:51:34 +0100] poller.php(40744): Failed dbQuery (#1062 - Duplicate entry '55-88-00408c6db7de-4870' for key 'dev_vlan_mac_port'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`)
V
ALUES ('55','88','4870','00408c6db7de','learned')
[2015/11/22 11:51:34 +0100] poller.php(40744): Failed dbQuery (#1062 - Duplicate entry '55-88-00408ccb0868-4870' for key 'dev_vlan_mac_port'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`)
V
ALUES ('55','88','4870','00408ccb0868','learned')
[2015/11/22 11:51:34 +0100] poller.php(40744): Failed dbQuery (#1062 - Duplicate entry '55-88-00408ccb63ad-4870' for key 'dev_vlan_mac_port'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`)
V
ALUES ('55','88','4870','00408ccb63ad','learned')
[2015/11/22 11:51:34 +0100] poller.php(40744): Failed dbQuery (#1062 - Duplicate entry '55-88-00408cd7d2a8-4870' for key 'dev_vlan_mac_port'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`)
V
ALUES ('55','88','4870','00408cd7d2a8','learned')
[2015/11/22 11:51:34 +0100] poller.php(40744): Failed dbQuery (#1062 - Duplicate entry '55-88-4419b6120416-4870' for key 'dev_vlan_mac_port'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`)
V
ALUES ('55','88','4870','4419b6120416','learned')
I have this for different devices (I see different device_ids appear in the log), but it seems to happen only once or twice a day. So every day another device.
Thanks again!
Regards,
Bastiaan Topper
Van: Adam Armstrong [mailto:adama@observium.org]
Verzonden: zondag 22 november 2015 15:04
Aan: Observium Network Observation System <observium@observium.org>
Onderwerp: Re: [Observium] Lot of DB errors
Hmm.
The alert_table-state table shouldn't be used in current versions. How odd!
Adam.
Sent with AquaMail for Android
http://www.aqua-mail.com
On 22 November 2015 1:48:54 pm Bastiaan Topper <B.Topper@korton.nl> wrote:
Sorry.
SVN version; latest build: 7208
Our version upgrades every day automatically, so yes I followed the normal upgrade procedure by svn update from the observium folder. We are using observium for multiple years now, so we started with a very early version, but updated every day so far.
I see the problem for a while now (for over a week I am sure), hoped it would get fixed by some update, but it didn’t.
Regards,
Bastiaan Topper
Van: Jason Lixfeld [mailto:jason@lixfeld.ca]
Verzonden: zondag 22 november 2015 14:24
Aan: Observium Network Observation System <observium@observium.org>
Onderwerp: Re: [Observium] Lot of DB errors
More info please.
CE or SVN?
Version?
When did you last upgrade, and did you follow the upgrade instructions?
Sent from my iPhone
On Nov 22, 2015, at 7:24 AM, Bastiaan Topper <B.Topper@korton.nl> wrote:Hi,
I receive a lot of DB errors on my Observium server every polling interval.
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10471' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10471')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10472' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10472')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10473' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10473')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10474' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10474')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10476' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10476')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10477' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10477')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10478' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10478')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10480' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10480')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10481' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10481')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10482' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10482')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10484' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10484')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10485' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10485')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10486' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10486')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10488' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10488')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10489' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10489')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10490' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10490')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10491' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10491')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10493' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10493')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10494' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10494')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10495' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10495')
[2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '67419' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('67419')
Every 5 minutes I have thousands of these errors in my error log (db.log in the observium logs folder). What could cause this? And how can I troubleshoot this?
I already tried to delete a few from the mentioned entries from the database, but it recreates them and still returns the errors. Almost all errors are for the alert_table-state table.
Thanks and regards,
Bastiaan
_______________________________________________
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