The mailing list for listmasters using Sympa

["Stefan Hornburg (Racke)" <address@concealed>]

On 10/24/18 4:01 PM, THOMAS M BLADER wrote:
> Hello,
> I am getting a few errors running Sympa 6.1.17~dfsg-1 on Ubuntu 14.04.
> 
> Recently I have been getting errors about "Bulk mailer error" saying
> "failed to store a message for list west.staff.all in the bulk mailer."
> 
> I have looked in the logs and it appears there is some mysql error
> during insert. Does anyone know what can cause this?

Hello Thomas,

usually that means the MySQL went away while Sympa still maintained the 
database handle,
e.g. the MySQL server was updated or restarted.

Regards
         Racke

> 
> Thank you
> 
> 
> Oct 23 16:37:56 lists sympa[1343]: notice main::DoFile() Processing
> /address@concealed ;
> sender: smith Alice E <address@concealed> ; message-id:
> <address@concealed>
> Oct 23 16:37:57 lists sympa[1343]: info main::DoMessage() Processing
> message for west.staff.all with priority 5,
> <address@concealed>
> Oct 23 16:38:02 lists sympa[1343]: notice
> List::on_the_fly_sync_include() Synchronizing list members...
> Oct 23 16:38:03 lists sympa[1343]: info List::_include_users_list()
> Include 709 users from list west.all.devprod
> Oct 23 16:38:03 lists sympa[1343]: info List::_include_users_list()
> Include 39 users from list west.all.sales
> Oct 23 16:38:03 lists sympa[1343]: info List::_include_users_list()
> Include 84 users from list west.all.users
> Oct 23 16:38:03 lists sympa[1343]: info List::_include_users_list()
> Include 35 users from list west.all.finance
> Oct 23 16:38:03 lists sympa[1343]: notice List::sync_include()
> List:sync_include(west.staff.all): 8 users updated
> Oct 23 16:38:03 lists sympa[1343]: notice List::remove_task() Removing
> task file address@concealed
> Oct 23 16:38:04 lists sympa[1343]: 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
> ('f80460a2e4bae4ceb513b4f532d5aac5',
> '<address@concealed>',
> 'UmV0dXJuLVBhdGg6IDxNZWdhbi5DaGlsZGVyc0BmYW1tBYEud2lzpq5lEHU+ClgtT3JpZ2luYWwt\nVG86IERGTUNILkFsbC5ERk1',
> 1, NULL ,NULL ,NULL, '')"; error : MySQL server has gone away
> Oct 23 16:38:04 lists sympa[1343]: err mail::sending() Failed to store
> message for list west.staff.all
> Oct 23 16:38:09 lists sympa[1343]: err List::send_msg() List::send_msg,
> could not send message to distribute from
> address@concealed (verp desabled)
> Oct 23 16:38:09 lists sympa[1343]: err main::DoMessage()
> sympa::DoMessage(): Unable to send message to list west.staff.all
> Oct 23 16:38:11 lists archived[1365]: notice Archiving
> address@concealed for list
> address@concealed
> Oct 23 16:38:14 lists sympa[1343]: 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
> ('a5729fe2eb402393fda1d6225cd3d296',
> '<address@concealed>',
> 'RGF0ZTogVHVlLCAyMyBPY3QgMjAxOCAxNjozOFoeMtUaACFqPBePcE1FLVZlcnNpb246IDEuMApB\ndXRvLVN1Ym1pdHRlZDogYXV',
> 1, NULL ,NULL ,NULL, '')"; error : MySQL server has gone away
> Oct 23 16:38:14 lists sympa[1343]: err mail::sending() Failed to store
> message for list west.staff.all
> Oct 23 16:38:15 lists task_manager[1348]: notice main::create() creation
> of
> /address@concealed
> Oct 23 16:38:15 lists task_manager[1348]: notice main::create() with
> model /usr/share/sympa/default/list_task_models/sync_include.ttl.task
> Oct 23 16:38:15 lists task_manager[1348]: notice main::execute() Running
> task
> /address@concealed,
> line 0 with vars )
> Oct 23 16:38:15 lists task_manager[1348]: info
> List::_include_users_list() Include 9 users from list staffteam
> Oct 23 16:38:15 lists task_manager[1348]: notice List::sync_include()
> List:sync_include(finance): 17 users updated
> Oct 23 16:38:15 lists task_manager[1348]: notice main::next_cmd() line 5
> of sync_include : next (1540334295, INIT)
> Oct 23 16:38:15 lists task_manager[1348]: notice main::create() creation
> of /address@concealed
> Oct 23 16:38:15 lists task_manager[1348]: notice main::create() with
> model /usr/share/sympa/default/list_task_models/sync_include.ttl.task
> Oct 23 16:38:15 lists task_manager[1348]: notice main::next_cmd() -->
> new task sync_include (23 Tue Oct 2018  17 h 38 min 15 s)
> Oct 23 16:38:19 lists sympa[1343]: err List::send_file()
> List::send_file, could not send template
> /usr/share/sympa/default/mail_tt2/message_report.tt2 to
> address@concealed
> Oct 23 16:38:19 lists sympa[1343]: notice report::reject_report_msg()
> report::reject_report_msg(): Unable to send template 'message_report' to
> 'address@concealed'
> Oct 23 16:38:25 lists sympa[1343]: notice Moving bad file
> address@concealed to bad/
> 
> 
> 


-- 
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.