Projection cannot be dropped because K-safety would be violated - Error Code: 44

  • Document ID:KM03253940
  • Creation Date:26-Sep-2018
  • Modified Date:26-Sep-2018
    • Micro Focus Products:
      vertica

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

cannot be dropped because K-safety would be violated

Question

[Error Code: 4455, SQL State: 55006] [Vertica][VJDBC](4455) ROLLBACK: Projection PROJ_TABLE_b0 cannot be dropped because K-safety would be violated
[Vertica][VJDBC]Detail: Current K-safety value = 1

Answer

You cannot drop one of the projections of the pair because the other projection of the pair would not have a buddy for a K=1 cluster. The solution is to drop both at once so that the projections always remain k-safe with proper buddies.


drop projection salesforce_b0, salesforce_b1;