Sounds like you're writing at ONE and reading at LOCAL_QUORUM.
If you call your hosts A,B,C
Your write lands on B
If your query hits A and C, you return 0 rows.
If your query hits A and B or B and C, you return 1 row AND (as a side
effect) the row is copied to either A or C (depending on which p
Cluster setup …
- C* 2.2.8
- Three RACs, one DC
- Keyspace with RF=3
- RS = Network topology
At CL=LQ …
I get zero rows on first attempt, and one row on the second or third. Once
found, I always get the row afterwards.
Trying to understand this behavior …
First attempt, my read request hits
