Page 3 of 3
Re: Intermittent Operations Screen error
Posted: Fri Jun 03, 2016 1:36 pm
by rkennedy
Looks like Postgres is now hitting the max connections, which is different from before.
Can you run locate postgresql.conf and then open that file, take a look at the max_connections field and double that. Then, restart postgresql, and it should stop returning that error now.
Re: Intermittent Operations Screen error
Posted: Fri Jun 03, 2016 2:27 pm
by Greg
I have modified the postgresql.conf file, and restarted the service. Will once again monitor the error log for further issues.
Re: Intermittent Operations Screen error
Posted: Fri Jun 03, 2016 6:54 pm
by Greg
It appears that we are once again receiving the "too many connections" errors. I had previously increased the mysql "max_connections" from 151 to 300; do the connections need to be increased even further? I expect 5~10 users to simultaneously be using the Operations Page (set to refresh every 10 seconds), is 300 connections really too low to support our needs?
Code: Select all
[Fri Jun 03 13:43:04 2016] [error] [client xxx.xxx.xxx.55] PHP Warning: mysql_connect(): Too many connections in /usr/local/nagiosxi/html/includes/components/opscreen/merlin.php on line 28, referer: http://172.21.0.138/nagiosxi/includes/components/opscreen/opscreen.php
[Fri Jun 03 13:45:04 2016] [error] [client xxx.xxx.xxx.44] PHP Warning: mysql_connect(): Too many connections in /usr/local/nagiosxi/html/includes/components/opscreen/merlin.php on line 28, referer: http://172.21.0.138/nagiosxi/includes/components/opscreen/opscreen.php
[Fri Jun 03 13:45:05 2016] [error] [client xxx.xxx.xxx.44] PHP Warning: mysql_connect(): Too many connections in /usr/local/nagiosxi/html/includes/components/opscreen/merlin.php on line 28, referer: http://172.21.0.138/nagiosxi/includes/components/opscreen/opscreen.php
[Fri Jun 03 13:45:05 2016] [error] [client xxx.xxx.xxx.55] PHP Warning: mysql_connect(): Too many connections in /usr/local/nagiosxi/html/includes/components/opscreen/merlin.php on line 28, referer: http://172.21.0.138/nagiosxi/includes/components/opscreen/opscreen.php
[Fri Jun 03 13:47:07 2016] [error] [client xxx.xxx.xxx.55] PHP Warning: mysql_connect(): Too many connections in /usr/local/nagiosxi/html/includes/components/opscreen/merlin.php on line 28, referer: http://172.21.0.138/nagiosxi/includes/components/opscreen/opscreen.php
[Fri Jun 03 13:47:08 2016] [error] [client xxx.xxx.xxx.44] PHP Warning: mysql_connect(): Too many connections in /usr/local/nagiosxi/html/includes/components/opscreen/merlin.php on line 28, referer: http://172.21.0.138/nagiosxi/includes/components/opscreen/opscreen.php
[Fri Jun 03 13:48:04 2016] [error] [client xxx.xxx.xxx.44] PHP Warning: mysql_connect(): Too many connections in /usr/local/nagiosxi/html/includes/components/opscreen/merlin.php on line 28, referer: http://172.21.0.138/nagiosxi/includes/components/opscreen/opscreen.php
Re: Intermittent Operations Screen error
Posted: Sun Jun 05, 2016 11:38 pm
by Box293
How long is a piece of string? Every customers environment needs adjusting differently based on their needs.
It would increase to 1000 and see how it goes from there.
In this KB article, it explains how to check how many connections it peaks at, as well as the number of connected threads. This information will better help understand your operating baseline and help determine if you need to increase it (instead of relying on errors in logs):
https://support.nagios.com/kb/article.php?id=513
Does this help?
Re: Intermittent Operations Screen error
Posted: Mon Jun 06, 2016 11:18 am
by Greg
Morning,
The provided support article looks to have been precisely the information I was looking for. I've increased the connections again, and set up monitoring to gain additional visibility into the issue. Really appreciate the assistance.
Re: Intermittent Operations Screen error
Posted: Mon Jun 06, 2016 12:25 pm
by lmiltchev
I am glad we were able to help! Is it safe to mark this topic as "resolved", and lock it?
Re: Intermittent Operations Screen error
Posted: Tue Jun 07, 2016 12:46 pm
by Greg
Monitoring show that we have been stable a 399 connections. I believe it should be fine to resolve this thread. Thanks again for the assistance.