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

[Sinisa Milivojevic]

BAUMEISTER Alexandre writes:
 > 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.
 > 
 > 
 > 

Ok, do not erase your binary, save it and try our binary for 2.7.

If you still get TCP errors, rebuilding MySQL will be the sole
solution.


Regards,

Sinisa

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