Attachment corruption, 3.4.1 => 3.4.4

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

-----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-----

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

Greetings!

Paul Grondahl wrote:

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.

Please describe your copy procedure and include mysql’s versions.

SY, Danial.


Danial Klimkin,
Falk eSolutions AG Russia
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDMRKc2ce6OqXQ52QRAof7AJwNN5S00LuEuSR8ed/U9VL1S20L8gCeM4Nv
yjIBmyc+PMhrnBnpXcrj2+M=
=TDMr
-----END PGP SIGNATURE-----