[dev.icinga.com #2793] icinga-reporting-1.7.1, empty availability-reports

[icinga-migration]

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

Created by croft on 2012-07-06 11:39:52 +00:00

Assignee: berk
Status: Closed (closed on 2012-08-23 13:12:36 +00:00)
Target Version: 1.8
Last Update: 2012-08-23 13:12:36 +00:00 (in Redmine)

Icinga Version: 1.7.1
DB Type: MySQL
DB Version: 5.0.67 SUSE MySQL RPM
Jasper Version: 4.5.0

---

Hi,

the service availibility reports are still empty.
Please have a look at http://monitoring-portal.org/wbb/index.php?page=Thread&postID=171991&highlight=#post171991 and the attached mail fom icinga-users.
Any ideas on this? It would be nice to be able to provide feedback to users.

Kind regards,
Lara

Attachments

• Re_icinga-users_Most_Jasper_Reports_are_blank__empty__Icinga-1.7.1_.txt croft - 2012-07-06 11:39:52 +00:00 - Mail_from_icinga_users
• availability.pdf croft - 2012-08-13 16:03:06 +00:00
• statehistory_ZLAW2KSV01 croft - 2012-08-14 08:56:20 +00:00
• hostgroup.txt croft - 2012-08-14 09:59:09 +00:00
• hostgroup_availability.pdf croft - 2012-08-14 09:59:09 +00:00
• show_single_events.sql tgelf - 2012-08-14 10:05:48 +00:00

---

Parent Task: #2972

[icinga-migration]

Updated by mfriedrich on 2012-08-09 10:08:32 +00:00

• Status changed from New to Feedback
• Assigned to set to berk
• Icinga Version set to 1
• (unknown custom field) set to sles

according to bernd, this should be fixed in git master in 929220d

could you please test that?
https://git.icinga.org/?p=icinga-reports.git;a=commit;h=929220d3d3fbddac0fff816a64eb9ae72512a2f3

[icinga-migration]

Updated by croft on 2012-08-09 10:43:41 +00:00

yes, I will test it.

[icinga-migration]

Updated by berk on 2012-08-09 10:47:54 +00:00

i will have a deeper look on the reporting next week

[icinga-migration]

Updated by croft on 2012-08-09 14:21:53 +00:00

I downloaded the mentioned git master.

./configure --with-jasper-server=/opt/jasperreports-server-cp-4.5.0
make
make update

So I tested all host and service reports, and I'm not happy ...

All Host- Reports for host san0003
Up: 01/01/12- 16/02/12 01/08/12-today
Down: 16/02/12- 01/08/12

HostActivityReportInGivenTime
san0003, Period 1/1/12- 8/9/12
2/16/12 2:52 PM 1 1 3 CRITICAL - 10.154.192.97: rta nan, lost 100%
2/16/12 2:57 PM 1 2 3 CRITICAL - 10.154.192.97: rta nan, lost 100%
2/16/12 3:02 PM 1 3 3 CRITICAL - 10.154.192.97: rta nan, lost 100%
8/1/12 11:31 AM 0 1 3 OK - 10.154.192.97: rta 0.153ms, lost 0%
Statechanges for this Object: 4
OK!

HostAvailabilityReportInGivenTime
san0003, Period 1/1/12- 8/9/12
Diagramm Page2, 100% up
Page 3 empty
WRONG!

CGI- Availreport says:
san0003, Period 1/1/12- 8/9/12
UP 24,608%
Down 75,392%

Host Availability Report For Last Month
san0003, Period 7/1/12- 7/31/12
Diagramm Page2, 100% down
Page3 empty
MAYBE OK!

Host Availability Report For Last Week
san0003, Period 7/30/12 - 8/5/12
Diagramm Page2, 100% down
Page3 empty
WRONG!

Host Availability Report For Last Year
san0003, Period 1/1/11 - 21/12/11
Diagramm Page2, 100% UP
WRONG!

CGI- Availreport says
san0003, Period 1/1/11 - 21/12/11
UP 99,993%
Down 0,007%

Host Downtime Report
san0003
Empty

HostNotificationReportAboutAllHostsInGivenTime
OK

Host Overview Report
san0003
OK

Host Top 10 Report In Given Time
OK

[icinga-migration]

Updated by croft on 2012-08-09 14:24:45 +00:00

...and for the Hostgroups and Services

HostgroupAvailabilityReportInGivenTime
like Host Availability Reports
san0003 Period: 8/1/12 - 8/912
Diagramm says 100% down- but he is up!
many empty pages
WRONG!

HostgroupOverviewReport
OK

ServiceActivityReportInGivenTime
OK

ServiceAvailabilityReportInGivenTime
empty page, no data

ServiceAvailabilityReportLastWeek
empty page, no data

ServiceDowntimeReport
empty, no data

ServiceNotificationReportAboutAllHostsInGivenTime
OK

ServiceTop10ReportInGivenTime
OK

[icinga-migration]

Updated by croft on 2012-08-09 14:26:25 +00:00

• Status changed from Feedback to Assigned

[icinga-migration]

Updated by tgelf on 2012-08-13 07:36:22 +00:00

Hi Lara,

I don't have a fix for your issue - but a completely new proposal for availability reports. Currently it's nothing but a pre-beta super-dangerous proposal without any warranty or support. However, it SHOULD work and is to be found in issue #2972.

Right now it is successfully running at a very few (but large) sites. Depending on your environment it could still show bugs. Therefore it would be great if you could test it and provide some feedback. If it doesn't work or show wrong results farther details such as related statehistory and downtime events would be fantastic.

Regards,
Thomas Gelf

[icinga-migration]

Updated by croft on 2012-08-13 16:03:06 +00:00

• File added availability.pdf
• Icinga Version changed from 1 to 1
• DB Type set to MySQL
• DB Version set to 5
• Jasper Version set to 4

Hi Thomas,
I tested your function and example report with a copy from my productive database with 800 Hosts and about 5000 services.
If I select a small hostgroup a got a nice report, if I select a hostgroup with many services (>2000) my jasperreport server dies....

I wonder why the sql-select says NULL for some servers availability although these server are up and running, another server has a 9999.999% availability ;)

