[dev.icinga.com #3515] status cronk: state filter urls don't work, sql exception in json

[icinga-migration]

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

Created by mfriedrich on 2013-01-02 15:19:57 +00:00

Assignee: mhein
Status: Resolved (closed on 2013-01-14 12:04:29 +00:00)
Target Version: 1.8.2
Last Update: 2013-01-14 12:04:29 +00:00 (in Redmine)

Icinga Version: 1.8.3
Icinga Web Version: 1.8.1-jmosshammer/filtering
IDO Version: 1.8.3
OS Version: Debian Testing/Wheezy 7.0
DB Type: MySQL
DB Version: 5.1.61
Browser Version: chrome 22

---

This happens reproducable with Windows7, IE9 as well as Debian Testing, Chromium Version 22.0.1229.94 Built on Debian wheezy/sid, running on Debian 7.0 (161065)

commit 5e22e00161a6c36ab9475d4524caf823fbfc3396
Merge: 1e675e0 b9bfd72
Author: Jannis Mosshammer 
Date:   Wed Jan 2 15:43:38 2013 +0100

    Merge branch 'jmosshammer/1.8.2' of ssh://git.icinga.org/icinga-web into jmosshammer/filtering

A critical exception occured!
Uncaught Doctrine_Connection_Mysql_Exception thrown:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i3__8' in 'where clause'. Failing Query: "SELECT DISTINCT i.icon_image AS i__0, i2.instance_name AS i2__1, i.host_object_id AS i__2, i4.name1 AS i4__3, i.alias AS i__4, i.display_name AS i__5, i3.current_state AS i3__6, i3.last_hard_state AS i3__7, i3.current_state AS i3__8, (CASE WHEN i3.last_state_change<='1970-01-01 00:00:00' THEN i5.program_start_time ELSE i3.last_state_change END) AS i__9, i3.last_check AS i3__10, i3.next_check AS i3__11, i5.program_start_time AS i5__12, i3.output AS i3__13, i3.current_check_attempt AS i3__14, i3.max_check_attempts AS i3__15, i3.process_performance_data AS i3__16, i3.max_check_attempts AS i3__17, i3.perfdata AS i3__18, i2.instance_id AS i2__19, i.host_id AS i__20, i.action_url AS i__21, i.notes AS i__22, i.notes_url AS i__23, (i3.has_been_checked-1)*-1 AS i__24, i3.notifications_enabled AS i3__25, i3.problem_has_been_acknowledged AS i3__26, i3.scheduled_downtime_depth AS i3__27, i3.has_been_checked AS i3__28 FROM icinga_hosts i LEFT JOIN icinga_instances i2 ON i.instance_id = i2.instance_id LEFT JOIN icinga_hoststatus i3 ON i.host_object_id = i3.host_object_id LEFT JOIN icinga_objects i4 ON i.host_object_id = i4.object_id LEFT JOIN icinga_programstatus i5 ON i2.instance_id = i5.instance_id WHERE (i.config_type = '1' AND i3__8 = '0' AND i3.has_been_checked = '0') ORDER BY i.host_object_id ASC LIMIT 25"
Stacktrace:

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

A critical exception occured! Uncaught Doctrine_Connection_Mysql_Exception thrown: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'service_status' in 'where clause'. Failing Query: "SELECT i.icon_image AS i__0, i2.instance_name AS i2__1, i4.host_object_id AS i4__2, i.service_object_id AS i__3, i6.name1 AS i6__4, i4.alias AS i4__5, i4.display_name AS i4__6, i7.name2 AS i7__7, i.display_name AS i__8, i3.process_performance_data AS i3__9, i3.current_state AS i3__10, i3.last_hard_state AS i3__11, i5.last_hard_state AS i5__12, i5.current_state AS i5__13, (CASE WHEN i3.last_state_change<='1970-01-01 00:00:00' THEN i8.program_start_time ELSE i3.last_state_change END) AS i__14, i8.program_start_time AS i8__15, i3.last_check AS i3__16, i3.next_check AS i3__17, i3.output AS i3__18, i3.perfdata AS i3__19, i3.current_check_attempt AS i3__20, i3.max_check_attempts AS i3__21, i2.instance_id AS i2__22, i.service_id AS i__23, i3.notifications_enabled AS i3__24, i3.problem_has_been_acknowledged AS i3__25, i3.scheduled_downtime_depth AS i3__26, i.action_url AS i__27, i4.notes AS i4__28, i4.notes_url AS i4__29, i.notes AS i__30, i3.has_been_checked AS i3__31 FROM icinga_services i INNER JOIN icinga_instances i2 ON i.instance_id = i2.instance_id INNER JOIN icinga_servicestatus i3 ON i.service_object_id = i3.service_object_id INNER JOIN icinga_hosts i4 ON i.host_object_id = i4.host_object_id INNER JOIN icinga_hoststatus i5 ON i4.host_object_id = i5.host_object_id INNER JOIN icinga_objects i6 ON i4.host_object_id = i6.object_id INNER JOIN icinga_objects i7 ON i.service_object_id = i7.object_id INNER JOIN icinga_programstatus i8 ON i2.instance_id = i8.instance_id WHERE (i.config_type = '1' AND service_status = '1' AND i3.has_been_checked = '1') ORDER BY i6.name1 ASC LIMIT 25" Stacktrace:

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

Changesets

2013-01-14 09:59:29 +00:00 by mhein 442b49c

Legacy filter format fixes #3515

[icinga-migration]

Updated by mfriedrich on 2013-01-02 15:20:49 +00:00

• OS Version changed from Debian Testing to Debian Testing/Wheezy 7.0

debian testing == wheezy 7.0, d-u yesterday.

[icinga-migration]

Updated by mfriedrich on 2013-01-09 19:02:12 +00:00

• Assigned to changed from jmosshammer to mhein

[icinga-migration]

Updated by mhein on 2013-01-14 12:04:29 +00:00

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

Applied in changeset 442b49c.