Hi, I've on a fresh install of observium, from the latest SVN (not the stable)
I'm seeing errors in the SQL log, mostly duplicate entry of various kinds: [2016/01/29 06:07:11 +0100] poller.php(17259): Failed dbQuery (#1062 - Duplicate entry '17-2-984be1747168-4934' for key 'dev_vlan_mac_port'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('17','2','4934','XXXXXXXXXX','learned')
But also: [2016/01/28 16:01:05 +0100] (5756): Failed dbQuery (#1054 - Unknown column '' in 'field list'), Query: SELECT `` FROM `slas` WHERE `device_id` = '24'; [2016/01/28 16:01:05 +0100] (5756): Failed dbQuery (#1054 - Unknown column '' in 'field list'), Query: SELECT `` FROM `pseudowires` WHERE `device_id` = '24'; [2016/01/28 16:01:05 +0100] (5756): Failed dbQuery (#1054 - Unknown column 'device_id' in 'where clause'), Query: SELECT `alert_test_id` FROM `alert_tests` WHERE `device_id` = '24'; [2016/01/28 16:01:05 +0100] (5756): Failed dbQuery (#1054 - Unknown column 'device_id' in 'where clause'), Query: SELECT `maint_id` FROM `alerts_maint` WHERE `device_id` = '24'; [2016/01/28 16:01:05 +0100] (5756): Failed dbQuery (#1054 - Unknown column 'device_id' in 'where clause'), Query: SELECT `group_id` FROM `groups` WHERE `device_id` = '24';
I guess the 2:th errors are just possible to ignore if logic has changed, but the first ones are a bit worrying, perhaps there is a mismatch in the MySQL? (I'm on RHEL 6.7)
//Anders