# Index not found in ES

**URL:** https://discuss.elastic.co/t/index-not-found-in-es/112005
**Category:** Elasticsearch
**Created:** [December 15, 2017, 3:20pm UTC](https://discuss.elastic.co/t/index-not-found-in-es/112005 "2017-12-15T15:20:20Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![bittujindani](https://avatars.discourse-cdn.com/v4/letter/b/b5ac83/32.png) [@bittujindani](https://discuss.elastic.co/u/bittujindani)
#### Post date: [December 15, 2017, 3:20pm UTC](https://discuss.elastic.co/t/index-not-found-in-es/112005/1 "2017-12-15T15:20:20Z")

</div>

I have configured the ES,LS and Kibana for my redshift database. I could see that LS started and working fine but dont see index in the ES. What could be reason here ?

index details :

root@ip-10-0-1-113:~# curl 'localhost:9200/\_cat/indices?v'  
health status index uuid pri rep docs.count docs.deleted store.size pri.store.size  
yellow open logstash-2017.12.11 EXhGFTiNQOC5hEvhf0bJOQ 5 1 2 0 9.7kb 9.7kb  
yellow open pg\_stat\_activity BrYAYp-jShSXt2-LM-zTSQ 5 1 40 0 386.7kb 386.7kb  
yellow open .kibana jhE1s1hxTNq319Mu8BA3vQ 1 1 6 0 36.1kb 36.1kb  
yellow open logstash-2017.12.13 LgEJJrS\_TMuQwcMZruobgw 5 1 12 0 46.9kb 46.9kb  
yellow open logstash-2017.12.12 CJuoyWY0QjyTTNNnTpTDlQ 5 1 2 0 9.7kb 9.7kb  
root@ip-10-0-1-113:~#

LS output :

root@ip-10-0-1-113:/etc/logstash-6.0.1/conf.d# /etc/logstash-6.0.1/bin/logstash -f /etc/logstash-6.0.1/conf.d/conf\_redshift.conf  
Sending Logstash's logs to /etc/logstash-6.0.1/logs which is now configured via log4j2.properties  
[2017-12-15T14:45:15,327][INFO][logstash.modules.scaffold] Initializing module {:module\_name=\>"fb\_apache", :directory=\>"/etc/logstash-6.0.1/modules/fb\_apache/configuration"}  
[2017-12-15T14:45:15,329][INFO][logstash.modules.scaffold] Initializing module {:module\_name=\>"netflow", :directory=\>"/etc/logstash-6.0.1/modules/netflow/configuration"}  
[2017-12-15T14:45:15,709][WARN][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified  
[2017-12-15T14:45:16,272][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600}  
[2017-12-15T14:45:19,361][WARN][logstash.outputs.elasticsearch] You are using a deprecated config setting "document\_type" set in elasticsearch. Deprecated settings will continue to work, but are scheduled for removal from logstash in the future. Document types are being deprecated in Elasticsearch 6.0, and removed entirely in 7.0. You should avoid this feature If you have any questions about this, please visit the #logstash channel on freenode irc. {:name=\>"document\_type", :plugin=\>\<LogStash::Outputs::ElasticSearch index=\>"Redshift", document\_type=\>"Redshift", hosts=\>["localhost:9200"], id=\>"b6ac7f1bc9ff0cb43a6a03727b3a5bf9af47d9f61652fd1e08934877e4a33615"\>}  
[2017-12-15T14:45:20,333][INFO][logstash.outputs.elasticsearch] Elasticsearch pool URLs updated {:changes=\>{:removed=\>[], :added=\>[[http://localhost:9200/](http://localhost:9200/)]}}  
[2017-12-15T14:45:20,335][INFO][logstash.outputs.elasticsearch] Running health check to see if an Elasticsearch connection is working {:healthcheck\_url=\>[http://localhost:9200/](http://localhost:9200/), :path=\>"/"}  
[2017-12-15T14:45:20,695][WARN][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=\>"[http://localhost:9200/](http://localhost:9200/)"}  
[2017-12-15T14:45:20,803][INFO][logstash.outputs.elasticsearch] ES Output version determined {:es\_version=\>nil}  
[2017-12-15T14:45:20,803][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}  
[2017-12-15T14:45:20,821][INFO][logstash.outputs.elasticsearch] Using mapping template from {:path=\>nil}  
[2017-12-15T14:45:20,834][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"}}}}}}}}  
[2017-12-15T14:45:20,844][INFO][logstash.outputs.elasticsearch] New Elasticsearch output {:class=\>"LogStash::Outputs::ElasticSearch", :hosts=\>["[//localhost:9200](https://localhost:9200)"]}  
[2017-12-15T14:45:20,904][INFO][logstash.pipeline] Starting pipeline {:pipeline\_id=\>"main", "pipeline.workers"=\>4, "pipeline.batch.size"=\>125, "pipeline.batch.delay"=\>5, "pipeline.max\_inflight"=\>500, :thread=\>"#\<Thread:0x7e66d8e@/etc/logstash-6.0.1/logstash-core/lib/logstash/pipeline.rb:290 run\>"}  
[2017-12-15T14:45:21,584][INFO][logstash.pipeline] Pipeline started {"[pipeline.id](http://pipeline.id)"=\>"main"}  
[2017-12-15T14:45:21,749][INFO][logstash.agent] Pipelines running {:count=\>1, :pipelines=\>["main"]}  
[2017-12-15T14:46:08,329][INFO][logstash.inputs.jdbc] (0.666344s) SELECT \* from pg\_stat\_activity where query\_start \> '2017-12-15 14:43:01.755373'  
[2017-12-15T14:47:01,832][INFO][logstash.inputs.jdbc] (0.274178s) SELECT \* from pg\_stat\_activity where query\_start \> '2017-12-15 14:46:07.518632'  
[2017-12-15T14:48:01,285][INFO][logstash.inputs.jdbc] (0.236496s) SELECT \* from pg\_stat\_activity where query\_start \> '2017-12-15 14:47:01.557541'  
[2017-12-15T14:49:01,116][INFO][logstash.inputs.jdbc] (0.234937s) SELECT \* from pg\_stat\_activity where query\_start \> '2017-12-15 14:48:01.047752'

---

<div class="post-metadata">

### Author: ![bittujindani](https://avatars.discourse-cdn.com/v4/letter/b/b5ac83/32.png) [@bittujindani](https://discuss.elastic.co/u/bittujindani)
#### Post date: [December 15, 2017, 3:45pm UTC](https://discuss.elastic.co/t/index-not-found-in-es/112005/2 "2017-12-15T15:45:53Z")

</div>

Seems it is not able to connect the DB. I tried it with below codes but it's not displaying any output. Does it support Redhsift database ?

output {  
stdout { codec =\> json\_lines }  
}

conf.d file details.  
input {  
jdbc {  
jdbc\_connection\_string =\> "jdbc:redshift://cluster-name.c6srgdetn1g4.us-west-2.redshift.amazonaws.com:8192/DB-NAME"  
jdbc\_user =\> " \*\*\*\*\*\* "  
jdbc\_password =\> " \*\*\*\*\* "  
jdbc\_validate\_connection =\> true  
jdbc\_driver\_library =\> "/tmp/RedshiftJDBC42-1.2.10.1009.jar"  
jdbc\_driver\_class =\> "com.amazon.redshift.jdbc42.Driver"  
statement =\> "SELECT \* from pg\_stat\_activity where query\_start \> :sql\_last\_value "  
last\_run\_metadata\_path =\> "/tmp/logstash-oradb.lastrun"  
record\_last\_run =\> true  
schedule =\> "\* \* \* \* \*"  
}  
}

root@ip-10-0-1-113:/etc/logstash-6.0.1/# /bin/logstash --config /etc/logstash-6.0.1/conf.d/rs\_3.conf  
Settings: Default pipeline workers: 4  
Pipeline main started

---

<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: [January 12, 2018, 3:58pm UTC](https://discuss.elastic.co/t/index-not-found-in-es/112005/3 "2018-01-12T15:58:33Z")

</div>

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