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