Skip to Content.
Sympa Menu

en - RE: [sympa-users] Sympa unable to send messages after system crash

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Steve Shipway <address@concealed>
  • To: Russ Kepler <address@concealed>, "address@concealed" <address@concealed>
  • Subject: RE: [sympa-users] Sympa unable to send messages after system crash
  • Date: Sat, 14 Dec 2013 07:04:46 +0000

I think "Failed to store message" means that it was unable to insert a record
into the bulk mailer table for distribution.

This could be for several reasons - one common one here is that the message
is simply too big as you need to set a max packet size setting in my.cnf to
be able to handle the larger messages.

I think your issue might be some sort of Mysql corruption. Maybe one of the
tables or indices is broken. You could put Sympa into debug mode and send a
message and see if you get more detailed sql error information.

When using the wwsympa interface, it is only using a couple of the tables,
which might be OK. The bulk process uses almost all of them. It might be
worth rebuilding the database, if you have a data backup. If you dont have a
data backup, and you don't have too many lists, you could still recreate the
database and then re-load the lists and Sympa will rebuild the rest.

Steve

Steve Shipway
University of Auckland ITS
UNIX Systems Design Lead
address@concealed
Ph: +64 9 373 7599 ext 86487


________________________________________
From: address@concealed
[address@concealed] on behalf of Russ Kepler
[address@concealed]
Sent: Saturday, 14 December 2013 6:07 p.m.
To: address@concealed
Subject: [sympa-users] Sympa unable to send messages after system crash

I've had Sympa running for a long while, long enough that I don't really
remember the details of setting it up - it's been that pain free for that
long. But today it's not restarting after a system failure of some kind.

As admin, I'm getting a message "Bulk mailer error" containing the text "Sympa
failed to store a message for list in the bulk mailer. You should check
log files!"

The applicable log messages seem to be:

Dec 13 21:34:18 main sympa[2287]: err mail::sending() Failed to store message
for list
Dec 13 21:34:18 main postfix/qmgr[1931]: 7A7AB140493: from=<sympa-
address@concealed>, size=595, nrcpt=1 (queue active)
Dec 13 21:34:18 main sympa[2287]: err List::send_global_file()
List::send_global_file, could not send template
/usr/share/sympa/default/mail_tt2/command_report.tt2 to address@concealed
Dec 13 21:34:18 main sympa[2287]: notice report::send_report_cmd()
report::send_report_cmd() : Unable to send template 'command_report' to
address@concealed

The database in mysql is still accessible from wwsympa on the web interface,
the sympa.conf looks OK, what am I missing (likely blindingly obvious but...)




Archive powered by MHonArc 2.6.19+.

Top of Page