[rt-users] Please help: RT3.4.4 running really slow
don garbage
dongarbage at hotmail.com
Sat Nov 11 11:01:19 EST 2006
Still need some help from rt-user land. Please :)
Here's the state of affairs for my problem:
- Remote users are having problems with remote access to RT system. Most
accesses stall with only a third of the page loading. From what I can tell,
this happens for all types of accesses, whether its just clicking on a
ticket or updating, or creating.
- I installed and enabled fastcgi.
- My postgres sql log file is identical for a successful access as it is for
a stalled access. So, the problem has to be on the return trip of the data.
- What happens in RT after the postgres data has been queried? And, how can
I track it?
- Note, that I'd like to track the simplest case of clicking on a ticket and
then having it display (the RT log will not display this info).
For your convenience, I am attaching my conf files.
Thanks so much for any help,
don
>From: "don garbage" <dongarbage at hotmail.com>
>To: r at elhames.co.uk, rfh at pipex.net
>CC: rt-users at lists.bestpractical.com
>Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>Date: Thu, 09 Nov 2006 23:29:46 +0000
>
>hi Roy,
>
>Yep. In RT_SiteConfig.pm, I added this line:
> Set($LogToFile , 'debug');
>RT_Config.pm has these values already set:
> Set($LogToSyslog , 'debug');
> Set($LogToScreen , 'error');
> Set($LogToFile , undef);
> Set($LogDir, '/var/log/request-tracker3.4');
> Set($LogToFileNamed , "rt.log"); #log to rt.log
>It is my understanding that RT_SiteConfig.pm settings override those set in
>RT_Config.pm. I get nothing other than user login messages in the rt.log
>file.
>There has to be another setting somewhere. Any suggestions?
>
>And, yes, I also logged queries. The postgres log is identical for both the
>successful ticket access and the stalled ticket access. So, the problem has
>to be somewhere between the query being made and the data being sent to the
>remote user.
>
>How can I track this?
>
>We must be getting closer :)
>
>thanks,
>Don
>
>
>>From: "Raed El-hames" <r at elhames.co.uk>
>>To: "don garbage" <dongarbage at hotmail.com>,<rfh at pipex.net>
>>CC: <rt-users at lists.bestpractical.com>
>>Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>>Date: Thu, 9 Nov 2006 22:15:51 -0000
>>
>>Don;
>>Thats odd , the 3 lines in RT_SiteConfig is all you needed to change, you
>>did restart apache??
>>Also have you started logging the sql queries??
>>Roy
>>
>>----- Original Message ----- From: "don garbage" <dongarbage at hotmail.com>
>>To: <dongarbage at hotmail.com>; <rfh at pipex.net>
>>Cc: <rt-users at lists.bestpractical.com>
>>Sent: Thursday, November 09, 2006 7:34 PM
>>Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>>
>>
>>>Ok, after googling, I got the fruit machine analogy :).
>>>
>>>My rt log is obviously not spitting out much info.
>>>Are there other settings I have to configure in order to see the log file
>>>scroll like a fruit machine? (note that I don't see any messages in the
>>>log file when I access RT locally with no access problems)
>>>
>>>Thanks,
>>>Don
>>>
>>>
>>>>From: "don garbage" <dongarbage at hotmail.com>
>>>>To: rfh at pipex.net
>>>>CC: rt-users at lists.bestpractical.com
>>>>Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>>>>Date: Thu, 09 Nov 2006 19:22:40 +0000
>>>>
>>>>Roy,
>>>>
>>>>The "connection reset by peer" messages come from me clicking the X
>>>>button in my browser.
>>>>
>>>>I don't get the "fruit machine" analogy" .. what do you mean?
>>>>
>>>>thanks,
>>>>don
>>>>
>>>>
>>>>>From: Roy El-Hames <rfh at pipex.net>
>>>>>To: don garbage <dongarbage at hotmail.com>
>>>>>CC: blkline at attglobal.net, rt-users at lists.bestpractical.com
>>>>>Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>>>>>Date: Thu, 09 Nov 2006 18:33:58 +0000
>>>>>
>>>>>I think debug is the most verbose you get, in my case the home page
>>>>>alone scroll the screen like a fruit machine when logging set to debug.
>>>>>BTW "Connection reset by peer" does not sound very healthy and again it
>>>>>suggest me a network or TCP/IP stack issue, ahh or your sql server
>>>>>(postgress) is giving up on you,
>>>>>have you checked the the state of the sql server, restarted it ??
>>>>>Roy
>>>>>
>>>>>don garbage wrote:
>>>>>>Roy,
>>>>>>
>>>>>>Are there more logging "levels" for $LogToFile other than 'debug'? All
>>>>>>I see in the rt.log file are occassional "Connection reset by peer"
>>>>>>messages. Or, is there a way to make RT be more verbose about what its
>>>>>>doing?
>>>>>>
>>>>>>Thanks,
>>>>>>Don
>>>>>>
>>>>>>
>>>>>>>From: Roy El-Hames <rfh at pipex.net>
>>>>>>>To: don garbage <dongarbage at hotmail.com>
>>>>>>>CC: blkline at attglobal.net, rt-users at lists.bestpractical.com
>>>>>>>Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>>>>>>>Date: Thu, 09 Nov 2006 17:26:40 +0000
>>>>>>>
>>>>>>>Don;
>>>>>>>If you have n't already done so, set up your RT logging to debug; (in
>>>>>>>RT_SiteConfig under Logging
>>>>>>>Set($LogToFile , 'debug');
>>>>>>>Set($LogDir, '/var/log/rt3');
>>>>>>>Set($LogToFileNamed , "rt.log"); #log to rt.log
>>>>>>>make sure the web user and group have write access to that file, and
>>>>>>>restart the web server)
>>>>>>>then you can tail -f /var/log/rt3/rt.log to see whats happening in
>>>>>>>RT as requests are coming through.
>>>>>>>I also suggest you enabled full logging on your database server,
>>>>>>>sorry I am not sure how to do that for postgress , once you done that
>>>>>>>again tail -f the sql logging file ..
>>>>>>>If these do n't help start using tcpdump to check whats happening to
>>>>>>>the traffic, also I think you can enable full logging on apache.
>>>>>>>Good luck;
>>>>>>>Roy
>>>>>>>
>>>>>>>don garbage wrote:
>>>>>>>>Roy,
>>>>>>>>
>>>>>>>>I thought the same. So, I created several web pages (some copied
>>>>>>>>exactly from RT tickets). And, remote users have no problems loading
>>>>>>>>those pages. I tested it remotely by clicking on those pages over
>>>>>>>>and over without ever seeing a page stall.
>>>>>>>>
>>>>>>>>It seems as though RT is sending just some of the data for a ticket,
>>>>>>>>then stalling since only part of the page loads. Its like some part
>>>>>>>>of the query didn't happen or stalled or got lost. Are the RT pages
>>>>>>>>sent in pieces? How can I track what happens on the RT server end as
>>>>>>>>a query comes in (a ticket is clicked on)?
>>>>>>>>
>>>>>>>>Thanks,
>>>>>>>>Don
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>From: Roy El-Hames <rfh at pipex.net>
>>>>>>>>>To: don garbage <dongarbage at hotmail.com>
>>>>>>>>>CC: blkline at attglobal.net, rt-users at lists.bestpractical.com
>>>>>>>>>Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>>>>>>>>>Date: Thu, 09 Nov 2006 16:14:52 +0000
>>>>>>>>>
>>>>>>>>>Don;
>>>>>>>>>That suggest to me that you may have network issues?? have you
>>>>>>>>>checked your NIC and did a traceroute or ping to your RT web server
>>>>>>>>>.
>>>>>>>>>Roy
>>>>>>>>>
>>>>>>>>>don garbage wrote:
>>>>>>>>>>I'm still having the problem and getting desparate.
>>>>>>>>>>
>>>>>>>>>>I determined that I did not have fastcgi enabled. So, I did the
>>>>>>>>>>following:
>>>>>>>>>>
>>>>>>>>>> sudo apt-get install libapache2-mod-fastcgi
>>>>>>>>>> sudo apt-get install libcgi-fast-perl
>>>>>>>>>> sudo a2enmod fastcgi
>>>>>>>>>> sudo ln -s /etc/request-tracker3.4/apache-fastcgi.conf
>>>>>>>>>>/etc/apache2/conf.d/
>>>>>>>>>> edit /etc/request-tracker3.4/apache-fastcgi.conf:
>>>>>>>>>> #FastCgiIpcDir /var/run/fastcgi
>>>>>>>>>> RedirectMatch ^/rt$ /rt/
>>>>>>>>>> sudo chown www-data: /etc/request-tracker3.4/RT_SiteConfig.pm
>>>>>>>>>>
>>>>>>>>>>this has enabled fastcgi. I also restarted apache2 and postgres.
>>>>>>>>>>But, I still have the same problem. For more than half of the
>>>>>>>>>>tickets that remote users try to access, the page stalls half way
>>>>>>>>>>through loading. I notice that when I access RT from localhost,
>>>>>>>>>>its very fast and pages never stall.
>>>>>>>>>>
>>>>>>>>>>Any help is so very appreciated,
>>>>>>>>>>Don
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>>From: "don garbage" <dongarbage at hotmail.com>
>>>>>>>>>>>To: blkline at attglobal.net
>>>>>>>>>>>CC: rt-users at lists.bestpractical.com
>>>>>>>>>>>Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>>>>>>>>>>>Date: Wed, 08 Nov 2006 15:23:46 +0000
>>>>>>>>>>>
>>>>>>>>>>>Barry,
>>>>>>>>>>>
>>>>>>>>>>>I know fcgi is installed, I'm not sure fcgi is enabled. At the
>>>>>>>>>>>moment, I'm trying to get server-info working, and will report
>>>>>>>>>>>back as soon as it is.
>>>>>>>>>>>
>>>>>>>>>>>Also, there are a bunch of symbolic links in
>>>>>>>>>>>/etc/apache2/mods-enabled/:
>>>>>>>>>>>
>>>>>>>>>>> /etc/apache2/mods-enabled/ssl.conf ->
>>>>>>>>>>>/etc/apache2/mods-available/ssl.conf
>>>>>>>>>>> /etc/apache2/mods-enabled/ssl.load ->
>>>>>>>>>>>/etc/apache2/mods-available/ssl.load
>>>>>>>>>>> /etc/apache2/mods-enabled/rewrite.load ->
>>>>>>>>>>>../mods-available/rewrite.load
>>>>>>>>>>> /etc/apache2/mods-enabled/perl.conf ->
>>>>>>>>>>>/etc/apache2/mods-available/perl.conf
>>>>>>>>>>> /etc/apache2/mods-enabled/perl.load ->
>>>>>>>>>>>/etc/apache2/mods-available/perl.load
>>>>>>>>>>> /etc/apache2/mods-enabled/cgid.conf ->
>>>>>>>>>>>/etc/apache2/mods-available/cgid.conf
>>>>>>>>>>> /etc/apache2/mods-enabled/cgid.load ->
>>>>>>>>>>>/etc/apache2/mods-available/cgid.load
>>>>>>>>>>> /etc/apache2/mods-enabled/userdir.conf ->
>>>>>>>>>>>/etc/apache2/mods-available/userdir.conf
>>>>>>>>>>> /etc/apache2/mods-enabled/userdir.load ->
>>>>>>>>>>>/etc/apache2/mods-available/userdir.load
>>>>>>>>>>>
>>>>>>>>>>>Here's the cat of those files:
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>>cgid.conf
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>># Socket thingy for CGI.
>>>>>>>>>>>ScriptSock /var/run/apache2/cgisock
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>>cgid.load
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>>LoadModule cgid_module /usr/lib/apache2/modules/mod_cgid.so
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>>perl.conf
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>># This file is a placeholder; you can safely ignore or delete it.
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>>perl.load
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>>LoadModule perl_module /usr/lib/apache2/modules/mod_perl.so
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>>rewrite.load
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>>LoadModule rewrite_module /usr/lib/apache2/modules/mod_rewrite.so
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>>ssl.conf
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>><IfModule mod_ssl.c>
>>>>>>>>>>>SSLRandomSeed startup builtin
>>>>>>>>>>>SSLRandomSeed connect builtin
>>>>>>>>>>>AddType application/x-x509-ca-cert .crt
>>>>>>>>>>>AddType application/x-pkcs7-crl .crl
>>>>>>>>>>>SSLPassPhraseDialog builtin
>>>>>>>>>>>SSLSessionCache dbm:/var/run/apache2/ssl_scache
>>>>>>>>>>>SSLSessionCacheTimeout 300
>>>>>>>>>>>
>>>>>>>>>>>SSLMutex file:/var/run/apache2/ssl_mutex
>>>>>>>>>>>SSLCipherSuite
>>>>>>>>>>>ALL:!ADH:!EXPORT56:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP:+eNULL
>>>>>>>>>>>
>>>>>>>>>>>SetEnvIf User-Agent ".*MSIE.*" \
>>>>>>>>>>> nokeepalive ssl-unclean-shutdown \
>>>>>>>>>>> downgrade-1.0 force-response-1.0
>>>>>>>>>>></IfModule>
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>>ssl.load
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>>LoadModule ssl_module /usr/lib/apache2/modules/mod_ssl.so
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>>userdir.conf
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>><IfModule mod_userdir.c>
>>>>>>>>>>> UserDir public_html
>>>>>>>>>>> UserDir disabled root
>>>>>>>>>>>
>>>>>>>>>>> <Directory /home/*/public_html>
>>>>>>>>>>> AllowOverride FileInfo AuthConfig Limit
>>>>>>>>>>> Options MultiViews Indexes SymLinksIfOwnerMatch
>>>>>>>>>>>IncludesNoExec
>>>>>>>>>>> </Directory>
>>>>>>>>>>></IfModule>
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>>userdir.load
>>>>>>>>>>>::::::::::::::
>>>>>>>>>>>LoadModule userdir_module /usr/lib/apache2/modules/mod_userdir.so
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>Thanks so very much for your help,
>>>>>>>>>>>Don
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>>From: "Barry L. Kline" <blkline at attglobal.net>
>>>>>>>>>>>>To: don garbage <dongarbage at hotmail.com>
>>>>>>>>>>>>CC: rt-users at lists.bestpractical.com
>>>>>>>>>>>>Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>>>>>>>>>>>>Date: Tue, 07 Nov 2006 14:14:27 -0500
>>>>>>>>>>>>
>>>>>>>>>>>>-----BEGIN PGP SIGNED MESSAGE-----
>>>>>>>>>>>>Hash: SHA1
>>>>>>>>>>>>
>>>>>>>>>>>>don garbage wrote:
>>>>>>>>>>>> > Hey Barry,
>>>>>>>>>>>> >
>>>>>>>>>>>> > Wow, that was fast, thanks so much.
>>>>>>>>>>>> >
>>>>>>>>>>>> > I actually did respond to your email. Here was my reply:
>>>>>>>>>>>> > Hi Barry,
>>>>>>>>>>>> >
>>>>>>>>>>>> > I just checked again for mod_fastcgi, and, it appears
>>>>>>>>>>>>that > I
>>>>>>>>>>>>do have
>>>>>>>>>>>> > it. In ubuntu, it is called
>>>>>>>>>>>> > libfcgi-perl
>>>>>>>>>>>> >
>>>>>>>>>>>> > So, back to the drawing board. :)
>>>>>>>>>>>> >
>>>>>>>>>>>> > Have you had the chance to check out my config files?
>>>>>>>>>>>> >
>>>>>>>>>>>> > Thanks for any further help,
>>>>>>>>>>>> > Don
>>>>>>>>>>>> >
>>>>>>>>>>>> > Perhaps the problem is in my config files. Any thoughts?
>>>>>>>>>>>>
>>>>>>>>>>>>I also see this in your file:
>>>>>>>>>>>>
>>>>>>>>>>>>Include /etc/apache2/mods-enabled/*.load
>>>>>>>>>>>>Include /etc/apache2/mods-enabled/*.conf
>>>>>>>>>>>>
>>>>>>>>>>>>What files are in this directory?
>>>>>>>>>>>>
>>>>>>>>>>>>Are you *sure* that the fcgi is enabled? The easiest way I know
>>>>>>>>>>>>for you
>>>>>>>>>>>>to check is to enable /server-status & /server-info in the
>>>>>>>>>>>>configuration
>>>>>>>>>>>>file. You can then check it via:
>>>>>>>>>>>>http://yourrtserver/server-info and
>>>>>>>>>>>>look for the appropriate modules.
>>>>>>>>>>>>
>>>>>>>>>>>>Barry
>>>>>>>>>>>>-----BEGIN PGP SIGNATURE-----
>>>>>>>>>>>>Version: GnuPG v1.2.6 (GNU/Linux)
>>>>>>>>>>>>
>>>>>>>>>>>>iD8DBQFFUNsTCFu3bIiwtTARAumMAJwPBfRVFFD1/6hv3wbIROkICSI+yQCeMLKn
>>>>>>>>>>>>/wGZejCJG9dZIVXLOjvr430=
>>>>>>>>>>>>=Oi4y
>>>>>>>>>>>>-----END PGP SIGNATURE-----
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>_______________________________________________
>>>>>>>>>>>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
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>_______________________________________________
>>>>>>>>>>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
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>>_______________________________________________
>>>>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
>>>
>>>
>>>_______________________________________________
>>>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
>>>
>>>
>>>--
>>>No virus found in this incoming message.
>>>Checked by AVG Free Edition.
>>>Version: 7.1.409 / Virus Database: 268.14.1/527 - Release Date: 11/9/2006
>>>
>>>
>>
>
>
>_______________________________________________
>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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: apache2.conf
Type: application/octet-stream
Size: 6532 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20061111/422f6c6f/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: apache2-modperl2.conf
Type: application/octet-stream
Size: 1486 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20061111/422f6c6f/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: RT_SiteConfig.pm
Type: application/x-perl
Size: 538 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20061111/422f6c6f/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ssl
Type: application/octet-stream
Size: 1301 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20061111/422f6c6f/attachment-0002.obj>
More information about the rt-users
mailing list