Reports Tab taking too longtime to load

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
raamardhani7
Posts: 459
Joined: Tue Jun 02, 2015 12:36 am

Reports Tab taking too longtime to load

Post 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.
You do not have the required permissions to view the files attached to this post.
Top
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:
Contact hsmith

Re: Reports Tab taking too longtime to load

Post by hsmith »

What do your system resources look like?

Code: Select all

top | head -n5
free -m
Former Nagios Employee.
me.
Top
User avatar
WillemDH
Posts: 2320
Joined: Wed Mar 20, 2013 5:49 am
Location: Ghent
Contact:
Contact WillemDH

Re: Reports Tab taking too longtime to load

Post by WillemDH »

Did you set autorun reports to disabled? With that many hosts, it will be necessary.
Nagios XI 5.8.1
https://outsideit.net
Top
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:
Contact scottwilkerson

Re: Reports Tab taking too longtime to load

Post 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
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Top
raamardhani7
Posts: 459
Joined: Tue Jun 02, 2015 12:36 am

Re: Reports Tab taking too longtime to load

Post 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
Top
raamardhani7
Posts: 459
Joined: Tue Jun 02, 2015 12:36 am

Re: Reports Tab taking too longtime to load

Post 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?
Top
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: Reports Tab taking too longtime to load

Post 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
Be sure to check out our Knowledgebase for helpful articles and solutions!
Top
raamardhani7
Posts: 459
Joined: Tue Jun 02, 2015 12:36 am

Re: Reports Tab taking too longtime to load

Post 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
Top
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: Reports Tab taking too longtime to load

Post 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
Former Nagios Employee
Top
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:
Contact scottwilkerson

Re: Reports Tab taking too longtime to load

Post 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
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Top
Locked

Return to “Nagios XI”