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

[BAUMEISTER Alexandre]

Sinisa,

SM>  > SM> Do you use thread cacheing ??
SM>  > 
SM>  > SM> Please turn it off temporarily and see if problem reccurs.
SM>  > 
SM>  >   Currently I have :
SM>  > 
SM>  > ============================================================================
SM>  >   my.cnf
SM>  > ============================================================================
SM>  > set-variable    = thread_cache=8
SM>  > set-variable    = thread_concurrency=8
SM>  > 
SM>  > ============================================================================
SM>  >   mysqladmin var
SM>  > ============================================================================
SM>  > | thread_cache_size     | 8      |
SM>  > | thread_concurrency    | 8      |
SM>  > | thread_stack          | 65536  |
SM>  > 
SM>  > ============================================================================
SM>  >   mysqladmin ext
SM>  > ============================================================================
SM>  > | Threads_cached        | 0      |
SM>  > | Threads_created       | 18     |
SM>  > | Threads_connected     | 18     |
SM>  > | Threads_running       | 1      |
SM>  > 
SM>  > 
SM>  >   If  I comment the set-variable lines about thread-cache in my.cnf, I
SM>  >   have that :
SM>  > 
SM>  > ============================================================================
SM>  >   mysqladmin var
SM>  > ============================================================================
SM>  > | thread_cache_size    | 0       | <- means no thread caching ?
SM>  > | thread_concurrency   | 10      |
SM>  > | thread_stack         | 65536   |
SM>  > 
SM>  > 
SM>  >   But still :
SM>  > 
SM>  > 010321 13:39:46  mysqld started
SM>  > Innobase: Started
SM>  > /usr/local/mysql/libexec/mysqld: ready for connections
SM>  > 010321 13:39:52  Warning: Got signal 14 from thread 5
SM>  > 010321 13:40:33  Warning: Got signal 14 from thread 5
SM>  > 010321 13:40:35  Warning: Got signal 14 from thread 4
SM>  > 010321 13:40:37  Warning: Got signal 14 from thread 5
SM>  > 010321 13:40:39  Warning: Got signal 14 from thread 8
SM>  > 010321 13:40:41  Warning: Got signal 14 from thread 8
SM>  > 010321 13:40:43  Warning: Got signal 14 from thread 5
SM>  > 010321 13:40:45  Warning: Got signal 14 from thread 8
SM>  > 010321 13:40:47  Warning: Got signal 14 from thread 5
SM>  > 010321 13:40:49  Warning: Got signal 14 from thread 4
SM>  > 010321 13:40:51  Warning: Got signal 14 from thread 8
SM>  > 
SM>  >   Regards,
SM>  >   Alex.
SM>  > 
SM>  > 
SM>  > 

SM> Hi!

SM> You have Solaris with 8 or 10 CPU's ??

  Solaris  with 4 CPU's. In the example conf file there is "Try number
  of CPU's*2". That's why I put 8.

  Alex.