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
Errors when copy Vertica 5 from one lunux host to another
Moderator: NorbertKrupa
-
- Newbie
- Posts: 17
- Joined: Wed Sep 12, 2012 8:28 pm
Re: Errors when copy Vertica 5 from one lunux host to anothe
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
Vertica Consultant, Zazz Technologies LLC