Skip to main content

ERROR Cannot plan query because no super projections are safe

  • December 10, 2017
  • 3 replies
  • 16 views

sreediff
Forum|alt.badge.img

When I try to access any table getting error ERROR: Cannot plan query because no super projections are safe, some node(s) are down ---> Vertica.Data.Internal.Util.ServerException: ERROR: Cannot plan query because no super projections are safe, some node(s) are down .

tried to get list of projections with ksafe issue using select projection_schema, projection_name, anchor_table_name from v_catalog.projections where verified_fault_tolerance = 0; but this gave big list.
Tried to run admintools -t rebalance_data -k 1 -d -p < password> but still error persists . Is there anything else needed to fix this error? currently ksafe is set to 1

3 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • December 10, 2017

See if you ca figure out which node(s) are down.

admintools -t list_allnodes


sreediff
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • December 11, 2017

Hi Jim, I checked and all 3 nodes are up


Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • December 12, 2017

Hmm.

Make sure the designed and current fault tolerances are the same:

select designed_fault_tolerance, current_fault_tolerance from system;

Per the doc, the value of verified_fault_tolerance in the v_catalog.projections table cannot be < than the database K-safe setting...

See:
https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/SQLReferenceManual/SystemTables/CATALOG/PROJECTIONS.htm