List:Cluster« Previous MessageNext Message »
From:periyannan natarajan Date:April 4 2012 6:54am
Subject:REG:ndb_restore failed in mysql cluster.
View as plain text  
Dear Friends,

                 Regarding ndb_restore failed:

My Management Server Config.ini is 
[NDBD DEFAULT]
NoOfReplicas=2

[MYSQLD DEFAULT]

[NDB_MGMD DEFAULT]

[TCP DEFAULT]

#Section for the cluster management node
[NDB_MGMD]
#IP address of the management node (this system)
Nodeid= 1
HostName=192.168.168.43

#Section for the storage nodes
[NDBD]
#IP address of the first storage node
Nodeid = 2
HostName=192.168.168.100
DataDir= /var/lib/mysql-cluster

[NDBD]
#IP address of the second storage node
Nodeid = 3
HostName=192.168.168.46
DataDir= /var/lib/mysql-cluster

# one [MYSQLD] per storage node

[MYSQLD]
Nodeid = 4
HostName=192.168.168.100

[MYSQLD]
Nodeid = 5
HostName=192.168.168.46

[MYSQLD]
Nodeid = 6
HostName=192.168.168.71

Then,
while i am restore my backup from 192.168.168.46 ,i got 
the below error:

root@brdvox02:/var/lib/mysql-cluster/BACKUP/BACKUP-1# ndb_restore -c
192.168.2.43:1186 -b 1 -r -n 3 -m /var/lib/mysql-cluster/BACKUP/BACKUP-1/
Backup Id = 1
Nodeid = 3
backup path = /var/lib/mysql-cluster/BACKUP/BACKUP-1/
Opening file '/var/lib/mysql-cluster/BACKUP/BACKUP-1/BACKUP-1.3.ctl'
Backup version in files: ndb-6.3.11 ndb version: mysql-5.1.51 ndb-7.1.9
Stop GCP of Backup: 43464
Failed to connect to ndb!!
Failed to initialize consumers

NDBT_ProgramExit: 1 - Failed

root@brdvox02:/var/lib/mysql-cluster/BACKUP/BACKUP-1# 


--------------------------------
Then I tried to restore this from 192.168.168.71(new API Slot) and i cant
not restore.please below error

root@brdvox07:/var/lib/mysql-cluster# ndb_restore -e -b 2 -n 3 -c
192.168.168.43:1186
Backup Id = 2
Nodeid = 3
backup path = ./
Opening file './BACKUP-2.3.ctl'
readDataFileHeader: Error reading header
Failed to read ./BACKUP-2.3.ctl

NDBT_ProgramExit: 1 - Failed

root@brdvox07:/var/lib/mysql-cluster# 

----------------------------------------------

Please someone give idea.i am first time restoring this MySQL cluster
backup.

Regards,
Periyannan Natarajan



--
View this message in context:
http://mysql-cluster.1050023.n4.nabble.com/REG-ndb-restore-failed-in-mysql-cluster-tp4531099p4531099.html
Sent from the MySQL - Cluster mailing list archive at Nabble.com.
Thread
REG:ndb_restore failed in mysql cluster.periyannan natarajan4 Apr