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

SM>  >   These  are  daemon  programs ... not exiting. I've about 10 programs
SM>  >   initialising  a  connection  and then looping, doing some updates on
SM>  >   table while receiving data from another input.
SM>  > 
SM>  >   The schema is :
SM>  > 
SM>  >      1. Connecting to Mysql
SM>  >      2. reading data (from a file for example)
SM>  >      3. updating Mysql table
SM>  >      4. if any error, do a mysql_ping() in order to re-connect if
SM>  >         disconnected
SM>  >      5. loop to 2.
SM>  > 
SM>  > SM> Also, please try our 2.7 binary, just to rule out build problmes.
SM>  > 
SM>  >   I will try now.
SM>  > 
SM>  >   Alex.
SM>  > 
SM>  > 
SM>  > 

SM> Well, the above provides some more light !

SM> Increase wait timeout to some HUGE value. Same for net_read_timeout
SM> and net_write_timeout.

SM> Also, if signal 14 happens again check if the corresponding daemon is
SM> still running.

  I incremented net_read_timeout and net_write_timeout each to 600 :

> mysqladmin var
...
| net_buffer_length     | 16384  |
| net_read_timeout      | 600    |
| net_retry_count       | 10     |
...

  But  I  still have some signal 14 just 7 seconds after Mysql is run.
  As  timeouts  are set to 600, the first messages should appear after
  at least 600 seconds isn't it ? (is net timeouts are the pb).

010321 14:40:46  mysqld started
Innobase: Started
/usr/local/mysql/libexec/mysqld: ready for connections
010321 14:40:53  Warning: Got signal 14 from thread 8
010321 14:40:55  Warning: Got signal 14 from thread 5
010321 14:40:57  Warning: Got signal 14 from thread 4
010321 14:41:03  Warning: Got signal 14 from thread 8
010321 14:41:05  Warning: Got signal 14 from thread 5
010321 14:41:07  Warning: Got signal 14 from thread 8
010321 14:41:09  Warning: Got signal 14 from thread 4
010321 14:41:11  Warning: Got signal 14 from thread 5
010321 14:41:13  Warning: Got signal 14 from thread 4
010321 14:41:15  Warning: Got signal 14 from thread 5
010321 14:41:17  Warning: Got signal 14 from thread 4
010321 14:41:19  Warning: Got signal 14 from thread 4
010321 14:41:25  Warning: Got signal 14 from thread 5
010321 14:41:27  Warning: Got signal 14 from thread 8

  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