backup Vertica 8.01 DB
Hi,
I used vbr utility to do the fully db backup and got the following message "Error: Error in snapshot manifest file: Malformed storage location line: 45035996273704984, dbfile/obrdb/v_obrdb_node0001_data", I would appreciate if someone can help me solve this issue. Thanks.
0
Comments
Can you post the config file?
Hi,
The following is the config file. Thanks.
Hi,
Is it possible the config file is not the root cause ? since I found the location_path is dbfile/obrdb/v_obrdb_node0001_data thru the sql statement select * from storage_locations or the storage_path is dbfile/obrdb/v_obrdb_node0001_data thru the sql statement select * from disk_storage, those paths don't show the full paths, because I'm a newbie and don't know why only the backup process has the error and it doesn't affect other db processes. Thanks.
You've unfortunately hit a bug in vbr; it does not correctly handle storage locations defined with relative paths. There's an issue filed and hopefully it will be fixed in an upcoming release.
For now, if possible I'd suggest that you migrate any data from this storage location to one with an absolute path, and drop the problematic location with the relative path. Using a relative path will put your data storage location underneath your catalog directory, which likely undesirable for other reasons as well.
Okay, Thanks for your information.