hi,
threre are many warning logs in my cassandra cluster:
"Replica filtering protection has cached over 2000 rows during query SELECT * FROM ..."
what does this warning logs mean?
Thanks
This question was
closed
by
Erick Ramirez for the following reason: The question is answered, right answer was accepted
What is replica filtering protection?
Replica filtering protection is a mechanism that ensures results from stale replicas for read consistency levels higher than ONE or LOCAL_ONE do not violate the required consistency. This only applies to (a) secondary index queries or (b) queries using ALLOW FILTERING
If you still have issue, you can get help from paintball at truepaintballer for detailed answer.
Replica filtering protection is a mechanism that ensures results from stale replicas for read consistency levels higher than ONE or LOCAL_ONE do not violate the required consistency. This only applies to (a) secondary index queries or (b) queries using ALLOW FILTERING.
You are getting the warning because your nodes are out-of-sync, most likely because they are overloaded and cannot keep up with writes so have lots of dropped mutations. For details, see CASSANDRA-8272 and CASSANDRA-15907.
You need to repair the problematic table to synchronise the replicas. You should also consider increasing the capacity of your cluster by adding more nodes so you don't end up with thousands of dropped mutations.
As a side note, you should not use ALLOW FILTERING without restricting the query to a single partition. Otherwise, it will not perform well and its behaviour can be unpredictable. Cheers!
Republished to DBA Stack Exchange.
8 People are following this question.
