MYSQL 集群的数据节点错误信息归档

62 阅读 0 评论 41 点赞

我是靠谱客的博主干净大树，最近开发中收集的这篇文章主要介绍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