Options

KSafe setting error - ( Urgent )

msanjibmsanjib Vertica Customer
edited February 2020 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

Answers

  • Options
    joergschaberjoergschaber Vertica Customer
    edited May 2023

    Hi, I am having the same problem. When I run
    admintools -t rebalance_data -d <<db_name>> -k 1
    I get
    STATUS: vertica.engine.api.db_client.module is still running on 1 host: xxx as of 2023-05-05 12:02:13. See /opt/vertica/log/adminTools.log for full details.

    And eventually
    Data rebalance was canceled or failed: DB client operation "Rebalance cluster" failed duringadd_node_rebalance: Severity: ERROR, Message: Rebalance data failed during select mark_design_ksafe(1), Sqlstate: VD001, Routine: dbd_add_nodes_rebalance_data, File: /data/jenkins/workspace/RE-ReleaseBuilds/RE-Knuckleboom_2/server/vertica/DBDesigner/D4_DBDFunctions.cpp, Line: 2960, Error Code: 4526, SQL: 'select dbd_add_nodes_rebalance_data(1);'

    What might be the problem here?

  • Options
    SruthiASruthiA Vertica Employee Administrator

    Are you adding nodes to single node database? Why are you rebalancing the data manually?

Leave a Comment

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