Nagios Support Forum

Support for Nagios products and services
https://support.nagios.com/forum/

Reports Tab taking too longtime to load

https://support.nagios.com/forum/viewtopic.php?t=35624

Page 1 of 2

Reports Tab taking too longtime to load

Posted: Mon Nov 09, 2015 3:03 am
by raamardhani7
Hi Team,

When I am clicking the reports tab, it is taking so much time to display the page. it is taking more than 15 mins to load the page.

Please advise me how can I overcome this issue. Attaching the screenshot of the number of hosts and services configured.

Re: Reports Tab taking too longtime to load

Posted: Mon Nov 09, 2015 10:30 am
by hsmith
What do your system resources look like?

Code: Select all

top | head -n5
free -m

Re: Reports Tab taking too longtime to load

Posted: Mon Nov 09, 2015 1:13 pm
by WillemDH
Did you set autorun reports to disabled? With that many hosts, it will be necessary.

Re: Reports Tab taking too longtime to load

Posted: Mon Nov 09, 2015 2:48 pm
by scottwilkerson
@WillemDH has a point, as the first report is the availability report for ALL host and services, it is a good idea to disable auto-running of reports in:
Admin -> Performance Settings -> Auto-Running Tab

Re: Reports Tab taking too longtime to load

Posted: Tue Nov 10, 2015 12:19 am
by raamardhani7
hsmith wrote:What do your system resources look like?

Code: Select all

top | head -n5
free -m
Hi Smith,

Code: Select all

 top | head -n5
top - 23:17:10 up 18 days,  7:55,  1 user,  load average: 9.34, 7.58, 6.50
Tasks: 216 total,   1 running, 215 sleeping,   0 stopped,   0 zombie
Cpu(s): 55.5%us, 18.1%sy,  0.7%ni,  9.4%id, 14.0%wa,  0.2%hi,  2.0%si,  0.0%st
Mem:   8061568k total,  7719836k used,   341732k free,   677700k buffers
Swap:  4128764k total,   144336k used,  3984428k free,  4315268k cached

Code: Select all

free -m
             total       used       free     shared    buffers     cached
Mem:          7872       7534        338         33        653       4145
-/+ buffers/cache:       2734       5137
Swap:         4031        140       3891

Re: Reports Tab taking too longtime to load

Posted: Tue Nov 10, 2015 12:43 am
by raamardhani7
scottwilkerson wrote:@WillemDH has a point, as the first report is the availability report for ALL host and services, it is a good idea to disable auto-running of reports in:
Admin -> Performance Settings -> Auto-Running Tab
Hi Scott, thanks for the update, it have set it to disable mode. I

After doing that I am unable to get reports for even a single host, when trying to get the information for a single host. It is still taking so much time.

Any thoughts on the same please?

Re: Reports Tab taking too longtime to load

Posted: Tue Nov 10, 2015 10:22 am
by lmiltchev
After doing that I am unable to get reports for even a single host, when trying to get the information for a single host. It is still taking so much time.
What is the time period that you have selected from the "Period" drop-down menu? Do you have any filters selected under the "Advanced" section?

Run the following commands and show the output in code wraps:

Code: Select all

tail -100 /var/log/httpd/error_log
tail -50 /var/log/mysqld.log

Re: Reports Tab taking too longtime to load

Posted: Wed Nov 11, 2015 8:45 am
by raamardhani7
lmiltchev wrote:
After doing that I am unable to get reports for even a single host, when trying to get the information for a single host. It is still taking so much time.
What is the time period that you have selected from the "Period" drop-down menu? Do you have any filters selected under the "Advanced" section?

Run the following commands and show the output in code wraps:

Code: Select all

tail -100 /var/log/httpd/error_log
tail -50 /var/log/mysqld.log
Hi,

It is taking more than 20 mins to generate the report for single server.

Code: Select all

