The copycluster task is failing

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration

Issue/Introduction

The copycluster task:

 

$ vbr.py --task copycluster --config-file copy_drdata.ini

 

Gets the Error:

ERROR 5127: Unable to create snapshot Could not link file [/data/drdata/v_drdata_node0003_catalog/Snapshots/ccs/data/drdata/v_drdata_node0003_catalog/Libraries/public_ApproximateLib_45035999976066596.so] to [/data/drdata/v_drdata_node0003_catalog/Libraries/public_ApproximateLib_45035999976066596.so]: No such file or directory

Environment

Any Vertica DB Version

Cause

There are missing Libraries and mismatching versions

Resolution

Command to check what is the missing Libraries and check versions:

 

SELECT lib_name, sdk_version FROM user_libraries;

 

Find the install.sql under /opt/vertica/packages/xxx/ddl

Finally run:

admintools -t install_package -d db-name -p password -P all --force-reinstall, it will reinstall all packages.