MySQL Forums
Forum List  »  NDB clusters

Re: Error 4009
Posted by: Mauritz Sundell
Date: January 10, 2024 06:05AM

Hi Nisa,

The connections between the sql node (mysqld) and data nodes (ndbmtd) are intended to live as long as the processes are up. They are not intended to go up and down per query or anything.

If the sql node for some reason has disconnected there should be something in the mysqld error log.

Also not that API node ids are not only used by sql nodes (mysqld) and one should have some API node ids defined that other tools can use like for example ndb_restore.

If you are running some ndb tool it may that tool that uses node id 47, and in that case the connect and disconnect in cluster log is expected.

You can check which processes uses which node id by:

mysql> SELECT * FROM ndbinfo.processes;

It will only show processes that currently are connected.

Regards,
Mauritz

Options: ReplyQuote


Subject
Views
Written By
Posted
153
January 05, 2024 09:35PM
Re: Error 4009
64
January 10, 2024 06:05AM
62
January 10, 2024 06:18AM
84
January 10, 2024 06:34AM


Sorry, only registered users may post in this forum.

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.