[rt-users] RT becoming unstable / unable to add attachments (Resolution Found)

[Rodney Caston]

Just to follow up on this issue for the ML:

Switching from mod_perl to FASTCGI resolved the issue, so I would
suggest that approach to resolving this if anyone else has these same
problems.



-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Rodney
Caston
Sent: Friday, January 28, 2005 11:59 AM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] RT becoming unstable / unable to add
attachments(requires apache restart to fix?)

We're having a strange problem where by a ticket(s) will accept image
attachments fine for awhile, then suddenly, any attachments made to it
no longer get stored corrected, a red X / box is displayed (broken link)
and even trying to save the attachment off results in a corrupted file.

The only way to fix this issue is to restart Apache, after doing so -
the tickets accept attachments normally again.  However, any attachments
made before the start are obviously still corrupted data.

Has anyone else had this issue of Apache needing to be restarted in
order to allow attachments to process correctly again?  


Rodney Caston
Match.com

##### The Details ####
Linux da0mirt001 2.4.21-4.ELsmp #1 SMP    # uname -a
3.2.2	 	# cat /opt/rt3/lib/RT.pm | grep VERSION 
5.8.6  	# perl -v
5.008	 	# echo "<% $] %>" >/opt/rt3/local/html/test.html 
1.19	# perl -MDBIx::SearchBuilder -e 'print
$DBIx::SearchBuilder::VERSION;'
2.0.46	# httpd -v
NO OUTPUT	# cat error_log | grep mod_perl | grep notice | tail -n
1 
3.23.58	# mysql -V

### begin httpd.conf ####
<VirtualHost 10.223.206.69>
    ServerName rt.match.corp
    DocumentRoot /usr/local/rt3/share/html
    AddDefaultCharset UTF-8
    Alias /NoAuth/images/ /usr/local/rt3/share/html/NoAuth/images/

    # these four lines apply to Apache2+mod_perl2 only: {{{
    PerlSetVar MasonArgsMethod CGI
    PerlModule Apache2 Apache::compat
    RewriteEngine On
    RewriteRule ^(.*)/$ $1/index.html
    # }}}

    PerlModule Apache::DBI
    PerlRequire /usr/local/rt3/bin/webmux.pl

    <Location />
        SetHandler perl-script
        PerlHandler RT::Mason
    </Location>
</VirtualHost>

<IfDefine PerlDProf>
  <Perl>
    use Apache::DB ();
    Apache::DB->init;
  </Perl>>

  <IfDefine !PerlSmallProf>
    PerlModule Apache::DProf
  </IfDefine>
</IfDefine>

# Change it to Apache2 if use mod_perl 2
PerlModule Apache2

<IfDefine PerlStatus>
  PerlModule Apache::Status
</IfDefine>

<IfDefine PerlDBIProf>
  PerlSetEnv DBI_PROFILE DBI::ProfileDumper::Apache
</IfDefine>
PerlModule Apache::DBI

AddDefaultCharset UTF-8

PerlRequire /usr/local/rt3/bin/webmux.pl

<Location />
  Options None
  SetHandler perl-script
  PerlHandler RT::Mason
  <IfDefine PerlDProf>
    <IfDefine PerlSmallProf>
      PerlFixupHandler Apache::SmallProf
    </IfDefine>
  </IfDefine>
</Location>

<Location /NoAuth/images>
  SetHandler default-handler
</Location>

<IfDefine PerlStatus>
  <Location /perl-status>
    SetHandler perl-script
    PerlHandler Apache::Status
    PerlSetVar StatusOptionsAll On
    PerlSetVar StatusTerse On
    PerlSetVar StatusTerseSize On
    PerlSetVar StatusTerseSizeMainSummary On
    PerlSetVar StatusLexInfo On
  </Location>
</IfDefine>
### end httpd conf ###
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact
training at bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com