We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Error in vbr copycluster — Vertica Forum

Error in vbr copycluster

Hi @ll

I follow the steps in https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/CopyingTheDatabaseToAnotherCluster.htm to do a simple test and I got this message:

dbadmin@srvvert02:~$ vbr -t copycluster -c copycluster.ini
Error: Worker process exited with error: Permission denied (publickey,password).

Copycluster FAILED.
dbadmin@srvvert02:~$

Is a very simple envirionment, two single nodes servers for test propouse

My copycluster.ini is here

dbadmin@srvvert02:~$ cat copycluster.ini
[Misc]
snapshotName = Copydb001
restorePointLimit = 5
tempDir = /tmp/vbr
retryCount = 5
retryDelay = 1

[Database]
dbName = db001
dbUser = dbadmin
dbPassword = vertica
dbPromptForPassword = False

[Transmission]
encrypt = False
checksum = False
port_rsync = 50000

[Mapping]
; backupDir is not used for cluster copy
v_db001_node0001 = 172.16.113.150

And a SSH passwordless is working

dbadmin@srvvert02:~$ ssh dbadmin@172.16.113.150
Welcome to Ubuntu 16.04.4 LTS (GNU/Linux 4.4.0-116-generic x86_64)

177 packages can be updated.
107 updates are security updates.

New release '18.04.2 LTS' available.
Run 'do-release-upgrade' to upgrade to it.

Last login: Tue Apr 9 18:16:29 2019 from 172.16.113.151
dbadmin@srvvert01:~$

Thank you!

Comments

  • AfeAfe - Select Field - Employee

    @AndreAlmeida Can you retry the operation with more verbose logging by adding "--debug 3" to the copycluster command line and paste the last few lines around the failure from the vbr log? The vbr log will be present in /tmp/vbr

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file