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

**URL:** <https://discuss.elastic.co/t/logstash-outputs-elasticsearch-attempted-to-resurrect-connection-to-dead-es-instance/216027>\
**Category:** Logstash\
**Created:** [January 22, 2020, 10:15am UTC](https://discuss.elastic.co/t/logstash-outputs-elasticsearch-attempted-to-resurrect-connection-to-dead-es-instance/216027 "2020-01-22T10:15:08Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![pyerunka](https://avatars.discourse-cdn.com/v4/letter/p/d6d6ee/32.png) [@pyerunka](https://discuss.elastic.co/u/pyerunka)\
**Post date:** [January 22, 2020, 10:15am UTC](https://discuss.elastic.co/t/logstash-outputs-elasticsearch-attempted-to-resurrect-connection-to-dead-es-instance/216027/1 "2020-01-22T10:15:08Z")

</div>

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/](http://127.0.0.1:9200/)", :error\_type=\>LogStash::Outputs::Elasticsearch::HttpClient::Pool::HostUnreachableError, :error=\>"Elasticsearch Unreachable: [[http://127.0.0.1:9200/](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

---

<div class="post-metadata">

**Author:** ![francescouk](https://avatars.discourse-cdn.com/v4/letter/f/7feea3/32.png) [@francescouk](https://discuss.elastic.co/u/francescouk)\
**Post date:** [January 22, 2020, 1:36pm UTC](https://discuss.elastic.co/t/logstash-outputs-elasticsearch-attempted-to-resurrect-connection-to-dead-es-instance/216027/2 "2020-01-22T13:36:09Z")

</div>

> [@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.

---

<div class="post-metadata">

**Author:** ![pyerunka](https://avatars.discourse-cdn.com/v4/letter/p/d6d6ee/32.png) [@pyerunka](https://discuss.elastic.co/u/pyerunka)\
**Post date:** [January 22, 2020, 1:53pm UTC](https://discuss.elastic.co/t/logstash-outputs-elasticsearch-attempted-to-resurrect-connection-to-dead-es-instance/216027/3 "2020-01-22T13:53:11Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![francescouk](https://avatars.discourse-cdn.com/v4/letter/f/7feea3/32.png) [@francescouk](https://discuss.elastic.co/u/francescouk)\
**Post date:** [January 22, 2020, 2:05pm UTC](https://discuss.elastic.co/t/logstash-outputs-elasticsearch-attempted-to-resurrect-connection-to-dead-es-instance/216027/4 "2020-01-22T14:05:48Z")

</div>

> [@pyerunka](#):
>
> output{  
> elasticsearch {  
> index =\> "new\_database"  
> }  
> }

How bout that:

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

```

---

<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:** [February 19, 2020, 2:05pm UTC](https://discuss.elastic.co/t/logstash-outputs-elasticsearch-attempted-to-resurrect-connection-to-dead-es-instance/216027/5 "2020-02-19T14:05:58Z")

</div>

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