[rt-users] mysql database copy fails with packet bigger than allowed

Harald Wagener hwagener at hamburg.fcb.com
Tue Aug 30 12:14:46 EDT 2005


Hello,
I had this a few days ago and retaliated by removing a word document  
from the attachments table, which obviously is not the clean way to  
proceed.

You should check for the biggest attachment in the attachments table  
by the following statement:

select max(length(Content)) from Attachments;

This should give You the actual size of the largest attachment in the  
database in bytes. Setting max_allowed_packet to something slightly  
larger than this should help.

If this does not help, there might be a problem with the attachment  
itself.

Regards,
     Harald



More information about the rt-users mailing list