[dev.icinga.com #4796] Servicegroup count wrong

[icinga-migration]

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

Created by Tux12Fun on 2013-10-02 10:53:24 +00:00

Assignee: mhein
Status: Feedback
Target Version: Backlog
Last Update: 2015-05-18 12:17:50 +00:00 (in Redmine)

Icinga Version: 1.9.3
Icinga Web Version: 1.9.0
IDO Version: 0.9.0
OS Version: SLES 11 SP3
DB Type: MySQL
DB Version: 5.6.13
Browser Version: ie 8.0.601

---

Hi,

I have set up a Icinga installation, but now I found something, wher I belive it is a Bug.

The count of the Services in a Servicegroup is 5 times to high.

I have two Systems with 3 Services. If I group the Services, I get a group with 30 Services. If I click on this group, I can see only 6 Services --> This is OK.

define servicegroup{
   servicegroup_name            test
   alias                        Test
   servicegroup_members         grp1, grp2   
}

define servicegroup{
   servicegroup_name            grp1
   alias                        XY Services
}
define service{
   use                          templ1
   host_name                    system1
   service_description          CPU Performance
   check_command                check_nrpe!check_cpu_perf
   servicegroups                grp1
}

define servicegroup{
   servicegroup_name            grp2
   alias                        AB Services
}
define service{
   use                          templ1
   host_name                    system2
   service_description          CPU Performance
   check_command                check_nrpe!check_cpu_perf
   servicegroups                grp2
}

I've added a Screenshot. Only the names are changed.

With best regards

Thomas

Attachments

• icinga_servicegroups.jpg Tux12Fun - 2013-10-02 10:53:24 +00:00
• Icinga.jpg Tux12Fun - 2013-11-08 11:30:10 +00:00
• screenshot.png Tux12Fun - 2014-09-25 11:59:19 +00:00

[icinga-migration]

Updated by mfrosch on 2013-10-02 12:27:35 +00:00

• Status changed from New to Assigned
• Assigned to set to mhein

Marius: Could you check this?

[icinga-migration]

Updated by mhein on 2013-10-02 12:33:14 +00:00

• Status changed from Assigned to Feedback

Hi,

what happens if you reload your icinga. Maybe it is a duplicate of https://dev.icinga.org/issues/4151.

Can you check this please?

Kind regards,
Marius.

[icinga-migration]

Updated by Tux12Fun on 2013-10-02 13:50:38 +00:00

Hello Marius,

I did a
/etc/init.d/icinga reload
Running configuration check...OK
Reloading icinga configuration...done

--> This didn't change anything

I viewed the SQL from Issue 4151, but my Hostgroups are OK. I have checked this double. The counts are correct.

If you have a SQL for Servicegoups, I can execute this on my Database and can tell you the result.

Table: icinga_services contains 53 Records. This is correct.
Table: icinga_service_groups contains 37 Records, seem to be fine.

[icinga-migration]

Updated by Tux12Fun on 2013-10-07 08:35:22 +00:00

Hello Marius,

could this bug occur, if group names are build with a "." ?

Because I'am using names like "group1.subgroup1.subgroup2.subgroup3"
But for the hostgroups, I use the same scheme. But there is every thing fine with the counts.

So I'am looking forward to your input.

[icinga-migration]

Updated by Tux12Fun on 2013-10-16 09:30:51 +00:00

Hello Marius,

I updated the new Web from 1.9.0 to 1.9.2 but the problem still exists.

Can you cange the Version above?

Can I suupport you with any further actions?

[icinga-migration]

Updated by Tux12Fun on 2013-11-08 11:30:10 +00:00

• File added Icinga.jpg

Hello Maris,

I had a new Idea and took a look into the Classic Web.

And there I can see the same thing. So it's not only a problem of New-Web :-(

I attached you a Screenshot of the Classic Web.

[icinga-migration]

Updated by Tux12Fun on 2013-11-08 11:35:57 +00:00

Current output of icinga -v (Checkconfig)

Running pre-flight check on configuration data...

Checking services...
        Checked 161 services.
Checking hosts...
        Checked 31 hosts.
Checking host groups...
        Checked 46 host groups.
Checking service groups...
        Checked 79 service groups.
Checking contacts...
        Checked 4 contacts.
Checking contact groups...
        Checked 4 contact groups.
Checking service escalations...
        Checked 0 service escalations.
Checking service dependencies...
        Checked 0 service dependencies.
Checking host escalations...
        Checked 0 host escalations.
Checking host dependencies...
        Checked 0 host dependencies.
Checking commands...
        Checked 45 commands.
Checking time periods...
        Checked 9 time periods.
Checking modules...
        Checked 0 modules.
Checking for circular paths between hosts...
Checking for circular host and service dependencies...
Checking global event handlers...
Checking obsessive compulsive processor commands...
Checking misc settings...

Total Warnings: 0
Total Errors:   0

The highest count of services in New-Web is currently 6.245 in one group.

[icinga-migration]

Updated by mfriedrich on 2013-11-08 11:50:41 +00:00

what's with these settings mentioned? https://dev.icinga.org/issues/4151#note-8

[icinga-migration]

Updated by Tux12Fun on 2013-11-08 15:14:11 +00:00

Hello dnsmichi,

this settings are set to this values at my system:

sm01:/usr/local/icinga/etc # grep clean_ ido2db.cfg
clean_realtime_tables_on_core_startup=1
clean_config_tables_on_core_startup=1

sm01:/usr/local/icinga/etc # ps aux | grep ido | grep -v grep
icinga    6027  0.0  0.0 111788  1516 ?        Ssl  Oct23   0:52 /usr/local/icinga/bin/ido2db -c /usr/local/icinga/etc/ido2db.cfg
icinga   15649  0.0  0.0 112656  3272 ?        Sl   12:00   0:04 /usr/local/icinga/bin/ido2db -c /usr/local/icinga/etc/ido2db.cfg

[icinga-migration]

Updated by Tux12Fun on 2014-09-25 11:59:57 +00:00

• File added screenshot.png

Hi,

Today I investigated a bit of time to analyse my Database for the duplicate entries.

This is what I found. (See attached Picture)

the System "dat1" has only one Service Check with this name but in the table servicegroup_members it is listed five times.

Used SQL to SELECT:

SELECT `icinga_servicegroup_members`.servicegroup_member_id,  
   (SELECT alias 
      FROM icinga_servicegroups
      WHERE icinga_servicegroups.servicegroup_id=`icinga_servicegroup_members`.`servicegroup_id`) as afgl_servicegroup_id,
     servicegroup_id,
   (SELECT display_name
      FROM icinga_services
      WHERE icinga_services.service_object_id=`icinga_servicegroup_members`.`service_object_id`) as serv_display_name,
     service_object_id,
   (SELECT display_name
      FROM icinga_hosts
      WHERE icinga_hosts.host_object_id=
        (SELECT host_object_id
           FROM icinga_services
           WHERE icinga_services.service_object_id=`icinga_servicegroup_members`.`service_object_id`)
     ) as host_name,
     service_object_id
FROM  `icinga_servicegroup_members` 
WHERE `icinga_servicegroup_members`.`servicegroup_id`=7990 AND service_object_id=94

Is this a fault or is this ok?

[icinga-migration]

Updated by berk on 2015-05-18 12:17:50 +00:00

• Target Version set to Backlog