Re: Data node deletion in NDB
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
Subject
Views
Written By
Posted
869
November 30, 2021 01:28PM
492
November 30, 2021 04:36PM
478
December 01, 2021 07:21AM
496
December 03, 2021 03:16PM
610
December 03, 2021 03:43PM
480
December 03, 2021 03:49PM
492
December 03, 2021 03:53PM
Re: Data node deletion in NDB
498
December 03, 2021 04:35PM
506
December 06, 2021 04:07PM
473
December 07, 2021 12:30PM
449
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.