The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Vertica backup issue

Dear's, can you please confirm why i am getting the error while doing the backup full/incremental.

Starting replication of objects ['FAS'] from OSSA.
Participating nodes: v_ossa_node0001, v_ossa_node0002, v_ossa_node0003.
Snapshotting the source database.
Error: SQL command "select object_snapshot('backup_snapshot_HKMDU9P3YXN67UUCR1ZN47IGSQGTG358','FAS',false);" failed: ERROR 7813: Snapshot failed because some projections unable to move out data to ROS. Minimum checkpoint epoch of projections in snapshot: 67156996, current epoch: 67167673
HINT: See vertica log for all the lagging projections
Replicate FAILED.
[dbadmin@ppsafas1 bin]$


  • SruthiASruthiA Vertica Employee Employee

    please perform moveout and then try replication to see if it helps.

    SELECT DO_TM_TASK('moveout');

  • Thanks Sruthia, basically it was inactive projection issue which is resolved now and backup start.

Leave a Comment

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