The mailing list for listmasters using Sympa

["Chris Hastie" (via sympa-users Mailing List) <address@concealed>]

I've had a couple of issues lately of message distribution failing with
the error "MySQL server has gone away". The first was with a daily
digest, and the most recent this afternoon with an ordinary message. It
also looks as if the attempt to tell the original sender of the failure
may itself have failed.

All I can find with a Google is a note (in French) at
http://www.sympa.org/faq/database suggesting that the MySQL server has
gone away message is nothing to worry about. However, in this case it
clearly is, since the message distribution is failing.

And idea of what I can do to stop this problem happening?


Dec 14 13:54:25 iorek sympa[24437]: notice main::DoFile() Processing
/address@concealed
;
sender: keithbond <address@concealed>#012 ; message-id:
<address@concealed>#012
Dec 14 13:54:25 iorek sympa[24437]: debug main::DoFile() Setting log
level with lists.raggedstaff.net configuration (or sympa.conf) : 4
Dec 14 13:54:25 iorek sympa[24437]: debug2 List::new()
List::new(sbsac-chat, lists.raggedstaff.net, )
Dec 14 13:54:25 iorek sympa[24437]: debug2 List::load()
List::load(sbsac-chat, lists.raggedstaff.net, )
Dec 14 13:54:26 iorek sympa[24437]: info main::DoMessage() Processing
message for sbsac-chat with priority 5,
<address@concealed>#0
12
Dec 14 13:54:27 iorek sympa[24437]: notice
List::on_the_fly_sync_include() Synchronizing list members...
Dec 14 13:54:27 iorek sympa[24437]: info List::_include_users_sql() 58
included users from SQL query
Dec 14 13:54:27 iorek sympa[24437]: notice List::sync_include()
List:sync_include(sbsac-chat): 0 users updated
Dec 14 13:54:27 iorek sympa[24437]: notice List::remove_task() Removing
task file address@concealed
Dec 14 13:54:27 iorek sympa[24437]: err Bulk::store() Unable to add
message in bulkspool_table "INSERT INTO bulkspool_table
(messagekey_bulkspool, m
essageid_bulkspool, message_bulkspool, lock_bulkspool, dkim_d_bulkspool,
dkim_i_bulkspool, dkim_selector_bulkspool, dkim_privatekey_bulkspool) VALUE
S ('0819d35034c5286b78d5f8b315707be4',
'<address@concealed>',
'UmV0dXJuLVBhdGg6IDxrZWl0aGJvbmRAdGFsazIxLmNvbT4KWC1PcmlnaW5hbC1Ubzog
c2JzYWMt\nY2hhdEBsaXN0cy5yYWdnZWR', 1, NULL, NULL, NULL, '')"; error :
MySQL server has gone away
Dec 14 13:54:27 iorek sympa[24437]: err mail::sending() Failed to store
message for list sbsac-chat
Dec 14 13:54:28 iorek sympa[24437]: err List::send_msg() List::send_msg,
could not send message to distribute from address@concealed
f.net (verp desabled)
Dec 14 13:54:28 iorek sympa[24437]: err main::DoMessage()
sympa::DoMessage(): Unable to send message to list sbsac-chat
Dec 14 13:54:28 iorek postfix/pickup[2362]: 4F4CA245EA3: uid=119
from=<address@concealed>
Dec 14 13:54:28 iorek postfix/cleanup[23241]: 4F4CA245EA3:
message-id=<address@concealed>
Dec 14 13:54:28 iorek postfix/qmgr[23692]: 4F4CA245EA3:
from=<address@concealed>, size=608, nrcpt=1 (queue active)
Dec 14 13:54:29 iorek sympa[24437]: err Bulk::store() Unable to add
message in bulkspool_table "INSERT INTO bulkspool_table
(messagekey_bulkspool, messageid_bulkspool, message_bulkspool,
lock_bulkspool, dkim_d_bulkspool, dkim_i_bulkspool,
dkim_selector_bulkspool, dkim_privatekey_bulkspool) VALUES
('b206520884daac604b3a4ddf6a9b1b10',
'<address@concealed>',
'TWVzc2FnZS1JZDogPHN5bXBhLjE0MTg1NjUyNjguMjQ0MzcuMzc3QGxpc3RzLnJhZ2dlZHN0YWZm\nLm5ldD4KRGF0ZTogU3VuLCA',
1, NULL, NULL, NULL, '')"; error : MySQL server has gone away
Dec 14 13:54:29 iorek sympa[24437]: err mail::sending() Failed to store
message for list sbsac-chat
Dec 14 13:54:29 iorek sympa[24437]: err List::send_file()
List::send_file, could not send template
/usr/local/sympa/default/mail_tt2/message_report.tt2 to address@concealed
Dec 14 13:54:29 iorek sympa[24437]: notice report::reject_report_msg()
report::reject_report_msg(): Unable to send template 'message_report' to
'address@concealed'