Andre,
innobase_log_arch_dir should be the same as innobase_log_group_home_dir.
Now there is an extra 'mysql' in the path. You probably do not
have that directory existing, and Innobase asserts a failure.
I am sorry, I will change the assert to an error message in the next release,
but have been too busy lately.
But you were able to compile on HP-UX?
Regards,
Heikki
..................
Hi,
I use the following my.cnf:
[mysqld]
innobase_data_home_dir = /opt/mysql/var/
innobase_data_file_path = ib_data1:10M
innobase_log_group_home_dir = /opt/mysql/var/
innobase_log_arch_dir = /opt/mysql/mysql/var/
set-variable = innobase_mirrored_log_groups=1
set-variable = innobase_log_files_in_group=3
set-variable = innobase_log_file_size=5M
set-variable = innobase_log_buffer_size=8M
innobase_flush_log_at_trx_commit=1
innobase_log_archive=0
set-variable = innobase_buffer_pool_size=16M
set-variable = innobase_additional_mem_pool_size=2M
set-variable = innobase_file_io_threads=4
set-variable = innobase_lock_wait_timeout=50
After first starting mysql with the start.server script innobase create the
necessary files in the /opt/mysql/var directory but than it ends up with a
memory fault..err:010405 16:45:39 mysqld started
Innobase: The first specified data file /opt/mysql/var/ib_data1 did not exist:
Innobase: a new database to be created!
Innobase: Log file /opt/mysql/var/ib_logfile0 did not exist: new to be created
Innobase: Log file /opt/mysql/var/ib_logfile1 did not exist: new to be created
010405 16:45:44 mysqld ended
Restarting mysql everytimes reproduces the memory fault.
After some experiments I found that the line
innobase_log_group_home_dir = /opt/mysql/var/causes the problem
If I start mysql (after removing all ib_files) with the following my.cnf
everthing works fine:[mysqld]innobase_data_home_dir = /opt/mysql/var/
innobase_data_file_path = ib_data1:10M
#innobase_log_group_home_dir = /opt/mysql/var/
#innobase_log_arch_dir = /opt/mysql/mysql/var/
#set-variable = innobase_mirrored_log_groups=1
#set-variable = innobase_log_files_in_group=3
#set-variable = innobase_log_file_size=5M
#set-variable = innobase_log_buffer_size=8M#innobase_flush_log_at_trx_commit=1
#innobase_log_archive=0#set-variable = innobase_buffer_pool_size=16M
#set-variable = innobase_additional_mem_pool_size=2M
#set-variable = innobase_file_io_threads=4
#set-variable = innobase_lock_wait_timeout=50
Now I again remove the ib_files and restarted mysqld with the following my.cnf
file and mysql crashes with a memory fault again.[mysqld]
innobase_data_home_dir = /opt/mysql/var/innobase_data_file_path = ib_data1:10M
innobase_log_group_home_dir = /opt/mysql/var/
The funny thing is, that if you initialize the innobase stuff with the '2 line'
my.cnf you can afterwards enable 'innobase_log_group_home_dir =
/opt/mysql/var/' and mysqld keeps on running.Any idea?Greetings from Germany
Andre
---------------------------------------------------------------------
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
