Re: [Warning] NDB: Failed to acquire global schema lock, error: (4009)Cluster Failure

[Mikael Ronström]

Samad Ul Haq Wrote:
-------------------------------------------------------
> I have 3-node mysql cluster. 1 cluster management
> node 2 datanode/API nodes.
>
> Upon changing the length of a column, show
> warnings advised that i should raise the
> MaxNoOfOrderedIndex in config.ini. After the
> change i reloaded the cluster management ndb_mgmd
> followed by restart of 2nd data/api node. Before
> the restart process of 2nd node completed, node 1
> got crashed. Since then im facing the error. I
> also have tried to reload management by disabling
> the parameters added after the initial
> configuration, but all in vain.

So from what I understand you followed the correct
process to change the configuration. I don't think it
is a good idea to change back everything to the original
configuration since that might mean that you decrease
a resource that you need to be able to restart.

So best is to try to understand why the node crashed.
Look in the ndb_(id)_error.log file found in the
data directory of the crashed node. Possibly this will
tell you more what happened.

As an example you have MaxNoOfAttributes=16384, so if
you need more than the default 1000, it will be hard to
restart again if you don't change back again.