List:General Discussion« Previous MessageNext Message »
From:BAUMEISTER Alexandre Date:March 20 2001 3:08pm
Subject:Re[2]: Warning: Got signal 14 from thread X
View as plain text  
Bonjour Heikki,

HT> let us see. A known bug with Innobase is that <sys/stat> was not included
HT> in univ.i in directory mysql/innobase/include. Then Innobase files are
HT> created with arbitrary access permissions on some Unixes.

HT> Could you look with ls -l what permissions Innobase data file ibdat1 has
HT> on your machine and also the permissions in
HT> log files in /usr/local/mysql/var/innobase_logs/ ?

Mysql is run as root.

 Innobase file/directories in /usr/local/mysql/var/ :
drwxr-xr-x   2 root     other        512 Mar 16 16:07 innobase_data/
-rwxrwx--x   1 root     other      25088 Mar 16 16:08
innobase_log_group_home_dirib_arch_log_0000000000*
drwxr-xr-x   2 root     other        512 Mar 16 16:08 innobase_logs/

 Innobase data file :
>ls -l
total 1024532
drwxr-xr-x   2 root     other        512 Mar 16 16:07 ./
drwx------  10 root     other        512 Mar 20 10:48 ../
-rwxrwx--x   1 root     other    524288000 Mar 20 15:51 ibdata1*

 Innobase log files :
>ls -l
total 30772
drwxr-xr-x   2 root     other        512 Mar 16 16:08 ./
drwx------  10 root     other        512 Mar 20 10:48 ../
-rwxrwx--x   1 root     other    5242880 Mar 20 15:52 ib_logfile0*
-rwxrwx--x   1 root     other    5242880 Mar 20 15:51 ib_logfile1*
-rwxrwx--x   1 root     other    5242880 Mar 20 15:52 ib_logfile2* 


HT> In the config parameters below you should not define

HT> innobase_log_arch_dir = innobase_log_group_home_dir,

HT> but write the path:

HT> innobase_log_arch_dir = /usr/local/mysql/var/innobase_logs/

  Ooops. Yes sorry.

HT> Your archived log file has now been created in the default
HT> directory: if you can find ib_arch_log_0000000000 somewhere,
HT> you could also look at the file access permissions and mail the
HT> output of ls -l to me.

 Yes. I wondered what it was :). It's in  /usr/local/mysql/var/ :

 -rwxrwx--x   1 root     other      25088 Mar 16 16:08
innobase_log_group_home_dirib_arch_log_0000000000*

 This is the only file containing ib_arch_log_0000000000 that I found.

 I modified innobase_log_arch_dir with the correct value and restarted
 Mysql. But it did not create another ib_arch_log_0000000000 file. And
 the  file I have in /usr/local/mysql/var/ is dated of Mar 16, is this
 normal ?

HT> If you try to recreate an Innobase database, you should delete all
HT> Innobase data files, log files, the small archived log file,
HT> and all .frm files for Innobase tables.

  You  mean  that  now  that  I  modified  my.cnf  in order to correct
  innobase_log_arch_dir  I  have  to  recreate  everything in order to
  effectively correct everything ?

  For now, Mysql is running with my.cnf corrected but I still have the
  same lines in the log :

010320 15:57:20  mysqld started
Innobase: Started
/usr/local/mysql/libexec/mysqld: ready for connections
010320 15:57:31  Warning: Got signal 14 from thread 8
010320 15:57:33  Warning: Got signal 14 from thread 5
010320 15:57:35  Warning: Got signal 14 from thread 5
010320 15:57:42  Warning: Got signal 14 from thread 8
010320 15:57:44  Warning: Got signal 14 from thread 5
010320 15:57:53  Warning: Got signal 14 from thread 5
010320 15:57:55  Warning: Got signal 14 from thread 5
010320 15:57:57  Warning: Got signal 14 from thread 5
010320 15:57:59  Warning: Got signal 14 from thread 8
010320 15:58:01  Warning: Got signal 14 from thread 5
010320 15:58:03  Warning: Got signal 14 from thread 8
010320 15:58:05  Warning: Got signal 14 from thread 5
010320 15:58:07  Warning: Got signal 14 from thread 8
010320 15:58:09  Warning: Got signal 14 from thread 8
010320 15:58:11  Warning: Got signal 14 from thread 5
010320 15:58:13  Warning: Got signal 14 from thread 8
010320 15:58:15  Warning: Got signal 14 from thread 8
010320 15:58:17  Warning: Got signal 14 from thread 8
010320 15:58:19  Warning: Got signal 14 from thread 5
010320 15:58:21  Warning: Got signal 14 from thread 5
010320 15:58:23  Warning: Got signal 14 from thread 8  

HT> I will also try to build 3.23.35 on our Solaris machine and look
HT> what happens.

  Thanks for you help.

  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