Redhat防火墙引起的一个NDB错误。

Redhat防火墙引起的一个错误。

Mysql NDB运行在Redhat6.4上。创建ndb表的时候报ERROR 1146 (42S02)。通过查看日志发现ndb有报错，停止红帽防火墙问题解决.

比较正式的解决方式应该是打开对应端口。

mysql> create database ndbtest;
Query OK, 1 row affected (0.00 sec)

mysql>  create database ndbtest;
ERROR 1007 (HY000): Can't create database 'ndbtest'; database exists
mysql> use ndbtest;
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| ndbinfo            |
| ndbtest            |
| performance_schema |
| test               |
+--------------------+
6 rows in set (0.00 sec)

mysql> use ndbtest;
Database changed
mysql> create table a(a int(11));    ---默认MyISAM引擎
Query OK, 0 rows affected (0.01 sec)

mysql> create table b(b int(11)) engine=ndb;
ERROR 1146 (42S02): Table 'ndbtest.b' doesn't exist
mysql> create table b(b int(11)) engine=ndb;
Query OK, 0 rows affected (0.06 sec)

日志================
2013-12-31 11:02:22 7922 [Note] NDB: Cleaning stray tables from database 'information_schema'
2013-12-31 11:02:22 7922 [Note] NDB: Cleaning stray tables from database 'ndbinfo'
2013-12-31 11:02:22 7922 [Note] NDB: Cleaning stray tables from database 'ndbtest'
2013-12-31 11:02:22 7922 [Note] NDB: Cleaning stray tables from database 'performance_schema'
2013-12-31 11:02:22 7922 [Note] NDB: Cleaning stray tables from database 'test'
2013-12-31 11:02:22 7922 [ERROR] NDB: failed to setup table test.a, error: 723, No such table existed
2013-12-31 11:02:23 7922 [Note] NDB: Cleaning stray tables from database 'information_schema'
2013-12-31 11:02:23 7922 [Note] NDB: Cleaning stray tables from database 'ndbinfo'
2013-12-31 11:02:23 7922 [Note] NDB: Cleaning stray tables from database 'ndbtest'
2013-12-31 11:02:23 7922 [Note] NDB: Cleaning stray tables from database 'performance_schema'
2013-12-31 11:02:23 7922 [Note] NDB: Cleaning stray tables from database 'test'
2013-12-31 11:02:23 7922 [Note] NDB: mismatch in frm for test.a, discovering...
2013-12-31 11:02:23 7922 [ERROR] ndbcluster_discover: Skipping locally defined table 'test.a'
2013-12-31 11:02:23 [NdbApi] INFO     -- Flushing incomplete GCI:s < 2368879/15
2013-12-31 11:02:23 [NdbApi] INFO     -- Flushing incomplete GCI:s < 2368879/15
2013-12-31 11:02:23 7922 [Note] NDB Binlog: starting log at epoch 2368879/15
2013-12-31 11:02:23 7922 [Note] NDB Binlog: ndb tables writable
2013-12-31 11:02:44 7922 [Note] NDB Binlog: CREATE TABLE Event: REPL$ndbtest/b

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15711267/viewspace-1065915/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15711267/viewspace-1065915/