backup Vertica 8.01 DB

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.


  • Jim_KnicelyJim_Knicely - Select Field - Administrator
    edited November 2017

    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.

  • jheffnerjheffner Employee
    edited November 2017

    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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file