[rt-devel] Too Many Connections

Jesse Vincent jesse at bestpractical.com
Thu Nov 28 01:04:48 EST 2002


you've configured your apache to spawn more children than you've told
your database to create.


On Thu, Nov 28, 2002 at 03:54:08PM +1100, Sam Johnston wrote:
> I found that after a few minutes of playing with RT the layout broke and 
> then I started getting 500 Internal Server Errors:
> 
> [Thu Nov 28 14:21:48 2002] [warning]: 
> DBI->connect(dbname=rt3;host=localhost) failed: Too many connections at 
> /usr/local/share/perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 119 
> (/opt/rt3/lib/RT.pm:220)
> [Fri Nov 29 01:21:48 2002] [error] Connect Failed Too many connections 
> at /opt/rt3/lib/RT.pm line 122
> 
> Turns out that MySQL had accrued heaps of connections (as per 
> processlist following). I'm running RT 2.1.51 on Debian GNU/Linux 3.0 
> with Apache 1.3.26-0woody1 and mod_perl 1.26-3.0woody1. My apache.conf 
> (included in httpd.conf) contains:
> 
> *<VirtualHost 1.2.3.4:80>
>  DocumentRoot /opt/rt3/share/html
>  ServerName mybox.mydomain.com
>  PerlRequire /opt/rt3/bin/webmux.pl
>  <Location />
>    SetHandler perl-script
>    PerlHandler RT::Mason
>  </Location>
> </VirtualHost>
> *
> I'm going to have a stab in the dark and try adding:
> 
> PerlModule Apache::DBI
> PerlFreshRestart On
> 
> 
> mysqladmin -u root -p processlist
> Enter password:
> +-----+---------+-----------+-----+---------+------+-------+------------------+
> | Id  | User    | Host      | db  | Command | Time | State | 
> Info             |
> +-----+---------+-----------+-----+---------+------+-------+------------------+
> | 25  | rt_user | localhost | rt3 | Sleep   | 4303 |       
> |                  |
> | 26  | rt_user | localhost | rt3 | Sleep   | 4303 |       
> |                  |
> | 30  | rt_user | localhost | rt3 | Sleep   | 4202 |       
> |                  |
> | 31  | rt_user | localhost | rt3 | Sleep   | 4202 |       
> |                  |
> | 33  | rt_user | localhost | rt3 | Sleep   | 3813 |       
> |                  |
> | 34  | rt_user | localhost | rt3 | Sleep   | 3813 |       
> |                  |
> | 36  | rt_user | localhost | rt3 | Sleep   | 3810 |       
> |                  |
> | 37  | rt_user | localhost | rt3 | Sleep   | 3810 |       
> |                  |
> | 39  | rt_user | localhost | rt3 | Sleep   | 3789 |       
> |                  |
> | 40  | rt_user | localhost | rt3 | Sleep   | 3789 |       
> |                  |
> | 42  | rt_user | localhost | rt3 | Sleep   | 3782 |       
> |                  |
> | 43  | rt_user | localhost | rt3 | Sleep   | 3782 |       
> |                  |
> | 45  | rt_user | localhost | rt3 | Sleep   | 3779 |       
> |                  |
> | 46  | rt_user | localhost | rt3 | Sleep   | 3779 |       
> |                  |
> | 47  | rt_user | localhost | rt3 | Sleep   | 3770 |       
> |                  |
> | 48  | rt_user | localhost | rt3 | Sleep   | 3770 |       
> |                  |
> | 50  | rt_user | localhost | rt3 | Sleep   | 3757 |       
> |                  |
> | 51  | rt_user | localhost | rt3 | Sleep   | 3757 |       
> |                  |
> | 53  | rt_user | localhost | rt3 | Sleep   | 3754 |       
> |                  |
> | 54  | rt_user | localhost | rt3 | Sleep   | 3753 |       
> |                  |
> | 56  | rt_user | localhost | rt3 | Sleep   | 3751 |       
> |                  |
> | 57  | rt_user | localhost | rt3 | Sleep   | 3751 |       
> |                  |
> | 59  | rt_user | localhost | rt3 | Sleep   | 3743 |       
> |                  |
> | 60  | rt_user | localhost | rt3 | Sleep   | 3743 |       
> |                  |
> | 61  | rt_user | localhost | rt3 | Sleep   | 3739 |       
> |                  |
> | 62  | rt_user | localhost | rt3 | Sleep   | 3739 |       
> |                  |
> | 64  | rt_user | localhost | rt3 | Sleep   | 3737 |       
> |                  |
> | 65  | rt_user | localhost | rt3 | Sleep   | 3736 |       
> |                  |
> | 67  | rt_user | localhost | rt3 | Sleep   | 3735 |       
> |                  |
> | 68  | rt_user | localhost | rt3 | Sleep   | 3735 |       
> |                  |
> | 70  | rt_user | localhost | rt3 | Sleep   | 3732 |       
> |                  |
> | 71  | rt_user | localhost | rt3 | Sleep   | 3732 |       
> |                  |
> | 72  | rt_user | localhost | rt3 | Sleep   | 3729 |       
> |                  |
> | 73  | rt_user | localhost | rt3 | Sleep   | 3729 |       
> |                  |
> | 75  | rt_user | localhost | rt3 | Sleep   | 3727 |       
> |                  |
> | 76  | rt_user | localhost | rt3 | Sleep   | 3727 |       
> |                  |
> | 78  | rt_user | localhost | rt3 | Sleep   | 3724 |       
> |                  |
> | 79  | rt_user | localhost | rt3 | Sleep   | 3724 |       
> |                  |
> | 80  | rt_user | localhost | rt3 | Sleep   | 3718 |       
> |                  |
> | 81  | rt_user | localhost | rt3 | Sleep   | 3718 |       
> |                  |
> | 82  | rt_user | localhost | rt3 | Sleep   | 1843 |       
> |                  |
> | 83  | rt_user | localhost | rt3 | Sleep   | 1843 |       
> |                  |
> | 85  | rt_user | localhost | rt3 | Sleep   | 1835 |       
> |                  |
> | 86  | rt_user | localhost | rt3 | Sleep   | 1834 |       
> |                  |
> | 87  | rt_user | localhost | rt3 | Sleep   | 1830 |       
> |                  |
> | 88  | rt_user | localhost | rt3 | Sleep   | 1829 |       
> |                  |
> | 89  | rt_user | localhost | rt3 | Sleep   | 1782 |       
> |                  |
> | 90  | rt_user | localhost | rt3 | Sleep   | 1782 |       
> |                  |
> | 92  | rt_user | localhost | rt3 | Sleep   | 1777 |       
> |                  |
> | 93  | rt_user | localhost | rt3 | Sleep   | 1777 |       
> |                  |
> | 95  | rt_user | localhost | rt3 | Sleep   | 1579 |       
> |                  |
> | 96  | rt_user | localhost | rt3 | Sleep   | 1578 |       
> |                  |
> | 98  | rt_user | localhost | rt3 | Sleep   | 1575 |       
> |                  |
> | 99  | rt_user | localhost | rt3 | Sleep   | 1575 |       
> |                  |
> | 100 | rt_user | localhost | rt3 | Sleep   | 1570 |       
> |                  |
> | 101 | rt_user | localhost | rt3 | Sleep   | 1570 |       
> |                  |
> | 102 | rt_user | localhost | rt3 | Sleep   | 1548 |       
> |                  |
> | 103 | rt_user | localhost | rt3 | Sleep   | 1548 |       
> |                  |
> | 105 | rt_user | localhost | rt3 | Sleep   | 1542 |       
> |                  |
> | 106 | rt_user | localhost | rt3 | Sleep   | 1542 |       
> |                  |
> | 107 | rt_user | localhost | rt3 | Sleep   | 1538 |       
> |                  |
> | 108 | rt_user | localhost | rt3 | Sleep   | 1538 |       
> |                  |
> | 109 | rt_user | localhost | rt3 | Sleep   | 1511 |       
> |                  |
> | 110 | rt_user | localhost | rt3 | Sleep   | 1511 |       
> |                  |
> | 112 | rt_user | localhost | rt3 | Sleep   | 1509 |       
> |                  |
> | 113 | rt_user | localhost | rt3 | Sleep   | 1509 |       
> |                  |
> | 114 | rt_user | localhost | rt3 | Sleep   | 1507 |       
> |                  |
> | 115 | rt_user | localhost | rt3 | Sleep   | 1507 |       
> |                  |
> | 117 | rt_user | localhost | rt3 | Sleep   | 1486 |       
> |                  |
> | 118 | rt_user | localhost | rt3 | Sleep   | 1486 |       
> |                  |
> | 120 | rt_user | localhost | rt3 | Sleep   | 1464 |       
> |                  |
> | 121 | rt_user | localhost | rt3 | Sleep   | 1464 |       
> |                  |
> | 122 | rt_user | localhost | rt3 | Sleep   | 1458 |       
> |                  |
> | 123 | rt_user | localhost | rt3 | Sleep   | 1457 |       
> |                  |
> | 125 | rt_user | localhost | rt3 | Sleep   | 1455 |       
> |                  |
> | 126 | rt_user | localhost | rt3 | Sleep   | 1455 |       
> |                  |
> | 128 | rt_user | localhost | rt3 | Sleep   | 1453 |       
> |                  |
> | 129 | rt_user | localhost | rt3 | Sleep   | 1453 |       
> |                  |
> | 131 | rt_user | localhost | rt3 | Sleep   | 1451 |       
> |                  |
> | 132 | rt_user | localhost | rt3 | Sleep   | 1451 |       
> |                  |
> | 134 | rt_user | localhost | rt3 | Sleep   | 1448 |       
> |                  |
> | 135 | rt_user | localhost | rt3 | Sleep   | 1448 |       
> |                  |
> | 136 | rt_user | localhost | rt3 | Sleep   | 1409 |       
> |                  |
> | 137 | rt_user | localhost | rt3 | Sleep   | 1409 |       
> |                  |
> | 138 | rt_user | localhost | rt3 | Sleep   | 1298 |       
> |                  |
> | 139 | rt_user | localhost | rt3 | Sleep   | 1298 |       
> |                  |
> | 141 | rt_user | localhost | rt3 | Sleep   | 1295 |       
> |                  |
> | 142 | rt_user | localhost | rt3 | Sleep   | 1295 |       
> |                  |
> | 143 | rt_user | localhost | rt3 | Sleep   | 628  |       
> |                  |
> | 144 | rt_user | localhost | rt3 | Sleep   | 627  |       
> |                  |
> | 145 | rt_user | localhost | rt3 | Sleep   | 416  |       
> |                  |
> | 146 | rt_user | localhost | rt3 | Sleep   | 416  |       
> |                  |
> | 148 | rt_user | localhost | rt3 | Sleep   | 408  |       
> |                  |
> | 149 | rt_user | localhost | rt3 | Sleep   | 408  |       
> |                  |
> | 151 | rt_user | localhost | rt3 | Sleep   | 404  |       
> |                  |
> | 152 | rt_user | localhost | rt3 | Sleep   | 404  |       
> |                  |
> | 153 | rt_user | localhost | rt3 | Sleep   | 402  |       
> |                  |
> | 154 | rt_user | localhost | rt3 | Sleep   | 402  |       
> |                  |
> | 155 | rt_user | localhost | rt3 | Sleep   | 389  |       
> |                  |
> | 161 | root    | localhost |     | Query   | 0    |       | show 
> processlist |
> +-----+---------+-----------+-----+---------+------+-------+------------------+
> 
> 
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
> 

-- 
»|« http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.



More information about the Rt-devel mailing list