Unable to connect to db , while taking backup

Moderator: NorbertKrupa

rajaduraibanu
Newbie
Newbie
Posts: 19
Joined: Thu Aug 08, 2013 8:01 am

Unable to connect to db , while taking backup

Post by rajaduraibanu » Wed Sep 25, 2013 10:00 am

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 .
Last edited by rajaduraibanu on Wed Sep 25, 2013 10:13 am, edited 1 time in total.

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Unable to connect to db , while taking backup

Post by id10t » Wed Sep 25, 2013 10:04 am

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.

rajaduraibanu
Newbie
Newbie
Posts: 19
Joined: Thu Aug 08, 2013 8:01 am

Re: Unable to connect to db , while taking backup

Post by rajaduraibanu » Wed Sep 25, 2013 12:40 pm

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!

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Unable to connect to db , while taking backup

Post by id10t » Wed Sep 25, 2013 1:12 pm

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?

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Unable to connect to db , while taking backup

Post by id10t » Thu Sep 26, 2013 12:05 am

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

Code: Select all

> vbr.py --setupconfig
...
Specify objects (no default): 
...
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

banurajadurai
Newbie
Newbie
Posts: 21
Joined: Tue Aug 27, 2013 10:31 am

Re: Unable to connect to db , while taking backup

Post by banurajadurai » Thu Sep 26, 2013 9:54 am

Thanku :) Now its working fine ..

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

rajaduraibanu
Newbie
Newbie
Posts: 19
Joined: Thu Aug 08, 2013 8:01 am

Re: Unable to connect to db , while taking backup

Post by rajaduraibanu » Thu Sep 26, 2013 12:23 pm

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 .

Post Reply

Return to “Vertica Backup & Recovery”