Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

remove_database_snapshot when S3 bucket gone

edited April 2020 in General Discussion

Hi,
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
....

remove_database_snapshot

Removed:
(1 row)
Thanks in advance.

Answers

  • SruthiASruthiA Employee

    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');

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

  • SruthiASruthiA Employee

    Please try to run to see if it helps.

    vbr -t collect-garbage -c configfile.ini

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.