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.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php