Intermittent Operations Screen error

[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.

[Greg]

I have modified the postgresql.conf file, and restarted the service. Will once again monitor the error log for further issues.

[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

[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?

[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.

[lmiltchev]

I am glad we were able to help! Is it safe to mark this topic as "resolved", and lock it?

[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.