Logstash don't have error, but not input any data!

Elastic Stack Logstash
1

Hello i running logstash 6.7.1. it fresh installation, but not storing any data to elasticsearch.

[2019-04-12T11:10:38,459][INFO ][logstash.pipeline        ] Starting pipeline {:pipeline_id=>"redemptionneeds", "pipeline.workers"=>4, "pipeline.batch.size"=>125, "pipeline.batch.delay"=>50}
[2019-04-12T11:10:39,285][INFO ][logstash.outputs.elasticsearch] Elasticsearch pool URLs updated {:changes=>{:removed=>[], :added=>[http://127.0.0.1:9200/]}}
[2019-04-12T11:10:39,653][WARN ][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=>"http://127.0.0.1:9200/"}
[2019-04-12T11:10:39,726][INFO ][logstash.outputs.elasticsearch] ES Output version determined {:es_version=>6}
[2019-04-12T11:10:39,735][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-04-12T11:10:39,830][INFO ][logstash.outputs.elasticsearch] New Elasticsearch output {:class=>"LogStash::Outputs::ElasticSearch", :hosts=>["http://127.0.0.1:9200/"]}
[2019-04-12T11:10:40,300][INFO ][logstash.pipeline        ] Pipeline started successfully {:pipeline_id=>"redemptionneeds", :thread=>"#<Thread:0x20d0ff2e run>"}
[2019-04-12T11:10:40,489][INFO ][logstash.agent           ] Pipelines running {:count=>1, :running_pipelines=>[:redemptionneeds], :non_running_pipelines=>[]}
[2019-04-12T11:10:41,080][INFO ][logstash.agent           ] Successfully started Logstash API endpoint {:port=>9600}
[2019-04-12T11:20:04,647][WARN ][logstash.runner          ] SIGTERM received. Shutting down.

This is my config.

input {
  jdbc {
    jdbc_driver_library => "/usr/local/etc/sqljdbc_7.2/enu/mssql-jdbc-7.2.1.jre11.jar"
    jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    jdbc_connection_string =>  "jdbc:sqlserver://*************;databaseName=**********"
    jdbc_user => "*****"
	jdbc_password  => "**********"	
    schedule => "*/5 * * * *"
    statement_filepath => "/etc/logstash/sql/RedemptionNeeds.sql"
	jdbc_paging_enabled => true
	jdbc_page_size => 50000
    last_run_metadata_path => "/usr/share/logstash/.logstash_jdbc_last_run_RedemptionNeeds"
  }
}

output {   
  elasticsearch { 
     hosts => ["http://127.0.0.1:9200/"]    
     	index => "redemptionneeds"
      	document_type => "redemption"
      	document_id => "%{id}"
      	manage_template => false
  }
}

Verry need your help, i thank you first.

2

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