Errors when copy Vertica 5 from one lunux host to another

Moderator: NorbertKrupa

Post Reply
brendon987
Newbie
Newbie
Posts: 17
Joined: Wed Sep 12, 2012 8:28 pm

Errors when copy Vertica 5 from one lunux host to another

Post by brendon987 » Mon Sep 17, 2012 6:54 pm

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 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
Master
Master
Posts: 302
Joined: Tue Aug 07, 2012 2:15 am

Re: Errors when copy Vertica 5 from one lunux host to anothe

Post by scutter » Mon Sep 17, 2012 7:46 pm

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.
Sharon Cutter
Vertica Consultant, Zazz Technologies LLC

Post Reply

Return to “Vertica Backup & Recovery”