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

[Ruslan Zakirov]

You're hang is of another sort, it's performance problem, search in
archives message from Dirk Pape just few days ago, as well you can
grab a patch from SVN.

On 2/3/07, Tom Holub <tom at ls.berkeley.edu> wrote:
> 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/>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>


-- 
Best regards, Ruslan.