Hey Guys,
Have you guys ever seen this error response from Cassandra when trying a query?
“Server failure during read query at consistency One (1 response(s) were required but only 0 replica(s) responded, 1 failed)”
From some researching, it looks like it has to do with Tombstones. But I’m not quite sure how to address it, as the same exact query works fine on my local DMA and a few others that I’ve tried this on, but not in this customer who has a BIG database.
In general terms the error means that not enough nodes managed to respond to satisfy the threshold for a successful query. In this case only 1 node needed to respond but it did not. This can be due a number of issues, tombstones being one of them. The best way to investigate this is to look in the system.log of Cassandra. Around the time of the query failure you should see a logline with “query aborted”. This logline will also tell you the reason for the query failure which then can be used to fix the issue. On a side note, which query did you try to launch? Certain queries are not recommended to be launched and will more often than not fail.