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