Bug #7625 Create table fails after initial cluster restart

• Submitted: 3 Jan 2005 12:30
• Modified: 12 Jan 2005 20:15
• Reporter: Johan Andersson
• Status: To be fixed later
• Category: Server: Cluster
• Severity: S3 (Non-critical)
• Version: 4.1.x
• OS: Any (*)

[3 Jan 2005 12:30] Johan Andersson

Description:
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