The Vertica Database Forums

After running a schema backup via vbr.py I sometimes see an empty .done directory. Sometimes not. What is the purpose of this directory?

Thanks for your help!

What version? I checked the script for 7.2.1-3 and can't find any reference to a .done directory.

What is the syntax for your backup command?

Hi Jim...


##### Version Info ###########
select version();
Vertica Analytic Database v7.1.2-1
#####
Running on AWS, using Vertica's AMI for AWS.
#################################


$ crontab -l
## Backup the public schema
20 16 * * 4 cd /nfs/workspace/dbadmin/run_backups/schema/; ./run_schema_backup.sh ./schema_public.ini > /dev/null 2>&1

## Below is the shell script called from crontab
$ cat run_schema_backup.sh
<< Omitted non-relevant stuff like checking args & logging... >>
/opt/vertica/bin/vbr.py --task backup --config-file $1 2>&1 | tee -a ./run_schema_backup.log


## cd to the backup destination...
$ pwd
/backup/<db_name>/v_<db_name>_node0001

$ ls -al | grep ^d | grep '.done'
drwxr-xr-x. 2 dbadmin verticadba 4096 Feb 16 17:27 .schema_public.done

$ cd .schema_public.done
[dbadmin@ip-xx-xxx-xxx-xxx .schema_public.done]$ ls -alt
total 8
drwxr-xr-x. 82 dbadmin verticadba 4096 Feb 17 00:47 ..
drwxr-xr-x. 2 dbadmin verticadba 4096 Feb 16 17:27 .
[dbadmin@ip-xx-xxx-xxx-xxx .schema_public.done]$

The .done directory seems to be a 7.1.x thing.

Another user was having an issue too:

viewtopic.php?t=1410

Are you getting any errors in your log files about not being to delete the directory?

I have not found issues due to the .done directory.
It had caught my attention while testing the backup process on a new server but I couldn't find any reference online or in the docs.
Many thanks for looking into this, Jim.