Bug #40723 Disk Tables Disappear After Entire Cluster Restart

• Submitted: 14 Nov 2008 1:11
• Modified: 14 Nov 2008 2:12
• Reporter: Mikiya Okuno
• Status: Closed
• Category: MySQL Cluster: Disk Data
• Severity: S3 (Non-critical)
• Version: 6.3.18
• OS: Linux (Ubuntu 8.10)
• CPU Architecture: Any

[14 Nov 2008 1:11] Mikiya Okuno

Description:
After a complete cluster shutdown and restart, Disk tables disappear. The data files exist but nothing can be found from a SQL node.

How to repeat:
1. Create disk tables

mysql> use test
Database changed
mysql> show tables;
Empty set (0.04 sec)

mysql> CREATE LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_2.dat' INITIAL_SIZE 256M UNDO_BUFFER_SIZE 16M ENGINE NDB;
Query OK, 0 rows affected (20.52 sec)

mysql> CREATE TABLESPACE ts_1 ADD DATAFILE 'data_2.dat' USE LOGFILE GROUP lg_1 INITIAL_SIZE 512M ENGINE NDB;
Query OK, 0 rows affected (44.37 sec)

mysql> CREATE TABLE t1 (a SERIAL, b VARCHAR(1024)) TABLESPACE ts_1 STORAGE DISK ENGINE=NDB;
Query OK, 0 rows affected (1.33 sec)

2. Restart the cluster

shell> mysqladmin shutdown
shell> ndb_mgm -e shutdown
...
shell> ndb_mgmd -f config.ini
shell> ndbd -c xxx.xxx.xxx.xxx
shell> mysqld_safe &

3. Tables disappear

shell> mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.28-ndb-6.3.18-innodb-cluster-com-log MySQL Cluster Server (Commercial)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use test
Database changed
mysql> show tables;
Empty set (0.05 sec)

Suggested fix:
Something missing during startup phases?

[14 Nov 2008 1:13] MySQL Verification Team

Data files still remain after restart.

shell> ls ndb_11_fs/
D1  D10  D11  D2  D8  D9  LCP  data_2.dat  undo_2.dat

But I cannot see from a SQL node.

mysql> use test
Database changed
mysql> show tables;
Empty set (0.05 sec)

mysql> select * from information_schema.files;
Empty set (0.03 sec)

[14 Nov 2008 2:12] MySQL Verification Team

Please let me close this bug, because this is not a bug, but my mistake. I'm sorry that I misconfigured my test system.

Kind regards!