Hi I am trying to load data from MS SQL server to Elastic search using logstash and got error in logstash agent
this is my logstash config file -
input {
jdbc {
jdbc_driver_library => "C:\local\lib\sqljdbc42.jar"
jdbc_driver_class => "com.microsoft.jdbc.sqlserver.SQLServerDriver"
jdbc_connection_string => "jdbc:sqlserver://MYSERVER:1433;DatabaseName=DB"
jdbc_user => "user"
jdbc_password => "password"
statement_filepath => "C:\Temp\TransactionEntity.sql"
jdbc_paging_enabled => true
jdbc_page_size => 1000
}
}
filter {
mutate {
remove_field => ["@timestamp", "@version"]
}
}
output {
elasticsearch {
hosts => ["127.0.0.1:9200"]
manage_template => false
action => "index"
index => "ed"
document_type => "TransactionEntity"
}
}
Below is the command i am running in CMD
C:\ES\logstash-5.6.4\bin>logstash --debug -f C:\ES\DataLoad\TransactionEntity.conf
Getting below Error -
] Successfully started Logstash API endpoint {:port=>9600}
[2017-11-24T09:31:59,802][DEBUG][logstash.inputs.jdbc ] closing {:plugin=>"LogStash::Inputs::Jdbc"}
[2017-11-24T09:31:59,802][DEBUG][logstash.pipeline ] Input plugins stopped! Will shutdown filter/output workers.
[2017-11-24T09:31:59,896][DEBUG][logstash.pipeline ] Pushing flush onto pipeline
[2017-11-24T09:31:59,896][DEBUG][logstash.pipeline ] Pushing shutdown {:thread=>"#<Thread:0x1cd33ce sleep>"}
[2017-11-24T09:31:59,896][DEBUG][logstash.pipeline ] Pushing shutdown {:thread=>"#<Thread:0x1485822 run>"}
[2017-11-24T09:31:59,896][DEBUG][logstash.pipeline ] Pushing shutdown {:thread=>"#<Thread:0x125ed04 sleep>"}
[2017-11-24T09:31:59,896][DEBUG][logstash.pipeline ] Pushing shutdown {:thread=>"#<Thread:0x246792 sleep>"}
[2017-11-24T09:31:59,896][DEBUG][logstash.pipeline ] Shutdown waiting for worker thread #Thread:0x1cd33ce
[2017-11-24T09:31:59,927][DEBUG][logstash.agent ] Error in reactor loop escaped: Bad file descriptor - Bad file descriptor (Errno::EBADF)
[2017-11-24T09:31:59,943][DEBUG][logstash.agent ] ["org/jruby/RubyIO.java:3705:in select'", "C:/ES/logstash-5.6.4/vendor/bundle/jruby/1.9/gems/puma-2.16.0-java/lib/puma/reactor.rb:29:inrun_internal'", "C:/ES/logstash-5.6.4/vendor/bundle/jruby/1.9/gems/puma-2.16.0-java/lib/puma/reactor.rb:138:in run_in_thread'"] [2017-11-24T09:31:59,943][DEBUG][logstash.agent ] 2017-11-24 09:31:59 +0530: Listen loop error: #<Errno::EBADF: Bad file descriptor - Bad file descriptor> [2017-11-24T09:31:59,943][DEBUG][logstash.agent ] org/jruby/RubyIO.java:3705:inselect'
C:/ES/logstash-5.6.4/vendor/bundle/jruby/1.9/gems/puma-2.16.0-java/lib/puma/server.rb:322:in handle_servers' C:/ES/logstash-5.6.4/vendor/bundle/jruby/1.9/gems/puma-2.16.0-java/lib/puma/server.rb:296:inrun'
[2017-11-24T09:31:59,943][DEBUG][logstash.agent ] 2017-11-24 09:31:59 +0530: Listen loop error: #<Errno::EBADF: Bad file descriptor - Bad file descriptor>
[2017-11-24T09:31:59,943][DEBUG][logstash.agent ] Error in reactor loop escaped: Bad file descriptor - Bad file descriptor (Errno::EBADF)
[2017-11-24T09:31:59,943][DEBUG][logstash.agent ] org/jruby/RubyIO.java:3705:in `select'
Kindly help on this .
Thanks in advance !
Arun