ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTER
来源:互联网 发布:caffe linux 安装 编辑:程序博客网 时间:2024/05/20 19:45
在mysql cluster 测试环境的其中一个节点上(id=4 192.168.1.251)执行 select 操作抱
而在 另外一个节点 192.168.1.252上执行相同的语句是没有问题的。
####192.168.1.251######
标题所示的错误:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| ndbinfo |
| performance_schema |
| test |
+--------------------+
5 rows in set (0.00 sec)
mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| teacher |
+----------------+
1 row in set, 1 warning (6.95 sec)
mysql> select * from teacher;
ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTER
mysql>
####192.168.1.251######
************************分割线******************************************************
####192.168.1.252######
mysql>
mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| teacher |
+----------------+
1 row in set (0.00 sec)
mysql> select * from teacher ;
+------+
| t_id |
+------+
| 188 |
+------+
####192.168.1.252######
*********************分割线***********************************************************
######192.168.1.244####################
回头去管理节点查看 ,发现管理节点机器挂了。
启动机器
启动服务 :
[root@slaver244 ~]# ndb_mgmd -f /app/mysql_cluster/config.ini
MySQL Cluster Management Server mysql-5.5.30 ndb-7.2.12
[root@slaver244 ~]#
[root@slaver244 ~]#
[root@slaver244 ~]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.1.246 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 0)
id=3 @192.168.1.250 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 0, Master)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.1.244 (mysql-5.5.30 ndb-7.2.12)
[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 192.168.1.251)
id=5 @192.168.1.252 (mysql-5.5.30 ndb-7.2.12)
ndb_mgm>
ndb_mgm>
#######192.168.1.244##########################
解决办法是重启 节点 192.168.1.251sql节点。
[mysqld(API)] 2 node(s)
id=4 @192.168.1.251 (mysql-5.5.30 ndb-7.2.12)
id=5 @192.168.1.252 (mysql-5.5.30 ndb-7.2.12)
在管理节点中看到的结果如上。
- ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTER
- mysqldump: Got error: 1296: Got error 157 'Unknown error code' from NDBCLUSTER when using LOCK TABLE
- ERROR 1296 (HY000): Got error 4243 'Index not found' from NDBCLUSTER & ndb_drop_index
- ERROR 1030 (HY000): Got error -1 from storage engine 错误
- ERROR 1030 (HY000): Got error 28 from storage engine
- 错误:ERROR 1290 (HY000): Unknown error 1290
- MySQL数据库ERROR 1030 (HY000): Got error 28 from storage engine
- MySQL ERROR 1030 (HY000): Got error 28 from storage engine错误
- SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine
- Unknown error code -49
- ndbcluster引擎表同步到innodb引擎报错Error 'Unknown storage engine 'ndbcluster'
- zf2+mysql Statement could not be executed (HY000 - 1030 - Got error 28 from storage engine)
- ERROR 2005 (HY000): Unknown MySQL server host
- 项目经验分享--今天公司网站打不开了!数据库:ERROR 1030 (HY000): Got error 28 from storage engine
- Mysql导致tmp目录空间耗尽问题(ERROR 1030 (HY000): Got error 28 from storage engine)
- Got error 157 'Connection to NDB failed' from NDBINFO
- Got error 134 from storage engine
- Mysql:Got error 28 from storage engine
- 我读过的那些技术书籍(英文为主)
- Tutorials - kd-tree
- MySQL的mysqldump工具的基本用法
- iOS SDK:预览和打开文档
- oracle 如何获取表的主键列名,如何获取表的所有列名 .
- ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTER
- oracle笔记
- 在VMWare 中增加磁盘(Adding a new disk to a VMware Virtual Machine in Linux)
- linux中shell变量$#,$@,$0,$1,$2的含义解释:
- goahead 利用ajax实现局部刷新
- Android的导航抽屉---Navigation Drawer
- Setsitelock:Stsadm 操作 (Office SharePoint Server)
- 华为内部面试题库---(3)
- 从命令行传递参数给内核模块 (MODULE_PARM)