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