Search found 9 matches

by alex9000
Tue Jul 28, 2020 9:03 am
Forum: Nagios XI
Topic: Nagios XI 5.7 - High CPU load caused by MySQL
Replies: 6
Views: 607

Re: Nagios XI 5.7 - High CPU load caused by MySQL

I also found some locks related to this: | 10 | ndoutils | localhost | nagios | Execute | 1 | Waiting for table level lock | INSERT INTO nagios_commenthistory (instance_id, comment_type, entry_type, object_id, comment_time, internal_comment_id, author_name, comment_data, is_persistent, comment_sourc...
by alex9000
Tue Jul 28, 2020 8:58 am
Forum: Nagios XI
Topic: Nagios XI 5.7 - High CPU load caused by MySQL
Replies: 6
Views: 607

Re: Nagios XI 5.7 - High CPU load caused by MySQL

Hi, we are still facing the mysql issue, i did a query to see the processes and the load seems to come from this update query (it returns again and again): select * from INFORMATION_SCHEMA.PROCESSLIST where db = 'nagios'; | 12 | ndoutils | localhost | nagios | Execute | 3 | Updating | UPDATE nagios_...
by alex9000
Wed Jul 22, 2020 3:50 am
Forum: Nagios XI
Topic: Nagios XI 5.7 - High CPU load caused by MySQL
Replies: 6
Views: 607

Re: Nagios XI 5.7 - High CPU load caused by MySQL

Hi, that is the output of the query: -bash-4.2$ mysql -uroot -pxxx -e "show variables like 'max_connections';" +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 151 | +-----------------+-------+ -bash-4.2$ mysql -uroot -pxxx -e "show...
by alex9000
Mon Jul 20, 2020 9:07 am
Forum: Nagios XI
Topic: Nagios XI 5.7 - High CPU load caused by MySQL
Replies: 6
Views: 607

Nagios XI 5.7 - High CPU load caused by MySQL

Hello, since the update to Nagios XI 5.7 (first was 5.7.1 and now 5.7.2), we are facing high CPU load through the mysql server. That means as soon as we change something in Nagios, e.g. change hosts and apply configuration, schedule a downtime, change services..., the mysql server is causing 100% CP...
by alex9000
Mon Jul 20, 2020 2:04 am
Forum: Nagios XI
Topic: Manage Deployed Agents - Status not updating
Replies: 3
Views: 249

Re: Manage Deployed Agents - Status not updating

Hi Alex, Yes, let's see if you can determine what's going on here. The last status check should when you refresh the pages, a few questions. 1. What operating system are you using for Nagios XI? 2. Are you logged in as the nagiosadmin or a user account? 3. Can you run the following tail command, an...
by alex9000
Fri Jul 17, 2020 4:02 am
Forum: Nagios XI
Topic: Manage Deployed Agents - Status not updating
Replies: 3
Views: 249

Manage Deployed Agents - Status not updating

Hi, when I go to Configure - Deploy Agent - Manage Deployed Agents the column "Last Status Check" and "Agent Version" are not updating at all. Also the column "OS" is empty. Is there something we can do about? Used Nagios XI: 5.7.2 (but this also occured with Nagios 5.7...
by alex9000
Wed Jun 24, 2020 3:26 am
Forum: Nagios XI
Topic: Error calling the REST API
Replies: 5
Views: 406

Re: Error calling the REST API

I am getting this error with each call to the API and also calling the API with a browser and also with CURL

e.g. call
nagiosxi/api/v1/objects/hostavailability?apikey=XXXXXXX8&pretty=1&hostgroup=XXXXX
by alex9000
Tue Jun 23, 2020 6:10 am
Forum: Nagios XI
Topic: Error calling the REST API
Replies: 5
Views: 406

Error calling the REST API

Hello, every time our Nagios REST API is called, we receive this error at the beginning of the response: <p><pre>SQL Error [nagiosxi] : ERROR: syntax error at or near "objects" LINE 1: ...6-23 13:07:12','API','jenkins',16,'API endpoint \'objects/ho... ^</pre></p> Nevertheless the call is s...
by alex9000
Mon Jun 22, 2020 9:04 am
Forum: Nagios XI
Topic: All hosts/services in pending state after upgrade to 5.7
Replies: 19
Views: 2935

Re: All hosts/services in pending state after upgrade to 5.7

Hello,

we are also facing this issue with Nagios 5.7.1: Round about 200 Hosts und 2000 Services.