List:General Discussion« Previous MessageNext Message »
From:BAUMEISTER Alexandre Date:March 21 2001 12:50pm
Subject:Re[6]: Warning: Got signal 14 from thread X
View as plain text  
Sinisa,

SM>  > SM>  > SM> Alex, you ran out of filedescriptors or out of anodes,
> depending on OS
SM>  > SM>  > SM> that you are using.
SM>  > SM>  > 
SM>  > SM>  >   I  though  filedescriptors  could  be the problem. I only had
> 256. I
SM>  > SM>  >   modified the system in order to have 1024 :
SM>  > SM>  > 
SM>  > SM>  >
> =========================================================================
SM>  > SM>  > [1:16pm]# ulimit -a
SM>  > SM>  > time(seconds)        unlimited
SM>  > SM>  > file(blocks)         unlimited
SM>  > SM>  > data(kbytes)         unlimited
SM>  > SM>  > stack(kbytes)        8192
SM>  > SM>  > coredump(blocks)     0
SM>  > SM>  > nofiles(descriptors) 1024
SM>  > SM>  > vmemory(kbytes)      unlimited
SM>  > SM>  >
> =========================================================================
SM>  > SM>  > 
SM>  > SM>  >   But still :
SM>  > SM>  >
> =========================================================================
SM>  > SM>  > 010321 13:22:42  Warning: Got signal 14 from thread 4
SM>  > SM>  > 010321 13:22:44  Warning: Got signal 14 from thread 8
SM>  > SM>  > 010321 13:22:46  Warning: Got signal 14 from thread 5
SM>  > SM>  > 010321 13:22:48  Warning: Got signal 14 from thread 8
SM>  > SM>  > 010321 13:22:50  Warning: Got signal 14 from thread 4
SM>  > SM>  > 010321 13:22:52  Warning: Got signal 14 from thread 4
SM>  > SM>  > 010321 13:22:54  Warning: Got signal 14 from thread 4
SM>  > SM>  > 010321 13:22:56  Warning: Got signal 14 from thread 4
SM>  > SM>  > 010321 13:22:58  Warning: Got signal 14 from thread 8
SM>  > SM>  > 010321 13:23:00  Warning: Got signal 14 from thread 8
SM>  > SM>  >
> =========================================================================
SM>  > SM>  > 
SM>  > SM>  >   How to know if filedescriptors or anode are the problem ?
SM>  > SM>  > 
SM>  > SM>  >   The extended stats below shows
SM>  > SM>  > 
SM>  > SM>  >         | Max_used_connections     | 17      |
SM>  > SM>  >         | Open_files               | 8       |
SM>  > SM>  >         | Open_tables              | 18      |
SM>  > SM>  > 
SM>  > SM>  >   I'm fare from 1024 filedescriptors.
SM>  > SM>  > 
SM>  > SM>  >
> =========================================================================
SM>  > SM>  >  [1:23pm]# mysqladmin ext
SM>  > SM>  > +--------------------------+---------+
SM>  > SM>  > | Variable_name            | Value   |
SM>  > SM>  > +--------------------------+---------+
SM>  > SM>  > | Aborted_clients          | 0       |
SM>  > SM>  > | Aborted_connects         | 0       |
SM>  > SM>  > | Bytes_received           | 1009183 |
SM>  > SM>  > | Bytes_sent               | 468860  |
SM>  > SM>  > | Connections              | 46      |
SM>  > SM>  > | Created_tmp_disk_tables  | 1       |
SM>  > SM>  > | Created_tmp_tables       | 1       |
SM>  > SM>  > | Created_tmp_files        | 0       |
SM>  > SM>  > | Delayed_insert_threads   | 0       |
SM>  > SM>  > | Delayed_writes           | 0       |
SM>  > SM>  > | Delayed_errors           | 0       |
SM>  > SM>  > | Flush_commands           | 1       |
SM>  > SM>  > | Handler_delete           | 0       |
SM>  > SM>  > | Handler_read_first       | 1       |
SM>  > SM>  > | Handler_read_key         | 18430   |
SM>  > SM>  > | Handler_read_next        | 3       |
SM>  > SM>  > | Handler_read_prev        | 0       |
SM>  > SM>  > | Handler_read_rnd         | 6       |
SM>  > SM>  > | Handler_read_rnd_next    | 48      |
SM>  > SM>  > | Handler_update           | 0       |
SM>  > SM>  > | Handler_write            | 70      |
SM>  > SM>  > | Key_blocks_used          | 3       |
SM>  > SM>  > | Key_read_requests        | 7       |
SM>  > SM>  > | Key_reads                | 3       |
SM>  > SM>  > | Key_write_requests       | 0       |
SM>  > SM>  > | Key_writes               | 0       |
SM>  > SM>  > | Max_used_connections     | 17      |
SM>  > SM>  > | Not_flushed_key_blocks   | 0       |
SM>  > SM>  > | Not_flushed_delayed_rows | 0       |
SM>  > SM>  > | Open_tables              | 18      |
SM>  > SM>  > | Open_files               | 8       |
SM>  > SM>  > | Open_streams             | 0       |
SM>  > SM>  > | Opened_tables            | 24      |
SM>  > SM>  > | Questions                | 9331    |
SM>  > SM>  > | Select_full_join         | 0       |
SM>  > SM>  > | Select_full_range_join   | 0       |
SM>  > SM>  > | Select_range             | 0       |
SM>  > SM>  > | Select_range_check       | 0       |
SM>  > SM>  > | Select_scan              | 1       |
SM>  > SM>  > | Slave_running            | OFF     |
SM>  > SM>  > | Slave_open_temp_tables   | 0       |
SM>  > SM>  > | Slow_launch_threads      | 0       |
SM>  > SM>  > | Slow_queries             | 0       |
SM>  > SM>  > | Sort_merge_passes        | 0       |
SM>  > SM>  > | Sort_range               | 0       |
SM>  > SM>  > | Sort_rows                | 6       |
SM>  > SM>  > | Sort_scan                | 2       |
SM>  > SM>  > | Table_locks_immediate    | 9308    |
SM>  > SM>  > | Table_locks_waited       | 0       |
SM>  > SM>  > | Threads_cached           | 0       |
SM>  > SM>  > | Threads_created          | 18      |
SM>  > SM>  > | Threads_connected        | 18      |
SM>  > SM>  > | Threads_running          | 1       |
SM>  > SM>  > | Uptime                   | 501     |
SM>  > SM>  > +--------------------------+---------+  
SM>  > SM>  > 
SM>  > SM>  > SM> It could also be caused by a bug in TCP/IP part of the
> kernel, but the
SM>  > SM>  > SM> above causes are much more likely.
SM>  > SM>  > 
SM>  > SM>  >   TCP/IP ? How to know if it could be the problem ?
SM>  > SM>  > 
SM>  > SM>  > SM> Check out both your global and ulimit values.
SM>  > SM>  > 
SM>  > SM>  >   I have copied "ulimit -a" exit in this email.
SM>  > SM>  > 
SM>  > SM>  > 
SM>  > SM>  >   Regards,
SM>  > SM>  >   Alex.
SM>  > SM>  > 
SM>  > SM>  > 
SM>  > SM>  > 
SM>  > 
SM>  > SM> What OS is that ??
SM>  > 
SM>  > 
SM>  >   From mysqlbug :
SM>  > 
SM>  > Server version          3.23.35
SM>  > Protocol version        10
SM>  > Connection              Localhost via UNIX socket
SM>  > UNIX socket             /tmp/mysql.sock
SM>  > Uptime:                 3 min 50 sec
SM>  > 
SM>  > Threads: 15  Questions: 15489  Slow queries: 0  Opens: 20  Flush tables: 1 
> Open tables: 14 Queries per second avg: 67.343
SM>  > >Environment:
SM>  >         <machine, os, target, libraries (multiple lines)>
SM>  > System: SunOS sun01381 5.8 Generic_108528-04 sun4u sparc SUNW,Ultra-80
SM>  > Architecture: sun4
SM>  > 
SM>  > Some paths:  /bin/perl /usr/ccs/bin/make /usr/local/bin/gmake
> /usr/local/bin/gcc /usr/ucb/cc
SM>  > GCC: Reading specs from
> /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs
SM>  > gcc version 2.95.2 19991024 (release)  
SM>  > 
SM>  > 
SM>  > 