tail -100 /var/log/httpd/error_log
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 108, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 109, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 110, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 111, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 112, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 113, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 118, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 119, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 120, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 121, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 122, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 123, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 108, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 109, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 110, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 111, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 112, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 113, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 118, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 119, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 120, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 121, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 122, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 123, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client ::1] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383
[Mon Nov 09 23:40:52 2015] [error] [client ::1] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383
[Mon Nov 09 23:40:52 2015] [error] [client ::1] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383
[Mon Nov 09 23:40:52 2015] [error] [client ::1] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383
[Mon Nov 09 23:40:52 2015] [error] [client ::1] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383
[Mon Nov 09 23:40:52 2015] [error] [client ::1] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  simplexml_load_string(): Entity: line 1: parser error : Start tag expected, '<' not found in /usr/local/nagiosxi/html/includes/utils-backend.inc.php on line 27, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  simplexml_load_string(): Message: A database connection error has been detected, we are attempting to rep in /usr/local/nagiosxi/html/includes/utils-backend.inc.php on line 27, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  simplexml_load_string(): ^ in /usr/local/nagiosxi/html/includes/utils-backend.inc.php on line 27, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined variable: count in /usr/local/nagiosxi/html/includes/utils-xmlstatus.inc.php on line 954, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  simplexml_load_string(): Entity: line 1: parser error : Start tag expected, '<' not found in /usr/local/nagiosxi/html/includes/utils-backend.inc.php on line 27, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  simplexml_load_string(): Message: A database connection error has been detected, we are attempting to rep in /usr/local/nagiosxi/html/includes/utils-backend.inc.php on line 27, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  simplexml_load_string(): ^ in /usr/local/nagiosxi/html/includes/utils-backend.inc.php on line 27, referer: http://10.10.83.90/nagiosxi/dashboards/
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined variable: count in /usr/local/nagiosxi/html/includes/utils-xmlstatus.inc.php on line 954, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined variable: count in /usr/local/nagiosxi/html/includes/utils-xmlstatus.inc.php on line 954, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined variable: count in /usr/local/nagiosxi/html/includes/utils-xmlstatus.inc.php on line 954, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined variable: count in /usr/local/nagiosxi/html/includes/utils-xmlstatus.inc.php on line 954, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined variable: count in /usr/local/nagiosxi/html/includes/utils-xmlstatus.inc.php on line 954, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined variable: count in /usr/local/nagiosxi/html/includes/utils-xmlstatus.inc.php on line 954, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 108, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 109, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 110, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 111, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 112, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 113, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 118, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 119, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 120, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 121, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 122, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:52 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 123, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:57 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:57 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:58 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:58 2015] [error] [client 172.30.245.215] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:58 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 108, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:58 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 109, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:58 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 110, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:58 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 111, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:58 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 112, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:58 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 113, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:58 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 118, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:58 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 119, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:58 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 120, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:58 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 121, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:58 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 122, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:40:58 2015] [error] [client 172.30.245.215] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 123, referer: http://10.10.83.90/nagiosxi/dashboards/dashboard.php?&=
[Mon Nov 09 23:41:24 2015] [error] [client 172.30.245.215] PHP Notice:  Use of undefined constant CONFIGWIZARD_FILTER_GROUPS - assumed 'CONFIGWIZARD_FILTER_GROUPS' in /usr/local/nagiosxi/html/includes/configwizards/windowswmi/windowswmi.inc.php on line 23, referer: http://10.10.83.90/nagiosxi/config/
[Mon Nov 09 23:41:24 2015] [error] [client 172.30.245.215] PHP Notice:  Use of undefined constant CONFIGWIZARD_REQUIRES_VERSION - assumed 'CONFIGWIZARD_REQUIRES_VERSION' in /usr/local/nagiosxi/html/includes/configwizards/windowswmi/windowswmi.inc.php on line 24, referer: http://10.10.83.90/nagiosxi/config/
[Tue Nov 10 00:11:03 2015] [notice] caught SIGTERM, shutting down
[Tue Nov 10 00:11:04 2015] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Tue Nov 10 00:11:04 2015] [notice] Digest: generating secret for digest authentication ...
[Tue Nov 10 00:11:04 2015] [notice] Digest: done
[Tue Nov 10 00:11:05 2015] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.1e-fips mod_wsgi/3.2 Python/2.6.6 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations
[Tue Nov 10 08:06:20 2015] [error] [client 10.10.80.31] File does not exist: /var/www/html/robots.txt
[Tue Nov 10 12:11:29 2015] [error] [client 10.10.95.128] File does not exist: /var/www/html/apple-touch-icon-120x120-precomposed.png
[Tue Nov 10 12:11:29 2015] [error] [client 10.10.95.128] File does not exist: /var/www/html/apple-touch-icon-120x120.png
[Tue Nov 10 12:11:29 2015] [error] [client 10.10.95.128] File does not exist: /var/www/html/apple-touch-icon.png
[Tue Nov 10 12:11:29 2015] [error] [client 10.10.95.128] File does not exist: /var/www/html/apple-touch-icon.png

Code: Select all

tail -50 /var/log/mysqld.log
151109 23:37:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:01 [Note] /usr/libexec/mysqld: Normal shutdown

151109 23:37:01 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:01 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:01 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:01 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:01 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed
151109 23:37:01 [Note] Event Scheduler: Purging the queue. 0 events
151109 23:37:03  InnoDB: Starting shutdown...
151109 23:37:06  InnoDB: Shutdown completed; log sequence number 0 128325
151109 23:37:06 [Note] /usr/libexec/mysqld: Shutdown complete

151109 23:37:06 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
151109 23:40:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
151109 23:40:37  InnoDB: Initializing buffer pool, size = 8.0M
151109 23:40:37  InnoDB: Completed initialization of buffer pool
151109 23:40:37  InnoDB: Started; log sequence number 0 128325
151109 23:40:37 [Note] Event Scheduler: Loaded 0 events
151109 23:40:37 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
151109 23:40:50 [Note] /usr/libexec/mysqld: Normal shutdown

151109 23:40:50 [Note] Event Scheduler: Purging the queue. 0 events
151109 23:40:52  InnoDB: Starting shutdown...
151109 23:40:57  InnoDB: Shutdown completed; log sequence number 0 128325
151109 23:40:57 [Note] /usr/libexec/mysqld: Shutdown complete

151109 23:40:57 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
151109 23:40:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
151109 23:40:58  InnoDB: Initializing buffer pool, size = 8.0M
151109 23:40:58  InnoDB: Completed initialization of buffer pool
151109 23:40:58  InnoDB: Started; log sequence number 0 128325
151109 23:40:58 [Note] Event Scheduler: Loaded 0 events
151109 23:40:58 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

Re: Reports Tab taking too longtime to load

Posted: Wed Nov 11, 2015 11:22 am
by rkennedy
Judging by the output of your top, this system seems to be hitting quite a high load and a pretty high memory usage.

How many CPUs do you have allocated to this machine? Is it physical or virtual? The reason I ask is because when you generate reports it will take quite a bit of time, especially if the system doesn't have the resources available.

Are you running a ramdisk in your environment?

Please run the following to repair your SQL DB -

Code: Select all

service mysqld stop
/usr/local/nagiosxi/scripts/repairmysql.sh nagios
service mysqld start

Re: Reports Tab taking too longtime to load

Posted: Wed Nov 11, 2015 11:23 am
by scottwilkerson
It also looks like you may have had a crashed table.

I would strongly suggest running the database repair script

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh
All times are UTC-05:00
Page 1 of 2

Powered by phpBB® Forum Software © phpBB Limited