Bug #7625 Create table fails after initial cluster restart
Submitted: 3 Jan 2005 12:30 Modified: 12 Jan 2005 20:15
Reporter: Johan Andersson Email Updates:
Status: Won't fix Impact on me:
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:4.1.x OS:Any (*)
Assigned to: CPU Architecture:Any

[3 Jan 2005 12:30] Johan Andersson
CREATE TABLE from mysql client fails after a system restart, because the frm file still exist in the mysql servers datadir as an frm file.

How to repeat:
use test;
CREATE TABLE T1(a integer) engine=ndb;

* restart cluster (with initial):
 and try to create table again:

create table T1(a integer) engine=ndb;
ERROR 1050 (42S01): Table 'T1' already exists

Suggested fix:
Make auto_discover go to cluster and check if table really exists in cluster or not.
[3 Jan 2005 12:30] Johan Andersson
removed showstopper status.
[3 Jan 2005 18:33] Jonas Oreland
mysql> show tables;

will remove the problem
[13 Mar 2014 13:33] Omer Barnir
This bug is not scheduled to be fixed at this time.