Re: Warning: Got signal 14 from thread X

[Sinisa Milivojevic]

BAUMEISTER Alexandre writes:
 > Bonjour,
 > 
 >   Here is my setup :
 > 
 > Mysql-3.23.35 complied from sources with :
 >   ./configure  --prefix=/usr/local/mysql --without-bench --enable-thread-safe-client
--with-innobase
 >
====================================================================================================
 > System: SunOS sun01381 5.8 Generic_108528-04 sun4u sparc SUNW,Ultra-80
 > Architecture: sun4
 > Some paths:  /bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc
/usr/ucb/cc
 > GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs
 > gcc version 2.95.2 19991024 (release)  
 >
====================================================================================================
 >   /etc/my.cnf
 > [mysqld]
 > port            = 3306
 > socket          = /tmp/mysql.sock
 > skip-locking
 > skip-name-resolve
 > set-variable    = key_buffer=128M
 > set-variable    = max_allowed_packet=1M
 > set-variable    = table_cache=256
 > set-variable    = sort_buffer=5M
 > set-variable    = record_buffer=1M
 > set-variable    = myisam_sort_buffer_size=64M
 > set-variable    = thread_cache=8
 > set-variable    = thread_concurrency=8  # Try number of CPU's*2
 > myisam-recover  = BACKUP,FORCE
 > 
 > # Innobase
 > innobase_data_home_dir = /usr/local/mysql/var/innobase_data/
 > innobase_data_file_path = ibdata1:500M
 > set-variable = innobase_mirrored_log_groups=1
 > innobase_log_group_home_dir = /usr/local/mysql/var/innobase_logs/
 > set-variable = innobase_log_files_in_group=3
 > set-variable = innobase_log_file_size=5M
 > set-variable = innobase_log_buffer_size=8M
 > innobase_flush_log_at_trx_commit=0
 > innobase_log_arch_dir = innobase_log_group_home_dir
 > innobase_log_archive=0
 > set-variable = innobase_buffer_pool_size=64M
 > set-variable = innobase_additional_mem_pool_size=2M
 > set-variable = innobase_file_io_threads=4
 > set-variable = innobase_lock_wait_timeout=50
 >
====================================================================================================
 > 
 >   Here is my problem :
 > 
 >     With  even  no  queries  on  the  server,  I  continually have the
 >     "Warning: Got signal 14 from thread X" in the log of Mysqld :
 > 
 > 010320 10:48:46  mysqld started
 > Innobase: Started
 > /usr/local/mysql/libexec/mysqld: ready for connections
 > 010320 10:49:32  Warning: Got signal 14 from thread 4
 > 010320 10:49:34  Warning: Got signal 14 from thread 3
 > 010320 10:49:36  Warning: Got signal 14 from thread 5
 > 010320 10:49:38  Warning: Got signal 14 from thread 4
 > 010320 10:49:40  Warning: Got signal 14 from thread 4
 > 010320 10:49:42  Warning: Got signal 14 from thread 6
 > 010320 10:49:44  Warning: Got signal 14 from thread 5
 > 010320 10:49:46  Warning: Got signal 14 from thread 4
 > 010320 10:49:48  Warning: Got signal 14 from thread 3
 > 010320 10:49:50  Warning: Got signal 14 from thread 5
 > 010320 10:49:52  Warning: Got signal 14 from thread 4
 > ...
 > 
 >     I  did  not have that with 3.23.32 ... but I did not have Innobase
 >     with 3.23.32 ...
 > 
 >     Is it a known bug ?
 > 
 >     Regards,
 >     Alex.


Hi!

The above could indicate some timeout problem.

Can you build mysql --with-debug and start it with --debug and see in
the trace file when are the above timeouts reported ??

Also, do you have clients that do not call mysql_close at the end ,
like PHP programs ?

Regards,

Sinisa

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