|
原因是我在一台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)
|