MySQL Forums
Forum List  »  NDB clusters

MySQL NDB Restore Failed.
Posted by: Karthik M
Date: October 29, 2021 08:38AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL NDB Restore Failed.
243
October 29, 2021 08:38AM
149
October 29, 2021 02:07PM
142
October 31, 2021 11:22PM
133
November 01, 2021 03:19AM


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.