[dev.icinga.com #8254] Fully support Livestatus as backend

[icinga-migration]

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

Created by ronny.biering on 2015-01-20 08:02:08 +00:00

Assignee: (none)
Status: Closed (closed on 2016-10-05 07:21:16 +00:00)
Target Version: (none)
Last Update: 2016-10-05 07:21:16 +00:00 (in Redmine)

---

The usability/support of mk_live as backend (only this) is not given 100%.

Host/Service groups are not shown correctly and exits with messages like:
"Server error: No such column: hosts_up"
"Server error: No such column: hosts_total"

The overview of open/unhandled does not show anything, but the services could be found with clicking on the summary button in the headline.

There are also some errors in the logfile:
icingaweb2[13789]: Stacktrace: #0 /usr/share/icingaweb/library/Icinga/Protocol/Livestatus/Query.php(255): Icinga\Module\Monitoring\Backend\Livestatus\Query\StatusSummaryQuery~~columnsToString() #1 /usr/share/icingaweb/library/Icinga/Protocol/Livestatus/Connection.php(232): Icinga\Protocol\Livestatus\Query>toString() #2 /usr/share/icingaweb/library/Icinga/Protocol/Livestatus/Connection.php(185): Icinga\Protocol\Livestatus\Connection->
execute(Object(Icinga\Module\Monitoring\Backend\Livestatus\Query\StatusSummaryQuery)) #3 /usr/share/icingaweb/library/Icinga/Protocol/Livestatus/Connection.php(150): Icinga\Protocol\Livestatus\ConnectionfetchAll(Object(Icinga\Module\Monitoring\Backend\Livestatus\Query\StatusSummaryQuery)) #4 /usr/share/icingaweb/library/Icinga/Data/SimpleQuery.php(353): Icinga\Protocol\Livestatus\Connection>fetchRow(Object(Icinga\Module\Monitoring\Backend\Livestatus\Query\StatusSummaryQuery)) #5 /usr/share/icingaweb/modules/monitoring/application/controllers/ListController.php(161): Icinga\Data\SimpleQueryfetchRow() #6 /usr/share/icingaweb/library/vendor/Zend/Controller/Action.php(507): Monitoring_ListController>hostsAction() #7 /usr/share/icingaweb/library/vendor/Zend/Controller/Dispatcher/Standard.php(303): Zend_Controller_Actiondispatch('hostsAction') #8 /usr/share/icingaweb/library/vendor/Zend/Controller/Front.php(937): Zend_Controller_Dispatcher_Standard>dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response)) #9 /usr/share/icingaweb/library/Icinga/Application/Web.php(159): Zend_Controller_Frontdispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response)) #10 /usr/share/icingaweb/library/Icinga/Application/webrouter.php(112): Icinga\Application\Web~~>dispatch() #11 /usr/share/icingaweb/public/index.php(5): require_once('/usr/share/icin...') #12 {main}
Fatal error: Call to undefined method Icinga\Module\Monitoring\Backend\Livestatus\Query\StatusQuery::group() in /usr/share/icingaweb/library/Icinga/Data/PivotTable.php on line 72
...
icingaweb2[5040]: Icinga\Exception\ProgrammingError in /usr/share/icingaweb/modules/monitoring/library/Monitoring/Backend/Livestatus/Query/StatusSummaryQuery.php:50 with message: No such column: hosts_total
...

Changesets

2015-02-20 10:23:31 +00:00 by elippmann e72de8d

Disable Livestatus as backend

Livestatus is not feature complete yet. This commit has to be reverted once we've fully implemented Livestatus support.

refs #8254

2015-03-10 10:00:51 +00:00 by jmeyer f4446cb

Add todo to the MonitoringWizard related to the livestatus backend type

The requirement should be added to the OR-set that has currently both
ido requirement sets so that livestatus may the only choice again.

refs #8254

---

Relations:

• relates #8254
• duplicates #8254
• duplicates #8254
• duplicates #8254

[icinga-migration]

Updated by tgelf on 2015-02-02 22:02:01 +00:00

Yes, Livestatus is not in a usable state right now - we will take care of it after beta2.

[icinga-migration]

Updated by elippmann on 2015-02-20 10:22:16 +00:00

• Subject changed from Usability of mk_live as backend to Fully support Livestatus as backend
• Target Version set to 2.0.0-rc1

[icinga-migration]

Updated by elippmann on 2015-02-20 10:22:39 +00:00

• Duplicated set to 8489

[icinga-migration]

Updated by icinga-kanban on 2015-02-20 10:28:24 +00:00

Build !#578 triggered by commit e72de8d passed successfully.

Branch: origin/master
Author: Eric Lippmann

[icinga-migration]

Updated by jmeyer on 2015-02-23 12:35:10 +00:00

• Relates set to 8508

[icinga-migration]

Updated by icinga-kanban on 2015-03-10 11:12:48 +00:00

Build !#617 triggered by the commits b978fdb, f4446cb, 59f43a0, c44d5d2, bc450c5, e80786d, 4badbc6, d0a8dd8, 551207b, 87fe9bd, 8ed4a94, 04630a2, 24d0999, 85e6fce passed successfully.

Branch: origin/master
Author: Johannes Meyer

[icinga-migration]

Updated by elippmann on 2015-03-27 15:06:12 +00:00

• Duplicated set to 4787

[icinga-migration]

Updated by elippmann on 2015-03-31 13:09:33 +00:00

• Duplicated set to 7799

[icinga-migration]

Updated by elippmann on 2015-05-18 10:41:29 +00:00

• Target Version changed from 2.0.0-rc1 to Backlog

We'll postpone this issue because Icinga 2.4 will introduce an API for querying monitoring data. Maybe we drop support for Livestatus completely.

[icinga-migration]

Updated by mfriedrich on 2015-06-15 12:04:52 +00:00

FYI in terms of livestatus and historical table support/performance: http://www.monitoring-portal.org/wbb/index.php?page=Thread&postID=217245#post217245

[icinga-migration]

Updated by elippmann on 2016-10-05 07:21:16 +00:00

• Status changed from New to Closed
• Target Version deleted Backlog

Won't fix.