K-Safety Issue

sumi_kuma12

Hi Team,

Recently I added 2 more node in single node cluster. And now we have 3 node cluster up and running. Also data is distributed among the nodes as per below output.

node_name | RowCount | UsedGB | RosCount
-----------------+----------+----------------------------------------------------------+----------
v_pmdb_node0001 | 35281217 | 1.000000000000000000000000000000000000000000000000000000 | 402
v_pmdb_node0002 | 35255293 | 1.000000000000000000000000000000000000000000000000000000 | 371
v_pmdb_node0003 | 35438896 | 1.000000000000000000000000000000000000000000000000000000 | 414
(3 rows)

But Still when I tried to run below command" , it giving 0 output.

select DESIGNED_FAULT_TOLERANCE, CURRENT_FAULT_TOLERANCE from system;
DESIGNED_FAULT_TOLERANCE | CURRENT_FAULT_TOLERANCE
--------------------------+-------------------------
0 | 0
(1 row)

Also when it tried to set K-safety 1 from below command , it is giving buddy projection error to me.
pmdb=> SELECT MARK_DESIGN_KSAFE (1);

Current design does not meet the requirements for K = 1.
Current design is valid for K = 0.
Projection perfengine.TBL_super has insufficient buddy projections; it has 0 buddies
Projection perfengine.BSMINTSCOMMETRICS__SQL DB ENGINE_LOCKS_LOCK REQUESTS_SEC_super has insufficient buddy projections; it has 0 buddies
Projection perfengine.BSMINTSCOMMETRICS__LOGICALDISK__ FREE SPACE_super has insufficient buddy projections; it has 0 buddies
Projection perfengine.
(1 row)

How can i fix this issue ? If i create buddy projection as per above statement, will it resolve ?

I want K-Safety as 1.

Regards,
Sumit Kumar

[Deleted User]

Try running following API:

select dbd_add_nodes_rebalance_data(1);

Above API will add buddy projection to projections missing buddy . From above output two projections are missing buddy.

bhanu_kishore

please login as dbadmin user and execute below command.

=> SELECT MARK_DESIGN_KSAFE(1);

mark_design_ksafe

Marked design 1-safe
(1 row)

If the physical schema design is not K-Safe, messages indicate which projections do not have a buddy:

=> SELECT MARK_DESIGN_KSAFE(1);
The given K value is not correct;
the schema is 0-safe
Projection p1 has 0 buddies,
which is smaller that the given K of 1
Projection p2 has 0 buddies,
which is smaller that the given K of 1
.
.

If you get output similar to above execute below command

select dbd_add_nodes_rebalance_data(1);