Re: Warning: Got signal 14 from thread X

[BAUMEISTER Alexandre]

Sinisa,

SM> Do you use thread cacheing ??

SM> Please turn it off temporarily and see if problem reccurs.

  Currently I have :

============================================================================
  my.cnf
============================================================================
set-variable    = thread_cache=8
set-variable    = thread_concurrency=8

============================================================================
  mysqladmin var
============================================================================
| thread_cache_size     | 8      |
| thread_concurrency    | 8      |
| thread_stack          | 65536  |

============================================================================
  mysqladmin ext
============================================================================
| Threads_cached        | 0      |
| Threads_created       | 18     |
| Threads_connected     | 18     |
| Threads_running       | 1      |


  If  I comment the set-variable lines about thread-cache in my.cnf, I
  have that :

============================================================================
  mysqladmin var
============================================================================
| thread_cache_size    | 0       | <- means no thread caching ?
| thread_concurrency   | 10      |
| thread_stack         | 65536   |


  But still :

010321 13:39:46  mysqld started
Innobase: Started
/usr/local/mysql/libexec/mysqld: ready for connections
010321 13:39:52  Warning: Got signal 14 from thread 5
010321 13:40:33  Warning: Got signal 14 from thread 5
010321 13:40:35  Warning: Got signal 14 from thread 4
010321 13:40:37  Warning: Got signal 14 from thread 5
010321 13:40:39  Warning: Got signal 14 from thread 8
010321 13:40:41  Warning: Got signal 14 from thread 8
010321 13:40:43  Warning: Got signal 14 from thread 5
010321 13:40:45  Warning: Got signal 14 from thread 8
010321 13:40:47  Warning: Got signal 14 from thread 5
010321 13:40:49  Warning: Got signal 14 from thread 4
010321 13:40:51  Warning: Got signal 14 from thread 8

  Regards,
  Alex.