I see the same, in the latest weekly builds, things seems (?) to work anyway but It might be worth investigating.

//Anders

-----Original Message----- From: observium [mailto:observium-bounces@observium.org] On Behalf Of Simon Smith Sent: torsdag, december 17, 2015 18:43 To: Observium Network Observation System observium@observium.org Subject: Re: [Observium] Duplicate entry in applications table

feel so glad its not just me!

Simon

On 17 Dec 2015, at 5:34 pm, Tom Laermans tom.laermans@powersource.cx wrote:

Simon,

I see the same, I likely caused it. Will investigate.

Tom

On 2015-12-17 18:25, Simon Smith wrote:

...

Hi All,

not sure if ive found a bug or something is wrong on my server that is being monitored

in my db.log I’m getting

[2015/12/17 17:05:10 +0000] poller.php(6976): Failed dbQuery (#1062 - Duplicate entry '64-apache-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','apache','') [2015/12/17 17:05:10 +0000] poller.php(6976): Failed dbQuery (#1062 - Duplicate entry '64-freeradius-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','freeradius','') [2015/12/17 17:05:10 +0000] poller.php(6976): Failed dbQuery (#1062 - Duplicate entry '64-mysql-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','mysql','') [2015/12/17 17:09:23 +0000] poller.php(12106): Failed dbQuery (#1062 - Duplicate entry '64-apache-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','apache','') [2015/12/17 17:09:23 +0000] poller.php(12106): Failed dbQuery (#1062 - Duplicate entry '64-freeradius-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','freeradius','') [2015/12/17 17:09:24 +0000] poller.php(12106): Failed dbQuery (#1062 - Duplicate entry '64-mysql-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','mysql','') [2015/12/17 17:15:15 +0000] poller.php(17083): Failed dbQuery (#1062 - Duplicate entry '64-apache-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','apache','') [2015/12/17 17:15:15 +0000] poller.php(17083): Failed dbQuery (#1062 - Duplicate entry '64-freeradius-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','freeradius','') [2015/12/17 17:15:15 +0000] poller.php(17083): Failed dbQuery (#1062 - Duplicate entry '64-mysql-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','mysql','')

currently the machine runs apache, freeradius, mysql, openvpn

I’m using the unix agents ? and they are installed correctly in /usr/lib/observium_agent/local

i can even execute them correctly and get data out from out observium server

whats also weird is I’m getting data for openvpn, just not the other?

i have deleted the table entrys, but they just re-appear, and then the logs appear again

is the a bug possible?

regards

Simon _______________________________________________ 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

seems to be working fine now!

thank you

Simon

On 18 Dec 2015, at 12:20 am, Tom Laermans tom.laermans@powersource.cx wrote:

Simon,

It can't ALWAYS be you! Try svn up and see if it's gone away.

Tom

On 17/12/2015 18:43, Simon Smith wrote:

...

feel so glad its not just me!

Simon

...

On 17 Dec 2015, at 5:34 pm, Tom Laermans tom.laermans@powersource.cx wrote:

Simon,

I see the same, I likely caused it. Will investigate.

Tom

On 2015-12-17 18:25, Simon Smith wrote:

...

Hi All,

not sure if ive found a bug or something is wrong on my server that is being monitored

in my db.log I’m getting

[2015/12/17 17:05:10 +0000] poller.php(6976): Failed dbQuery (#1062 - Duplicate entry '64-apache-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','apache','') [2015/12/17 17:05:10 +0000] poller.php(6976): Failed dbQuery (#1062 - Duplicate entry '64-freeradius-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','freeradius','') [2015/12/17 17:05:10 +0000] poller.php(6976): Failed dbQuery (#1062 - Duplicate entry '64-mysql-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','mysql','') [2015/12/17 17:09:23 +0000] poller.php(12106): Failed dbQuery (#1062 - Duplicate entry '64-apache-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','apache','') [2015/12/17 17:09:23 +0000] poller.php(12106): Failed dbQuery (#1062 - Duplicate entry '64-freeradius-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','freeradius','') [2015/12/17 17:09:24 +0000] poller.php(12106): Failed dbQuery (#1062 - Duplicate entry '64-mysql-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','mysql','') [2015/12/17 17:15:15 +0000] poller.php(17083): Failed dbQuery (#1062 - Duplicate entry '64-apache-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','apache','') [2015/12/17 17:15:15 +0000] poller.php(17083): Failed dbQuery (#1062 - Duplicate entry '64-freeradius-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','freeradius','') [2015/12/17 17:15:15 +0000] poller.php(17083): Failed dbQuery (#1062 - Duplicate entry '64-mysql-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','mysql','')

currently the machine runs apache, freeradius, mysql, openvpn

I’m using the unix agents ? and they are installed correctly in /usr/lib/observium_agent/local

i can even execute them correctly and get data out from out observium server

whats also weird is I’m getting data for openvpn, just not the other?

i have deleted the table entrys, but they just re-appear, and then the logs appear again

is the a bug possible?

regards

Simon _______________________________________________ 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

---

observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium