The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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.
[[email protected] bin]$

Comments

  • 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.
    Br.

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.