Hi List,
I am hiving issue in setting ksafe value to 1 for my database in a 3 node Vertica cluster. Looks like there is some issue in the existing database design? This database has been designed by a 3rd party software and I don't have much control.
In fact, I am worried about the warning, Your answer and advice will be a great help for me.
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.
In fact, I tried to set using below command
appdefenderdb=> SELECT MARK_DESIGN_KSAFE(1); but get error as mentioned below. Looks like it required buddy projections.
Thanks in advance,
SM
Please find the error below.
appdefenderdb=> SELECT MARK_DESIGN_KSAFE(1);
MARK_DESIGN_KSAFE
Current design does not meet the requirements for K = 1.
Current design is valid for K = 0.
Projection td67563fd3a224ee0ba27db536deccb6b.schema_version_super has insufficient buddy projections; it has 0 buddies
Projection td67563fd3a224ee0ba27db536deccb6b.security_events_super has insufficient buddy projections; it has 0 buddies
Projection td67563fd3a224ee0ba27db536deccb6b.security_events_map_super has insufficient buddy projections; it has 0 buddies
Projection td67563fd3a224ee0ba27db536deccb6b.security_events_flownode_super has insufficient buddy projections; it has 0 buddies
Projection td67563fd3a224ee0ba27db536deccb6b.security_events_fn_trace_super has insufficient buddy projections; it has 0 buddies
Projection td67563fd3a224ee0ba27db536deccb6b.monitor_events_count_super has insufficient buddy projections; it has 0 buddies
Projection td67563fd3a224ee0ba27db536deccb6b.security_events_unexpected_super has insufficient buddy projections; it has 0 buddies
Projection td67563fd3a224ee0ba27db536deccb6b.monitor_events_unexpected_super has insufficient buddy projections; it has 0 buddies
Projection td67563fd3a224ee0ba27db536deccb6b.vulnerability_super has insufficient buddy projections; it has 0 buddies
Projection td67563fd3a224ee0ba27db536deccb6b.iast_events_super has insufficient buddy projections; it has 0 buddies
Projection td67563fd3a224ee0ba27db536deccb6b.iast_events_map_super has insufficient buddy projections; it has 0 buddies
Projection td67563fd3a224ee0ba27db536deccb6b.iast_events_flownode_super has insufficient buddy projections; it has 0 buddies
Projection td67563fd3a224ee0ba27db536deccb6b.iast_events_fn_trace_super has insufficient buddy projections; it has 0 buddies
Projection td67563fd3a224ee0ba27db536deccb6b.iast_events_tagsource_super has insufficient buddy projections; it has 0 buddies
Projection td67563fd3a224ee0ba27db536deccb6b.vulnerability_delta_super has insufficient buddy projections; it has 0 buddies
Projection t02f59f138ef343f3880f1c8a68efd676.schema_version_super has insuffici
(1 row)
appdefenderdb=> SELECT IS_REBALANCE_RUNNING FROM ELASTIC_CLUSTER;
IS_REBALANCE_RUNNING
f
(1 row)