SM> And all connections are on the localhost ??

  Yes,  for  now. But in the final application, there will be a lot of
  connections from network.


Thread
Configure problemsKevin Price-Ward13 Mar
  • Re: Configure problemsGerald L. Clark13 Mar
    • Re: Configure problemsKevin Price-Ward13 Mar
      • Warning: Got signal 14 from thread XBAUMEISTER Alexandre20 Mar
        • Re: Warning: Got signal 14 from thread XSinisa Milivojevic20 Mar
          • Re[2]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre20 Mar
            • Re: Re[2]: Warning: Got signal 14 from thread XSinisa Milivojevic21 Mar
Re: Warning: Got signal 14 from thread XHeikki Tuuri20 Mar
  • Re[2]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre20 Mar
Re: Warning: Got signal 14 from thread XHeikki Tuuri20 Mar
  • Re[2]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre20 Mar
    • SHOW STATUS / COUNT(*) Innobase table.BAUMEISTER Alexandre21 Mar
  • Re: Warning: Got signal 14 from thread XSinisa Milivojevic21 Mar
    • Re[2]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
      • Re: Re[2]: Warning: Got signal 14 from thread XSinisa Milivojevic21 Mar
        • Re[4]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
          • Re: Re[4]: Warning: Got signal 14 from thread XSinisa Milivojevic21 Mar
            • Re[6]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
              • Re: Re[6]: Warning: Got signal 14 from thread XSinisa Milivojevic21 Mar
                • Re[8]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
                  • Re: Re[8]: Warning: Got signal 14 from thread XSinisa Milivojevic21 Mar
                    • Re[10]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
                      • Re: Re[10]: Warning: Got signal 14 from thread XSinisa Milivojevic21 Mar
                        • Re[12]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
                          • Re: Re[12]: Warning: Got signal 14 from thread XSinisa Milivojevic21 Mar
                            • Re[14]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
                              • Re: Re[14]: Warning: Got signal 14 from thread XSinisa Milivojevic21 Mar
                                • Re[16]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
                                  • Re: Re[16]: Warning: Got signal 14 from thread XSinisa Milivojevic21 Mar
                                    • Re[18]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
                        • Re[12]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
                    • Re[10]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
                      • Re: Re[10]: Warning: Got signal 14 from thread XSinisa Milivojevic21 Mar
  • where do i get an authcode from ?anna soobrattee21 Mar
    • Re: where do i get an authcode from ?Brian McDonough21 Mar
  • Re: where do i get an authcode from ? - PLEASE GET ME UNSUBSCRIBED OFF THIS LIST....anna soobrattee26 Mar
