Connect Failed Too many connections


#1

Hi,
Been running RT for almost 2 years w/o incident, and NEVER had this problem before.
Came in this morning to people saying they couldn’t log into RT. I look in the apache error log and see:
[Thu Jun 05 09:48:59 2008] [error] [client xxx.xxx.xxx.xxx] Connect Failed Too many connections\n at /opt/rt3/lib/RT.pm line 220\n
DBI connect(‘dbname=rt3;host=localhost’,‘rt_user’,…) failed: Too many connections at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106

I had made a change to resolv.conf the previous day to address a mail problem we had (which had caused
a lot of emails to back up) but as of 12:30am today (8 hours before the error cropped up) RT was working
fine, and I was getting emails. so something happened overnight.
Like i said, never had this problem, don’t know what could have caused it, and don’t know what I can do to prevent it.
[root@rt DBIx]# rpm -qa | grep -i dbi
libdbi-drivers-0.8.1a-1.2.1
perl-DBI-1.50-2.2
libdbi-0.8.1-1.2.1
libdbi-dbd-mysql-0.8.1a-1.2.1
[root@rt DBIx]# rpm -qa | grep mysql
mysql-server-5.0.18-2.1
mysql-5.0.18-2.1
mysql-connector-odbc-3.51.12-1.2.1
libdbi-dbd-mysql-0.8.1a-1.2.1

rt 3.6.4
Thanks.


#2

I would suggest upping max_connections in my.cnf since you are
getting the Too many connections error from MySQL.

Sean wrote:

Hi,
Been running RT for almost 2 years w/o incident, and NEVER had this problem before.
Came in this morning to people saying they couldn’t log into RT. I look in the apache error log and see:
[Thu Jun 05 09:48:59 2008] [error] [client xxx.xxx.xxx.xxx] Connect Failed Too many connections\n at /opt/rt3/lib/RT.pm line 220\n
DBI connect(‘dbname=rt3;host=localhost’,‘rt_user’,…) failed: Too many connections at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106

I had made a change to resolv.conf the previous day to address a mail problem we had (which had caused
a lot of emails to back up) but as of 12:30am today (8 hours before the error cropped up) RT was working
fine, and I was getting emails. so something happened overnight.
Like i said, never had this problem, don’t know what could have caused it, and don’t know what I can do to prevent it.
[root@rt DBIx]# rpm -qa | grep -i dbi
libdbi-drivers-0.8.1a-1.2.1
perl-DBI-1.50-2.2
libdbi-0.8.1-1.2.1
libdbi-dbd-mysql-0.8.1a-1.2.1
[root@rt DBIx]# rpm -qa | grep mysql
mysql-server-5.0.18-2.1
mysql-5.0.18-2.1
mysql-connector-odbc-3.51.12-1.2.1
libdbi-dbd-mysql-0.8.1a-1.2.1

rt 3.6.4
Thanks.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati