errno 155 and its effects :(

[Peter Schulz]

Hey there,

since i got in trouble with the strange eerno 4242 and its solution ( tweaking my cluster.ini) i'm no on a point i don't know wether mysql cluster is the solution which could bring me in good times :(

i set up my cluster config with (on a machine with 4gig ram, which is only and just only db server...):
[NDBD DEFAULT]
NoOfReplicas=2 # Number of replicas
DataMemory=2048M # How much memory to allocate for data storage
IndexMemory=512M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
MaxNoOfUniqueHashIndexes=256
MaxNoOfOrderedIndexes=32678
MaxNoOfAttributes=32678
MaxNoOfConcurrentOperations=250000
#RedoBuffer=128M
-------------------------------------------------
i thought that is MORE then enough for my few dbs (disk usage for the dumbs of dbs is only 100MB ...),
today i wanted to create a new table in one db... it failed with errno 155... WHY?
i searched but only found that i have to few space :/ but aren't 2GIG enough?

i wanted to tweak again but...
ndb_mgm> 2 stop
Node 2: Node shutdown aborted
Shutdown failed.
* 2002: Stop failed
* Node shutdown would cause system crash

... WHY? it worked the last 2 weeks but why not now?..

please help
_pete®