ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTER

朴灿烈づ我的快乐病毒、 2022-02-15 12:15 184阅读 0赞

在mysql cluster 测试环境的其中一个节点上（id=4 192.168.1.251）执行 select 操作抱

而在 另外一个节点 192.168.1.252上执行相同的语句是没有问题的。

\#\#\#\#192.168.1.251\#\#\#\#\#\#

标题所示的错误：

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)

在管理节点中看到的结果如上。