Re: ERROR 1050 (42S01): Table already exists

[Han Chee]

Hi!
I have modified the my.cnf like yours above. However, the problem still exists.

Below is the output when I try to ALTER TABLE

*****************************************************************
mysql> ALTER TABLE `TBL1` ENGINE = NDBCLUSTER;
ERROR 1050 (42S01): Table '#sql-1e4c_5' already exists
mysql> SHOW WARNINGS;
+---------+------+------------------------------------------------------------------+
| Level | Code | Message |
+---------+------+------------------------------------------------------------------+
| Warning | 1105 | Ndb might have problems storing the max amount of rows specified |
| Error | 1296 | Got error 4009 'Cluster Failure' from NDB |
| Error | 1050 | Table '#sql-1e4c_5' already exists |
+---------+------+------------------------------------------------------------------+
*****************************************************************

Any idea on this?
Thanks!