Re[2]: Warning: Got signal 14 from thread X

[BAUMEISTER Alexandre]

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.