Search code examples
cassandratimeoutcqlshoperation

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

I want to transfer data from one Cassandra cluster (reached via 192.168.0.200) to another Cassandra cluster (reached via 127.0.0.1). The data is 523 rows but each row is about 1 MB. I am using the COPY FROM and COPY TO command. I get the following error when I issue 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 tried to change the ~/.cassandra/cqlshrc file to:

[connection]
client_timeout = 5000

But this hasn't helped.

Solution

  • It's not clear which version of Cassandra you're 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 though you might want to check some of your timeout settings in cassandra

    The docs here show a pagetimeout setting too which may help you.

    Moving data between two clusters can be done a number of other ways. You could use of any of the following:

    1. The sstableloader
    2. One of the drivers like the java driver
    3. Using spark to copy data from one cluster to another, like in this example
    4. Using OpsCenter to clone a cluster
    5. The cassandra bulk loader (I've known a number of people to use this)

    Of course #3 and #4 need DSE cassandra but its just to give you an idea. I wasn't sure if you were using Apache Cassandra or Datastax Enterprise Cassandra.

    Anyway, hope this helps!