The DB is 0-safe after adding nodes

Products

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

Issue/Introduction

I was adding new nodes to a vertica cluster and made a typo in creating the new projection and no the database will not go into K=1 mode.

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

Cause

dadaemon on the Data Aggregator was running

Resolution

Stop dadaemon on the Data Aggregator and create the projection again

CREATE PROJECTION daadmin.migration_status_super_b1( migration_id, last_start_time, last_failure_time, complete_time, last_status_message)AS SELECT migration_status.migration_id,        migration_status.last_start_time,        migration_status.last_failure_time,        migration_status.complete_time,        migration_status.last_status_message FROM daadmin.migration_status ORDER BY migration_status.migration_id,          migration_status.last_start_time,          migration_status.last_failure_time,          migration_status.complete_time,          migration_status.last_status_messageSEGMENTED BY hash(migration_status.last_start_time, migration_status.last_failure_time, migration_status.complete_time, migration_status.migration_id, migration_status.last_status_message) ALL NODES OFFSET 1;SELECT START_REFRESH();

then you can do after a minute at most...

SELECT MARK_DESIGN_KSAFE(1);