[dev.icinga.com #2602] (Pending) service not listed

[icinga-migration]

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

Created by ossmon on 2012-05-11 11:15:11 +00:00

Assignee: mfrosch
Status: Resolved (closed on 2013-04-10 21:54:30 +00:00)
Target Version: 1.9
Last Update: 2013-04-10 21:54:30 +00:00 (in Redmine)

Icinga Version: 1.6.0
Icinga Web Version: 1.6.0
IDO Version: 1.6.0
OS Version: Any
DB Type: MySQL
DB Version: 5.1
Browser Version: any

---

Icinga-Core: 1.6.1
Icinga-Web: git master

In the current git master (a75f1e3;sf), the bug #2472 is not resolved.
New service are shown als pending im classic gui, but are not shown in icinga-web.

Can anyone say me how we have to handle closed issue that are again buggy ? I dont't know if the issue will be handled from the developers when i add a comment although the issue is already closed. For this reason i open a new issue.

Attachments

• Bildschirmfoto_2012-05-11_um_14.18.36.png jmosshammer - 2012-05-11 12:23:53 +00:00
• ServicePending.JPG ossmon - 2013-03-13 13:39:01 +00:00

Changesets

2013-03-13 11:12:54 +00:00 by mfrosch 898005f

Merge branch 'mfrosch/pendingstates' into next

(refs #2602)

---

Relations:

• relates #2265
• relates #1741
• relates #3838
• relates #2602
• relates #2602

[icinga-migration]

Updated by jmosshammer on 2012-05-11 12:23:54 +00:00

• File added Bildschirmfoto_2012-05-11_um_14.18.36.png

That's perfectly fine, it's best to open a new bug and reference to the closed one. You never know if it's a regression or a new bug.

I can't reproduce this issue, all pending services are shown in my web instance (see attachement).

AFAIK you're using mysql, does the service appear when you try querying

SELECT s.display_name, ss.service_object_id FROM icinga_servicestatus ss INNER JOIN icinga_services s ON s.service_object_id = ss.service_object_id WHERE has_been_checked = 0 \G

in your mysql database.

[icinga-migration]

Updated by ossmon on 2012-05-11 13:15:48 +00:00

i have done again a simple test:

• define a passive service which doesn't receive a value
• pending service is shown in classic gui as pending
• pending service is not shown in web gui
• pending service is not listed in the select statement

we have icinga-core 1.6.1. Perhaps we need the new core version ?

i will redo the test next week with the official release of core+web.

[icinga-migration]

Updated by jmosshammer on 2012-05-11 14:06:13 +00:00

hi,

I fear that this might be an issue of ido2db not recognizing that the service exists. If
SELECT s.display_name, ss.service_object_id FROM icinga_servicestatus ss INNER JOIN icinga_services s ON s.service_object_id = ss.service_object_id WHERE display_name = 'YOUR SERVICE NAME$'

doesn't return your service, its the idodb.

[icinga-migration]

Updated by ossmon on 2012-05-11 14:24:45 +00:00

yes you are right, the service is not found in above select.

[icinga-migration]

Updated by ossmon on 2012-05-22 09:43:12 +00:00

hi,

with the new icinga/icinga-web version 1.7.0, it's the same problem.

[icinga-migration]

Updated by ossmon on 2012-06-01 07:23:48 +00:00

I have test again and the problem is not resolved in my environment.
The problem is that the new defined passiv service is not store in the table icinga_servicestatus after the reload of the core.
Only if i set the state of the service manually, it will be stored in the table.

1. Can anyone say me when the insert in the table icinga_servicestatus occurs ?
2. During testing, i suspect that a service who was deleted from the config file (and then reload), will be deleted from the icinga_services table but not from the icinga_servicestatus table. Can anyone confirm this ? I think it is a bug ?
   It has the effect that a deleted service which will be later defined again (with the same parameters) inherit the old status if the object id has not changed.

[icinga-migration]

Updated by ossmon on 2012-06-01 07:25:35 +00:00

can anyone remove the string "(with current git-master)" in the title of the issue because i've tested with the official 1.7 release.

[icinga-migration]

Updated by mfriedrich on 2012-06-01 07:56:17 +00:00

• Subject changed from (Pending) service not listed (with current git-master) to (Pending) service not listed

[icinga-migration]

Updated by ossmon on 2012-07-04 05:54:41 +00:00

Can someone reopen this Bug ? Thanks.

[icinga-migration]

Updated by mfriedrich on 2012-07-04 08:00:49 +00:00

status is still 'new'

[icinga-migration]

Updated by mfriedrich on 2012-09-24 13:32:07 +00:00

• Icinga Version set to 1
• Icinga Web Version set to 1
• IDO Version set to 1
• OS Version set to Any
• DB Type set to MySQL
• DB Version set to 5
• Browser Version set to any

ossmon wrote:

1. Can anyone say me when the insert in the table icinga_servicestatus occurs ?

when the core dumps retained states, as well as on new checks, resulting in a status update.

2. During testing, i suspect that a service who was deleted from the config file (and then reload), will be deleted from the icinga_services table but not from the icinga_servicestatus table. Can anyone confirm this ? I think it is a bug ?

it will remain there, as the status tables won't be cleaned on restarts. a dedicated solution for marking single objects as deleted is not given right now.
currently, it's all about ido2db diffing the objects table against incoming data, and once you've gotten is_active=1 you'll see those being active.

It has the effect that a deleted service which will be later defined again (with the same parameters) inherit the old status if the object id has not changed.

in general, there's currently 2 conditions

• service exists in services and servicestatus table, hasbeenchecked=0+shouldbescheduled=1, is_active=1
• service exists in services table and not in servicestatus table, but is marked as is_active in objects table

[icinga-migration]

Updated by kustodian on 2012-10-10 09:58:15 +00:00

I hade the same problem when I added new servers to the configuration and then released Icinga, but after a icinga restart everything worked fine.

It is version 1.7.2.

[icinga-migration]

Updated by mfriedrich on 2012-11-20 17:22:11 +00:00

within #2265 there have been fixes implanted into the core - is this fixed within 1.8.x ?

[icinga-migration]

Updated by talpa on 2013-01-09 13:23:45 +00:00

I don't think so. I tested with core 1.8.3/ web 1.8.1.

• Created a passiv service

• icinga reload
  => pending service is shown in classic gui, but not in web gui
  => The sql statement (#3) doesn't return the pending service.

• icinga restart
  => pending service is shown in classic and web gui
  => The sql statement (#3) returns the pending service.

[icinga-migration]

Updated by mfriedrich on 2013-03-11 17:29:57 +00:00

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

I'm aware of the problem (ido related), but still, i don't have an idea to properly fix it. Just assigning to me to keep it on my todo list.

[icinga-migration]

Updated by mfriedrich on 2013-03-12 09:10:31 +00:00

partly related to the change in #1741 which revokes all status updates during scheduling queue initialisation. re-enabling this might solve the issue partly, but still it will dump the retained states (retention.dat) duplicated then, which does not make sense at all.

[icinga-migration]

Updated by mfrosch on 2013-03-13 09:25:40 +00:00

• Assigned to changed from mfriedrich to mfrosch

Hey,
I've splitted this into multiple issues

• missing initial states in host/servicestatus tables (pending)
  Core Feature #3838
  Web Workaround: #3844

• Pending states shown as OK #3843
  the grid prints pending states as OK

• API Problems #3847

Regards
Markus

[icinga-migration]

Updated by mfrosch on 2013-03-13 09:25:56 +00:00

• Category set to Framework
• Target Version set to 1.9

[icinga-migration]

Updated by mfrosch on 2013-03-13 11:24:43 +00:00

• Status changed from Assigned to Feedback
• Done % changed from 100 to 90

I've pushed the fixes into next branch.

Could you please test this in your environment?

We are considering to release the #3843 fix with 1.8.3, which should solve your main problem.

[icinga-migration]

Updated by ossmon on 2013-03-13 13:39:02 +00:00

• File added ServicePending.JPG

Hi Markus,

i've tested your git version (your branch with the tag "mfrosch/pendingstates").

i created a new service and it is now displayed after a reload in the icinga-web as a pending service.

One problem perhaps: In the "Attempt" column, the name of a variable is displayed (${field.service_...), see screenshot. What is it ?

[icinga-migration]

Updated by mfrosch on 2013-03-13 17:07:20 +00:00

Hey,
I've seen that, it's a graphical glitch because of the missing initial state of that service (#3838 / #3844)

Basically: The status row is NULL at this time, and I'm cheating some values to be 0 instead of NULL, so the backend interprets the values as PENDING.

I could change all those columns to their respective "default" values, but that would mess up the XMLs quite a bit.

-Markus

[icinga-migration]

Updated by mfrosch on 2013-04-10 21:54:30 +00:00

• Status changed from Feedback to Resolved
• Done % changed from 90 to 100

Considering this done for now!