MySQL Forums
Forum List  »  NDB clusters

SQL node not run.
Posted by: David Garcia
Date: October 19, 2006 01:45PM

Hello, I install cluster mysql and configure with:

http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-quick.html

But I not work SQL NODE(mysqld(API)).
I disable iptables firewall, I update mysql 4.1 at 5.0 and 5.1.11, simple cluster not work please help me¡¡¡¡ Thanks

LOG and info:
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 1 node(s)
id=2 @127.0.0.1 (Version: 5.0.26, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @127.0.0.1 (Version: 5.0.26)

[mysqld(API)] 3 node(s)
id=3 (not connected, accepting connect from any host)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
-------------------------------------------------------------
mysql> USE test;
Database changed
mysql> REATE TABLE ctest (i INT) ENGINE=NDBCLUSTER;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REATE TABLE ctest (i INT) ENGINE=NDBCLUSTER' at line 1
mysql> CREATE TABLE ctest (i INT) ENGINE=NDBCLUSTER;
ERROR 1050 (42S01): Table 'ctest' already exists
-------------------------------------------------------------
log in: ndb_1_cluster.log
2006-10-19 21:26:58 [MgmSrvr] INFO -- NDB Cluster Management Server. Version 5.0.26
2006-10-19 21:26:58 [MgmSrvr] INFO -- Id: 1, Command port: 1186
2006-10-19 21:27:00 [MgmSrvr] INFO -- Mgmt server state: nodeid 3 reserved for ip 127.0.0.1, m_reserved_nodes 000000000000000a.
2006-10-19 21:27:00 [MgmSrvr] INFO -- Node 3: mysqld --server-id=0
2006-10-19 21:27:05 [MgmSrvr] INFO -- Mgmt server state: nodeid 2 reserved for ip 127.0.0.1, m_reserved_nodes 000000000000000e.
2006-10-19 21:27:06 [MgmSrvr] INFO -- Node 1: Node 2 Connected
2006-10-19 21:27:06 [MgmSrvr] INFO -- Node 2: Start phase 0 completed
2006-10-19 21:27:06 [MgmSrvr] INFO -- Node 2: Initial start with nodes 0000000000000004 [ missing: 0000000000000000 no-wait: 00000000000$
2006-10-19 21:27:06 [MgmSrvr] INFO -- Node 2: CM_REGCONF president = 2, own Node = 2, our dynamic id = 1
2006-10-19 21:27:06 [MgmSrvr] INFO -- Node 2: Start phase 1 completed
2006-10-19 21:27:06 [MgmSrvr] INFO -- Node 2: Start phase 2 completed (initial start)
2006-10-19 21:27:06 [MgmSrvr] INFO -- Node 2: Start phase 3 completed (initial start)
2006-10-19 21:27:06 [MgmSrvr] INFO -- Mgmt server state: nodeid 2 freed, m_reserved_nodes 000000000000000a.
2006-10-19 21:27:14 [MgmSrvr] INFO -- Node 2: Start phase 4 completed (initial start)
2006-10-19 21:27:15 [MgmSrvr] INFO -- Node 2: Local checkpoint 1 started. Keep GCI = 1 oldest restorable GCI = 1
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Start phase 5 completed (initial start)
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Start phase 6 completed (initial start)
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: President restarts arbitration thread [state=1]
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Start phase 7 completed (initial start)
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Communication to Node 3 opened
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Communication to Node 4 opened
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Communication to Node 5 opened
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Communication to Node 0 opened
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Start phase 8 completed (initial start)
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Start phase 9 completed (initial start)
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Started (version 5.0.26)
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Node 3 Connected
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Node 3: API version 5.1.11
2006-10-19 21:27:17 [MgmSrvr] INFO -- Node 2: Node 1: API version 5.0.26
2006-10-19 21:27:17 [MgmSrvr] INFO -- Node 2: Started arbitrator node 1 [ticket=2c8d0001620aab04]
2006-10-19 21:27:20 [MgmSrvr] WARNING -- Node 2: Node 3 missed heartbeat 2
2006-10-19 21:27:22 [MgmSrvr] WARNING -- Node 2: Node 3 missed heartbeat 3
2006-10-19 21:27:23 [MgmSrvr] WARNING -- Node 2: Node 3 missed heartbeat 4
2006-10-19 21:27:23 [MgmSrvr] ALERT -- Node 2: Node 3 declared dead due to missed heartbeat
2006-10-19 21:27:23 [MgmSrvr] INFO -- Node 2: Communication to Node 3 closed
2006-10-19 21:27:23 [MgmSrvr] ALERT -- Node 2: Node 3 Disconnected
2006-10-19 21:27:27 [MgmSrvr] INFO -- Node 2: Communication to Node 3 opened
2006-10-19 21:27:27 [MgmSrvr] INFO -- Node 2: Node 3 Connected
2006-10-19 21:27:27 [MgmSrvr] INFO -- Node 2: Node 3: API version 5.1.11
2006-10-19 21:27:31 [MgmSrvr] WARNING -- Node 2: Node 3 missed heartbeat 2
2006-10-19 21:27:32 [MgmSrvr] WARNING -- Node 2: Node 3 missed heartbeat 3
2006-10-19 21:27:34 [MgmSrvr] WARNING -- Node 2: Node 3 missed heartbeat 4
2006-10-19 21:27:34 [MgmSrvr] ALERT -- Node 2: Node 3 declared dead due to missed heartbeat
2006-10-19 21:27:34 [MgmSrvr] INFO -- Node 2: Communication to Node 3 closed
2006-10-19 21:27:34 [MgmSrvr] ALERT -- Node 2: Node 3 Disconnected
--------------------------------------------------------------------------------
Actual mysql rpm install:
MySQL-client-5.1.11-0.glibc23.i386.rpm MySQL-ndb-storage-5.1.11-0.glibc23.i386.rpm
MySQL-devel-5.1.11-0.glibc23.i386.rpm MySQL-ndb-tools-5.1.11-0.glibc23.i386.rpm
MySQL-ndb-extra-5.1.11-0.glibc23.i386.rpm MySQL-server-5.1.11-0.glibc23.i386.rpm
MySQL-ndb-management-5.1.11-0.glibc23.i386.rpm MySQL-shared-5.1.11-0.glibc23.i386.rpm



Edited 3 time(s). Last edit at 10/19/2006 01:47PM by David Garcia.

Options: ReplyQuote


Subject
Views
Written By
Posted
SQL node not run.
1897
October 19, 2006 01:45PM
957
October 19, 2006 11:48PM
1061
October 20, 2006 03:10AM
1191
October 20, 2006 04:36AM
1043
October 20, 2006 04:45AM
955
October 20, 2006 05:36AM


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.