Dear Team,
Please do help me solve the following issues:
Recently I added few more devices into the observium. To my surprise, when I click on Ports---> All Ports, the page show is blank. Before the addition of the additional devices, the interface work fine.
I tried to dig the issues by putting debug=yes into the URL: I get the following output.
SQL[SELECT sensor_class,COUNT(sensor_id) AS c FROM sensors GROUP BY sensor_class ORDER BY sensor_class ] SQL[SELECT COUNT(`app_id`) FROM `applications`]
devices WHERE status = '1' AND `ignore` = '0' AND `disabled` = '0'] SQL[SELECT COUNT(*) FROM devices WHERE status = '0' AND `ignore` = '0' AND `disabled` = '0'] SQL[SELECT COUNT(*) FROM devices WHERE `ignore` = '1' AND `disabled` = '0'] SQL[SELECT COUNT(*) FROM devices WHERE `disabled` = '1'] SQL[SELECT COUNT(*) FROM ports WHERE deleted = '0'] SQL[SELECT COUNT(*) FROM ports AS I, devices AS D WHERE I.deleted = '0' AND I.ifOperStatus = 'up' AND I.ignore = '0' AND I.device_id = D.device_id AND D.ignore = '0'] SQL[SELECT COUNT(*) FROM ports AS I, devices AS D WHERE I.deleted = '0' AND I.ifOperStatus = 'down' AND I.ifAdminStatus = 'up' AND I.ignore = '0' AND D.device_id = I.device_id AND D.ignore = '0'] SQL[SELECT COUNT(*) FROM ports AS I, devices AS D WHERE I.deleted = '0' AND I.ifAdminStatus = 'down' AND I.ignore = '0' AND D.device_id = I.device_id AND D.ignore = '0'] SQL[SELECT COUNT(*) FROM ports AS I, devices AS D WHERE I.deleted = '0' AND D.device_id = I.device_id AND (I.ignore = '1' OR D.ignore = '1')] SQL[SELECT COUNT(*) FROM ports AS I, devices AS D WHERE I.deleted = '0' AND D.device_id = I.device_id AND (I.ignore = '0' OR D.ignore = '0') AND (I.ifInErrors_delta > '0' OR I.ifOutErrors_delta > '0')] SQL[SELECT COUNT(service_id) FROM services] SQL[SELECT COUNT(service_id) FROM services WHERE service_status = '1' AND service_ignore ='0'] SQL[SELECT COUNT(service_id) FROM services WHERE service_status = '0' AND service_ignore = '0'] SQL[SELECT COUNT(service_id) FROM services WHERE service_ignore = '1'] SQL[SELECT COUNT(service_id) FROM services WHERE service_disabled = '1'] SQL[SELECT COUNT(sensor_id) FROM sensors] SQL[SELECT COUNT(sensor_id) FROM sensors WHERE sensor_status = '1' AND sensor_ignore ='0'] SQL[SELECT COUNT(sensor_id) FROM sensors WHERE sensor_status = '0' AND sensor_ignore = '0'] SQL[SELECT COUNT(sensor_id) FROM sensors WHERE sensor_ignore = '1']
Device Alerts SQL[SELECT * FROM `devices` AS D WHERE D.status = 0 AND D.ignore = 0 ORDER BY D.hostname ASC] SQL[SELECT * FROM `devices` AS D WHERE D.status = 1 AND D.uptime > 0 AND D.uptime < 84600 AND D.ignore = 0 ORDER BY D.hostname ASC] SQL[SELECT * FROM `ports` AS I LEFT JOIN `devices` AS D ON I.device_id = D.device_id WHERE I.ifOperStatus = 'down' AND I.ifAdminStatus = 'up' AND I.ignore = 0 AND I.deleted = 0 AND D.ignore = 0 AND I.ifLastChange >= DATE_SUB(NOW(), INTERVAL 24 HOUR) ORDER BY I.ifLastChange DESC, D.hostname ASC, I.ifDescr * 1 ASC ] SQL[SELECT * FROM `services` AS S LEFT JOIN `devices` AS D ON S.device_id = D.device_id WHERE S.service_status = 'down' AND S.service_ignore = 0 AND D.ignore = 0 ORDER BY D.hostname ASC] SQL[SELECT * FROM `devices` AS D LEFT JOIN bgpPeers AS B ON B.device_id = D.device_id WHERE (bgpPeerAdminStatus = 'start' OR bgpPeerAdminStatus = 'running') AND bgpPeerState != 'established' AND D.ignore = 0 ORDER BY D.hostname ASC]
Your help will be appreciated.
Regards