DR upgrade is failing - dr_install.sh is trying to create new Vertica 23.4.0 db

Products

• DX NetOps
• CA Performance Management - Usage and Administration

Issue/Introduction

Upgrading Data Repository DR from 23.3.8 (Vertica 10.1.1-20) to 23.3.13 (Vertica 23.4.0).

The dr_install.sh is trying to create a new Vertica 23.4.0 drdata database.

Create Vertica Database

Creating Vertica database: drdata on host(s): <DR_hostname> using data directory: /data and catalog directory: /catalog
A database with this name (drdata) already exists.
Creating Vertica database failed

Environment

DX NetOps Performance Management: Any version

Cause

The /opt/vertica/config/admintools/.conf file has this entry:

[Nodes]
node0001 = xx.yy.ww.zz,/data,/data
v_drdata_node0001 = xx.yy.ww.zz,/data,/data

The 2nd argument (/data) is catalog and 3rd argument (/data) is data dir.

 

The drinstall.properties file has an incorrect entry:

The DbCatalogDir=/catalog

parameter must be /data rather than /catalog.

Resolution

Edit the drinstall.properties file and change to:

 DbCatalogDir=/data