Chinaunix首页 | 论坛 | 博客
  • 博客访问: 4149651
  • 博文数量: 240
  • 博客积分: 11504
  • 博客等级: 上将
  • 技术积分: 4277
  • 用 户 组: 普通用户
  • 注册时间: 2006-12-28 14:24
文章分类

全部博文(240)

分类: Mysql/postgreSQL

2007-12-03 10:49:54

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

阅读(8361) | 评论(2) | 转发(0) |
给主人留下些什么吧!~~

万种诗怀2015-03-16 10:30:43

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'.
我有2个数据节点node2(master),node3,node3退出,报error2305.后来我直接node3 initial启动,结果node2退出了,结果现在node3成了主节点。请

chinaunix网友2008-06-24 10:23:50

你好!我看了这篇文章,第一个问题我也碰到,但是我这里没有发生IP冲突,我观察到的现象是只要1个数据节点通讯出问题了,另1个数据节点也会被仲裁程序关闭,这应该是不对的吧,请问应该怎么解决呢?