Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

K-Safety Issue

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

Comments

  • skamatskamat Administrator

    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.

  • edited May 2017

    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);

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.