# Cluster stops responding when transferring data to relational index

**URL:** <https://discuss.elastic.co/t/cluster-stops-responding-when-transferring-data-to-relational-index/271332>\
**Category:** Elasticsearch\
**Created:** [April 27, 2021, 8:29am UTC](https://discuss.elastic.co/t/cluster-stops-responding-when-transferring-data-to-relational-index/271332 "2021-04-27T08:29:20Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![RusseL](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/russel/32/77328_2.png) [@RusseL](https://discuss.elastic.co/u/RusseL)\
**Post date:** [April 27, 2021, 8:29am UTC](https://discuss.elastic.co/t/cluster-stops-responding-when-transferring-data-to-relational-index/271332/1 "2021-04-27T08:29:20Z")

</div>

Hi everyone. I have a cluster of 3 main 13 data nodes. I have a relational index of 40 shards in this set. '[ERROR] [o.e.x.m.c.c.ClusterStatsCollector] [main-3] collector [cluster\_stats] timed out while collecting data' and '  
[ERROR] [o.e.x.m.c.i.IndexStatsCollector] [main-3] collector [index statistics] timed out collecting data errors while transferring data to this directory, and after a while the cluster stopped responding.

 ![discuss](https://us1.discourse-cdn.com/elastic/original/3X/9/5/953d5dcf8f525720578023eaa4475e94a55f6e7d.png)

Soon after I stopped transfering data, the cluster returns to normal.

I don't know if it helps or not. I'm a newcomer to elasticsearch. Could it have something to do with the situation in the GET \_cat / thread\_pool output?

![thread_pool](https://us1.discourse-cdn.com/elastic/original/3X/7/e/7ed82423b2cf2f8e1b067673cab96965dfe5afbe.png)

Please tell me if you want more details.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [April 28, 2021, 1:30am UTC](https://discuss.elastic.co/t/cluster-stops-responding-when-transferring-data-to-relational-index/271332/2 "2021-04-28T01:30:32Z")

</div>

There's not a lot here to go on unfortunately.

> [@RusseL](#):
>
> Soon after I stopped transfering data, the cluster returns to normal.

What do you mean by this? Transferring the data how?

What is the output from the `_cluster/stats?pretty&human` API?

---

<div class="post-metadata">

**Author:** ![RusseL](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/russel/32/77328_2.png) [@RusseL](https://discuss.elastic.co/u/RusseL)\
**Post date:** [April 28, 2021, 7:20am UTC](https://discuss.elastic.co/t/cluster-stops-responding-when-transferring-data-to-relational-index/271332/3 "2021-04-28T07:20:37Z")

</div>

> [@warkolm](#):
>
> What do you mean by this? Transferring the data how?

Data indexing process. We transfer data from SQL Server to Elasticsearch with a c # program that uses the NEST library. The program is doing data indexing. However, we have been experiencing breaks while transferring data to the relational index recently. Some nodes leave the cluster if we do not close the program when we experience interruptions while performing data indexing.

> [@warkolm](#):
>
> What is the output from the `_cluster/stats?pretty&human` API?

\_cluster / stats output I shared here. Please tell me if you want more details.

> <https://github.com/Resul-Hasturk/Elasticsearch/blob/main/_cluster/stats2>

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [April 28, 2021, 11:52pm UTC](https://discuss.elastic.co/t/cluster-stops-responding-when-transferring-data-to-relational-index/271332/4 "2021-04-28T23:52:11Z")

</div>

Are you using `_bulk` in your code?

```
"versions" : [
      "7.4.2"
    ],

```

FYI 7.4 is now [EOL](https://www.elastic.co/support/eol), please upgrade.

```
"jvm" : {
      "max_uptime" : "477.5d",
      "max_uptime_in_millis" : 41262132073,
      "versions" : [
        {
          "version" : "13.0.1",
          "vm_name" : "OpenJDK 64-Bit Server VM",
          "vm_version" : "13.0.1+9",
          "vm_vendor" : "AdoptOpenJDK",
          "bundled_jdk" : true,
          "using_bundled_jdk" : true,
          "count" : 16
        }
      ],

```

Also please upgrade your JVM.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 26, 2021, 11:52pm UTC](https://discuss.elastic.co/t/cluster-stops-responding-when-transferring-data-to-relational-index/271332/5 "2021-05-26T23:52:59Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.