Copy a Vertica database from one linux to another error

[brendon987]

Hi All,

I am trying to copy a live vertica database from one linux host to another linux host.

I do the following command
./vbr.py --config-file /opt/vertica/bin/CopyPDW-dev-to-prod.ini --task copycluster

Its seems that my copy gets about 40% complete, then get errors. It happens somewhere between 1-2 hour mark. Does rsync have any type of time/cpu limit ? Any ideas ? Is this Vertica or Linux ? issue. This has happen two\ice now. What should I be looking at.

file has vanished: "/data/pdw/pdw/v_pdw_node0001_catalog/Snapshots/CopyPDWfromDev/data/pdw/pdw/v_pdw_node0001_data/599/45035996278925599/45035996278925599_0.fdb"
file has vanished: "/data/pdw/pdw/v_pdw_node0001_catalog/Snapshots/CopyPDWfromDev/data/pdw/pdw/v_pdw_node0001_data/599/45035996278925599/45035996278925599_0.pidx"
rsync warning: some files vanished before they could be transferred (code 24) at main.c(1042) [sender=3.0.7]
rsync failed!

Thanks

[scutter]

Check your SnapShotRetentionTime config parameter. It defaults to 3600 seconds, after which the snapshot will be removed on the next RemoveSnapShotInterval cycle. Once the snapshot is removed, data files are no longer guaranteed to continue to exist.

[brendon987]

Thanks for the reply.

I am pretty new to vertica. Where do I find the SnapShotRetentionTime config parameter ?.

Also should I be checking the setting of the Source or the Target.

Dont worry, I have workout the answers. Thanks for the right answer and help.

Thanks

Brendon