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
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
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.nlmailto: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.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
You're sure you ran ./discovery.php -u after you upgraded?
Sent from my iPhone
On Nov 22, 2015, at 8:48 AM, 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
Yes I am sure, to be sure I run it by hand a minute ago; database is up to date.
Regards, Bastiaan Topper
Van: Jason Lixfeld [mailto:jason@lixfeld.ca] Verzonden: zondag 22 november 2015 14:56 Aan: Observium Network Observation System observium@observium.org Onderwerp: Re: [Observium] Lot of DB errors
You're sure you ran ./discovery.php -u after you upgraded?
Sent from my iPhone
On Nov 22, 2015, at 8:48 AM, Bastiaan Topper <B.Topper@korton.nlmailto: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.orgmailto: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.nlmailto: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.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Hello, Is is posible somehow disable ( what more then >1000),because is used vlan,but I need only port's info not vlan. ( the same as bad[if] in config.php)
including: includes/polling/ports.inc.php Caching Oids: ifEntry CMD[.[0;33m/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'10.253.0.201':'161' ifEntry.[0m] EXITCODE[.[0;32m0.[0m] RUNTIME[.[0;32m2.4383s.[0m].[0m ifSpeed.21 = 0 ifSpeed.22 = 0 ifSpeed.23 = 100000000 ifSpeed.24 = 0 ifSpeed.25 = 1000000000 ifSpeed.26 = 1000000000 ifSpeed.1024 = 0 ifSpeed.1063 = 0 ifSpeed.1104 = 0 ifSpeed.2027 = 0 and more... Thanks
Hello, Is is posible somehow disable ( what more then >1000 disable ),because is used vlan,but I need only port's info not vlan. ( the same as bad[if] in config.php)
including: includes/polling/ports.inc.php Caching Oids: ifEntry CMD[.[0;33m/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'10.253.0.201':'161' ifEntry.[0m] EXITCODE[.[0;32m0.[0m] RUNTIME[.[0;32m2.4383s.[0m].[0m ifSpeed.21 = 0 ifSpeed.22 = 0 ifSpeed.23 = 100000000 ifSpeed.24 = 0 ifSpeed.25 = 1000000000 ifSpeed.26 = 1000000000 ifSpeed.1024 = 0 ifSpeed.1063 = 0 ifSpeed.1104 = 0 ifSpeed.2027 = 0 and more... Thanks
No.
Sent with AquaMail for Android http://www.aqua-mail.com
On 24 November 2015 12:21:00 Gediminas Karčmarinas gediminas@kava.lt wrote:
Hello, Is is posible somehow disable ( what more then >1000 disable ),because is used vlan,but I need only port's info not vlan. ( the same as bad[if] in config.php)
including: includes/polling/ports.inc.php Caching Oids: ifEntry CMD[.[0;33m/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'10.253.0.201':'161' ifEntry.[0m] EXITCODE[.[0;32m0.[0m] RUNTIME[.[0;32m2.4383s.[0m].[0m ifSpeed.21 = 0 ifSpeed.22 = 0 ifSpeed.23 = 100000000 ifSpeed.24 = 0 ifSpeed.25 = 1000000000 ifSpeed.26 = 1000000000 ifSpeed.1024 = 0 ifSpeed.1063 = 0 ifSpeed.1104 = 0 ifSpeed.2027 = 0 and more... Thanks
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
in not CE version is not possible to ?
On 2015-11-24 14:21, Adam Armstrong wrote:
No.
Sent with AquaMail for Android http://www.aqua-mail.com
On 24 November 2015 12:21:00 Gediminas Karčmarinas gediminas@kava.lt wrote:
Hello, Is is posible somehow disable ( what more then >1000 disable ),because is used vlan,but I need only port's info not vlan. ( the same as bad[if] in config.php)
including: includes/polling/ports.inc.php Caching Oids: ifEntry CMD[.[0;33m/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'10.253.0.201':'161' ifEntry.[0m] EXITCODE[.[0;32m0.[0m] RUNTIME[.[0;32m2.4383s.[0m].[0m ifSpeed.21 = 0 ifSpeed.22 = 0 ifSpeed.23 = 100000000 ifSpeed.24 = 0 ifSpeed.25 = 1000000000 ifSpeed.26 = 1000000000 ifSpeed.1024 = 0 ifSpeed.1063 = 0 ifSpeed.1104 = 0 ifSpeed.2027 = 0 and more... Thanks
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
In any version is not possible to.
On Tue, Nov 24, 2015 at 5:09 AM, Gediminas Karčmarinas gediminas@kava.lt wrote:
in not CE version is not possible to ?
On 2015-11-24 14:21, Adam Armstrong wrote:
No.
Sent with AquaMail for Android http://www.aqua-mail.com
On 24 November 2015 12:21:00 Gediminas Karčmarinas gediminas@kava.lt wrote:
Hello,
Is is posible somehow disable ( what more then >1000 disable ),because is used vlan,but I need only port's info not vlan. ( the same as bad[if] in config.php)
including: includes/polling/ports.inc.php Caching Oids: ifEntry CMD[.[0;33m/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'10.253.0.201':'161' ifEntry.[0m] EXITCODE[.[0;32m0.[0m] RUNTIME[.[0;32m2.4383s.[0m].[0m ifSpeed.21 = 0 ifSpeed.22 = 0 ifSpeed.23 = 100000000 ifSpeed.24 = 0 ifSpeed.25 = 1000000000 ifSpeed.26 = 1000000000 ifSpeed.1024 = 0 ifSpeed.1063 = 0 ifSpeed.1104 = 0 ifSpeed.2027 = 0 and more... Thanks
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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
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.nlmailto: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.orgmailto: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
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.nlmailto: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.orgmailto: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.nlmailto: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.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.orgmailto:observium%40observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observiumhttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
This vlans one has persisted for a very long time.
I'm not sure where it is. It's pretty annoying though!
Adam.
Sent with AquaMail for Android http://www.aqua-mail.com
On 22 November 2015 2:58:59 pm Bastiaan Topper B.Topper@korton.nl wrote:
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.nlmailto: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.orgmailto: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.nlmailto: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.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.orgmailto:observium%40observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observiumhttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
I can't find an uncommented line referencing alert_table-state.
Perhaps this was an SVN sync issue. Please delete that file, svn up and see if you get the uncommented line again.
adam. On 22/11/2015 15:31:08, Adam Armstrong adama@observium.org wrote: This vlans one has persisted for a very long time. I'm not sure where it is. It's pretty annoying though! Adam. Sent with AquaMail for Android http://www.aqua-mail.com [http://www.aqua-mail.com] On 22 November 2015 2:58:59 pm Bastiaan Topper B.Topper@korton.nl wrote: 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 [http://www.aqua-mail.com] On 22 November 2015 1:48:54 pm Bastiaan Topper <B.Topper@korton.nl [mailto: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 [mailto:jason@lixfeld.ca]] Verzonden: zondag 22 november 2015 14:24 Aan: Observium Network Observation System <observium@observium.org [mailto: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 [mailto: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 [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium] _______________________________________________ observium mailing list observium@observium.org [mailto:observium%40observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium] _______________________________________________ observium mailing list observium@observium.org [mailto:observium%40observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
Hi Adam,
I tried that, after that the file came back, with the line commented. Very strange… but it is fixed now.
Thanks again! Met vriendelijke groet, Bastiaan Topper
Van: Adam Armstrong [mailto:adama@observium.org] Verzonden: zondag 22 november 2015 18:45 Aan: observium@observium.org Onderwerp: Re: [Observium] Lot of DB errors
I can't find an uncommented line referencing alert_table-state.
Perhaps this was an SVN sync issue. Please delete that file, svn up and see if you get the uncommented line again.
adam.
On 22/11/2015 15:31:08, Adam Armstrong <adama@observium.orgmailto:adama@observium.org> wrote:
This vlans one has persisted for a very long time.
I'm not sure where it is. It's pretty annoying though!
Adam.
Sent with AquaMail for Android http://www.aqua-mail.com
On 22 November 2015 2:58:59 pm Bastiaan Topper <B.Topper@korton.nlmailto:B.Topper@korton.nl> wrote: 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.orgmailto: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.nlmailto: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.orgmailto: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.nlmailto: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.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.orgmailto:observium%40observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observiumhttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.orgmailto:observium%40observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observiumhttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Hi Bastiaan,
I'm still unsure why this happens, but sometimes SVN decides to skip an update on a file. It's very strange.
adam. On 23/11/2015 11:55:48, Bastiaan Topper b.topper@korton.nl wrote: Hi Adam, I tried that, after that the file came back, with the line commented. Very strange… but it is fixed now. Thanks again! Met vriendelijke groet, Bastiaan Topper Van: Adam Armstrong [mailto:adama@observium.org] Verzonden: zondag 22 november 2015 18:45 Aan: observium@observium.org Onderwerp: Re: [Observium] Lot of DB errors I can't find an uncommented line referencing alert_table-state. Perhaps this was an SVN sync issue. Please delete that file, svn up and see if you get the uncommented line again. adam. On 22/11/2015 15:31:08, Adam Armstrong <adama@observium.org [mailto:adama@observium.org]> wrote: This vlans one has persisted for a very long time. I'm not sure where it is. It's pretty annoying though! Adam. Sent with AquaMail for Android http://www.aqua-mail.com [http://www.aqua-mail.com] On 22 November 2015 2:58:59 pm Bastiaan Topper <B.Topper@korton.nl [mailto:B.Topper@korton.nl]> wrote: 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 [mailto:adama@observium.org]] Verzonden: zondag 22 november 2015 15:04 Aan: Observium Network Observation System <observium@observium.org [mailto: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 [http://www.aqua-mail.com] On 22 November 2015 1:48:54 pm Bastiaan Topper <B.Topper@korton.nl [mailto: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 [mailto:jason@lixfeld.ca]] Verzonden: zondag 22 november 2015 14:24 Aan: Observium Network Observation System <observium@observium.org [mailto: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 [mailto: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 [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium] _______________________________________________ observium mailing list observium@observium.org [mailto:observium%40observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium] _______________________________________________ observium mailing list observium@observium.org [mailto:observium%40observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
participants (6)
-
Aaron Finney -
Adam Armstrong -
Adam Armstrong -
Bastiaan Topper -
Gediminas Karčmarinas -
Jason Lixfeld