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

Tue Apr 7 13:49:15 EDT 2009

Just realised you are using Oracle, but the bug seems almost identical.

Curtis Bruneau wrote:
> 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
>
>