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
428
November 30, 2021 01:28PM
187
November 30, 2021 04:36PM
202
December 01, 2021 07:21AM
195
December 03, 2021 03:16PM
312
December 03, 2021 03:43PM
186
December 03, 2021 03:49PM
178
December 03, 2021 03:53PM
Re: Data node deletion in NDB
191
December 03, 2021 04:35PM
206
December 06, 2021 04:07PM
194
December 07, 2021 12:30PM
169
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.