Hi there!
I am facing a problem with jdbc_static, because it does not write any staging file.
I have scheduled each load */8 hours, but it is querying the database many more times (near 1 per minute) because it does not create any staging file. Nor using the parameter "staging_directory" pointing to a custom path, nor leaving it by default pointing to "/tmp/logstash/jdbc_static/import_data".
If I leave it unset, the logstash process creates a new folder "/tmp/logstash/jdbc_static/import_data", but it does not create any file inside it.
How can I fix this problem and force the staging file creation?
I am using Logstash 6.3.1.
Thanks,
Best regards