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
295
November 30, 2021 01:28PM
143
November 30, 2021 04:36PM
160
December 01, 2021 07:21AM
151
December 03, 2021 03:16PM
262
December 03, 2021 03:43PM
145
December 03, 2021 03:49PM
133
December 03, 2021 03:53PM
Re: Data node deletion in NDB
147
December 03, 2021 04:35PM
154
December 06, 2021 04:07PM
147
December 07, 2021 12:30PM
128
December 07, 2021 06:00PM


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.