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.
Subject
Views
Written By
Posted
MySQL NDB Restore Failed.
712
October 29, 2021 08:38AM
411
October 29, 2021 02:07PM
452
October 31, 2021 11:22PM
471
November 01, 2021 03:19AM
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.