The Vertica Database Forums

hi
i created configuration file using vbr.py
and now trying to take entire backup of my single node Vertica db using vbr.py
but m getting below error

./vbr.py --task backup --config-file /home/dbadmin/VerticaBkp.ini
Preparing...
Found Database port: 5433
Traceback (most recent call last):
File "./vbr.py", line 1956, in backup
prepareAll()
File "./vbr.py", line 1388, in prepareAll
getHostNameAndCatDir()
File "./vbr.py", line 1655, in getHostNameAndCatDir
saveInfoFile(os.path.abspath('%s/%s.info'%(g["tmpDir"], g["snapshotName"])))
File "./vbr.py", line 1546, in saveInfoFile
infoFile = open(infoFilePath, 'w')
IOError: [Errno 2] No such file or directory: '/tmp/vbr/home/dbadmin/VerticaBkp.info'
backup failed unexpectedly!



my config file content is

[Misc]
snapshotName = /home/dbadmin/VerticaBkp
verticaConfig = True
restorePointLimit = 1
objects = yes

[Database]
dbName = tdadb
dbUser = dbadmin
dbPassword = tdadb

[Transmission]

[Mapping0]
dbNode = v_tdadb_node0001
backupHost = 172.20.0.238
backupDir = /opt/etl/tmp




Can u pls tell me where m going wrong .

Hi!

Check passwordless ssh connection.

Before you back up to hosts outside of the local cluster, configure the target backup locations to work with the vbr.py utility. The backup hosts you use must:

• Have sufficient backup disk space.
• Be accessible from your database cluster.
• Have passwordless SSH access for the database administrator account.
• Test SSH between cluster nodes and backup node(s).
• Have a copy of the same versions of Python and rsync that were installed by the Vertica installer.

hi , i created password less ssh connection even then getting same error
What is that .info file , what should be its content ???
and now i modified snapshot name in config file as snapshotName = VerticaBkp
now my error is as below


./vbr.py --task backup --config-file /home/dbadmin/VerticaBkp.ini
Preparing...
Found Database port: 5433
The authenticity of host '127.0.0.1 (127.0.0.1)' can't be established.
RSA key fingerprint is 63:d6:30:52:06:60:5e:d7:7a:6b:72:54:f2:13:37:40.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '127.0.0.1' (RSA) to the list of known hosts.
The authenticity of host '172.20.0.238 (172.20.0.238)' can't be established.
RSA key fingerprint is 63:d6:30:52:06:60:5e:d7:7a:6b:72:54:f2:13:37:40.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '172.20.0.238' (RSA) to the list of known hosts.
ERROR 5211: Unknown or unsupported object: yes
When communicating with vertica, the process failed with code 1
backup failed!
Retrying... #1
ERROR 5211: Unknown or unsupported object: yes
When communicating with vertica, the process failed with code 1
backup failed!
Retrying... #2
ERROR 5211: Unknown or unsupported object: yes
When communicating with vertica, the process failed with code 1
backup failed!

Hi!

Some corruption caused to your data, that why Vertica can't do backup: "ERROR 5211: Unknown or unsupported object: yes", but I realize that you know to read and I don't need explain it to you. May be you have VIEW that corresponding table was deleted? Or you defined object backup for object "yes" that doesn't exists. You MUST to resolve it! Run CRC (it's not will solve a problem, but should point on data corruption).
https://my.vertica.com/docs/6.1.x/HTML/ ... #18683.htm
https://my.vertica.com/docs/6.1.x/HTML/ ... #18739.htm
https://my.vertica.com/docs/6.1.x/HTML/ ... #18742.htm

PS
So you likes clones: banurajadurai and rajaduraibanu (posting.php?mode=reply&f=35&t=1378)?
And who is a real and who is clone? To whom I should answer? Or it helps to you to feel that "you are many"? Should I concatenate your posts?

Hi!

Heh-heh! On question "Specify objects (no default):" of "vbr.py --setupconfig" you gave answer 'yes', while object it's database object, i.e. - table, schema

Object

The object names (schemas or tables) to include in a snapshot. Enter multiple names in a comma-separated list.
Object names can include UTF-8 alphanumeric characters (as in snapshotName, above). Object names cannot include escape characters, single quote (') or double quote (") characters.
To use non-alphanumeric characters, use a backslash (\) followed by a hex value. For instance, if the table name is a my table (my followed by a space character, then table), enter the object name as follows: objects=my\20table

Thanku Now its working fine ..

Sorry for confusion , me and my colleague was working on this so bit confusion
Banu Rajadurai

HI can i restore my backup with New database Name
i mean i took backup of tdadb database , i want to restore it with new name .