Options

Vertica backup issue

JunaidKhanJunaidKhan ✭
in General Discussion

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]$

Comments

  • Options
    SruthiASruthiA Vertica Employee Administrator

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

    SELECT DO_TM_TASK('moveout');

  • Options
    JunaidKhanJunaidKhan ✭

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...