[rt-users] Got a packet bigger than 'max_allowed_packet'

[Peter Ziobrzynski]

Got the following error after somebody provided comment via email with 
the attachement. Attachment was about 1.3MByte which is lower then the 
limit of the message on my sendmail (sendmail.mc: O 
MaxMessageSize=100000000) and rt (RT_SiteConfig.pm: 
Set($MaxAttachmentSize , 10000000);). The ticket was processed three 
more times in one hour intervals and then looping stopped.
Here is the error in /usr/local/rt3/var/log/rt.log:


[Wed Jun 11 00:36:00 2003] [debug]: Found a ticket ID. It's 2189 
(/usr/local/rt3/lib/RT/EmailParser.pm:261)
[Wed Jun 11 00:36:00 2003] [warning]: DBD::mysql::st execute failed: Got 
a packet bigger than 'max_allowed_packet' at 
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 386.
 (/usr/local/rt3/lib/RT.pm:226)
[Wed Jun 11 00:36:00 2003] [warning]: RT::Handle=HASH(0x99ecf60) 
couldn't execute the query 'INSERT INTO Attachments (Subject, 
ContentType, Filename, Headers, Creator, Parent, Created, ContentEncodi
ng, Content, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at 
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 393.
 (/usr/local/rt3/lib/RT.pm:226)


Any ideas? Thanks
-Peter

-- 
Peter Ziobrzynski, mailto:pzi at pzi.net