Bug #37186 MyISAM table cannot be loaded into Cluster

• Submitted: 4 Jun 2008 9:32
• Modified: 12 Jul 2008 22:15
• Reporter: Oli Sennhauser
• Status: No Feedback
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S2 (Serious)
• Version: 5.1.23-ndb-6.2.15
• OS: Linux (debian 2.6.18-6-amd64)
• Assigned to: Assigned Account
• CPU Architecture: Any

[4 Jun 2008 9:32] Oli Sennhauser

Description:
Converting MyISAM table to cluster does not work.

How to repeat:
mysql> ALTER TABLE new.quote_intraday_price_volume ENGINE=NDB;
ERROR 1297 (HY000): Got temporary error 286 'Node failure caused abort of transaction' from NDBCLUSTER

The I tried to do again with ONE node and it works:

mysql> ALTER TABLE new.quote_intraday_price_volume ENGINE=NDB;
Query OK, 5563749 rows affected (1 min 18.14 sec)
Records: 5563749  Duplicates: 0  Warnings: 0

After node restart everything looks fine.

Before we hade to increase the FragmentLogFileSize from default (16 m) to 32M and the RedoBuffer from 32m to 64m

[12 Jul 2008 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".