[rt-users] attachment corruption, 3.4.1 => 3.4.4

[Joby Walker]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

With a database don't ever copy the files, dump the database on the old,
and load on the new.

jbw

Paul Grondahl wrote:
> hello,
> 
> i just moved moved our rt instance from one rhel 4 system to another
> identical system.
> 
> i copied the db between the systems and ran md5sum to ensure that it didn't
> get corrupted.
> 
> old system:
> - rt 3.4.1
> - apache 2.0.52-9
> - mod_perl-1.99_16-4
> - perl 5.8.5-12.1
> 
> new system:
> - rt 3.4.4
> - apache 2.0.52-12.2
> - fast_cgi
> - perl 5.8.5-12.1
> 
> the old system was working, but performance was not great.
> 
> upon moving to the new system, i installed rt 3.4.4. as 3.4.4 does not
> support mod_perl 1.99 i installed fast_cgi. this also improved performance a
> lot.
> 
> the problem is that most attachments are corrupted. most attachments, not
> all. bmp files are intact, whereas jpg's are corrupted. zip archives are
> partially corrupted, meaning that some of the files within are readable.
> 
> please see logs below.
> 
> i see from the archives that this has been an issue, but none of the
> solutions mentioned seem to apply.
> 
> thanks,
> 
> paul
> 
> 
> /var/log/httpd/error_log shows:
> 
> 
> [Tue Sep 20 09:48:32 2005] [error] [client xxx] FastCGI: server
> "/opt/rt3/bin/mason_handler.fcgi" stderr: [Tue Sep 20 16:48
> :32 2005] [error]: Encoding error: Unknown encoding '\\"ISO-8859-1\\"' at
> /opt/rt3/lib/RT/I18N.pm line 451 [Tue Sep 20 09:48:32 2005] [error] [client
> xxx] FastCGI: server "/opt/rt3/bin/mason_handler.fcgi" stderr: Stack:
> [Tue Sep 20 09:48:32 2005] [error] [client xxx] FastCGI: server
> "/opt/rt3/bin/mason_handler.fcgi" stderr:   [/usr/lib/perl5
> /5.8.5/Carp.pm:201]
> [Tue Sep 20 09:48:32 2005] [error] [client xxx] FastCGI: server
> "/opt/rt3/bin/mason_handler.fcgi" stderr:   [/usr/lib/perl5
> /5.8.5/i386-linux-thread-multi/Encode.pm:177]
> [Tue Sep 20 09:48:32 2005] [error] [client xxx] FastCGI: server
> "/opt/rt3/bin/mason_handler.fcgi" stderr:   [/opt/rt3/lib/R
> T/I18N.pm:451]
> [Tue Sep 20 09:48:32 2005] [error] [client xxx] FastCGI: server
> "/opt/rt3/bin/mason_handler.fcgi" stderr:   [/opt/rt3/lib/R
> T/I18N.pm:196]
> [Tue Sep 20 09:48:32 2005] [error] [client xxx] FastCGI: server
> "/opt/rt3/bin/mason_handler.fcgi" stderr:   [/opt/rt3/lib/R
> T/I18N.pm:188]
> [Tue Sep 20 09:48:32 2005] [error] [client xxx] FastCGI: server
> "/opt/rt3/bin/mason_handler.fcgi" stderr:   [/opt/rt3/lib/R
> T/I18N.pm:188]
> [Tue Sep 20 09:48:32 2005] [error] [client xxx] FastCGI: server
> "/opt/rt3/bin/mason_handler.fcgi" stderr:   [/opt/rt3/lib/R
> T/EmailParser.pm:267]
> [Tue Sep 20 09:48:32 2005] [error] [client xxx] FastCGI: server
> "/opt/rt3/bin/mason_handler.fcgi" stderr:   [/opt/rt3/lib/R
> T/EmailParser.pm:238]
> [Tue Sep 20 09:48:32 2005] [error] [client xxx] FastCGI: server
> "/opt/rt3/bin/mason_handler.fcgi" stderr:   [/opt/rt3/lib/R
> T/EmailParser.pm:211]
> [Tue Sep 20 09:48:32 2005] [error] [client xxx] FastCGI: server
> "/opt/rt3/bin/mason_handler.fcgi" stderr:   [/opt/rt3/lib/R
> T/EmailParser.pm:129]
> [Tue Sep 20 09:48:32 2005] [error] [client xxx] FastCGI: server
> "/opt/rt3/bin/mason_handler.fcgi" stderr:   [/opt/rt3/lib/R
> T/Interface/Email.pm:511]
> [Tue Sep 20 09:48:32 2005] [error] [client xxx] FastCGI: server
> "/opt/rt3/bin/mason_handler.fcgi" stderr:   [/opt/rt3/share
> /html/REST/1.0/NoAuth/mail-gateway:57]
> [Tue Sep 20 09:48:32 2005] [error] [client xxx] FastCGI: server
> "/opt/rt3/bin/mason_handler.fcgi" stderr:  defaulting to IS
> O-8859-1 -> UTF-8 (/opt/rt3/lib/RT/I18N.pm:454)
> 
> 
> i also get these:
> 
> [Tue Sep 20 13:21:55 2005] [error] [client xxx] FastCGI: server
> "/opt/rt3/bin/mason_handler.fcgi" stderr: [Tue Sep 20 20:2
> 1:55 2005] [error]: Deserialization of attribute 77 failed
> (/opt/rt3/lib/RT/Attribute_Overlay.pm:232), referer:
> http://xxx.com/Search/Build.html
> 
> 
> 
> 
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 
> Buy your copy of our new book, RT Essentials, today! 
> 
> Download a free sample chapter from http://rtbook.bestpractical.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDMNz3gA0gpghkf88RAizNAJ0eRvSttbhD/hXYRn4+Ddq+/lwcsQCg5u85
Uay0i4wqc1giwV+mAkLyk44=
=8LnG
-----END PGP SIGNATURE-----