[rt-users] fcgi read timeout error in 4.2.5

[Shawn Plummer]

On Jun 17, 2014, at 3:01 PM, Kevin Falcone <falcone at bestpractical.com> wrote:

> Look for slow queries in your database (there are oracle specific
> reports for this) or try turning on MasonX::Profiler in development
> and see what RT is doing when it times out.


I enabled MasonX::Profiler as you suggested. Here is the relevant log entries


RT::Config::__ANON__('RT::Config=HASH(0x14eab98)', undef) called at /opt/rt4devel/sbin/../lib/RT/Config.pm line 1159
RT::Config::PostLoadCheck('RT::Config=HASH(0x14eab98)') called at /opt/rt4devel/sbin/../lib/RT.pm line 199
RT::Init('RT', 'Heavy', 1) called at /opt/rt4devel/sbin/rt-server.fcgi line 126

==> /var/log/httpd/error_log <==
=Mason= localhost - /index.html BEGINS {{{
=Mason= localhost -     /autohandler {{{
=Mason= localhost -         /Elements/SetupSessionCookie {{{

At this point there is a 3 minute (I upped it to see if it would ever finish) wait until fcgi times out and throws the internal server error.

==> /var/log/httpd/rt4devel_error_log <==
[Tue Jun 24 14:17:06 2014] [warn] [client 137.238.60.9] mod_fcgid: read data timeout in 180 seconds, referer: https://rtdevel.geneseo.edu/index.html?HomeRefreshInterval=120
[Tue Jun 24 14:17:06 2014] [error] [client 137.238.60.9] Premature end of script headers: rt-server.fcgi, referer: https://rtdevel.geneseo.edu/index.html?HomeRefreshInterval=120

==> /var/log/httpd/error_log <==
=Mason= localhost - /favicon.ico BEGINS {{{
=Mason= localhost -     /autohandler {{{
=Mason= localhost -         /Elements/SetupSessionCookie }}} 180.1433
TONS more Mason logs

Not sure what this really tells me.

Our DBA is looking into the database side. Apparently It is blocking itself going against the 11g database. Sessions are blocking other sessions. We are looking into any possible database parameters new to 11g that cause this behavior to be different from our production 10g RT database.


--
Shawn Plummer
Systems Manager | SUNY Geneseo
South Hall 119 | 585-245-5577 | http://www.geneseo.edu/cit

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140624/6083fdd0/attachment.htm>