mysql could not start!

Problems with the Linux version of XAMPP, questions, comments, and anything related.

mysql could not start!

Postby hanpedro » 24. August 2009 05:38

My box is centos 5.3 x86 and installed xampp for linux 1.7.2.

After changing my.cnf, mysql could not start!

my.cnf I used at xampp 1.6.8 is here;

Code: Select all
# The following options will be passed to all MySQL clients
[client]
#password   = your_password
port      = 3306
socket      = /opt/lampp/var/mysql/mysql.sock

# The MySQL server
[mysqld]
port      = 3306
socket      = /opt/lampp/var/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

server-id   = 1

# Comment the following if you are using InnoDB tables
# skip-innodb
innodb_data_home_dir = /opt/lampp/var/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /opt/lampp/var/mysql/
innodb_log_arch_dir = /opt/lampp/var/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout


And error log is here;

Code: Select all
090824 13:02:19 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
090824 13:02:19 [Note] Plugin 'FEDERATED' is disabled.
090824 13:02:20  InnoDB: Started; log sequence number 0 44233
090824 13:02:20 [Note] PrimeBase XT (PBXT) Engine 1.0.08 RC loaded...
090824 13:02:20 [Note] Paul McCullagh, PrimeBase Technologies GmbH, http://www.primebase.org
090824 13:02:20 [ERROR] /opt/lampp/sbin/mysqld: unknown variable 'innodb_log_arch_dir=/opt/lampp/var/mysql/'
090824 13:02:20 [ERROR] Aborting

090824 13:02:20 [Note] PrimeBase XT Engine shutdown...
090824 13:02:20  InnoDB: Starting shutdown...
090824 13:02:21  InnoDB: Shutdown completed; log sequence number 0 44233
090824 13:02:21 [Warning] Forcing shutdown of 1 plugins
090824 13:02:21 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

090824 13:02:21 - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=151330288
read_buffer_size=262144
max_used_connections=0
max_threads=151
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 264707 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd: 0x944c378
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0xaefb836c thread_stack 0x30000
/opt/lampp/sbin/mysqld(my_print_stacktrace+0x22)[0x84b94c2]
/opt/lampp/sbin/mysqld(handle_segfault+0x39e)[0x81d937e]
[0x672420]
[0x18868c]
[0x1a7ad8]
/lib/libpthread.so.0[0x98c49b]
/lib/libc.so.6(clone+0x5e)[0x8e342e]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at (nil) is an invalid pointer
thd->thread_id=0
thd->killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
090824 13:02:21 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/localhost.localdomain.pid ended


Please let me know how I can fix this.
Many thanks in advance.
hanpedro
 
Posts: 134
Joined: 09. February 2005 06:03
Operating System: SCientific Linux 6.1 x86

Re: mysql could not start!

Postby Wiedmann » 24. August 2009 11:39

Code: Select all
090824 13:02:20 [ERROR] /opt/lampp/sbin/mysqld: unknown variable 'innodb_log_arch_dir=/opt/lampp/var/mysql/'
090824 13:02:20 [ERROR] Aborting

Remove "innodb_log_arch_dir" from your "my.cnf".
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 16 guests