MySQL Forums
Forum List  »  NDB clusters

Re: [Warning] NDB: Failed to acquire global schema lock, error: (4009)Cluster Failure
Posted by: Mikael Ronström
Date: October 06, 2017 12:01PM

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.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.