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!
.done directory after vbr.py schema backup
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: .done directory after vbr.py schema backup
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?
What is the syntax for your backup command?
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: .done directory after vbr.py schema backup
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]$
##### 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]$
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: .done directory after vbr.py schema backup
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?
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?
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: .done directory after vbr.py schema backup
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.
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.