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

[BAUMEISTER Alexandre]

Sinisa,

SM>  >   These  are  daemon  programs ... not exiting. I've about 10 programs
SM>  >   initialising  a  connection  and then looping, doing some updates on
SM>  >   table while receiving data from another input.
SM>  > 
SM>  >   The schema is :
SM>  > 
SM>  >      1. Connecting to Mysql
SM>  >      2. reading data (from a file for example)
SM>  >      3. updating Mysql table
SM>  >      4. if any error, do a mysql_ping() in order to re-connect if
SM>  >         disconnected
SM>  >      5. loop to 2.
SM>  > 
SM>  > SM> Also, please try our 2.7 binary, just to rule out build problmes.
SM>  > 
SM>  >   I will try now.
SM>  > 
SM>  >   Alex.
SM>  > 
SM>  > 
SM>  > 

SM> Well, the above provides some more light !

SM> Increase wait timeout to some HUGE value. Same for net_read_timeout
SM> and net_write_timeout.

SM> Also, if signal 14 happens again check if the corresponding daemon is
SM> still running.

  If  I  had a thread on my daemons which executes a mysql_ping() each
  30 secondes and increase net_read_timeout to 60 will it be ok ? Does
  a mysql_ping() reset net_read and net_write timer ?

  Alex.