[logstash.outputs.elasticsearch] Attempted to resurrect connection to dead ES instance


I am trying to use jdbc input plugin using logstash so that i can fetch data from sql database and create the index.
But when i am running config file for logstash. It is showing me below error:

[2020-01-22T10:04:27,133][WARN ][logstash.outputs.elasticsearch][main] Attempted to resurrect connection to dead ES instance,
but got an error. {:url=>"", :error_type=>LogStash::Outputs::ElasticSearch::HttpClient::Pool::HostUnreachableError, :error=>"Elasticsearch Unreachable: [][Manticore::SocketException] Connection refused: connect"}

I have clustering enable with 3 nodes.
Can anyone guide me on the same?


I had a similar situation yesterday. The problem was on my output config. If you want to share urs, I may be abble to help.

Hello @francescouk,

Please find below config file:

input {
jdbc {
jdbc_driver_library => "E:\oracle\product\12.2.0\client_1\jdbc\ojdbc8.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "db connection string"
jdbc_user => "username"
jdbc_password => "password"
statement => "sql statement"
last_run_metadata_path => "E:/usr/share/logstash/last_run_metadata/Master.txt"
use_column_value => true
tracking_column => "version"
schedule=> "0 * * * *"
elasticsearch {
index => "new_database"


How bout that:

output {
elasticsearch {
hosts => ["http://localhost:9200"]
index => "new_database"

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