MySQL Forums
Forum List  »  NDB clusters

Unable to create event in database.
Posted by: Andi Constantin
Date: August 21, 2013 06:01AM

Hi,

I try to start a cluster with two nodes.

config.ini:

[ndb_mgmd]
hostname=192.168.9.199
datadir= /home/mysql_cluster/ndb_data

[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=18M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.

[TCP DEFAULT]
portnumber=2202 # This the default; however, you can use any
# port that is free for all the hosts in cluster
# Note: It is recommended beginning with MySQL 5.0 that
# you do not specify the portnumber at all and simply allow
# the default value to be used instead

[ndbd]
hostname=192.168.9.194
datadir=/home/mysql_cluster/mysql_data
NodeId=3

[ndbd]
hostname=192.168.9.193
datadir=/home/mysql_cluster/mysql_data
NodeId=2

[mysqld]

[mysqld]


Node 1 my.cfg:

[mysqld]
ndbcluster
datadir=/home/mysql_cluster/mysql_data
port=3306
bind-address=192.168.9.193
ndb-connectstring=192.168.9.199
#server-id=6
#ndb-nodeid=2
socket=/var/run/mysqld/mysqld.sock


[mysql_cluster]
ndb-connectstring=192.168.9.199


Node 2 my.cfg:
[mysqld]
ndbcluster
datadir=/home/mysql_cluster/mysql_data
port=3306
#bind-address=192.168.9.194
#bind-address=127.0.0.1
bind-address=0.0.0.0
ndb-connectstring=192.168.9.199
#server-id=5
#ndb-nodeid=3
socket=/var/run/mysqld/mysqld.sock


[mysql_cluster]
ndb-connectstring=192.168.9.199

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.9.193 (mysql-5.6.11 ndb-7.3.2, Nodegroup: 0, Master)
id=3 @192.168.9.194 (mysql-5.6.11 ndb-7.3.2, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.9.199 (mysql-5.6.11 ndb-7.3.2)

[mysqld(API)] 2 node(s)
id=4 @192.168.9.194 (mysql-5.6.11 ndb-7.3.2)
id=5 @192.168.9.193 (mysql-5.6.11 ndb-7.3.2)

ndb_mgm>

So everything is connected but both nodes mysqld log says:
2013-08-21 14:50:52 13295 [Note] Server hostname (bind-address): '192.168.9.193'; port: 3306
2013-08-21 14:50:52 13295 [Note] - '192.168.9.193' resolves to '192.168.9.193';
2013-08-21 14:50:52 13295 [Note] Server socket created on IP: '192.168.9.193'.
2013-08-21 14:50:52 13295 [Note] Event Scheduler: Loaded 0 events
2013-08-21 14:50:52 13295 [Note] /opt/mysql/server-5.6/bin/mysqld: ready for connections.
Version: '5.6.11-ndb-7.3.2-cluster-gpl' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Cluster Community Server (GPL)
2013-08-21 14:50:52 13295 [ERROR] NDB Binlog: Unable to create event in database. Event: REPL$mysql/ndb_schema Error Code: 1 Message: Unknown error code
2013-08-21 14:50:52 13295 [ERROR] NDB Binlog: FAILED CREATE (DISCOVER) TABLE Event: REPL$mysql/ndb_schema
2013-08-21 14:50:52 13295 [Note] NDB: Creating mysql.ndb_schema
2013-08-21 14:50:52 13295 [Note] NDB: Flushing mysql.ndb_schema
2013-08-21 14:50:52 13295 [ERROR] NDB Binlog: Unable to create event in database. Event: REPL$mysql/ndb_schema Error Code: 1 Message: Unknown error code
2013-08-21 14:50:52 13295 [ERROR] NDB Binlog: FAILED CREATE (DISCOVER) TABLE Event: REPL$mysql/ndb_schema
2013-08-21 14:50:52 13295 [ERROR] NDB Binlog: Unable to create event in database. Event: REPL$mysql/ndb_schema Error Code: 1 Message: Unknown error code
2013-08-21 14:50:52 13295 [ERROR] NDB Binlog: FAILED CREATE (DISCOVER) TABLE Event: REPL$mysql/ndb_schema
2013-08-21 14:50:52 13295 [ERROR] NDB: Query 'CREATE TABLE IF NOT EXISTS mysql.ndb_schema ( db VARBINARY(63) NOT NULL,name VARBINARY(63) NOT NULL,slock BINARY(32) NOT NULL,query BLOB NOT NULL,node_id INT UNSIGNED NOT NULL,epoch BIGINT UNSIGNED NOT NULL,id INT UNSIGNED NOT NULL,version INT UNSIGNED NOT NULL,type INT UNSIGNED NOT NULL,PRIMARY KEY USING HASH (db,name) ) ENGINE=NDB CHARACTER SET latin1' failed, error: 1296: Got error 1 'Unknown error code' from NDBCLUSTER
2013-08-21 14:50:52 13295 [Warning] create index stats events failed: error 1 line 2430
2013-08-21 14:50:53 13295 [ERROR] NDB Binlog: Unable to create event in database. Event: REPL$mysql/ndb_schema Error Code: 1 Message: Unknown error code
2013-08-21 14:50:53 13295 [ERROR] NDB Binlog: FAILED CREATE (DISCOVER) TABLE Event: REPL$mysql/ndb_schema
2013-08-21 14:50:53 13295 [Note] NDB: Creating mysql.ndb_schema
2013-08-21 14:50:53 13295 [Note] NDB: Flushing mysql.ndb_schema
2013-08-21 14:50:53 13295 [ERROR] NDB Binlog: Unable to create event in database. Event: REPL$mysql/ndb_schema Error Code: 1 Message: Unknown error code
2013-08-21 14:50:53 13295 [ERROR] NDB Binlog: FAILED CREATE (DISCOVER) TABLE Event: REPL$mysql/ndb_schema
2013-08-21 14:50:53 13295 [ERROR] NDB Binlog: Unable to create event in database. Event: REPL$mysql/ndb_schema Error Code: 1 Message: Unknown error code
2013-08-21 14:50:53 13295 [ERROR] NDB Binlog: FAILED CREATE (DISCOVER) TABLE Event: REPL$mysql/ndb_schema
2013-08-21 14:50:53 13295 [ERROR] NDB: Query 'CREATE TABLE IF NOT EXISTS mysql.ndb_schema ( db VARBINARY(63) NOT NULL,name VARBINARY(63) NOT NULL,slock BINARY(32) NOT NULL,query BLOB NOT NULL,node_id INT UNSIGNED NOT NULL,epoch BIGINT UNSIGNED NOT NULL,id INT UNSIGNED NOT NULL,version INT UNSIGNED NOT NULL,type INT UNSIGNED NOT NULL,PRIMARY KEY USING HASH (db,name) ) ENGINE=NDB CHARACTER SET latin1' failed, error: 1296: Got error 1 'Unknown error code' from NDBCLUSTER
2013-08-21 14:50:53 13295 [Warning] create index stats events failed: error 1 line 2430

Also when i try:
mysql> use test;
Database changed
mysql> CREATE TABLE tblCustomer (ID INT) ENGINE=NDBCLUSTER;
ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTER
mysql>

What do i do wrong ?

Thanks,
Andi.

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to create event in database.
3418
August 21, 2013 06:01AM


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.