Vertica Copycluster Error: Database path does not match on source

Products

• CA Performance Management - Usage and Administration

Issue/Introduction

Starting copy of database drdata.

Participating nodes: v_drdata_node0001, v_drdata_node0002, v_drdata_node0003.

Error: Database path does not match on source (v_drdata_node0001: /opt/CAcatalog/drdata/v_drdata_node0001_catalog) and destination (vm-capc-dr1: /mnt/CAcatalog/drdata/v_drdata_node0001_catalog) nodes.

Copycluster FAILED.

Cause

Copycluster FAILED due different storage_path

Source storage_path /opt/

Target storage_path /mnt

Environment

Release : 20.2

Component : PERFORMANCE MANAGEMENT INTEGRATIONS

Resolution

On Vertica target Server (All nodes) create a Linux symbolic link /opt/CAcatalog to /mnt/CAcatalog, and rebuild the database via admintools