[rt-devel] rt3 crashin with connections in RT.pm

[Peter Mikeska]

Hello Joseph,

Monday, March 31, 2003, 3:44:24 PM, you wrote:


JWB> Is this a mysql problem?  How many open connections are present when you
JWB> do a 'mysqladmin processlist' ?


>> Dobry den, rt-devel,
>>
>>   Hi, I have still problem with this from error.log in apache
>> Mon Mar 31 13:26:38 2003] [notice] Apache/1.3.27 (Unix)  (Red-Hat/Linux)
>> mod_ssl/2.8.12 OpenSSL/0.9.6b DAV/1.0.3
>>  PHP/4.3.0 mod_perl/1.26 configured -- resuming normal operations
>> [Mon Mar 31 13:26:38 2003] [notice] suEXEC mechanism enabled (wrapper:
>> /usr/sbin/suexec)
>> [Mon Mar 31 13:26:38 2003] [notice] Accept mutex: sysvsem (Default:
>> sysvsem)
>> [Mon Mar 31 13:38:00 2003] [error] Connect Failed Too many connections
>>  at /opt/rt3/lib/RT.pm line 124
>>
>>  I have rt3 with imported tickets from rt2, all is working but stil in
>>  some circumstancies i get this error. Im not sure where is problem
>>  coz connections is from RT.pm, also its small site , maybe 2-3 people
>>  working on it, server is 2xXEON1.8GHz / 1GB RAM / SCSI18GB, nothing
>>  else is runing on mysql, just this. I tried it with clean install and
>>  empty database , still same behavior.
>>  Maybe its something with install Apache::DBI but what, how to find
>>  out, i found only error in log from apache.
>>
>>  here is httpd.conf part, i can send all conf if there is some trash
>>  to kickout.
>>  >>>>>>>>>>>>
>> <VirtualHost 149.204.1.15>
>>   DocumentRoot /opt/rt3/share/html
>>   ServerName rt.alcatel.sk
>>         PerlFreshRestart On
>>         SetHandler perl-script
>>         PerlHandler Apache::DBI
>>         PerlRequire /opt/rt3/bin/webmux.pl
>>   <Location />
>>     SetHandler perl-script
>>     PerlHandler RT::Mason
>>   </Location>
>> </VirtualHost>
>> -----------------------------------
>> thnx for nay help
>>
>>
>> --
>> S pozdravom
>>  Peter                          mailto:mikeska at alcatel.sk
>>
>> _______________________________________________
>> rt-devel mailing list
>> rt-devel at lists.fsck.com
>> http://lists.fsck.com/mailman/listinfo/rt-devel
>>

JWB> _______________________________________________
JWB> rt-devel mailing list
JWB> rt-devel at lists.fsck.com
JWB> http://lists.fsck.com/mailman/listinfo/rt-devel
sorry if I send mail directly to you ;)

Hi, i found out that it seems like put all connection to sleep and not
closing them after few tens its stop, when \I delete them two or three
it work again for awhile. how to correct it , somehow in mysql i think?

-- 
Best regards,
 Peter                            mailto:mikeska at alcatel.sk