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 ([EMAIL PROTECTED], 510-642-9069)
Director of Computing, College of Letters & Science
249 Campbell Hall
<http://LS.berkeley.edu/lscr/>
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
