Cassandra CQLSH OperationTimedOut error =客户端请求超时.请参见Session.execute [_async](超时) [英] Cassandra CQLSH OperationTimedOut error=Client request timeout. See Session.execute[_async](timeout)

问题描述

我想将数据从一个Cassandra群集(通过192.168.0.200到达)传输到另一个Cassandra群集(通过127.0.0.1到达).数据为523行，但每行约为1 MB.我正在使用COPY FROM和COPY TO命令.发出COPY TO命令时出现以下错误:

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).

我试图将~/.cassandra/cqlshrc文件更改为:

[connection]
client_timeout = 5000

但这没有帮助.

推荐答案

目前尚不清楚您在使用哪个版本的Cassandra，因此我假设使用3.0.x

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

COPY功能不错，但并非总是最佳选择(例如，如果您有大量数据)，但是为此，您可能要检查一些

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

此处的文档显示 pagetimeout 设置也可能会对您有所帮助.

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. sstableloader
2. 其中一种驱动程序，例如 java驱动程序
3. 使用spark将数据从一个群集复制到另一个群集，如本例中所示，
4. 使用OpsCenter 克隆群集
5. cassandra散装机(我知道有很多人在使用它)

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)

当然，#3和#4需要DSE cassandra，但这只是为了给您一个想法.我不确定您使用的是Apache Cassandra还是Datastax Enterprise Cassandra.

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!

这篇关于Cassandra CQLSH OperationTimedOut error =客户端请求超时.请参见Session.execute [_async](超时)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！