Hi
i have 10 jdbc.conf files when i start the logstash all queries executed successfully but after the first shot some of the queries not execute.
i tried to find the reason in logstash.log but nothing show
PFB screenshot from the dashboard and you can see the gaps
my jdbc.conf
input {
jdbc {
jdbc_driver_library => "/opt/ojdbc7.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "jdbc:oracle:thin:@*:*/*"
jdbc_user => "*"
jdbc_password => "*"
schedule => "* * * * *"
statement => "select * from my table"
}
##############################################
jdbc {
jdbc_driver_library => "/opt/ojdbc7.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "jdbc:oracle:thin:@*/*"
jdbc_user => "*"
jdbc_password => "*"
schedule => "* * * * *"
statement => "select * from my table"
}
}
filter {
uuid {
target => "uuid"
overwrite => true
}
}
output {stdout { codec => rubydebug }
elasticsearch { hosts => ["http://localhost:9200"]
data_stream => "true"
data_stream_type => "logs"
document_id => "%{uuid}"
user => "*"
password => "*"
}
}
the other files same structure but without filter and output