The mailing list for listmasters using Sympa

[IKEDA Soji <address@concealed>]

Hi Darrin,

On 2022/09/01 17:48, Darrin de Groot wrote:
> Hi,
>
> We're using sympa 6.2.60 and had an incident the other day whereby our 
> database server had an outage. During this time we noticed that the 
> postfix on the sympa server accepted incoming email, passed them off to 
> sympa which then processed the emails, archived them correctly, but did 
> not deliver any email as it (understandably) couldn't determine the 
> subscriber list - we saw this type of error in the logs (note - I 
> altered the name of the list):
>
> Aug 19 14:33:40 listserver sympa_msg[2969132]: info 
> Sympa::Spindle::ToList::_send_msg() No subscriber in list Sympa::List 
> <address@concealed>
>
> Is there any option or configuration that could enable sympa to queue 
> incoming email or bounce back to the sender in the event that the 
> database is down rather than assume that the list is empty?

I couldn't reproduce the problem you encountered.
The expected behavior of Sympa is as described in below.

To help resolve your problem, please let us know the configuration of
the list in question (such as config file).

Regards,
-- Soji

                                      ***

I tried with Sympa 6.2.68.

I stopped database server (MariaDB) keeping Sympa services running,
and sent a message to a list.

Then, sympa_msg.pl accepted the message but paused processing of it, and
repeatedly output the following log.

| Oct  6 14:59:43 listserver sympa_msg[6000]: err main::#243 > Sympa::Sp
| indle::spin#95 > Sympa::Spindle::ToList::_twist#58 > Sympa::Spindle::T
| oList::_send_msg#198 > Sympa::List::sync_include#4080 > Sympa::List::h
| as_included_users#5704 > Sympa::Database::do_prepared_query#360 > Symp
| a::DatabaseDriver::MySQL::connect#58 > Sympa::Database::connect#171 Ca
| n't connect to Database Sympa::DatabaseDriver::MySQL <db_host=localhos
| t;db_name=sympa;db_user=sympa>, still trying...

I restared database server.  After a few minutes, this log appeared:

| Oct  6 15:16:14 listserver sympa_msg[6000]: notice Sympa::Database::co
| nnect() Connection to Database Sympa::DatabaseDriver::MySQL <db_host=l
| ocalhost;db_name=sympa;db_user=sympa> restored

Then sympa_msg.pl resumed processing the message and it was delivered.


> Regards,
>
> Darrin

--
株式会社 コンバージョン
ITソリューション部 システムソリューション1グループ 池田荘児
e-mail address@concealed
https://www.conversion.co.jp/