We are seeing that even if the servers are down, t...
# troubleshooting
s
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.
m
It should return metadata stating that the result is partial. Client should check on that metadata.
s
i dont see any metadata stating that.. can you please suggest which parameter should say that?
m
Can you select “Show JSON format”
s
partialresponse column is empty.
m
What about servers queried and responded?
s
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
m
If it is both 2, then the data for query is available
Can you paste the text (not screenshot)?
s
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
n
do you have replication of 2?
s
We have replication of 3. Overall 12 servers.. 4 servers per replica group
n
the query is a group by-order by query or aggregation only?
s
Aggregation only..no group by
n
can you check brokerResource external view, and see if the servers mapped to this table are incomplete?