Problem saving attachments on db mysql

RT Users
1

Hi all,

my name is Davide Manzoni, I work ad a System Specialist in an Italian
ireless Company. This is my first post to this mailing list.

We have used RT for months, without problem, upgrading it a couple of
times. Now we found a problem with attachments. Some attachments are not
being saved by the DBD:mysql module called by RT. The logs say:

DBD::mysql::st execute failed: MySQL server has gone away at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/H
andle.pm line 320, line 25657.
RT::Handle=HASH(0x80fda30) couldn’t execute the query 'INSERT INTO
Attachments (Creator, ContentEncoding, Filena
me, TransactionId, Headers, ContentType, Subject, Content, Created,
Parent) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?
)'MySQL server has gone away

This problem arises only for attachment over a certain dimension (1Mb is
ok, but 1.2Mb always gives such problems). Two attachments of 1Mb are
saved correctly (with two INSERT I suppose).

Could anyone help me to solve this problem, please ?

Thanks,

	Davide Manzoni
2

Davide Manzoni wrote:

This problem arises only for attachment over a certain dimension (1Mb is
ok, but 1.2Mb always gives such problems). Two attachments of 1Mb are
saved correctly (with two INSERT I suppose).

Check your mysql config; you’re hitting the max_allowed_packet size.

set-variable = max_allowed_packet=10M

in your my.cnf should help you.
Phil Homewood, Systems Janitor, www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances