problem with alter tablespace, add or drop datafile

[Jason Downing]

I'm having problems adding a datafile to my tablespace, version 5.1.11. When I try to add a datafile it says failed to alter tablespace. Some questions:

Should I select a database before adding logfile groups and tablespaces?

Do I need to have a separate logfile group or tablespace for each database I have?

What I did was to add the logfiles and tablespace and datafile (I only added one datafile) and the added a database with a disk storage table. This worked. Later I tried to add another datafile and it would not add. Then I could not remove the datafile I had, or the tablespace. (I dropped the database before trying this.) Now I can't add or drop datafiles. Here is the ndb_mgm show output:

Cluster Configuration
---------------------
[ndbd(NDB)] 3 node(s)
id=2 @192.168.0.10 (Version: 5.1.11, Nodegroup: 0, Master)
id=3 @192.168.0.11 (Version: 5.1.11, Nodegroup: 0)
id=4 @192.168.0.12 (Version: 5.1.11, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.0.17 (Version: 5.1.11)

[mysqld(API)] 3 node(s)
id=5 @192.168.0.13 (Version: 5.1.11)
id=6 (not connected, accepting connect from 192.168.0.14)
id=7 (not connected, accepting connect from 192.168.0.15)

I haven't connected the other two mysqld nodes yet, for various reasons. Could this be the problem?

I'm completely stuck as I cannot add or drop datafiles, or tablespaces.

Thanks