Unknown column 'idSlaveS' while opening servicegroups

[eloyd]

Any idea why we'd be getting this error when trying to open Servicegroups in the CCM on 2024R1.1.4? This is preventing us from either configuring existing servicegroups, or making new ones.

Code: Select all

[Tue Apr 22 17:06:41.619020 2025] [php:error] [pid 1774574] [client 10.40.4.21:56356] PHP Fatal error:  Uncaught mysqli_sql_exception: Unknown column 'idSlaveS' in 'where clause' in /usr/local/nagiosxi/html/includes/components/ccm/classes/db.class.php:103\nStack trace:\n#0 /usr/local/nagiosxi/html/includes/components/ccm/classes/db.class.php(103): mysqli->query()\n#1 /usr/local/nagiosxi/html/includes/components/ccm/classes/db.class.php(254): DB->query()\n#2 /usr/local/nagiosxi/html/includes/components/ccm/classes/form.class.php(562): DB->find_links()\n#3 /usr/local/nagiosxi/html/includes/components/ccm/classes/form.class.php(214): Form->find_servicegroup_relationships()\n#4 /usr/local/nagiosxi/html/includes/components/ccm/includes/page_router.inc.php(194): Form->prepare_data()\n#5 /usr/local/nagiosxi/html/includes/components/ccm/index.php(51): page_router()\n#6 {main}\n  thrown in /usr/local/nagiosxi/html/includes/components/ccm/classes/db.class.php on line 103, referer: https://10.40.1.1/nagiosxi/includes/components/ccm/?cmd=view&type=servicegroup

[kfanselow]

Hi Eric,

It looks like you ran into an issue in the 2024R1.1.x branches and should be resolved in 2024R1.2.2. The problem often is triggered when someone puts a service group inside a service group. Your best bet is to upgrade to a newer version. For reference here is the relevant line from the changelog:

Code: Select all

Fixed an issue where service groups could not be edited in the CCM in some cases [GL:XI#1254] – CN

https://www.nagios.com/changelog/

Hope that's helpful !!

[eloyd]

Thanks. We'll see if we can get an upgrade on their maintenance schedule. Any idea why this would suddenly kick in on a server which was otherwise fine? And any caveats for doing the upgrade, since Nagios thinks the database is out of whack?

[kfanselow]

Hi Eric,

Sorry I missed your reply previously. The issue was related to an imprecise string match and usually the problem is triggered by someone putting a service group inside of another service group in CCM. It shouldn't be a problem for the upgrade but as always we recommend making sure you've got a good backup and test the upgrade on a test server first.

Thanks and have a great weekend !!