List:General Discussion« Previous MessageNext Message »
From:BAUMEISTER Alexandre Date:March 26 2001 9:34am
Subject:Re[33]: Warning: Got signal 14 from thread X
View as plain text  
Heikki and Monty,

HT> maybe Monty discovered the source of the problem: Innobase indeed
HT> modifies the sigmask of the thread which does the database intialization.
HT> Maybe other threads then inherit the modified sigmask.

HT> I had disabled the use of native Unix aio from Innobase, but forgot
HT> the following segment of code into /innobase/os/os0file.c,
HT> about line 920 in function os_aio_init:
HT> .................................
HT>         }

HT> #ifdef POSIX_ASYNC_IO
HT>         /* Block aio signals from the current thread and its children:
HT>         for this to work, the current thread must be the first created
HT>         in the database, so that all its children will inherit its
HT>         signal mask */

HT>         sigemptyset(&sigset);
HT>         sigaddset(&sigset, SIGRTMIN + 1 + 0);
HT>         sigaddset(&sigset, SIGRTMIN + 1 + 1);
HT>         sigaddset(&sigset, SIGRTMIN + 1 + 2);
HT>         sigaddset(&sigset, SIGRTMIN + 1 + 3);

HT>         pthread_sigmask(SIG_BLOCK, &sigset, NULL);
HT> #endif
HT> }
HT> .................................

HT> Alex, try commenting out those lines, and check if the signal 14 error
HT> still occurs.


  Sorry, I commented out these lines but :

010326 11:30:24  mysqld started
Innobase: The first specified data file /usr/local/mysql/var/innobase_data/ibdata1 did not
exist:
Innobase: a new database to be created!
Innobase: Log file /usr/local/mysql/var/innobase_logs/ib_logfile0 did not exist: new to be
created
Innobase: Log file /usr/local/mysql/var/innobase_logs/ib_logfile1 did not exist: new to be
created
Innobase: Log file /usr/local/mysql/var/innobase_logs/ib_logfile2 did not exist: new to be
created
Innobase: Log file /usr/local/mysql/var/innobase_logs/ib_logfile3 did not exist: new to be
created
Innobase: Log file /usr/local/mysql/var/innobase_logs/ib_logfile4 did not exist: new to be
created
Innobase: Started
Innobase: Setting file /usr/local/mysql/var/innobase_data/ibdata1 size to 524288000
Innobase: Database physically writes the file full: wait...
Innobase: Setting log file /usr/local/mysql/var/innobase_logs/ib_logfile0 size to 31457280
Innobase: Setting log file /usr/local/mysql/var/innobase_logs/ib_logfile1 size to 31457280
Innobase: Setting log file /usr/local/mysql/var/innobase_logs/ib_logfile2 size to 31457280
Innobase: Setting log file /usr/local/mysql/var/innobase_logs/ib_logfile3 size to 31457280
Innobase: Setting log file /usr/local/mysql/var/innobase_logs/ib_logfile4 size to 31457280
/usr/local/mysql/libexec/mysqld: ready for connections
010326 11:32:16  Warning: Got signal 14 from thread 4
010326 11:32:18  Warning: Got signal 14 from thread 4
010326 11:32:24  Warning: Got signal 14 from thread 4
010326 11:32:26  Warning: Got signal 14 from thread 4
010326 11:32:28  Warning: Got signal 14 from thread 4
010326 11:32:30  Warning: Got signal 14 from thread 4
010326 11:32:32  Warning: Got signal 14 from thread 4
010326 11:32:34  Warning: Got signal 14 from thread 4
010326 11:32:36  Warning: Got signal 14 from thread 4

  Maybe  you  found a possible cause of problem, but there seems to be
  another.

  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