Re: Data node deletion in NDB

[Mauritz Sundell]

Hi Tayyab

Giving a invalid nodegroup number shows error: -1, since your nodegroup numbers are 0 and 1, nodegroup 2 is invalid.

If nodegroup has table data error: -2 will show.

From mysql client you can run below to see if node 3 and 4 has any table data:
SELECT DISTINCT node_id, fq_name, type FROM ndbinfo.memory_per_fragments WHERE node_id IN (3,4);

If there are any table data on node 3 or node 4 (nodegroup 1) you can not drop that nodegroup.

The only they to force dropping the nodegroup in that case is to first drop each table that has data on that nodegroup, and then drop nodegroup.

Example fq_name test/def/t1 maps to the sql table name test.t1, for dropping that table DROP TABLE test.t1

Regards,
Mauritz