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 .
Unable to connect to db , while taking backup
Moderator: NorbertKrupa
-
- Newbie
- Posts: 19
- Joined: Thu Aug 08, 2013 8:01 am
Unable to connect to db , while taking backup
Last edited by rajaduraibanu on Wed Sep 25, 2013 10:13 am, edited 1 time in total.
Re: Unable to connect to db , while taking backup
Hi!
Check passwordless ssh connection.
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.
-
- Newbie
- Posts: 19
- Joined: Thu Aug 08, 2013 8:01 am
Re: Unable to connect to db , while taking backup
hi , i created password less ssh connection even then getting same error ![Sad :(](./images/smilies/icon_e_sad.gif)
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!
![Sad :(](./images/smilies/icon_e_sad.gif)
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!
Re: Unable to connect to db , while taking backup
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?
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?
Re: Unable to connect to db , while taking backup
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
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
-
- Newbie
- Posts: 21
- Joined: Tue Aug 27, 2013 10:31 am
Re: Unable to connect to db , while taking backup
Thanku
Now its working fine ..
Sorry for confusion , me and my colleague was working on this so bit confusion![Smile :)](./images/smilies/icon_e_smile.gif)
Banu Rajadurai
![Smile :)](./images/smilies/icon_e_smile.gif)
Sorry for confusion , me and my colleague was working on this so bit confusion
![Smile :)](./images/smilies/icon_e_smile.gif)
Banu Rajadurai
-
- Newbie
- Posts: 19
- Joined: Thu Aug 08, 2013 8:01 am
Re: Unable to connect to db , while taking backup
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 .
i mean i took backup of tdadb database , i want to restore it with new name .