我有四个数据节点,其中三个已经启动起来了,然后有一个启不起来,然后启动时加上--initial启动,发现其Nodegroup 本来应该是1现在为0了,启动报错和日志信息如下:
ndb_mgm> show;
Cluster Configuration
---------------------
[ndbd(NDB)] 4 node(s)
id=2 @172.16.48.206 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0)
id=3 @172.16.48.207 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master)
id=4 @172.16.48.208 (mysql-5.5.22 ndb-7.2.6, starting, Nodegroup: 0)
id=5 @172.16.48.211 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 1) [ndb_mgmd(MGM)] 1 node(s)
id=1 @172.16.48.204 (mysql-5.5.22 ndb-7.2.6) [mysqld(API)] 4 node(s)
id=6 @172.16.48.206 (mysql-5.5.22 ndb-7.2.6)
id=7 (not connected, accepting connect from 172.16.48.207)
id=8 (not connected, accepting connect from 172.16.48.208)
id=9 (not connected, accepting connect from 172.16.48.211)
ndb_mgm> Node 4: Forced node shutdown completed. Occured during startphase 5. Caused by error 2303: 'System error, node killed during node restart by other node(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'. 日志文件:Time: Wednesday 13 June 2012 - 14:19:01
Status: Temporary error, restart node
Message: System error, node killed during node restart by other node (Internal error, programming error or missing error message, please report a bug)
Error: 2303
Error data: Killed by node 4 as copyfrag failed, error: 1501
Error object: NDBCNTR (Line: 277) 0x00000006
Program: ndbd
Pid: 5397
Version: mysql-5.5.22 ndb-7.2.6
Trace: /opt/mysql-cluster/data/ndb_4_trace.log.6 [t1..t1]
***EOM***网上有人说是undo 日志空间用完了,增加了undo日志空间文件还是解决不了问题。请高手帮忙!!!
ndb_mgm> show;
Cluster Configuration
---------------------
[ndbd(NDB)] 4 node(s)
id=2 @172.16.48.206 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0)
id=3 @172.16.48.207 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master)
id=4 @172.16.48.208 (mysql-5.5.22 ndb-7.2.6, starting, Nodegroup: 0)
id=5 @172.16.48.211 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 1) [ndb_mgmd(MGM)] 1 node(s)
id=1 @172.16.48.204 (mysql-5.5.22 ndb-7.2.6) [mysqld(API)] 4 node(s)
id=6 @172.16.48.206 (mysql-5.5.22 ndb-7.2.6)
id=7 (not connected, accepting connect from 172.16.48.207)
id=8 (not connected, accepting connect from 172.16.48.208)
id=9 (not connected, accepting connect from 172.16.48.211)
ndb_mgm> Node 4: Forced node shutdown completed. Occured during startphase 5. Caused by error 2303: 'System error, node killed during node restart by other node(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'. 日志文件:Time: Wednesday 13 June 2012 - 14:19:01
Status: Temporary error, restart node
Message: System error, node killed during node restart by other node (Internal error, programming error or missing error message, please report a bug)
Error: 2303
Error data: Killed by node 4 as copyfrag failed, error: 1501
Error object: NDBCNTR (Line: 277) 0x00000006
Program: ndbd
Pid: 5397
Version: mysql-5.5.22 ndb-7.2.6
Trace: /opt/mysql-cluster/data/ndb_4_trace.log.6 [t1..t1]
***EOM***网上有人说是undo 日志空间用完了,增加了undo日志空间文件还是解决不了问题。请高手帮忙!!!
Occured during startphase 5.
Caused by error 2341: 'Internal program error (failed ndbrequire)(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.
后面的错误发现时7.2.13版本的bug.