MySQL Forums
Forum List  »  NDB clusters

Re: Data node deletion in NDB
Posted by: Mauritz Sundell
Date: December 03, 2021 04:35PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
460
November 30, 2021 01:28PM
212
November 30, 2021 04:36PM
224
December 01, 2021 07:21AM
226
December 03, 2021 03:16PM
339
December 03, 2021 03:43PM
209
December 03, 2021 03:49PM
214
December 03, 2021 03:53PM
Re: Data node deletion in NDB
210
December 03, 2021 04:35PM
228
December 06, 2021 04:07PM
218
December 07, 2021 12:30PM
191
December 07, 2021 06:00PM


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.