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

Marcus Ramberg marcus at mediaflex.no
Thu Jun 12 06:56:52 EDT 2003


Does this mean that 16M is the biggest record mysql can handle? Ouch, I 
am in deep shit then. We use rt to recieve advertisements for a 
newspaper, and some attachments can be way  more than 16 M. Anyone know 
a workaround for this?

Marcus
On torsdag, jun 12, 2003, at 02:04 Europe/Oslo, Peter Ziobrzynski wrote:

> 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
>
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

--
This e-mail has been protected by Song Networks' virus-scan service:
http://www.securemail.no




More information about the rt-users mailing list