How to trace the fail reads, like select query? What keys are failing?
I’m not sure what you mean by “What keys are failing”.
There are different options for Tracing in ScyllaDB, read more about it here.
Need to trace which key’s or queries are failing.