dr_validate.message Checking ETL health. failed [FAIL]

Products

• CA Performance Management - Usage and Administration

Issue/Introduction

[root@server11 DR]# ./dr_validate.sh -p drinstall.properties
Log File: logs/install_log_validate_07-21-2022_12-02-48.log
===============================================================================
Checking Passwordless SSH to all hosts: server11 server12 server13
===============================================================================
Passwordless SSH from server11 to root@server11 .................[ OK ]
Passwordless SSH from server11 to root@server12 .................[ OK ]
Passwordless SSH from server11 to root@server13 .................[ OK ]
...
Verifying database connection properties. ...............................[ OK ]
Checking existing DB for ETL health.
WARNING 6046:  The database is currently 0-safe, which could result in catastrophic data loss in the event of a failure.  Do not use k=0 in a production environment. For test, dev or other non-production environments, K=0 may be acceptable however Vertica still recommends a minimum value of K=1
Fatal error, unable to create table qname_dups
WARNING 6046: The database is currently 0-safe, which could result in catastrophic data loss in the event of a failure. Do not use k=0 in a production environment. For test, dev or other non-production environments, K=0 may be acceptable however Vertica still recommends a minimum value of K=1
Checking ETL health. failed .............................................[FAIL]

Environment

Release : 21.2

Component : DR Storage

Cause

The database currently is 0 K-safe

Resolution

Please run these commands:

• Connect to vsql on the data repository
• SELECT current_fault_tolerance from system; 
• SELECT dbd_add_nodes_rebalance_data(1);
  • API will add buddy projection to projections missing buddy . 
• SELECT MARK_DESIGN_KSAFE(1);
• SELECT current_fault_tolerance from system;  ---> Should show a value of 1 now as opposed to 

After re-run the dr_validate