RT becoming unstable / unable to add attachments (Resolution Found)

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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Rodney
Caston
Sent: Friday, January 28, 2005 11:59 AM
To: rt-users@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>
use Apache::DB (); Apache::DB->init; >

<IfDefine !PerlSmallProf>
PerlModule Apache::DProf

Change it to Apache2 if use mod_perl 2

PerlModule Apache2

PerlModule Apache::Status PerlSetEnv DBI_PROFILE DBI::ProfileDumper::Apache PerlModule Apache::DBI

AddDefaultCharset UTF-8

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

Options None SetHandler perl-script PerlHandler RT::Mason PerlFixupHandler Apache::SmallProf

<Location /NoAuth/images>
SetHandler default-handler

SetHandler perl-script PerlHandler Apache::Status PerlSetVar StatusOptionsAll On PerlSetVar StatusTerse On PerlSetVar StatusTerseSize On PerlSetVar StatusTerseSizeMainSummary On PerlSetVar StatusLexInfo On ### 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@bestpractical.com for details.

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