remove_database_snapshot when S3 bucket gone

edited April 2020 in General Discussion

I have an 5 month older database snapshot that i noticed today. I cant recall the details of that backup job, but the command to clean up and remove this snapshot fails due to S3 backup bucket being unavailable.
What is the proper way to clean up ?

dbadmin=> select remove_database_snapshot('snapshotname');

WARNING 2919: Could not stat file [s3://bucket/*/Snapshots/snapshotname]: The specified bucket does not exist


(1 row)
Thanks in advance.


  • Options
    SruthiASruthiA Vertica Employee Administrator

    Can you try the below and see if it helps. Do you have more than 1 restore point associated with that snapshot?

    select remove_database_snapshot('snapshot_test','true');

  • Options

    No, unfortunately , the outcome is the same. I assume the restore point information was saved on s3://<> , but that bucket is gone, so i cant really check that out. There must be a way to clean up a local DB snapshot.

  • Options
    SruthiASruthiA Vertica Employee Administrator

    Please try to run to see if it helps.

    vbr -t collect-garbage -c configfile.ini

Leave a Comment

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