MySQL Forums
Forum List  »  Backup

ndb_restore fails
Posted by: Gord Taylor
Date: January 07, 2016 04:57PM

Hello,

I've been trying with intermittent success to restore my ndb_backups to a new cluster.

We have a 6 NDB node cluster with 3 API nodes. When I run an ndb_restore, usually the first 2 or 3 node backups get pulled in without issue. But the 4th and 5th node fail with the following error:

Temporary error: 266: Time-out in NDB, probably caused by deadlock
Temporary error: 266: Time-out in NDB, probably caused by deadlock
Retried transaction 10 times.
Last error266: Time-out in NDB, probably caused by deadlock
...Unable to recover from errors. Exiting...

Strangely, sometimes I can simply rerun the backup and it finishes without error.

I'm hoping someone knows what kind of tweaks I can make to my configuration to optimize this process. Here are my version numbers and configs:

mysql-5.6.22 ndb-7.3.8

######################
#MGM CONFIG
######################
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataMemory=8144M # How much memory to allocate for data storage
IndexMemory=8144M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.

[ndb_mgmd]
# Management process options:
hostname=192.168.207.133 # Hostname or IP address of MGM node
NodeId=1

[ndb_mgmd]
# Management process options:
hostname=192.168.207.45 # Hostname or IP address of MGM node
NodeId=2

[ndbd]
# Options for data node "A":
hostname=192.168.207.135 # Hostname or IP address
NodeId=3

[ndbd]
# Options for data node "B":
hostname=192.168.207.171 # Hostname or IP address
NodeId=4


[ndbd]
# Options for data node "C":
hostname=192.168.207.174 # Hostname or IP address
NodeId=5


[ndbd]
# Options for data node "D":
hostname=192.168.207.27 # Hostname or IP address
NodeId=6


[ndbd]
# Options for data node "E":
hostname=192.168.207.169 # Hostname or IP address
NodeId=7


[ndbd]
# Options for data node "F":
hostname=192.168.207.178 # Hostname or IP address
NodeId=8


[mysqld]
hostname=192.168.207.177
NodeId=10

[mysqld]
hostname=192.168.207.35
NodeId=11

[mysqld]
hostname=192.168.207.148
NodeId=12

######################
#API CONFIG
######################
[mysqld]
ndbcluster

[mysql_cluster]
ndb-connectstring=192.168.207.133,192.168.207.45 # location of management server

######################
#NDB CONFIG
######################




Really hope someone can help. I've been at this for a month.

Options: ReplyQuote


Subject
Views
Written By
Posted
ndb_restore fails
2437
January 07, 2016 04:57PM


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.