The mailing list for listmasters using Sympa

[David Verdin <address@concealed>]

Hi Matthew,

Have a look at the spools anyway. It happened to me before on some rare occasions for weirdly encoded messages: the sympa_msg.pl stalls on the treatment of the weird message until you need to kill it or it crashes. Problem is: it stalls back (more or less like the proverbial empire - sorry, I had to do it) when meeting the message again in the spools.

You should have a look at the Sympa logs to see which message it was handling just before being locked and check what happened to this message.

If it happens to still be in the spools, I'm sure you could submit an issue to the Sympa Github  with the message attached and the corresponding logs, as the same problem could happen to somebody else.

Regards,

David

On 10/06/2020 22:48, Matthew Goebel wrote:

Looks like the problem was that sympa_msg.pl was locked up.

I had to killed -9 it and then restart sympa.

Matt

On Wed, Jun 10, 2020 at 4:04 PM Matthew Goebel <address@concealed> wrote:

In a file in /home/sympa/spool/tmp I'm getting lots of the following?

Use of uninitialized value $value in printf at /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN25840> line 1. Use of uninitialized value $value in printf at /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN25840> line 1.
Thanks,
Matt

On Wed, Jun 10, 2020 at 3:40 PM Matthew Goebel <address@concealed> wrote:

Hello again,

Since this error it does not appear to processing the messages in spool/msg 

Jun 10 15:08:58 sega archived[3264]: notice Sympa::Spindle::ProcessArchive::_twist() Processing Sympa::Message <address@concealed,3241,8601>; sender: address@concealed; message ID: address@concealed Jun 10 15:09:03 sega sympa_msg[3241]: notice Sympa::Spindle::ProcessIncoming::_twist() Processing Sympa::Message <address@concealed>; address@concealed; address@concealed; address@concealed Jun 10 15:09:03 sega sympa_msg[3241]: err main::#243 > Sympa::Spindle::spin#95 > Sympa::Spindle::AuthorizeMessage::_twist#106 > Sympa::Scenario::authz#407 > (eval)#407 > Sympa::Scenario::__ANON__#34 > Sympa::Scenario::do_search#1293 > Sympa::DatabaseDriver::MySQL::connect#58 > Sympa::Database::connect#164 Can't connect to Database Sympa::DatabaseDriver::MySQL <db_host=localhost;db_name=sympa;db_user=sympa>, still trying...
Is there some kind of file lock I need to fiddle with to get things processing again?

Thanks,

Matt

On Wed, Jun 10, 2020 at 3:29 PM Matthew Goebel <address@concealed> wrote:

Hello,

running sympa 6.2.56 on redhat Enterprise 7

Just before it seems to have stopped processing the incoming email it threw 

an email "Cannot connect to database", after restarting sympa everything seems 

to be working fine except for the email processing?

Can't seem to find anything odd in the sympa.log file.

Thanks,
Matt

--

Matthew Goebel : address@concealed : Unix Jockey @ EMU : Hail Eris
Neo-Student, Net Lurker, Donut consumer, and procrastinating medher...
 "Always with the negative waves, Moriarty" - Oddball
 "Comfort the troubled, and trouble the comfortable." - Dietrich Bonhoeffer

-----------------

Please note: My work schedule has changed.  I am now working Monday-Wednesday, and Friday.  I will respond to most communications during my regular work schedule.  If you need immediate assistance on a Thursday, please contact the I.T. help Desk at 734.487.2120.

--

Matthew Goebel : address@concealed : Unix Jockey @ EMU : Hail Eris
Neo-Student, Net Lurker, Donut consumer, and procrastinating medher...
 "Always with the negative waves, Moriarty" - Oddball
 "Comfort the troubled, and trouble the comfortable." - Dietrich Bonhoeffer

-----------------

Please note: My work schedule has changed.  I am now working Monday-Wednesday, and Friday.  I will respond to most communications during my regular work schedule.  If you need immediate assistance on a Thursday, please contact the I.T. help Desk at 734.487.2120.

--

Matthew Goebel : address@concealed : Unix Jockey @ EMU : Hail Eris
Neo-Student, Net Lurker, Donut consumer, and procrastinating medher...
 "Always with the negative waves, Moriarty" - Oddball
 "Comfort the troubled, and trouble the comfortable." - Dietrich Bonhoeffer

-----------------

Please note: My work schedule has changed.  I am now working Monday-Wednesday, and Friday.  I will respond to most communications during my regular work schedule.  If you need immediate assistance on a Thursday, please contact the I.T. help Desk at 734.487.2120.

      --

Matthew Goebel : address@concealed : Unix Jockey @ EMU : Hail Eris
Neo-Student, Net Lurker, Donut consumer, and procrastinating medher...
 "Always with the negative waves, Moriarty" - Oddball
 "Comfort the troubled, and trouble the comfortable." - Dietrich Bonhoeffer

-----------------

Please note: My work schedule has changed.  I am now working Monday-Wednesday, and Friday.  I will respond to most communications during my regular work schedule.  If you need immediate assistance on a Thursday, please contact the I.T. help Desk at 734.487.2120.

-- 
"Mieux vaut viser la perfection et la rater que viser la médiocrité et l'atteindre."
- Francis Blanche

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature