Page 1 of 1
Availability report not working
Posted: Tue Nov 09, 2021 8:57 am
by nagiosATdmcico
After 10 minutes i get this error:
Gateway Timeout
The gateway did not receive a timely response from the upstream server or application.
At the OS level the process takes a full cpu core:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
512678 apache 20 0 339388 112540 7792 R 99.3 0.7 0:07.51 avail.cgi
ssl_error_log
[Mon Nov 08 18:58:07.686106 2021] [proxy_fcgi:error] [pid 2635534:tid 140246587012864] (70007)The timeout specified has expired: [client 172.22.4.206:4257] AH01075: Error dispatching request to : (polling), referer:
https://ng.xxxxx.com/nagiosxi/reports/
Manual installation
Oracle Linux Server release 8.4
Linux 5.4.17-2102.203.5.el8uek.x86_64 #2 SMP Mon Jun 28 16:44:26 PDT 2021 x86_64 x86_64 x86_64 GNU/Linux
Nagios XI 5.8.5
Re: Availability report not working
Posted: Tue Nov 09, 2021 4:16 pm
by ssax
Please follow the instructions in the attached document and let us know if that resolves your issue (it should).
php-fpm timeout issue.txt
Re: Availability report not working
Posted: Wed Nov 10, 2021 9:09 am
by nagiosATdmcico
After the changes im not getting the error but still a month report is not finishing.
I try to schedule the report but after 10-12 minutes of running, the attached CSV says "Your session has timed out".
Im not sure why the performance is this slow.
Is there another way to get month availaibility for my services?
I checked the archive log files and i see that for some reason size increased a lot, maybe is this causing the perfomance issue?
-rw-r--r-- 1 nagios nagios 11M Oct 2 20:00 nagios-10-02-2021-00.log
-rw-r--r-- 1 nagios nagios 6.0M Oct 3 07:34 nagios-10-03-2021-00.log
-rw-r--r-- 1 nagios nagios 6.3M Oct 4 07:40 nagios-10-04-2021-00.log
-rw-r--r-- 1 nagios nagios 6.8M Oct 5 07:48 nagios-10-05-2021-00.log
-rw-r--r-- 1 nagios nagios 6.7M Oct 6 08:27 nagios-10-06-2021-00.log
-rw-r--r-- 1 nagios nagios 6.0M Oct 7 10:46 nagios-10-07-2021-00.log
-rw-r--r-- 1 nagios nagios 6.5M Oct 8 10:08 nagios-10-08-2021-00.log
-rw-r--r-- 1 nagios nagios 6.6M Oct 9 07:33 nagios-10-09-2021-00.log
-rw-r--r-- 1 nagios nagios 6.5M Oct 10 04:50 nagios-10-10-2021-00.log
-rw-r--r-- 1 nagios nagios 6.4M Oct 11 05:11 nagios-10-11-2021-00.log
-rw-r--r-- 1 nagios nagios 6.3M Oct 12 05:05 nagios-10-12-2021-00.log
-rw-r--r-- 1 nagios nagios 6.1M Oct 13 20:00 nagios-10-13-2021-00.log
-rw-r--r-- 1 nagios nagios 6.1M Oct 14 06:53 nagios-10-14-2021-00.log
-rw-r--r-- 1 nagios nagios 6.5M Oct 15 04:07 nagios-10-15-2021-00.log
-rw-r--r-- 1 nagios nagios 5.9M Oct 16 20:00 nagios-10-16-2021-00.log
-rw-r--r-- 1 nagios nagios 6.1M Oct 17 08:04 nagios-10-17-2021-00.log
-rw-r--r-- 1 nagios nagios 6.5M Oct 18 02:53 nagios-10-18-2021-00.log
-rw-r--r-- 1 nagios nagios 22M Oct 19 00:00 nagios-10-19-2021-00.log
-rw-r--r-- 1 nagios nagios 38M Oct 20 00:00 nagios-10-20-2021-00.log
-rw-r--r-- 1 nagios nagios 36M Oct 21 00:00 nagios-10-21-2021-00.log
-rw-r--r-- 1 nagios nagios 37M Oct 22 00:00 nagios-10-22-2021-00.log
-rw-r--r-- 1 nagios nagios 35M Oct 23 00:00 nagios-10-23-2021-00.log
-rw-r--r-- 1 nagios nagios 37M Oct 24 00:00 nagios-10-24-2021-00.log
-rw-r--r-- 1 nagios nagios 35M Oct 25 00:00 nagios-10-25-2021-00.log
-rw-r--r-- 1 nagios nagios 37M Oct 26 00:00 nagios-10-26-2021-00.log
-rw-r--r-- 1 nagios nagios 34M Oct 27 00:00 nagios-10-27-2021-00.log
-rw-r--r-- 1 nagios nagios 30M Oct 28 00:00 nagios-10-28-2021-00.log
-rw-r--r-- 1 nagios nagios 75M Oct 30 00:00 nagios-10-30-2021-00.log
-rw-r--r-- 1 nagios nagios 43M Oct 31 00:00 nagios-10-31-2021-00.log
-rw-r--r-- 1 nagios nagios 41M Nov 1 00:00 nagios-11-01-2021-00.log
-rw-r--r-- 1 nagios nagios 41M Nov 2 00:00 nagios-11-02-2021-00.log
-rw-r--r-- 1 nagios nagios 36M Nov 3 00:00 nagios-11-03-2021-00.log
-rw-r--r-- 1 nagios nagios 37M Nov 4 00:00 nagios-11-04-2021-00.log
-rw-r--r-- 1 nagios nagios 33M Nov 5 00:00 nagios-11-05-2021-00.log
-rw-r--r-- 1 nagios nagios 33M Nov 6 00:00 nagios-11-06-2021-00.log
-rw-r--r-- 1 nagios nagios 34M Nov 7 00:00 nagios-11-07-2021-00.log
-rw-r--r-- 1 nagios nagios 33M Nov 8 00:00 nagios-11-08-2021-00.log
-rw-r--r-- 1 nagios nagios 34M Nov 9 00:00 nagios-11-09-2021-00.log
-rw-r--r-- 1 nagios nagios 33M Nov 10 00:00 nagios-11-10-2021-00.log
Re: Availability report not working
Posted: Thu Nov 11, 2021 10:12 am
by ssax
Please PM me a copy of your
profile.zip, you can download it from Admin > System Profile by clicking the Download Profile button.
Attach this file as well:
Re: Availability report not working
Posted: Fri Nov 12, 2021 5:16 pm
by nagiosATdmcico
I attached the files requested.
Moderator's Note: The profile has been shared with the support team but has been removed from the public forum.
Re: Availability report not working
Posted: Mon Nov 15, 2021 2:51 pm
by ssax
Please send the output of these commands:
- NOTE: You may need to adjust the -uroot and -pnagiosxi in the first two commands if you've changed the root mysql password
Code: Select all
echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -uroot -pnagiosxi --table
mysql -uroot -pnagiosxi -e 'SELECT NOW(); SELECT @@GLOBAL.time_zone, @@SESSION.time_zone;'
date
ls -l /etc/localtime
php -r 'echo date("D M j G:i:s T Y")."\n";'
Run this command as root and leave it running:
Code: Select all
tail -Fn0 /var/log/httpd/error_log /var/log/httpd/ssl_error_log /var/log/php-fpm/error.log /var/log/php-fpm/www-error.log /usr/local/nagiosxi/var/wkhtmltox.log
Then force the report to fail, once it fails PM me the entire output from the still running tail command above and PM me a fresh copy of your profile.zip.
Thank you!