Re: Error 4009

[Mauritz Sundell]

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