[rt-users] Connect Failed Too many connections

[Drew Barnes]

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 at 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 at 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 at 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