Shards will be relocated away from this node in ES


(narasiman) #1

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.


(Mark Walkom) #2

Have a look at https://www.elastic.co/guide/en/elasticsearch/reference/6.1/disk-allocator.html


(system) #3

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