[rt-users] Hanging Login Page (ModPerl2, HTTPD, Oracle, RHEL5)

Tue Apr 7 13:47:27 EDT 2009

Seems a lot like the DBD::MySQL bug that many people have had with older 
versions, basically the children are segfaulting on some timeout bug. 
During a refresh the parent process is reaping the child and restarting 
it with a functional process, which is why it appears to take several 
refreshes to get a page view. I think the last several versions have 
fixed this.

Charles Kugelman wrote:
>
> Update on this:
>
> I’ve noticed that while this is happening, I can hit F5 (refresh) a 
> few times and the page will then successfully load.
>
> Any ideas?
>
> ** **
>
> **-CK*** *
>
> ------------------------------------------------------------------------
>
> *From:* rt-users-bounces at lists.bestpractical.com 
> [mailto:rt-users-bounces at lists.bestpractical.com] *On Behalf Of 
> *Charles Kugelman
> *Sent:* Monday, April 06, 2009 8:33 AM
> *To:* rt-users at lists.bestpractical.com
> *Subject:* Re: [rt-users] Hanging Login Page (ModPerl2, HTTPD, Oracle, 
> RHEL5)
>
> Update on this:
>
> I’ve updated httpd, httpd-devel, mod_perl, mod_ssl to the latest 
> version. Problem still exists.
>
> One additional thing to note is that this is running as a virtual 
> machine (on ESX) with 1GB of memory allocated.
>
> **-CK****
>
> ------------------------------------------------------------------------
>
> *From:* rt-users-bounces at lists.bestpractical.com 
> [mailto:rt-users-bounces at lists.bestpractical.com] *On Behalf Of 
> *Charles Kugelman
> *Sent:* Friday, April 03, 2009 11:36 AM
> *To:* rt-users at lists.bestpractical.com
> *Subject:* [rt-users] Hanging Login Page (ModPerl2, HTTPD, Oracle, RHEL5)
>
> Greetings RT Gurus!
>
> --Problem--
>
> Every morning when I sit down at my desk and point my browser to RT, 
> it hangs when the login page should be displayed. Usually I’ve just 
> performed a “service httpd restart” to resolve the problem. This 
> morning, I just let it sit and load for in excess of 20 minutes, and 
> the page finally appeared, after which RT seemed to be performing fine 
> – even if I restart my browser and head back to the logon page. This 
> did happen in the middle of the day yesterday as well, to which I 
> restarted httpd, as normal. This, obviously, won’t work for production 
> (which we plan on this system being shortly). I’m sending this message 
> in the hope that someone can assist me with this problem.
>
> --Relevant Info--
>
> - RT Version: 3.8.2
>
> - HTTPD Package (RPM): httpd-2.2.3-6.el5
>
> - Mod_Perl Package (RPM): mod_perl-2.0.2-6.1
>
> - Perl Package (RPM): perl-5.8.8-18.el5
>
> - OS: RedHat Enterprise Linux 5
>
> - Oracle Client: 10.2, Instant Client
>
> - Oracle Server (remote server): 11g
>
> - Mail Package (RPM): postfix-2.3.3-2
>
> - I’ve done some digging in the archives and found the post by Dirk 
> Pape (subject: Performance-Bug in SelfService when updated from 3.6.1 
> to 3.6.3, date: Jan 22, 2007, 11:39 PM) and the issue seems to be very 
> close to what I’m seeing. But the resolution that Dirk used doesn’t 
> seem to apply to the current version of RT, as “@roles => ('Watcher')” 
> is already set in the html/SelfService/Elements/MyRequests file by 
> default. And my seems to be with the logon page.
>
> - I have added the following lines to httpd.conf in order to force 
> http:// requests to use https:// (don’t know if this may have some 
> sort of impact).
>
> RewriteEngine On
>
> RewriteCond %{HTTPS} off
>
> RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI}
>
> - Could the way Postfix is configured be causing this problem? The 
> problem seemed to come into play when I started working on the mail 
> components.
>
> --Non-Standard Features Being Used--
>
> - SSL (on the front end)
>
> - RT External Auth Plugin (authenticating successfully against AD)
>
> --What Seem to be Relevant Error Log Outputs--
>
> - /var/log/httpd/access_log: The error below seems to be appearing 
> quite frequenetly. I’m not sure if it’s related or not, but doesn’t 
> look good.
>
> (RTHOST) - - [03/Apr/2009:09:51:57 -0400] "POST 
> /REST/1.0/NoAuth/mail-gateway HTTP/1.1" 302 333 "-" "libwww-perl/5.805"
>
> - None of the other logs that I’ve checked (httpd error_log, rt log) 
> appear to have anything of relevance to this problem.
>
> Thanks in advance for any assistance you may be able to offer.
>
> -CK
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.283 / Virus Database: 270.11.38/2037 - Release Date: 
> 04/03/09 06:19:00
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.285 / Virus Database: 270.11.42/2042 - Release Date: 
> 04/06/09 06:22:00
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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