# Logstash get stuck after Successfully started Logstash API endpoint {:port=\>9600}

**URL:** <https://discuss.elastic.co/t/logstash-get-stuck-after-successfully-started-logstash-api-endpoint-port-9600/171870>\
**Category:** Logstash\
**Created:** [March 12, 2019, 6:36am UTC](https://discuss.elastic.co/t/logstash-get-stuck-after-successfully-started-logstash-api-endpoint-port-9600/171870 "2019-03-12T06:36:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mandar.raj](https://avatars.discourse-cdn.com/v4/letter/m/82dd89/32.png) [@mandar.raj](https://discuss.elastic.co/u/mandar.raj)\
**Post date:** [March 12, 2019, 6:36am UTC](https://discuss.elastic.co/t/logstash-get-stuck-after-successfully-started-logstash-api-endpoint-port-9600/171870/1 "2019-03-12T06:36:54Z")

</div>

When i run config file it stucks at Successfully started Logstash API endpoint {:port=\>9600}, Nothing happens after this. Could you please help me to resolve this. Earlier it was working fine with this config

My Config file is as below  
input {  
jdbc {  
#input Configuration  
jdbc\_connection\_string =\> "jdbc:oracle:thin:@sgtd37-scan.net:8889/CWS"  
jdbc\_user =\> "ACT\_TM"  
jdbc\_password =\> "\*\*\*\*\*_"  
jdbc\_driver\_library =\> "I:\Jars\ojdbc6.jar"  
jdbc\_driver\_class =\> "Java::oracle.jdbc.driver.OracleDriver"  
statement =\> "select ALERT\_ID, regexp\_replace(regexp\_substr(html\_file\_key,'\<elem name="alertDate"\>(._?)'),'\<elem name="alertDate"\>|','') as alertDate from alerts where DELETED =0 and rownum\<=100000 order by create\_date desc"

```
	}

```

}

output {  
elasticsearch {  
#output configuration  
hosts =\> "[http://localhost:9200](http://localhost:9200)"  
index =\> "alert\_index"  
document\_type =\> "alert"  
#document\_id =\> "%{alert\_internal\_id}"  
}  
stdout{  
codec =\> rubydebug  
{  
metadata =\> true  
}  
}  
}

Logs:  
[2019-03-12T12:03:01,988][INFO][logstash.pipeline] Starting pipeline {:pipeline\_id=\>"main", "pipeline.workers"=\>2, "pipeline.batch.size"=\>125, "pipeline.batch.delay"=\>50}  
[2019-03-12T12:03:02,812][INFO][logstash.outputs.elasticsearch] Elasticsearch pool URLs updated {:changes=\>{:removed=\>, :added=\>[[http://localhost:9200/](http://localhost:9200/)]}}  
[2019-03-12T12:03:03,349][WARN][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=\>"[http://localhost:9200/](http://localhost:9200/)"}  
[2019-03-12T12:03:03,480][INFO][logstash.outputs.elasticsearch] ES Output version determined {:es\_version=\>6}  
[2019-03-12T12:03:03,489][WARN][logstash.outputs.elasticsearch] Detected a 6.x and above cluster: the `type` event field won't be used to determine the document \_type {:es\_version=\>6}  
[2019-03-12T12:03:03,607][INFO][logstash.outputs.elasticsearch] New Elasticsearch output {:class=\>"LogStash::Outputs::ElasticSearch", :hosts=\>["[http://localhost:9200](http://localhost:9200)"]}  
[2019-03-12T12:03:03,686][INFO][logstash.outputs.elasticsearch] Using mapping template from {:path=\>nil}  
[2019-03-12T12:03:03,784][INFO][logstash.outputs.elasticsearch] Attempting to install template {:manage\_template=\>{"template"=\>"logstash-_", "version"=\>60001, "settings"=\>{"index.refresh\_interval"=\>"5s"}, "mappings"=\>{"default"=\>{"dynamic\_templates"=\>[{"message\_field"=\>{"path\_match"=\>"message", "match\_mapping\_type"=\>"string", "mapping"=\>{"type"=\>"text", "norms"=\>false}}}, {"string\_fields"=\>{"match"=\>"_", "match\_mapping\_type"=\>"string", "mapping"=\>{"type"=\>"text", "norms"=\>false, "fields"=\>{"keyword"=\>{"type"=\>"keyword", "ignore\_above"=\>256}}}}}], "properties"=\>{"@timestamp"=\>{"type"=\>"date"}, "@version"=\>{"type"=\>"keyword"}, "geoip"=\>{"dynamic"=\>true, "properties"=\>{"ip"=\>{"type"=\>"ip"}, "location"=\>{"type"=\>"geo\_point"}, "latitude"=\>{"type"=\>"half\_float"}, "longitude"=\>{"type"=\>"half\_float"}}}}}}}}  
[2019-03-12T12:03:04,945][INFO][logstash.pipeline] Pipeline started successfully {:pipeline\_id=\>"main", :thread=\>"#\<Thread:0x20948060 sleep\>"}  
[2019-03-12T12:03:05,009][INFO][logstash.agent] Pipelines running {:count=\>1, :running\_pipelines=\>[:main], :non\_running\_pipelines=\>}  
[2019-03-12T12:03:08,645][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600}

---

<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:** [April 9, 2019, 6:38am UTC](https://discuss.elastic.co/t/logstash-get-stuck-after-successfully-started-logstash-api-endpoint-port-9600/171870/2 "2019-04-09T06:38:28Z")

</div>

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