The mailing list for listmasters using Sympa

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

On 9/28/20 3:35 PM, TISSOT Jacques wrote:
> Errors in .stderr file :
> 
>  
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614503> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614503> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614503> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614503> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614503> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614503> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614503> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614507> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614507> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614507> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614527> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614531> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614539> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614539> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614543> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614543> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614547> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614547> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614547> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614547> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614551> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN4614555> line 1.
> 
>  
> 
> Does it help?
> 

This problem has been fixed by pull request 
https://github.com/sympa-community/sympa/pull/941 and will be included
in the next release of Sympa (6.2.58).

Regards
         Racke

>  
> 
> Jacques
> 
>  
> 
>  
> 
> *From:*Matthew Goebel <address@concealed>
> *Sent:* lundi, 28 septembre 2020 15:32
> *To:* TISSOT Jacques <address@concealed>
> *Cc:* address@concealed
> *Subject:* Re: [sympa-users] incoming email spooling in spool/msg but not 
> getting processed?
> 
>  
> 
> Sounds like that might be a different issue.  What errors where in the 
> .stderr file?
> 
>  
> 
> Thanks,
> 
> Matt
> 
>  
> 
>  
> 
> On Mon, Sep 28, 2020 at 9:20 AM TISSOT Jacques <address@concealed 
> <mailto:address@concealed>> wrote:
> 
>     Dear David and Matthew,
> 
>      
> 
>     I’m running SYMPA 6.2.54.
> 
>     I have the same phenomenon. It has one time filled up .stderr file to 
> 16GB (!)
> 
>     These lines seem to be related with badly formed emails in include 
> file. Isnt’it?
> 
>      
> 
>     Regards,
> 
>     J. Tissot
> 
>     University of Fribourg
> 
>     Switzerland
> 
>      
> 
>      
> 
>     *From:*address@concealed 
> <mailto:address@concealed>
>     <address@concealed 
> <mailto:address@concealed>> *On Behalf Of *David Verdin
>     *Sent:* jeudi, 11 juin 2020 10:00
>     *To:* address@concealed 
> <mailto:address@concealed>
>     *Subject:* Re: [sympa-users] incoming email spooling in spool/msg but 
> not getting processed?
> 
>      
> 
>     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 <http://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 <http://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 
> <mailto: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 <mailto: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
>                 
> <mailto:address@concealed>,3241,8601>;
>  sender: address@concealed
>                 <mailto:address@concealed>; message ID: 
> address@concealed
>                 
> <mailto:address@concealed>
> 
>                 Jun 10 15:09:03 sega sympa_msg[3241]: notice 
> Sympa::Spindle::ProcessIncoming::_twist() Processing
>                 Sympa::Message <address@concealed>
>                 <mailto:address@concealed>; 
> address@concealed
>                 <mailto:address@concealed>; 
> address@concealed
>                 
> <mailto:address@concealed>;
>  address@concealed
>                 <mailto: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 <mailto: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 : m 
> <mailto:address@concealed>address@concealed <mailto: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 : m 
> <mailto:address@concealed>address@concealed <mailto: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 : m 
> <mailto:address@concealed>address@concealed <mailto: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 : m <mailto:address@concealed>address@concealed 
> <mailto: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
> 
> 
>  
> 
> -- 
> 
> Matthew Goebel : m <mailto:address@concealed>address@concealed 
> <mailto: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
> 
>  
> 
>  
> 


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

Attachment: signature.asc
Description: OpenPGP digital signature