Let me know if I could do some further tests.

Regards,
Lara

[icinga-migration]

Updated by tgelf on 2012-08-13 20:56:17 +00:00

Hey, that's looking pretty good! Showing thousands of services in a single report should work, allowing Jasper to eat more memory could help here. Right now I'm more interested in your 9999,99% Host. Could you provide me it's statehistory table entires during the chosen period and up to five events before and after that period? If there have been downtimes I'd also like to have those information too. I'll try to create "Collect debug data" query for such tasks, right now you are on your own :p

NULL values could have different reasons. Usually they will be there if you are asking for an avaialability in a time period the given host didn't exist. Right now there are other reasons too, some of them might be little bugs. Please note that currently there is a small known issue in the report package I uploaded today: it show's only active hosts, but it may also show services once configured for these hosts and been deleted quite some time ago.

I'll try to improve the SLA function within the next weeks, it will (hopefully) get better and better. However I think even right now it is already pretty cool, isn't it? ;-)

Cheers,
Thomas

[icinga-migration]

Updated by croft on 2012-08-14 08:56:20 +00:00

• File added statehistory_ZLAW2KSV01

It's pretty cool, sure :-)

[icinga-migration]

Updated by croft on 2012-08-14 09:59:09 +00:00

• File added hostgroup.txt
• File added hostgroup_availability.pdf

Bug: Hostgroup with 4 Servers, all active, but only one server in the generated report...
Maybe we should open a new issue for testing results ?

[icinga-migration]

Updated by tgelf on 2012-08-14 10:05:48 +00:00

• File added show_single_events.sql

Great, thank you. I added some SQL to this comment, could you run this too? Piping into mysql will probably not work as expected, please paste it to the interactive CLI. Starting mysql CLI with "A" (no auto-complition) is a good idea when doing so ;) And please replace <object_id> with 942.

Cheers,
Thomas

NB: Of course the last semicolon hasn't been forgotten. It's missing intentionally and therefore allows you to manually press the big red button :p

[icinga-migration]

Updated by tgelf on 2012-08-14 10:22:57 +00:00

croft wrote:

Maybe we should open a new issue for testing results ?

Shall we move to issue #2972?

[icinga-migration]

Updated by croft on 2012-08-14 10:49:58 +00:00

yes, move to #2972

[icinga-migration]

Updated by berk on 2012-08-15 10:12:23 +00:00

• Category set to Queries

[icinga-migration]

Updated by berk on 2012-08-23 13:12:36 +00:00

• Status changed from Assigned to Closed
• Parent Id set to 2972

new sla implementation available in current master. installation procedure for function still missing. Moving on in parent ticket.