NDB alter table engine ... flush tables

[Gert Vandelaer]

Hy all,

yesterday an ndbcluster went down ... no error messages in the logs, we did a restart ... update to 4.1.15 ... still nothing, eventually had to do a "ndbd --initial" to get the cluster back up. The last query that ran was a huge select on table X, query took over 8 minutes (Jboss java app that ran it, actually timed out) and than the cluster went offline ...

Anyway, I tried to figure out what went wrong on 2 devel machines, and imported table X there ... did an alter table engine=MyISAM ; created some basic indexes ; engine back to ndbcluster .; flush tables ... I did the flush tables on both nodes btw (same query took only 1 minute after that)

After this the weirdest thing happened : all tables except the one I just altered / indexed / altered were dropped. I could still actually see the .frm and .ndb files in the mysql-data dir, but once i did a "show tables" in mysql, they were just dropped, no error messages whatsoever ... gone :-/

I couldn't find any info about this 'feature', I usually don't do "flush tables" after alter table, this was first time I did that, could that ave anything to do with it ?

Bye,
Gert