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

SM> Alex, you ran out of filedescriptors or out of anodes, depending on OS
SM> that you are using.

  I  though  filedescriptors  could  be the problem. I only had 256. I
  modified the system in order to have 1024 :

=========================================================================
[1:16pm]# ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        8192
coredump(blocks)     0
nofiles(descriptors) 1024
vmemory(kbytes)      unlimited
=========================================================================

  But still :
=========================================================================
010321 13:22:42  Warning: Got signal 14 from thread 4
010321 13:22:44  Warning: Got signal 14 from thread 8
010321 13:22:46  Warning: Got signal 14 from thread 5
010321 13:22:48  Warning: Got signal 14 from thread 8
010321 13:22:50  Warning: Got signal 14 from thread 4
010321 13:22:52  Warning: Got signal 14 from thread 4
010321 13:22:54  Warning: Got signal 14 from thread 4
010321 13:22:56  Warning: Got signal 14 from thread 4
010321 13:22:58  Warning: Got signal 14 from thread 8
010321 13:23:00  Warning: Got signal 14 from thread 8
=========================================================================

  How to know if filedescriptors or anode are the problem ?

  The extended stats below shows

        | Max_used_connections     | 17      |
        | Open_files               | 8       |
        | Open_tables              | 18      |

  I'm fare from 1024 filedescriptors.

=========================================================================
 [1:23pm]# mysqladmin ext
+--------------------------+---------+
| Variable_name            | Value   |
+--------------------------+---------+
| Aborted_clients          | 0       |
| Aborted_connects         | 0       |
| Bytes_received           | 1009183 |
| Bytes_sent               | 468860  |
| Connections              | 46      |
| Created_tmp_disk_tables  | 1       |
| Created_tmp_tables       | 1       |
| Created_tmp_files        | 0       |
| Delayed_insert_threads   | 0       |
| Delayed_writes           | 0       |
| Delayed_errors           | 0       |
| Flush_commands           | 1       |
| Handler_delete           | 0       |
| Handler_read_first       | 1       |
| Handler_read_key         | 18430   |
| Handler_read_next        | 3       |
| Handler_read_prev        | 0       |
| Handler_read_rnd         | 6       |
| Handler_read_rnd_next    | 48      |
| Handler_update           | 0       |
| Handler_write            | 70      |
| Key_blocks_used          | 3       |
| Key_read_requests        | 7       |
| Key_reads                | 3       |
| Key_write_requests       | 0       |
| Key_writes               | 0       |
| Max_used_connections     | 17      |
| Not_flushed_key_blocks   | 0       |
| Not_flushed_delayed_rows | 0       |
| Open_tables              | 18      |
| Open_files               | 8       |
| Open_streams             | 0       |
| Opened_tables            | 24      |
| Questions                | 9331    |
| Select_full_join         | 0       |
| Select_full_range_join   | 0       |
| Select_range             | 0       |
| Select_range_check       | 0       |
| Select_scan              | 1       |
| Slave_running            | OFF     |
| Slave_open_temp_tables   | 0       |
| Slow_launch_threads      | 0       |
| Slow_queries             | 0       |
| Sort_merge_passes        | 0       |
| Sort_range               | 0       |
| Sort_rows                | 6       |
| Sort_scan                | 2       |
| Table_locks_immediate    | 9308    |
| Table_locks_waited       | 0       |
| Threads_cached           | 0       |
| Threads_created          | 18      |
| Threads_connected        | 18      |
| Threads_running          | 1       |
| Uptime                   | 501     |
+--------------------------+---------+  

SM> It could also be caused by a bug in TCP/IP part of the kernel, but the
SM> above causes are much more likely.

  TCP/IP ? How to know if it could be the problem ?

SM> Check out both your global and ulimit values.

  I have copied "ulimit -a" exit in this email.


  Regards,
  Alex.


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