Backup to standby cluster
Posted: Wed Sep 12, 2012 4:31 pm
Hi,
I have successfully performed a backup locally on my live cluster by creating a snapshot and subsequent incrementals and this works fine.
I now want to back up the same database to a standby cluster in my secondary data centre so I have created this ini file :
--------------------------------------------------
[Misc]
snapshotName = backup_snapshot
verticaConfig = False
restorePointLimit = 1
[Database]
dbName = DataStore
dbUser = vertica
dbPassword = xxxxxxx
[Transmission]
[Mapping0]
dbNode = v_datastore_node0001
backupHost = livevertica005-priv
backupDir = /vert_data
[Mapping1]
dbNode = v_datastore_node0002
backupHost = livevertica006-priv
backupDir = /vert_data
[Mapping2]
dbNode = v_datastore_node0003
backupHost = livevertica007-priv
backupDir = /vert_data
[Mapping3]
dbNode = v_datastore_node0004
backupHost = livevertica008-priv
backupDir = /vert_data
--------------------------------------------------
However I get the following error when running :
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[LIVE.DC1][vertica@livevertica001 /opt/vertica/config]$ /opt/vertica/bin/vbr.py -t backup --config-file /opt/vertiica/config/backup_snapshot.ini
Preparing...
Found Database port: 5433
Copying...
29117: vbr client subproc on 172.24.2.153 terminates with returncode 1. Details in vbr_v_datastore_node0004_client.log on that host.
Error msg: Host key verification failed.
Traceback (most recent call last):
File "/tmp/vbr/vbr.py", line 2215, in work
remoteClient(args[0], args[1], args[2], args[3], args[4], args[5], args[6] == 'True')
File "/tmp/vbr/vbr.py", line 844, in remoteClient
ssList = subprocess.check_output(['ssh', '-x', sHost, cmd])
File "/opt/vertica/oss/python/lib/python2.7/subprocess.py", line 537, in check_output
raise CalledProcessError(retcode, cmd, output=output)
CalledProcessError: Command '['ssh', '-x', '172.24.6.153', 'ls -1 /vert_data/v_datastore_node0004']' returned non-zero exit status 255
29114: vbr client subproc on 172.24.2.151 terminates with returncode 1. Details in vbr_v_datastore_node0002_client.log on that host.
Error msg: Host key verification failed.
Traceback (most recent call last):
File "/tmp/vbr/vbr.py", line 2215, in work
remoteClient(args[0], args[1], args[2], args[3], args[4], args[5], args[6] == 'True')
File "/tmp/vbr/vbr.py", line 844, in remoteClient
ssList = subprocess.check_output(['ssh', '-x', sHost, cmd])
File "/opt/vertica/oss/python/lib/python2.7/subprocess.py", line 537, in check_output
raise CalledProcessError(retcode, cmd, output=output)
CalledProcessError: Command '['ssh', '-x', '172.24.6.151', 'ls -1 /vert_data/v_datastore_node0002']' returned non-zero exit status 255
Child processes terminated abnormally.
backup failed!
cleaning up...
29115: vbr client subproc on 172.24.2.152 terminates with returncode 255. Details in vbr_v_datastore_node0003_client.log on that host.
Error msg: Killed by signal 2.
Retrying... #1
ERROR 4153: Node: v_datastore_node0001: Cannot grab lock to create snapshot 'backup_snapshot'. It might be used by others
When communicating with vertica, the process failed with code 1
backup failed!
Retrying... #2
ERROR 4153: Node: v_datastore_node0001: Cannot grab lock to create snapshot 'backup_snapshot'. It might be used by others
When communicating with vertica, the process failed with code 1
backup failed!
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I have set up passwordless ssh between all nodes and this works but the backup will not.
Any ideas?
Cheers
I have successfully performed a backup locally on my live cluster by creating a snapshot and subsequent incrementals and this works fine.
I now want to back up the same database to a standby cluster in my secondary data centre so I have created this ini file :
--------------------------------------------------
[Misc]
snapshotName = backup_snapshot
verticaConfig = False
restorePointLimit = 1
[Database]
dbName = DataStore
dbUser = vertica
dbPassword = xxxxxxx
[Transmission]
[Mapping0]
dbNode = v_datastore_node0001
backupHost = livevertica005-priv
backupDir = /vert_data
[Mapping1]
dbNode = v_datastore_node0002
backupHost = livevertica006-priv
backupDir = /vert_data
[Mapping2]
dbNode = v_datastore_node0003
backupHost = livevertica007-priv
backupDir = /vert_data
[Mapping3]
dbNode = v_datastore_node0004
backupHost = livevertica008-priv
backupDir = /vert_data
--------------------------------------------------
However I get the following error when running :
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[LIVE.DC1][vertica@livevertica001 /opt/vertica/config]$ /opt/vertica/bin/vbr.py -t backup --config-file /opt/vertiica/config/backup_snapshot.ini
Preparing...
Found Database port: 5433
Copying...
29117: vbr client subproc on 172.24.2.153 terminates with returncode 1. Details in vbr_v_datastore_node0004_client.log on that host.
Error msg: Host key verification failed.
Traceback (most recent call last):
File "/tmp/vbr/vbr.py", line 2215, in work
remoteClient(args[0], args[1], args[2], args[3], args[4], args[5], args[6] == 'True')
File "/tmp/vbr/vbr.py", line 844, in remoteClient
ssList = subprocess.check_output(['ssh', '-x', sHost, cmd])
File "/opt/vertica/oss/python/lib/python2.7/subprocess.py", line 537, in check_output
raise CalledProcessError(retcode, cmd, output=output)
CalledProcessError: Command '['ssh', '-x', '172.24.6.153', 'ls -1 /vert_data/v_datastore_node0004']' returned non-zero exit status 255
29114: vbr client subproc on 172.24.2.151 terminates with returncode 1. Details in vbr_v_datastore_node0002_client.log on that host.
Error msg: Host key verification failed.
Traceback (most recent call last):
File "/tmp/vbr/vbr.py", line 2215, in work
remoteClient(args[0], args[1], args[2], args[3], args[4], args[5], args[6] == 'True')
File "/tmp/vbr/vbr.py", line 844, in remoteClient
ssList = subprocess.check_output(['ssh', '-x', sHost, cmd])
File "/opt/vertica/oss/python/lib/python2.7/subprocess.py", line 537, in check_output
raise CalledProcessError(retcode, cmd, output=output)
CalledProcessError: Command '['ssh', '-x', '172.24.6.151', 'ls -1 /vert_data/v_datastore_node0002']' returned non-zero exit status 255
Child processes terminated abnormally.
backup failed!
cleaning up...
29115: vbr client subproc on 172.24.2.152 terminates with returncode 255. Details in vbr_v_datastore_node0003_client.log on that host.
Error msg: Killed by signal 2.
Retrying... #1
ERROR 4153: Node: v_datastore_node0001: Cannot grab lock to create snapshot 'backup_snapshot'. It might be used by others
When communicating with vertica, the process failed with code 1
backup failed!
Retrying... #2
ERROR 4153: Node: v_datastore_node0001: Cannot grab lock to create snapshot 'backup_snapshot'. It might be used by others
When communicating with vertica, the process failed with code 1
backup failed!
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I have set up passwordless ssh between all nodes and this works but the backup will not.
Any ideas?
Cheers