原因是我在一台SQL节点的机器上ALTER了一下TABLE。
而且启动的时候没有按照常规的顺序启动所有节点。
具体原因:192.168.0.233,234(SQL节点)
SQL节点233没有停。停了234
然后启动管理节点和NDBD节点,之后就出现这样的问题。
mysql> select * from t33;
ERROR 1296 (HY000): Got error 241 'Invalid schema object version' from NDBCLUSTER
mysql> flush tables;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
正常启动顺序:
1、启动所有管理节点
2、启动所有NDBD节点。
3、启动MYSQL节点。
正常的运行结果:
机器233:
mysql> select * from t33;
+----+------------+
| id | link_str |
+----+------------+
| 1 | I love you |
| 2 | Also in cu |
+----+------------+
2 rows in set (0.00 sec)
mysql> alter table t33 change link_str str varchar(1000) not null;
Query OK, 2 rows affected (1.64 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> select * from t33;
+----+------------+
| id | str |
+----+------------+
| 1 | I love you |
| 2 | Also in cu |
+----+------------+
2 rows in set (0.00 sec)
机器234:
mysql> select * from t33;
+----+------------+
| id | link_str |
+----+------------+
| 1 | I love you |
| 2 | Also in cu |
+----+------------+
2 rows in set (0.00 sec)
mysql> select * from t33;
+----+------------+
| id | str |
+----+------------+
| 1 | I love you |
| 2 | Also in cu |
+----+------------+
2 rows in set (0.03 sec)
阅读(2847) | 评论(0) | 转发(0) |