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