# Shards will be relocated away from this node in ES

**URL:** <https://discuss.elastic.co/t/shards-will-be-relocated-away-from-this-node-in-es/112745>\
**Category:** Elasticsearch\
**Created:** [December 21, 2017, 4:49am UTC](https://discuss.elastic.co/t/shards-will-be-relocated-away-from-this-node-in-es/112745 "2017-12-21T04:49:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![narasiman1986](https://avatars.discourse-cdn.com/v4/letter/n/ce73a5/32.png) [@narasiman1986](https://discuss.elastic.co/u/narasiman1986)\
**Post date:** [December 21, 2017, 4:49am UTC](https://discuss.elastic.co/t/shards-will-be-relocated-away-from-this-node-in-es/112745/1 "2017-12-21T04:49:42Z")

</div>

i am displaying the records from mysql to elastic search through logstash and GUI kibana

In logstash config file code as follows

```
input {

jdbc {

jdbc_driver_library => "D:\mysql-connector-java-5.1.44\mysql-connector-java-5.1.44\mysql-connector-java-5.1.44-bin.jar"

jdbc_driver_class => "com.mysql.jdbc.Driver"

 
jdbc_connection_string => "jdbc:mysql://localhost:3306/sample"

  
jdbc_user => "root"

jdbc_password => "root"

jdbc_fetch_size => 5000

    schedule => "* * * * *"
    statement => "select * from patdetails order by mrno asc limit 15"

codec => "json"

  }

}

output {

elasticsearch { 
hosts => ["localhost:9200"] 
index => "testingsample" 
document_id => "%{mrno }" }
stdout { codec => rubydebug }
}

```

in kibana GUI displaying only 8 records

inkibana discover tab shows 8 hits and kibana GUI also displaying 8 records only but in logstash config file i written code as select \* from patdetails order by mrno asc limit 15

display 15 reords

when i see the elastic search log file shows message as follows

[INFO] [high disk watermark exceeded on one or more nodes]

[WARN] high disk watermark [90%] exceeded on shards will be relocated away from this node

INFO and WARN. why 15 records is not displaying in Kibana GUI.

how to solve this problem please let me know.

---

<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:** [December 21, 2017, 5:40am UTC](https://discuss.elastic.co/t/shards-will-be-relocated-away-from-this-node-in-es/112745/2 "2017-12-21T05:40:17Z")

</div>

> [@narasiman1986](#):
>
> [WARN] high disk watermark [90%] exceeded on shards will be relocated away from this node

Have a look at [Disk-based Shard Allocation | Elasticsearch Reference [6.1] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/6.1/disk-allocator.html)

---

<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:** [January 18, 2018, 5:40am UTC](https://discuss.elastic.co/t/shards-will-be-relocated-away-from-this-node-in-es/112745/3 "2018-01-18T05:40:22Z")

</div>

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