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

[Peter Ziobrzynski]

I will answer my own question:
A classic case of RTFM - this parameter is the MySQL parameter that is 
set in /etc/my.cnf and by default is 1M and can be as big as 16M.


Peter Ziobrzynski wrote:

> 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