Re: Re[32]: Warning: Got signal 14 from thread X

[Sinisa Milivojevic]

BAUMEISTER Alexandre writes:
 > Heikki,
 >   If  I  run  Mysql  without having any client connected nor doing any
 >   "mysqladmin xxx" command, the is no Warning messages. Only :
 > 
 > 010326 11:43:29  mysqld started
 > Innobase: Started
 > /usr/local/mysql/libexec/mysqld: ready for connections
 > 
 >   If I do "mysqladmin ping" , "mysqladmin status" ... no problems.
 > 
 >   As soon as I run my daemons :
 > 
 > 010326 11:47:28  Warning: Got signal 14 from thread 4
 > 010326 11:47:30  Warning: Got signal 14 from thread 4
 > 010326 11:47:32  Warning: Got signal 14 from thread 4
 > 010326 11:47:34  Warning: Got signal 14 from thread 4
 > 
 >   another  thing  really  interesting  is  that  if  I  do  a  lot  of
 >   "mysqladmin proc", then the Warning messages are paused.
 > 
 >   I  explain.  I'm doing a "tail -f myserver.err" on a console. Then I
 >   see that about each 2 seconds I got a "Warning ... message".
 > 
 >   On  another console I do "mysqladmin proc" and as soons as I get the
 >   result I do another "mysqladmin proc" and so on ...
 > 
 >   Then I noticed that while I'm doing "mysqladmin proc", the "Warning"
 >   messages are no more send to error log.
 > 
 >   A soon as I stop doing "mysqladmin proc", the "Warning" messages are
 >   coming back :(
 > 
 >   This  seems  very  incomprehensible  to  me, but I though maybe this
 >   could be a clue for you.
 > 
 >   NB:  I did the test with "mysqladmin ping" , "mysqladmin status" and
 >   it's the same than with "mysqladmin proc".
 > 
 >   Regards,
 >   Alex.
 > 
 > 
 > 

Hi!

Seems like Innobase has introduced some timeout ( I do not see how) on
the sleeping connections.


Regards,

Sinisa

      ____  __     _____   _____  ___     ==  MySQL AB
     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic
    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaca, Cyprus
  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____
  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
             /*/             \*\                Developers Team