The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

KSafe setting error - ( Urgent )

edited February 10 in General Discussion

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)

Best Answer

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.