We are seeing that even if the servers are down, the query execution still succeeds and returns the output based on incomplete data on other available servers. This makes the system unstable. How can we ensure that the query fails if any server is down and not query on the incomplete dataset. Thank you.

It should return metadata stating that the result is partial. Client should check on that metadata.

i dont see any metadata stating that.. can you please suggest which parameter should say that?

Can you select “Show JSON format”

partialresponse column is empty.

What about servers queried and responded?

its both 2.. as seen in first snapshot. but we have 4 servers.. so this is not helpful either.. as it doesnt tell if its partial

If it is both 2, then the data for query is available

no the query had no filters and its supposed to scan all 3.5 million rows but it only scanned half of it as seen in snapshot.. i didnt save the output of text.. just have the screen shot.. unable to reproduce again as server was restarted now

do you have replication of 2?

We have replication of 3. Overall 12 servers.. 4 servers per replica group

the query is a group by-order by query or aggregation only?

Aggregation only..no group by

can you check brokerResource external view, and see if the servers mapped to this table are incomplete?