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

[pyerunka (Priyanka)]

Hello,

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=>"http://127.0.0.1:9200/", :error_type=>LogStash::Outputs::Elasticsearch::HttpClient::Pool::HostUnreachableError, :error=>"Elasticsearch Unreachable: [http://127.0.0.1:9200/][Manticore::SocketException] Connection refused: connect"}

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

Reagrds,
Priyanka

[francescouk (Francesco Ferrari)]

@pyerunka

use jdbc input plugin using logstash so that i can fetch

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.

[pyerunka (Priyanka)]

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 * * * *"
}
}
output{
elasticsearch {
index => "new_database"
}
}

Regards,
Priyanka

[francescouk (Francesco Ferrari)]

@pyerunka

output{
elasticsearch {
index => "new_database"
}
}

How bout that:

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