Hi, We recently started getting intermittent timeouts on primary key queries (select * from table where key=<key>)
The error is : com.datastax.driver.core.exceptions.ReadTimeoutException: Cassandra timeout during read query at consistency LOCAL_QUORUM (2 responses were required but only 1 replica a responded) The same query would work fine when tried directly from cqlsh. There are no indications in system.log for the table in question, though there were compactions in progress for tables in another keyspace which is more frequently accessed. My understanding is that the chances of primary key queries timing out is very minimal. Please share the possible reasons / ways to debug this issue. We are using Cassandra 2.1 (DSE 4.8.7). Thanks, Joseph
