[dev.icinga.com #6416] Filter for Status do not work in hostgroups and servicegroups view

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/6416

Created by mfischer on 2014-06-05 14:59:37 +00:00

Assignee: (none)
Status: New
Target Version: Backlog
Last Update: 2016-03-02 08:33:26 +00:00 (in Redmine)

Icinga Version: 1.11.4
Icinga Web Version: 1.11.0
IDO Version: 1.11.3
OS Version: RHEL 6.5
DB Type: MySQL
DB Version: Ver 14.14 Distrib 5.1.73
Browser Version: Firefox 24.0

---

For example I want to see only servicegroups containing a service with status=warning.
When I choose Filter and apply the filter Status = 1 nothing happens. I still see all my servicegroups.

Attachments

• hostgroups_status_filter.png mfischer - 2014-06-05 15:16:33 +00:00
• servicegroups_status_filter.png mfischer - 2014-06-05 15:16:36 +00:00
• 2016-03-02 09_05_53-Icinga - Hostgroups.png log1c - 2016-03-02 08:20:20 +00:00 - Error - Sort by "Status" column

[icinga-migration]

Updated by mfriedrich on 2014-06-05 15:04:10 +00:00

Screenshot?

[icinga-migration]

Updated by mfischer on 2014-06-05 15:16:39 +00:00

• File added hostgroups_status_filter.png
• File added servicegroups_status_filter.png

Uploaded two screenshots (hostgroup und servicegroup)
We only have one servicegroup in our test environment, but I chose to filter for status=1.
In the hostgroup view for example I only want to see the unreachable, but I see all hostgroups regardless of the status filter

[icinga-migration]

Updated by berk on 2015-05-18 12:18:01 +00:00

• Target Version set to Backlog

[icinga-migration]

Updated by log1c on 2016-03-02 08:33:26 +00:00

• File added 2016-03-02 09_05_53-Icinga - Hostgroups.png

The problem still exists in v1.13.1 of icinga-web. Icinga and IDO are on v1.13.3. I can reproduce it on both Ubuntu 12.04 LTS and centOS7. Browser is Google Chrome (up-to-date).

using the developer console from my browser, I extracted the message behind the error:
[added a filter for Status=2 in servicegroups-view]

`

Uncaught Doctrine_Connection_Mysql_Exception thrown:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i6__6' in 'where clause'

`

Additionally I can produce the following error by clicking the status colum in the hostgroup-view. This gives "Request failed" messages by icinga-web. (see screenshot)

`

Uncaught Doctrine_Connection_Mysql_Exception thrown:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'HOST_CURRENT_STATE' in 'order clause'. Failing Query: "SELECT i.hostgroup_id AS i__0, i3.name1 AS i3__1, i.alias AS i__2, i2.instance_id AS i2__3, i2.instance_name AS i2__4, COUNT(COALESCE(i6.current_state, 0)) AS i6__5, COALESCE(i6.current_state, 0) AS i6__6, COALESCE(i6.current_state, 0) AS i6__7, COALESCE(i6.has_been_checked, 0) AS i6__8 FROM icinga_hostgroups i INNER JOIN icinga_instances i2 ON i.instance_id = i2.instance_id INNER JOIN icinga_objects i3 ON i.hostgroup_object_id = i3.object_id INNER JOIN icinga_hostgroup_members i5 ON (i.hostgroup_id = i5.hostgroup_id) INNER JOIN icinga_hosts i4 ON i4.host_object_id = i5.host_object_id LEFT JOIN icinga_hoststatus i6 ON i4.host_object_id = i6.host_object_id INNER JOIN icinga_hosts i7 ON i6.host_object_id = i7.host_object_id WHERE (i3.is_active = '1' AND i.config_type = '1') GROUP BY i.hostgroup_id, i3.name1, i.alias, i2.instance_id, i2.instance_name, i6.current_state, i6.has_been_checked ORDER BY HOST_CURRENT_STATE ASC LIMIT 25"

`

This does not affect the servicegroups-view where I can sort by Status by clicking on the Status column.