# Logstash Not sending Data to Elastic Search only for jdbc input **URL:** \ **Category:** Logstash\ **Created:** [June 13, 2019, 2:09pm UTC](https://discuss.elastic.co/t/logstash-not-sending-data-to-elastic-search-only-for-jdbc-input/185662 "2019-06-13T14:09:41Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![VIPS](https://avatars.discourse-cdn.com/v4/letter/v/54ee81/32.png) [@VIPS](https://discuss.elastic.co/u/VIPS)\ **Post date:** [June 13, 2019, 2:09pm UTC](https://discuss.elastic.co/t/logstash-not-sending-data-to-elastic-search-only-for-jdbc-input/185662/1 "2019-06-13T14:09:41Z")
Hi, I am trying to get data from SQL server and push it into elastic search... Logstash and elastic search both are up and running .. I can send sample data with below configuration and i can see index is created input { stdin { } } filter { grok { match =\> { "message" =\> "%{COMBINEDAPACHELOG}" } } date { match =\> ["timestamp" , "dd/MMM/yyyy:HH:mm:ss Z"] } } output { elasticsearch { hosts =\> ["localhost:9200"] } stdout { codec =\> rubydebug } } Which makes it clear that there is no issue while connecting logstash to sql server However when i change input to JDBC data is not sent to elastic search neither it's printed ... I ran logstash in debug mode there's no error on console.. and i also verified sql query is getting executed using profiler Below is log extract C:\logstash-6.8.0\>bin\logstash -f config\request1.conf --debug Java HotSpot(TM) 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release. WARNING: An illegal reflective access operation has occurred WARNING: Illegal reflective access by org.jruby.runtime.encoding.EncodingService (file:/C:/logstash-6.8.0/logstash-core/lib/jars/jruby-complete-9.2.7.0.jar) to field java.io.Console.cs WARNING: Please consider reporting this to the maintainers of org.jruby.runtime.encoding.EncodingService WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations WARNING: All illegal access operations will be denied in a future release Sending Logstash logs to C:/logstash-6.8.0/logs which is now configured via log4j2.properties [DEBUG][logstash.outputs.elasticsearch] Running health check to see if an Elasticsearch connection is working {:healthcheck\_url=\>[http://localhost:9200/](http://localhost:9200/), :path=\>"/"} [WARN][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=\>"[http://localhost:9200/](http://localhost:9200/)"} [INFO][logstash.outputs.elasticsearch] ES Output version determined {:es\_version=\>7} [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=\>7} [INFO][logstash.outputs.elasticsearch] New Elasticsearch output {:class=\>"LogStash::Outputs::ElasticSearch", :hosts=\>["[//localhost:9200](https://localhost:9200)"]} [logstash.outputs.elasticsearch] Using default mapping template [logstash.outputs.elasticsearch] Attempting to install template {:manage\_template=\>{"index\_patterns"=\>"logstash-_", "version"=\>60001, "settings"=\>{"index.refresh\_interval"=\>"5s", "number\_of\_shards"=\>1}, "mappings"=\>{"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"}}}}}}} [DEBUG][logstash.outputs.elasticsearch] Found existing Elasticsearch template. Skipping template management {:name=\>"logstash"} [INFO][logstash.pipeline] Pipeline started successfully {:pipeline\_id=\>"main", :thread=\>"#\"} [2019-06-13T23:34:44,732][INFO][logstash.agent] Pipelines running {:count=\>1, :running\_pipelines=\>[:main], :non\_running\_pipelines=\>} [2019-06-13T23:34:44,770][DEBUG][logstash.agent] Starting puma [DEBUG][logstash.agent] Trying to start WebServer {:port=\>9600} [DEBUG][logstash.api.service] [api-service] start [2019-06-13T23:34:45,154][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600} [2019-06-13T23:34:45,626][DEBUG][logstash.instrument.periodicpoller.cgroup] One or more required cgroup files or directories not found: /proc/self/cgroup, /sys/fs/cgroup/cpuacct, /sys/fs/cgroup/cpu [DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=\>"ParNew"} [DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=\>"ConcurrentMarkSweep"} [INFO][logstash.inputs.jdbc] (0.113391s) SELECT CAST(SERVERPROPERTY('ProductVersion') AS varchar) [INFO][logstash.inputs.jdbc] (0.000607s) SELECT TOP (1) count(\*) AS [COUNT] FROM (select top(10)id,name from customer) AS [T1] [DEBUG][logstash.inputs.jdbc] Executing JDBC query {:statement=\>"select top(10)id,perpname from Request", :parameters=\>{:sql\_last\_value=\>2019-06-13 13:33:29 UTC}, :count=\>0} [INFO][logstash.inputs.jdbc] (0.000781s) select top(10)id,perpname from Request [DEBUG][logstash.inputs.jdbc] Closing {:plugin=\>"LogStash::Inputs::Jdbc"} [DEBUG][logstash.pipeline] Pushing flush onto pipeline {:pipeline\_id=\>"main", :thread=\>"#\"} [DEBUG][logstash.pipeline] Shutting down filter/output workers {:pipeline\_id=\>"main", :thread=\>"#\"} [DEBUG][logstash.pipeline] Setting shutdown {:pipeline\_id=\>"main", :thread=\>"#\"} [2019-06-13T23:34:46,633][DEBUG][logstash.pipeline] Shutdown waiting for worker thread {:pipeline\_id=\>"main", :thread=\>"#\"} [2019-06-13T23:34:46,673][DEBUG][logstash.pipeline] Shutdown waiting for worker thread {:pipeline\_id=\>"main", :thread=\>"#\"} [DEBUG][logstash.outputs.elasticsearch] Closing {:plugin=\>"LogStash::Outputs::ElasticSearch"} [DEBUG][logstash.outputs.elasticsearch] Stopping sniffer [DEBUG][logstash.outputs.elasticsearch] Stopping resurrectionist [DEBUG][logstash.outputs.elasticsearch] Waiting for in use manticore connections [DEBUG][logstash.outputs.elasticsearch] Closing adapter LogStash::Outputs::ElasticSearch::HttpClient::ManticoreAdapter:0x413818d6 [DEBUG][logstash.outputs.stdout] Closing {:plugin=\>"LogStash::Outputs::Stdout"} [2019-06-13T23:34:47,248][INFO][logstash.pipeline] Pipeline has terminated {:pipeline\_id=\>"main", :thread=\>"#\"} [DEBUG][logstash.instrument.periodicpoller.os] Stopping [DEBUG][logstash.instrument.periodicpoller.jvm] Stopping [DEBUG][logstash.instrument.periodicpoller.persistentqueue] Stopping [DEBUG][logstash.instrument.periodicpoller.deadletterqueue] Stopping [DEBUG][logstash.agent] Shutting down all pipelines {:pipelines\_count=\>0} [2019-06-13T23:34:47,437][DEBUG][logstash.agent] Converging pipelines state {:actions\_count=\>0} [INFO][logstash.runner] Logstash shut down. Additional info elastic search version 7.1.1. logstash version 6.8.8 OS windows 10 I am 100% sure it's connecting to sql server and executing query i can tell it looking at profiler. I have also looked into elastic search log.. there's nothing .. no request came while log stash was executing Please help ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 11, 2019, 2:09pm UTC](https://discuss.elastic.co/t/logstash-not-sending-data-to-elastic-search-only-for-jdbc-input/185662/2 "2019-07-11T14:09:54Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.