K-safety

abhishek_1

Hi,

I am using 3 node cluster with the k-safe value  1.
For some testing purpose, k-safe value was brought down to 0. select mark_design_ksafe(0);

Now I want to bring the k-safe back to 1 .
I tried with the SQL: select mark_design_ksafe(1); but it's not working.
I am getting the below message:
 
"Current design does not meet the requirements for K = 1.Current design is valid for K = 0."

Projection test.emp_super has insufficient buddy projections; it has 0 buddies
Projection abhi.emp_super has insufficient buddy projections; it has 0 buddies
.
.
....

There are many such projections.

Is there any way round to bring the k-safe back to 1?


Thanks in advance !

[Deleted User]

Hi,

It means that you need to create buddy projections for all these projetions listed in mark_design_ksafe output.  Vertica documentation discusses this in section "Desinging Segmented Projections for K-Safety".

Administrator's Guide --> Configuring the Database --> Creating a Database Design --> Creating Custom designs --> Planning your design --> Desinging Segmented Projections for K-Safety.

Create buddy projections for all these projections without buddies and then run mark_Design_ksafe() again. 

Thanks.