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