The mailing list for listmasters using Sympa

[Tornoci Laszlo <address@concealed>]

On 02/09/2010 06:51 PM, address@concealed wrote:
> Hi, all,
>
> I'm having a problem with Sympa 6.0.1 when my users try and send attachments
> to their lists.  I am getting this error:
>
> Feb  8 13:36:54 young sympa[32538]: Bulk::store() Unable to add message in
> bulkspool_table "INSERT INTO bulkspool_table (messagekey_bulkspool,
> message_bulkspool, lock_bulkspool) VALUES
> ('a82dc44c53fa227b3207c4b3ba66b5be',
> 'WC1TeW1wYS1UbzogbWluaXN0ZXJzQGdyb3Vwcy53ZXN0b3Zlci5vcmcKUmVjZWl2ZWQ6IGZyb20g
> \nc210cDEwMi5zYmMubWFpbC5', '1')"; error : Got a packet bigger than
> 'max_allowed_packet' bytes
>
> I suspect that I have to configure max_allowed_packet in my /etc/my.cnf
> file, but has anyone already one this, and do you know what is an
> appropriate new limit?
>
> Many Thanks,
> John
Hi John,

I use:
# increase max_allowed packet for sympa
max_allowed_packet=16M

The mysql documentation says it is safe to increase this value, it will 
increase memory use only when it is actually needed:

http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html

Yours: Laszlo