MySQL Forums
Forum List  »  NDB clusters

Re: Segmentation fault
Posted by: silouane
Date: June 28, 2006 05:07AM

the mysql user is mysqlcluster


192.168.39.216.err :
**********
010819 01:06:59 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
010819 1:06:59 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
010819 1:07:00 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
010819 1:07:01 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
010819 1:07:03 InnoDB: Started; log sequence number 0 0
010819 1:07:03 [Note] /home/mysqlcluster/mysql-max-5.0.22-linux-i686/bin/mysqld: ready for connections.
Version: '5.0.22-max-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Experimental (GPL)
010819 1:08:06 [Note] /home/mysqlcluster/mysql-max-5.0.22-linux-i686/bin/mysqld: Normal shutdown

010819 1:08:06 InnoDB: Starting shutdown...
010819 1:08:09 InnoDB: Shutdown completed; log sequence number 0 43655
010819 1:08:10 [Note] /home/mysqlcluster/mysql-max-5.0.22-linux-i686/bin/mysqld: Shutdown complete

010819 01:08:10 mysqld ended

010819 01:08:59 mysqld started
010819 1:08:59 InnoDB: Started; log sequence number 0 43655
010819 01:08:59 mysqld ended

010819 01:56:12 mysqld started
010819 1:56:12 InnoDB: Started; log sequence number 0 43655
010819 01:56:12 mysqld ended

my.cnf :
********
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /usr/local/mysql/data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
user=root

# Here follows entries for some specific programs


# Options for ndbd process:
[MYSQL_CLUSTER]
ndb-connectstring=192.168.39.211 # location of MGM node

# The MySQL server
[mysqld]
ndbcluster # run NDB engine
ndb-connectstring=192.168.39.211

user=mysqlcluster
port = 3306
socket = /tmp/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

# binary logging is required for replication
log-bin=mysql-bin

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash


[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

config.ini :
************

[NDBD DEFAULT]
NoOfReplicas= 2
DataDir= /home/mysqlcluster/mysql5/mysql-cluster

[NDB_MGMD]
Hostname= 192.168.39.211
DataDir= /home/mysqlcluster/mysql5/mysql-cluster

[NDBD]
Id=2
HostName= 192.168.39.216

[NDBD]
Id=3
HostName= 192.168.39.217

[NDBD]
HostName= 192.168.39.211
[NDBD]
HostName= 192.168.39.184

[MYSQLD]
Id=5
HostName= 192.168.39.211

[MYSQLD]
Id=6


mysqld crash on 192.168.39.216 (node Id 6)
there isn't acktrace on .err file

I hope this information can be useful

Options: ReplyQuote


Subject
Views
Written By
Posted
1669
June 28, 2006 01:44AM
1044
June 28, 2006 04:25AM
Re: Segmentation fault
1361
June 28, 2006 05:07AM
1046
June 30, 2006 08:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.