Cannot backup vertica with messages after login

Hi Robert,

In your vbr cobfiguration file, I see

[Mapping]
v_itbadb_node0001 = localhost:/tmp/vertica_backup/
v_itbadb_node0002 = localhost:/tmp/vertica_backup/
v_itbadb_node0003 = localhost:/tmp/vertica_backup/

Looks like you are attempting to backup to the same node. Just replace localhost with the IP addresses of the nodes and re run the backup.

Thanks

Gayatri

Thanks Gayatri,

I tried as you said, but it still cannot work. From my perspective, the backup host is where the backup files should locate, rather than where the node is, because Vertica itself will care where its nodes are, am I correct? I attached the log file after I execute the backup command.

Regards,

Robert

Hi Robert,

This time vbr is failing due to insufficient disk space on node2 and node3

rsync: writefd_unbuffered failed to write 4 bytes to socket [sender]: Broken pipe (32)
rsync: write failed on "/home/dbadmin/vertica_backup/v_itbadb_node0002/backup~new~/opt/vertica/itbadb/v_itbadb_node0002_catalog/Snapshots/catalog.ctlg": No space left on device (28)
rsync error: error in file IO (code 11) at receiver.c(302) [receiver=3.0.7]
rsync: connection unexpectedly closed (115 bytes received so far) [sender]
rsync error: error in rsync protocol data stream (code 12) at io.c(601) [sender=3.0.7]
rsync failed!

rsync: write failed on "/home/dbadmin/vertica_backup/v_itbadb_node0003/backup~new~/opt/vertica/itbadb/v_itbadb_node0003_catalog/Snapshots/catalog.ctlg": No space left on device (28)

Retry the backup after freeing up space on the vertica nodes or try to backup to different hosts.

Hope this helps.

Thanks

Gayatri