The mailing list for listmasters using Sympa

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

On 9/28/20 3:50 PM, Matthew Goebel wrote:
> I can confirm that I am seeing the same errors ... no clue what is causing 
> these, but the log files does get huge if
> sympa not restarted very often.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN1605102> line 1.
> 
> Use of uninitialized value $value in printf at 
> /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN1605102> line 1.
> 
> 
> Matt
> 

Hello Matt,

the value in the database record is NULL, which corresponds to undef on the 
Perl side and causes that warning.

Regards
         Racke
> 
> 
> On Mon, Sep 28, 2020 at 9:35 AM TISSOT Jacques <address@concealed 
> <mailto:address@concealed>> 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?____
> 
>     __ __
> 
>     Jacques____
> 
>     __ __
> 
>     __ __
> 
>     *From:*Matthew Goebel <address@concealed <mailto:address@concealed>>
>     *Sent:* lundi, 28 septembre 2020 15:32
>     *To:* TISSOT Jacques <address@concealed 
> <mailto:address@concealed>>
>     *Cc:* address@concealed 
> <mailto: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____
> 
>     __ __
> 
>     __ __
> 
> 
> 
> -- 
> 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