mysql集群的数据节点无效_MYSQL 集群的数据节点错误信息归档

1、数据节点的IP地址和其它的客户端主机冲突导致的错误。

管理节点报告：

ndb_mgm> Node 4: Forced node shutdown completed. Caused by error 2305: 'Node lost connection to other nodes and can not form a unpartitioned cluster, please investigate if there are error(s) on other node(s)(Arbitration error). Temporary error, restart node'.

数据节点错误日志：

[root@localhost data]# vi ndb_4_error.log

Current byte-offset of file-pointer is: 1067

Time: Saturday 1 December 2007 - 18:10:56

Status: Temporary error, restart node

Message: Node lost connection to other nodes and can not form a unpartitioned cluster, please investigate if there are error(s) on other node(s) (Arbitration error)

Current byte-offset of file-pointer is: 1067

Time: Saturday 1 December 2007 - 18:10:56

Status: Temporary error, restart node

Message: Node lost connection to other nodes and can not form a unpartitioned cluster, please investigate if there are error(s) on other node(s) (Arbitration error)

Current byte-offset of file-pointer is: 1067

Time: Saturday 1 December 2007 - 18:10:56

Status: Temporary error, restart node

Message: Node lost connection to other nodes and can not form a unpartitioned cluster, please investigate if there are error(s) on other node(s) (Arbitration error)

Error: 2305

Error data: Arbitrator decided to shutdown this node

Error object: QMGR (Line: 4897) 0x0000000e

Program: /usr/local/mysql/bin/ndbd

Pid: 6285

Trace: /usr/local/mysql/data/ndb_4_trace.log.1

Version: Version 5.1.21 (beta)

***EOM***

Time: Monday 3 December 2007 - 17:50:51

Status: Temporary error, restart node

Message: Node lost connection to other nodes and can not form a unpartitioned cluster, please investigate if there are error(s) on other node(s) (Arbitration error)

Error: 2305

Error data: Arbitrator decided to shutdown this node

Error object: QMGR (Line: 4897) 0x0000000a

Program: /usr/local/mysql/bin/ndbd

Pid: 8794

Trace: /usr/local/mysql/data/ndb_4_trace.log.2Version: Version 5.1.21 (beta)***EOM***

2、我进行在线恢复的时候出现的。

[root@localhost data]# /usr/local/mysql/bin/ndb_restore -n5 -b1 -r -m --backup_path=/usr/local/mysql/data/BACKUP/BACKUP-1/

Nodeid = 5

Backup Id = 1

backup path = /usr/local/mysql/data/BACKUP/BACKUP-1/

Ndb version in backup files: Version 5.1.22

Configuration error: Error : Could not alloc node id at 192.168.0.231 port 1186: No free node id found for mysqld(API).

Failed to initialize consumers

NDBT_ProgramExit: 1 - Failed

原因是我的管理节点配置中的SQL节点部分没有加空的[MYSQLD]部分。

所以我加了和SQL节点数目一致的[MYSQLD]就好了。

多谢CU的showsa兄弟。

3、早上来的时候发现数据节点DOWN掉了

Time: Sunday 16 December 2007 - 09:01:40

Status: Temporary error, restart node

Message: Internal program error (failed ndbrequire) (Internal error, programming error or missing error message, please report a bug)

Error: 2341

Error data: suma/Suma.cpp

Error object: SUMA (Line: 3168) 0x0000000a

Program: /usr/local/mysql/bin/ndbd

Pid: 9396

Trace: /usr/local/mysql/data/ndb_3_trace.log.11

Version: Version 5.1.21 (beta)

***EOM***

结果办法：

在管理节点的配置文件中添加：

[ndbd default]

MaxNoOfOrderedIndexes=512

默认值是128