<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Charles,<br>
<br>
<br>
WE also have Oracle, but we are on 3.6.4. I have noticed that when
I first bring up RT, it takes a little while, ESPECIALLY if I have some
queries I selected for my home page. I'm not a DBA, nor a UNIX
specialist, but as I watch my computer take a long time with the
initial loading, I wonder if there are some sort of size parametrs that
can be set that allow for larger batches of cache data, buffered data
or whatever to be loaded faster. I/O always takes way more time to
process than internal commands, so I just figured that the excess time
was due to the fact I may be loading a search/result that goes to a
table with a poor index or key. Or perhaps I have too many user with
wide-open permissions and all that I/O to check the different DB Tables
for permissions, etc was taking all the time.<br>
I'd try changing your home page to NOT pull ANY searchs and see how
that affects the loading time. If it is still incredibly slow, then
there must be some setting that affects data transfer size that might
help.<br>
Just a couple dumb thoughts.<br>
<br>
<br>
Kenn<br>
LBNL<br>
<br>
On 4/7/2009 10:49 AM, Curtis Bruneau wrote:
<blockquote cite="mid:49DB921B.6060805@vianet.ca" type="cite">
<pre wrap="">Just realised you are using Oracle, but the bug seems almost identical.
Curtis Bruneau wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">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:* <a class="moz-txt-link-abbreviated" href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a>
[<a class="moz-txt-link-freetext" href="mailto:rt-users-bounces@lists.bestpractical.com">mailto:rt-users-bounces@lists.bestpractical.com</a>] *On Behalf Of
*Charles Kugelman
*Sent:* Monday, April 06, 2009 8:33 AM
*To:* <a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>
*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:* <a class="moz-txt-link-abbreviated" href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a>
[<a class="moz-txt-link-freetext" href="mailto:rt-users-bounces@lists.bestpractical.com">mailto:rt-users-bounces@lists.bestpractical.com</a>] *On Behalf Of
*Charles Kugelman
*Sent:* Friday, April 03, 2009 11:36 AM
*To:* <a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>
*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
<a class="moz-txt-link-freetext" href="http://">http://</a> requests to use <a class="moz-txt-link-freetext" href="https://">https://</a> (don’t know if this may have some
sort of impact).
RewriteEngine On
RewriteCond %{HTTPS} off
RewriteRule (.*) <a class="moz-txt-link-freetext" href="https://%">https://%</a>{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 - <a class="moz-txt-link-abbreviated" href="http://www.avg.com">www.avg.com</a>
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 - <a class="moz-txt-link-abbreviated" href="http://www.avg.com">www.avg.com</a>
Version: 8.5.285 / Virus Database: 270.11.42/2042 - Release Date:
04/06/09 06:22:00
------------------------------------------------------------------------
_______________________________________________
<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Community help: <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Commercial support: <a class="moz-txt-link-abbreviated" href="mailto:sales@bestpractical.com">sales@bestpractical.com</a>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a>
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
<pre wrap=""><!---->
_______________________________________________
<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Community help: <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Commercial support: <a class="moz-txt-link-abbreviated" href="mailto:sales@bestpractical.com">sales@bestpractical.com</a>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a>
</pre>
</blockquote>
</body>
</html>