MySQL NDB Restore Failed.

[Karthik M]

Hello,

In my ndbcluster setup i have 2 datanodes. Of which one of the nodes went down.

I am taking a backup after the node is down (with only one node running) and then during restoration i am unable to restore the backup to the one node which is running.

[data]$ sudo ndb_restore --ndb-connectstring=<string> --restore_meta --nodeid=4 --backupid=2110291059 --backup_path=/var/tmp/BACKUP-2110291059/BACKUP-2110291059 --disable-indexes --verbose=255 --print
Nodeid = 4
Backup Id = 2110291059
backup path = /var/tmp/BACKUP-2110291059/BACKUP-2110291059
2021-10-29 16:11:14 [restore_metadata] Read meta data file header
Opening file '/var/tmp/BACKUP-2110291059/BACKUP-2110291059/BACKUP-2110291059.4.ctl'
File size 53760 bytes
Backup version in files: ndb-6.3.11 ndb version: mysql-5.7.35 ndb-7.6.19
2021-10-29 16:11:14 [restore_metadata] Load content
Start GCP of Backup: 469160
Stop GCP of Backup: 469163
2021-10-29 16:11:14 [restore_metadata] Get number of Tables
2021-10-29 16:11:14 [restore_metadata] Validate Footer
Connected to ndb!!
2021-10-29 16:11:15 [restore_metadata] Restore objects (tablespaces, ..)
2021-10-29 16:11:15 [restore_metadata] Restoring tables
-- sys/def/213/PRIMARY --
Version: 1
Fragment type: FragUndefined
K Value: 6
Min load factor: 78
Max load factor: 80
Temporary table: yes
Number of attributes: 3
Number of primary keys: 1
Length of frm data: 0
Max Rows: 0
Row Checksum: 1
Row GCI: 1
SingleUserMode: 2
ForceVarPart: 0
PartitionCount: 2
FragmentCount: 2
PartitionBalance: FOR_RP_BY_LDM
ExtraRowGciBits: 0
ExtraRowAuthorBits: 0
TableStatus: Retrieved
Table options:

Successfully printed table: -- sys/def/81/PRIMARY --
Version: 1
Fragment type: FragUndefined
K Value: 6
Min load factor: 78
Max load factor: 80
Temporary table: yes
Number of attributes: 3
Number of primary keys: 1
Length of frm data: 0
Max Rows: 0
Row Checksum: 1
Row GCI: 1
SingleUserMode: 2
ForceVarPart: 0
PartitionCount: 2
FragmentCount: 2
PartitionBalance: FOR_RP_BY_LDM
ExtraRowGciBits: 0
ExtraRowAuthorBits: 0
TableStatus: Retrieved
Table options:

Successfully printed table: -- hivemetadata/def/FUNC_RU --
Version: 16777217
Fragment type: HashMapPartition
K Value: 6
Min load factor: 78
Max load factor: 80
Temporary table: no
Number of attributes: 4
Number of primary keys: 2
Length of frm data: 382
Max Rows: 0
Row Checksum: 1
Row GCI: 1
SingleUserMode: 0
ForceVarPart: 1
PartitionCount: 2
FragmentCount: 2
PartitionBalance: FOR_RP_BY_LDM
ExtraRowGciBits: 0
ExtraRowAuthorBits: 0
TableStatus: Retrieved
Table options:

Successfully printed table: Successfully restored table `hivemetadata/def/FUNC_RU`
Create table event for hivemetadata/def/FUNC_RU failed: 1: Unknown error code
Restore: Failed to restore table: `hivemetadata/def/FUNC_RU` ... Exiting


I am getting the above error during restoration.

Is it possible to restore the backup in this scenario.