Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Query failing on a cluster with 2 nodes down
Hi, I have a cluster of 5 nodes (v6.1.2), with 2 nodes currently down. Elastic_cluster is enabled, all my design is ksafe=2. I would thus expect to be able to carry on working as usual for whichever 2 nodes down. I now have queries failing with the following error:
ERROR: Insufficient projections to answer query Detail: Path segment called for on node v_spil_dwh_node0003 can not be computednode3 is indeed one of the nodes down. I checked all the projections of the tables referenced in the query, they all are ksafe=2, I can select from all of them. There is nothing relevant I could find in the documentation. What could be the cause (and solution) of this? Thanks, Guillaume