Re: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
  • Re: Warning: Got signal 14 from thread XSinisa Milivojevic21 Mar
    • Re[2]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
      • Re: Re[2]: Warning: Got signal 14 from thread XSinisa Milivojevic21 Mar
        • Re[4]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
          • Re: Re[4]: Warning: Got signal 14 from thread XSinisa Milivojevic21 Mar
        • Re[4]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
Re:SHOW STATUS / COUNT(*) Innobase table.Heikki Tuuri21 Mar
Re[12]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
Re[12]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre21 Mar
  • Re[12]: Warning: Got signal 14 from thread XMichael Widenius23 Mar
    • Re[13]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre23 Mar
      • Re[13]: Warning: Got signal 14 from thread XMichael Widenius24 Mar
        • Re[14]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre24 Mar
Re[28]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre23 Mar
  • Re: Re[28]: Warning: Got signal 14 from thread XSinisa Milivojevic24 Mar
    • Re[30]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre24 Mar
    • Re[30]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre24 Mar
    • Re[30]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre24 Mar
  • Re[28]: Warning: Got signal 14 from thread XMichael Widenius24 Mar
Re[28]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre23 Mar
Re[31]: Warning: Got signal 14 from thread XHeikki Tuuri24 Mar
Re[31]: Warning: Got signal 14 from thread XHeikki Tuuri24 Mar
  • Re[31]: Warning: Got signal 14 from thread XMichael Widenius24 Mar
  • Re[32]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre26 Mar
    • Re: Re[32]: Warning: Got signal 14 from thread XSinisa Milivojevic26 Mar
      • Re[34]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre26 Mar
Re[32]: Warning: Got signal 14 from thread XHeikki Tuuri25 Mar
  • Re[32]: Warning: Got signal 14 from thread XMichael Widenius26 Mar
  • Re[33]: Warning: Got signal 14 from thread XBAUMEISTER Alexandre26 Mar