Schedule not working sometimes | gaps in records

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

CS

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

can anyone help me here :frowning:
i tried to increase the pipeline.workers but still the same
please let me know if any further details needed
thanks

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