Geek Answers Handbook

Cassandra CQLSH OperationTimedOut error = Client request timeout. See Session.execute [_async] (timeout)

I want to transfer data from one cassandra cluster (reached through 192.168.0.200) to another cassandra cluster (reached through 127.0.0.1). The data is 523 lines, but each line is about 1 MB. I use the command COPY FROM and COPY TO. I get the following error when issuing the COPY TO command:

Error for (8948428671687021382, 9075041744804640605): OperationTimedOut - errors={ '192.168.0.200': 'Client request timeout. See Session.execute[_async](timeout)'}, last_host=192.168.0.200 (will try again later attempt 1 of 5).

I am tired of changing the ~/.cassandra/cqlshrc to:

 [connection] client_timeout = 5000

But it did not help. Thank you for your help.

+7
cassandra timeout cqlsh
source share
2 answers

It is not clear which version of Cassandra you are using here, so I'm going to assume 3.0.x

The COPY function is good, but not always the best choice (i.e. if you have a lot of data), however, for this, although you can check some of the cassandra timeout settings

The docs show a pagetimeout value that might help you.

Moving data between two clusters can be done in several other ways. You can use any of the following actions:

Of course, # 3 and # 4 need a DSE cassandra, but this is just to give you an idea. I was not sure if you were using Apache Cassandra or Datastax Enterprise Cassandra.

Anyway, hope this helps!

+1
source share

You can increase the timeout for the request (default: 10 seconds) rather than the connection timeout.

Try:

 cqlsh --request-timeout=6000
+3
source share

More articles:


All Articles