Cassandra: Request did not complete within rpc_timeout

cassandraexceptionquery-timeout

i was working with Cassandra 1.2.4 probably, after restoring some key-space when i tried to query in a key-space it gave me Request did not complete within rpc_timeout

so i checked system.log & output.log under /var/log/cassandra path

i just find this exception:

Exception in thread Thread[ReadStage:42,5,main] java.lang.RuntimeException: org.apache.cassandra.io.sstable.CorruptSSTableException: java.io.EOFException

what is the reason ? and how can i get rid of rpc_timeout

thanks in advance,

Best Answer

From the EOFException I take it that your problem is not the rpc_timeout but a corrupt data file. And it seams that Cassandra is not properly handling the exception and never returns the error to the piece of server code that "holds" your client connection and waits for data to send back to the client. Thus the timeout.

You could try and run nodetool repair <your_keyspace>. Maybe it is able to fix the corrupted data file. If not, try to drop the keyspace and restore it again.

To answer your question. The timeouts are set in the cassandra.yaml file in the config directory of your cassandra installation on each node.