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.

  I incremented net_read_timeout and net_write_timeout each to 600 :

> mysqladmin var
...
| net_buffer_length     | 16384  |
| net_read_timeout      | 600    |
| net_retry_count       | 10     |
...

  But  I  still have some signal 14 just 7 seconds after Mysql is run.
  As  timeouts  are set to 600, the first messages should appear after
  at least 600 seconds isn't it ? (is net timeouts are the pb).

010321 14:40:46  mysqld started
Innobase: Started
/usr/local/mysql/libexec/mysqld: ready for connections
010321 14:40:53  Warning: Got signal 14 from thread 8
010321 14:40:55  Warning: Got signal 14 from thread 5
010321 14:40:57  Warning: Got signal 14 from thread 4
010321 14:41:03  Warning: Got signal 14 from thread 8
010321 14:41:05  Warning: Got signal 14 from thread 5
010321 14:41:07  Warning: Got signal 14 from thread 8
010321 14:41:09  Warning: Got signal 14 from thread 4
010321 14:41:11  Warning: Got signal 14 from thread 5
010321 14:41:13  Warning: Got signal 14 from thread 4
010321 14:41:15  Warning: Got signal 14 from thread 5
010321 14:41:17  Warning: Got signal 14 from thread 4
010321 14:41:19  Warning: Got signal 14 from thread 4
010321 14:41:25  Warning: Got signal 14 from thread 5
010321 14:41:27  Warning: Got signal 14 from thread 8

  Alex.