The mailing list for listmasters using Sympa

[David Verdin <address@concealed>]

Hi,

Lazslo's right. You must increase the max_allowed_packet value.
I just want to add a note: you can test the maximum message size that 
will be accepted by your RDBMS thanks to the following command:

sympa.pl --test_database_message_buffer

This sends incrementally bigger packets to the database, until one is 
refused because it's too big.

Regards,

David

Le 09/02/2010 21:21, Tornoci Laszlo a écrit :
> 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

--
David Verdin
Comité réseau des universités