Hi, I'm new with elk stack, i'm trying to pull data from a view in oracle, now i'm stuck with the logstash.conf file.
input {
jdbc {
jdbc_validate_connection => true
jdbc_driver_library => "/etc/logstash/conf.d/jdbc/ojdbc8.jar"
jdbc_driver_class => "Java:oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "jdbc:oracle:thin:@10.000.0.00:1521/name"
jdbc_user => "user"
jdbc_password =>"pass"
schedule => " */2 * * * *"
statement => "select ID, ID_EJECUCION, FECHA_INICIO, FECHA_FIN, PROCESO, ESTADO, OBSERVACIONES, DIM_TIEMPOS, MINUTOS FROM V_LOG WHERE trunc(FECHA_INICIO)=trunc(sysdate) and (proceso like 'Precarga%' or proceso like '0 -ORACLE%' or proceso like '4%' or proceso like 'Extraccion%)' order by ID"
}
}
output {
elasticsearch {
index => "exampleindex"
document_id => "%{ID}"
}
}
this is the output log in logstash_plain.log
[2019-10-24T10:42:47,039][WARN ][org.logstash.execution.ShutdownWatcherExt] {"inflight_count"=>0, "stalling_threads_info"=>{"other"=>[{"thread_id"=>47, "name"=>"[main]<jdbc", "current_call"=>"[...]/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler.rb:170:in join'"}, {"thread_id"=>31, "name"=>"[main]>worker0", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:inblock in start_workers'"}, {"thread_id"=>32, "name"=>"[main]>worker1", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:in block in start_workers'"}, {"thread_id"=>33, "name"=>"[main]>worker2", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:inblock in start_workers'"}, {"thread_id"=>34, "name"=>"[main]>worker3", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:in block in start_workers'"}, {"thread_id"=>35, "name"=>"[main]>worker4", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:inblock in start_workers'"}, {"thread_id"=>36, "name"=>"[main]>worker5", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:in block in start_workers'"}, {"thread_id"=>37, "name"=>"[main]>worker6", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:inblock in start_workers'"}, {"thread_id"=>38, "name"=>"[main]>worker7", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:in block in start_workers'"}, {"thread_id"=>39, "name"=>"[main]>worker8", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:inblock in start_workers'"}, {"thread_id"=>40, "name"=>"[main]>worker9", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:in block in start_workers'"}, {"thread_id"=>41, "name"=>"[main]>worker10", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:inblock in start_workers'"}, {"thread_id"=>42, "name"=>"[main]>worker11", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:in block in start_workers'"}, {"thread_id"=>43, "name"=>"[main]>worker12", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:inblock in start_workers'"}, {"thread_id"=>44, "name"=>"[main]>worker13", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:in block in start_workers'"}, {"thread_id"=>45, "name"=>"[main]>worker14", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:inblock in start_workers'"}, {"thread_id"=>46, "name"=>"[main]>worker15", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:in `block in start_workers'"}]}}
Any comment will be helpful!
Best Regards!