Subject: The mailing list for listmasters using Sympa
List archive
RE: [sympa-users] Sympa unable to send messages after system crash
- 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...)
-
[sympa-users] Sympa unable to send messages after system crash,
Russ Kepler, 12/14/2013
-
RE: [sympa-users] Sympa unable to send messages after system crash,
Steve Shipway, 12/14/2013
- Re: [sympa-users] Sympa unable to send messages after system crash, Russ Kepler, 12/14/2013
-
RE: [sympa-users] Sympa unable to send messages after system crash,
Steve Shipway, 12/14/2013
Archive powered by MHonArc 2.6.19+.