[rt-users] Re: RT/Apache suddenly hangs

[Tom Holub]

I'm having what might be a related issue.  My setup:

RHEL4
Perl 5.8.6 (compiled ourselves)
RT 3.6.3
Apache 2.0.58
mod_perl 2.0.3
mysql-4.1.20-1.RHEL4.1

Our hang happens whenever anyone authenticates to the SelfService interface. 
The page header displays, down to "RT Self Service / Open Tickets" header, and 
then the web page sits there spinning forever.  While it is spinning, mysqld 
is using 100% of CPU, and other RT requests are delayed or also hang indefinitely.

The only solution is to restart mysqld.  Sometimes that causes the server to 
return an error (attached below), but sometimes I also see the runaway Apache 
behavior that Tomas Olaj is seeing, and I need to restart Apache as well.


DBD::mysql::st execute failed: MySQL server has gone away at 
/local/rh/rhel4/depot/perl-5.8.6/lib/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm 
line 70.


Trace begun at 
/local/rh/rhel4/depot/perl-5.8.6/lib/site_perl/5.8.6/HTML/Mason/Exceptions.pm 
line 129
HTML::Mason::Exceptions::rethrow_exception('DBD::mysql::st execute failed: 
MySQL server has gone away at 
/local/rh/rhel4/depot/perl-5.8.6/lib/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm 
line 70.^J') called at 
/local/rh/rhel4/depot/perl-5.8.6/lib/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm 
line 70
Apache::Session::Lock::MySQL::release_read_lock('Apache::Session::Lock::MySQL=HASH(0xa37e170)') 
called at 
/local/rh/rhel4/depot/perl-5.8.6/lib/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm 
line 81
Apache::Session::Lock::MySQL::release_all_locks('Apache::Session::Lock::MySQL=HASH(0xa37e170)') 
called at 
/local/rh/rhel4/depot/perl-5.8.6/lib/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm 
line 87
Apache::Session::Lock::MySQL::DESTROY('Apache::Session::Lock::MySQL=HASH(0xa37e170)') 
called at 
/local/rh/rhel4/depot/perl-5.8.6/lib/site_perl/5.8.6/HTML/Mason/Request.pm 
line 1250
eval {...} at 
/local/rh/rhel4/depot/perl-5.8.6/lib/site_perl/5.8.6/HTML/Mason/Request.pm 
line 1250
HTML::Mason::Request::comp(undef, undef, undef) called at 
/local/rh/rhel4/depot/perl-5.8.6/lib/site_perl/5.8.6/HTML/Mason/Request.pm 
line 460
eval {...} at 
/local/rh/rhel4/depot/perl-5.8.6/lib/site_perl/5.8.6/HTML/Mason/Request.pm 
line 460
eval {...} at 
/local/rh/rhel4/depot/perl-5.8.6/lib/site_perl/5.8.6/HTML/Mason/Request.pm 
line 412
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xa335574)') 
called at 
/local/rh/rhel4/depot/perl-5.8.6/lib/site_perl/5.8.6/HTML/Mason/ApacheHandler.pm 
line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xa335574)') 
called at 
/local/rh/rhel4/depot/perl-5.8.6/lib/site_perl/5.8.6/HTML/Mason/ApacheHandler.pm 
line 826
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x94b8c18)', 
'Apache2::RequestRec=SCALAR(0x936c180)') called at 
/local/rh/rhel4/depot/rt-3.6.3/bin/webmux.pl line 123
eval {...} at /local/rh/rhel4/depot/rt-3.6.3/bin/webmux.pl line 123
RT::Mason::handler('Apache2::RequestRec=SCALAR(0x936c180)') called at -e line 0
eval {...} at -e line 0


-- 
Tom Holub (tom_holub at LS.Berkeley.EDU, 510-642-9069)
Director of Computing, College of Letters & Science
249 Campbell Hall
<http://LS.berkeley.edu/lscr/>