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]$
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
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.