[dev.icinga.com #11603] Grouping error: 7 ERROR: column "cgo.name1" must appear in the GROUP BY clause

[icinga-migration]

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

Created by jsaathof on 2016-04-18 06:58:12 +00:00

Assignee: (none)
Status: Closed (closed on 2016-04-19 04:35:33 +00:00)
Target Version: (none)
Last Update: 2016-04-19 04:35:33 +00:00 (in Redmine)

---

After upgrading to Icinga Web 2.3.0 we encouter the following error when clicking on a service or a host.

---

SQLSTATE[42803]: Grouping error: 7 ERROR: column "cgo.name1" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT cgo.name1 AS contactgroup_name, cg.alias AS contactgr...
^, query was: SELECT cgo.name1 AS contactgroup_name, cg.alias AS contactgroup_alias FROM icinga_contactgroups AS cg
INNER JOIN icinga_objects AS cgo ON cgo.object_id = cg.contactgroup_object_id AND cgo.is_active = 1 AND cgo.objecttype_id = 11
LEFT JOIN icinga_service_contactgroups AS scg ON scg.contactgroup_object_id = cg.contactgroup_object_id
LEFT JOIN icinga_services AS s ON s.service_id = scg.service_id
LEFT JOIN icinga_objects AS so ON so.object_id = s.service_object_id AND so.is_active = 1 AND so.objecttype_id = 2 WHERE (so.name1 = 'package' AND so.name2 = 'apache') GROUP BY cg.contactgroup_id

Extra information is given below:

#0 /usr/share/icingaweb2/library/vendor/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array)
#1 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array)
#2 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Select), Array)
#3 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Abstract.php(744): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select), Array)
#4 /usr/share/php/Icinga/Data/Db/DbConnection.php(260): Zend_Db_Adapter_Abstract->fetchRow(Object(Zend_Db_Select))
#5 /usr/share/php/Icinga/Data/SimpleQuery.php(577): Icinga\Data\Db\DbConnection->fetchRow(Object(Icinga\Module\Monitoring\Backend\Ido\Query\ContactgroupQuery))
#6 /usr/share/php/Icinga/Data/SimpleQuery.php(453): Icinga\Data\SimpleQuery->fetchRow()
#7 /usr/share/icingaweb2/modules/monitoring/library/Monitoring/DataView/DataView.php(539): Icinga\Data\SimpleQuery->hasResult()
#8 zend.view:///usr/share/icingaweb2/modules/monitoring/application/views/scripts/show/components/contacts.phtml(22): Icinga\Module\Monitoring\DataView\DataView->hasResult()
#9 /usr/share/php/Icinga/Web/View.php(204): include('zend.view:///us...')
#10 /usr/share/icingaweb2/library/vendor/Zend/View/Abstract.php(888): Icinga\Web\View->_run('/usr/share/icin...')
#11 zend.view:///usr/share/icingaweb2/modules/monitoring/application/views/scripts/partials/object/detail-content.phtml(28): Zend_View_Abstract->render('show/components...')
#12 /usr/share/php/Icinga/Web/View.php(204): include('zend.view:///us...')
#13 /usr/share/icingaweb2/library/vendor/Zend/View/Abstract.php(888): Icinga\Web\View->_run('/usr/share/icin...')
#14 zend.view:///usr/share/icingaweb2/modules/monitoring/application/views/scripts/service/show.phtml(8): Zend_View_Abstract->render('partials/object...')
#15 /usr/share/php/Icinga/Web/View.php(204): include('zend.view:///us...')
#16 /usr/share/icingaweb2/library/vendor/Zend/View/Abstract.php(888): Icinga\Web\View->_run('/usr/share/icin...')
#17 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/Helper/ViewRenderer.php(904): Zend_View_Abstract->render('service/show.ph...')
#18 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/Helper/ViewRenderer.php(925): Zend_Controller_Action_Helper_ViewRenderer->renderScript('service/show.ph...', NULL)
#19 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/Helper/ViewRenderer.php(964): Zend_Controller_Action_Helper_ViewRenderer->render()
#20 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/HelperBroker.php(272): Zend_Controller_Action_Helper_ViewRenderer->postDispatch()
#21 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action.php(518): Zend_Controller_Action_HelperBroker->notifyPostDispatch()
#22 /usr/share/php/Icinga/Web/Controller/Dispatcher.php(76): Zend_Controller_Action->dispatch('showAction')
#23 /usr/share/icingaweb2/library/vendor/Zend/Controller/Front.php(937): Icinga\Web\Controller\Dispatcher->dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response))
#24 /usr/share/php/Icinga/Application/Web.php(384): Zend_Controller_Front->dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response))
#25 /usr/share/php/Icinga/Application/webrouter.php(109): Icinga\Application\Web->dispatch()
#26 /usr/share/icingaweb2/public/index.php(4): require_once('/usr/share/php/...')
#27 {main}

---

---

Relations:

• relates #11598

[icinga-migration]

Updated by jsaathof on 2016-04-18 07:00:44 +00:00

We are running SLES11 SP4 with the packages from packages.icinga.org.

[icinga-migration]

Updated by mfriedrich on 2016-04-18 07:06:29 +00:00

• Relates set to 11598

[icinga-migration]

Updated by mthode on 2016-04-18 16:06:59 +00:00

Does this still occur in 2.3.1, iirc that should fix the psql issues.

[icinga-migration]

Updated by jsaathof on 2016-04-18 17:13:46 +00:00

I hadn't seen 2.3.1 was out. Just installed it and the problem does not exist anymore. This case may be closed.

[icinga-migration]

Updated by elippmann on 2016-04-19 04:35:33 +00:00

• Status changed from New to Closed