[dev.icinga.com #3935] new filtering: Filtertypes from other cronks are displayed

[icinga-migration]

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

Created by mfriedrich on 2013-04-08 22:47:09 +00:00

Assignee: jmosshammer
Status: Resolved (closed on 2013-04-11 12:39:07 +00:00)
Target Version: 1.9
Last Update: 2013-04-11 18:53:27 +00:00 (in Redmine)

Icinga Version: 1.9.0
Icinga Web Version: 1.9.0
IDO Version: 1.9.0
OS Version: Debian/wheezy
DB Type: MySQL
DB Version: 5.1.66
Browser Version: chromium 25

---

filtering by a hostgroup (in open problems) throws an exception which again isn't dumped to logs, but only visible via dev tools (500 internal)

                    A critical exception occured!
                    

                        Uncaught Doctrine_Connection_Mysql_Exception thrown:
                        
                                                        SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hostgroup_name' in 'where clause'                        
                        Stacktrace:#0 /usr/share/icinga-web/lib/doctrine/lib/Doctrine/Connection/Statement.php(274): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Statement))

#1 /usr/share/icinga-web/lib/doctrine/lib/Doctrine/Connection.php(1014): Doctrine_Connection_Statement->execute(Array)
#2 /usr/share/icinga-web/lib/doctrine/lib/Doctrine/Query/Abstract.php(976): Doctrine_Connection->execute('SELECT i.object...', Array)
#3 /usr/share/icinga-web/app/modules/Api/lib/database/IcingaDoctrine_Query.class.php(116): Doctrine_Query_Abstract->_execute(NULL)
#4 /usr/share/icinga-web/lib/doctrine/lib/Doctrine/Query/Abstract.php(1026): IcingaDoctrine_Query->_execute(NULL)
#5 /usr/share/icinga-web/app/modules/Api/models/Views/ApiDQLViewModel.class.php(92): Doctrine_Query_Abstract->execute(NULL, 5)
#6 /usr/share/icinga-web/app/modules/Cronks/lib/template/TemplateWorker/DQLCronkTemplateWorker.class.php(82): API_Views_ApiDQLViewModel->getResult()
#7 /usr/share/icinga-web/app/modules/Cronks/views/System/ViewProcSuccessView.class.php(141): DQLCronkTemplateWorker->fetchDataArray()
#8 /var/cache/icinga-web/config/compile.xml_production__d41bc4e7416d79a2859fb497054ab4f5308e2df1.php(1672): Cronks_System_ViewProcSuccessView->executeJson(Object(AgaviWebRequestDataHolder))
#9 /var/cache/icinga-web/config/compile.xml_production__d41bc4e7416d79a2859fb497054ab4f5308e2df1.php(1533): AgaviExecutionFilter->executeView(Object(AgaviExecutionContainer))
#10 /var/cache/icinga-web/config/compile.xml_production__d41bc4e7416d79a2859fb497054ab4f5308e2df1.php(1255): AgaviExecutionFilter->execute(Object(AgaviFilterChain), Object(AgaviExecutionContainer))
#11 /var/cache/icinga-web/config/compile.xml_production__d41bc4e7416d79a2859fb497054ab4f5308e2df1.php(1700): AgaviFilter->executeOnce(Object(AgaviFilterChain), Object(AgaviExecutionContainer))
#12 /usr/share/icinga-web/lib/agavi/src/filter/AgaviSecurityFilter.class.php(73): AgaviFilterChain->execute(Object(AgaviExecutionContainer))
#13 /var/cache/icinga-web/config/compile.xml_production__d41bc4e7416d79a2859fb497054ab4f5308e2df1.php(1255): AgaviSecurityFilter->execute(Object(AgaviFilterChain), Object(AgaviExecutionContainer))
#14 /var/cache/icinga-web/config/compile.xml_production__d41bc4e7416d79a2859fb497054ab4f5308e2df1.php(1700): AgaviFilter->executeOnce(Object(AgaviFilterChain), Object(AgaviExecutionContainer))
#15 /var/cache/icinga-web/config/compile.xml_production__d41bc4e7416d79a2859fb497054ab4f5308e2df1.php(870): AgaviFilterChain->execute(Object(AgaviExecutionContainer))
#16 /var/cache/icinga-web/config/compile.xml_production__d41bc4e7416d79a2859fb497054ab4f5308e2df1.php(1266): AgaviExecutionContainer->execute()
#17 /var/cache/icinga-web/config/compile.xml_production__d41bc4e7416d79a2859fb497054ab4f5308e2df1.php(1255): AgaviDispatchFilter->execute(Object(AgaviFilterChain), Object(AgaviExecutionContainer))
#18 /var/cache/icinga-web/config/compile.xml_production__d41bc4e7416d79a2859fb497054ab4f5308e2df1.php(1700): AgaviFilter->executeOnce(Object(AgaviFilterChain), Object(AgaviExecutionContainer))
#19 /usr/share/icinga-web/lib/agavi/src/filter/AgaviFormPopulationFilter.class.php(78): AgaviFilterChain->execute(Object(AgaviExecutionContainer))
#20 /var/cache/icinga-web/config/compile.xml_production__d41bc4e7416d79a2859fb497054ab4f5308e2df1.php(1700): AgaviFormPopulationFilter->executeOnce(Object(AgaviFilterChain), Object(AgaviExecutionContainer))
#21 /var/cache/icinga-web/config/compile.xml_production__d41bc4e7416d79a2859fb497054ab4f5308e2df1.php(579): AgaviFilterChain->execute(Object(AgaviExecutionContainer))
#22 /usr/share/icinga-web/pub/index.php(49): AgaviController->dispatch()
#23 {main}

this works flawlessly in host status grid. might be related to the fact that open problems can't have several attributes.

Attachments

• Screen_Shot_2013-04-11_at_12.47.41_PM.png jmosshammer - 2013-04-11 10:50:07 +00:00

Changesets

2013-04-11 11:07:55 +00:00 by jmosshammer 1b4ec0e

Clear all filterpresets when displaying the filter window

 The possiblefilter property in FilterEditor wasn't correctly cleared
 when switching cronks. As the FilterEditor is only constructed once,
 this caused all filters that showed up for different cronks to be summarized. Therefore it was possible to filter for properties that weren't available.

 fixes #3935

---

Relations:

• relates #3268
• relates #3935

[icinga-migration]

Updated by jmosshammer on 2013-04-11 10:34:55 +00:00

• Assigned to set to jmosshammer

[icinga-migration]

Updated by jmosshammer on 2013-04-11 10:50:07 +00:00

• File added Screen_Shot_2013-04-11_at_12.47.41_PM.png

The problem is that the filter types from other cronks appear in this filter view. When reloading icinga-web and displaying the filter for open problems, they look like in my attachement, w\o hostgroups.
I changed the ticket title according to that.

[icinga-migration]

Updated by jmosshammer on 2013-04-11 10:51:00 +00:00

• Subject changed from new filtering: hostgroup filter in open problems: Unknown column 'hostgroup_name' in 'where clause' to new filtering: Filtertypes from other cronks are displayed

[icinga-migration]

Updated by mfriedrich on 2013-04-11 11:00:12 +00:00

i do remember discussing the issue with you in january already, but i do not really remember the solution for that. is that fixable?

[icinga-migration]

Updated by jmosshammer on 2013-04-11 11:08:59 +00:00

fixed in 1b4ec0e

[icinga-migration]

Updated by jmosshammer on 2013-04-11 12:39:07 +00:00

• Status changed from New to Resolved
• Done % changed from 0 to 100

Applied in changeset 1b4ec0e.

[icinga-migration]

Updated by mfriedrich on 2013-04-11 18:53:27 +00:00

works, thanks for fixing.