KSafe setting error - ( Urgent )

msanjib

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)

Jim_Knicely

Hi,
Can you run admintools? You will need to be the admin user (i.e. dbadmin). If so, this command will fix the issue by creating the necessary buddy projections for K-Safety = 1:

admintools -t rebalance_data -d <<db_name>> -k 1

See:
https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/AdministratorsGuide/AdminTools/WritingAdministrationToolsScripts.htm

What does this query return?

SELECT designed_fault_tolerance, current_fault_tolerance, node_count, node_down_count FROM system;

joergschaber

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?

SruthiA

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