The log output doesnt give me much of a clue what the problem is:
My config:
jdbc_static {
loaders => [
<loaders removed for brevity>
]
local_db_objects => [
<local db objects removed for brevity>
]
staging_directory => "/tmp/logstash/jdbc_static/import_data"
loader_schedule => "* */2 * * *" # run loaders every 2 hours
jdbc_user => "${WATCHLIST_DB_USER}"
jdbc_password => "${WATCHLIST_DB_PASSWORD}"
jdbc_connection_string => "jdbc:sqlserver://${WATCHLIST_DB_HOST}:${WATCHLIST_DB_PORT};databaseName=${WATCHLIST_DB_NAME}"
jdbc_driver_library => "/home/myuser/logstash/mssql-connector-java/mssql-jdbc-8.2.0.jre8.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
}
][logstash.javapipeline ] t_0.lib.sequel.adapters.jdbc.RUBY$method$connect$0$__VARARGS__(usr/share/logstash/vendor/bundle/jruby/$2_dot_5_dot_0/gems/sequel_minus_5_dot_20_dot_0/lib/sequel/adapters//usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.20.0/lib/sequel/adapters/jdbc.rb)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.sequel_minus_5_dot_20_dot_0.lib.sequel.connection_pool.make_new(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.20.0/lib/sequel/connection_pool.rb:122)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.sequel_minus_5_dot_20_dot_0.lib.sequel.connection_pool.RUBY$method$make_new$0$__VARARGS__(usr/share/logstash/vendor/bundle/jruby/$2_dot_5_dot_0/gems/sequel_minus_5_dot_20_dot_0/lib/sequel//usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.20.0/lib/sequel/connection_pool.rb)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.sequel_minus_5_dot_20_dot_0.lib.sequel.connection_pool.threaded.assign_connection(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.20.0/lib/sequel/connection_pool/threaded.rb:209)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.sequel_minus_5_dot_20_dot_0.lib.sequel.connection_pool.threaded.RUBY$method$assign_connection$0$__VARARGS__(usr/share/logstash/vendor/bundle/jruby/$2_dot_5_dot_0/gems/sequel_minus_5_dot_20_dot_0/lib/sequel/connection_pool//usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.20.0/lib/sequel/connection_pool/threaded.rb)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.sequel_minus_5_dot_20_dot_0.lib.sequel.connection_pool.threaded.acquire(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.20.0/lib/sequel/connection_pool/threaded.rb:139)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.sequel_minus_5_dot_20_dot_0.lib.sequel.connection_pool.threaded.RUBY$method$acquire$0$__VARARGS__(usr/share/logstash/vendor/bundle/jruby/$2_dot_5_dot_0/gems/sequel_minus_5_dot_20_dot_0/lib/sequel/connection_pool//usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.20.0/lib/sequel/connection_pool/threaded.rb)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.sequel_minus_5_dot_20_dot_0.lib.sequel.connection_pool.threaded.hold(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.20.0/lib/sequel/connection_pool/threaded.rb:91)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.sequel_minus_5_dot_20_dot_0.lib.sequel.database.connecting.synchronize(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.20.0/lib/sequel/database/connecting.rb:270)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.sequel_minus_5_dot_20_dot_0.lib.sequel.database.connecting.test_connection(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.20.0/lib/sequel/database/connecting.rb:279)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.sequel_minus_5_dot_20_dot_0.lib.sequel.database.connecting.connect(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.20.0/lib/sequel/database/connecting.rb:58)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.sequel_minus_5_dot_20_dot_0.lib.sequel.core.connect(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.20.0/lib/sequel/core.rb:121)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_filter_minus_jdbc_static_minus_1_dot_0_dot_6.lib.logstash.filters.jdbc.basic_database.verify_connection(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-jdbc_static-1.0.6/lib/logstash/filters/jdbc/basic_database.rb:108)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_filter_minus_jdbc_static_minus_1_dot_0_dot_6.lib.logstash.filters.jdbc.basic_database.RUBY$method$verify_connection$0$__VARARGS__(usr/share/logstash/vendor/bundle/jruby/$2_dot_5_dot_0/gems/logstash_minus_filter_minus_jdbc_static_minus_1_dot_0_dot_6/lib/logstash/filters/jdbc//usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-jdbc_static-1.0.6/lib/logstash/filters/jdbc/basic_database.rb)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_filter_minus_jdbc_static_minus_1_dot_0_dot_6.lib.logstash.filters.jdbc.read_only_database.post_create(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-jdbc_static-1.0.6/lib/logstash/filters/jdbc/read_only_database.rb:48)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_filter_minus_jdbc_static_minus_1_dot_0_dot_6.lib.logstash.filters.jdbc.read_only_database.RUBY$method$post_create$0$__VARARGS__(usr/share/logstash/vendor/bundle/jruby/$2_dot_5_dot_0/gems/logstash_minus_filter_minus_jdbc_static_minus_1_dot_0_dot_6/lib/logstash/filters/jdbc//usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-jdbc_static-1.0.6/lib/logstash/filters/jdbc/read_only_database.rb)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_filter_minus_jdbc_static_minus_1_dot_0_dot_6.lib.logstash.filters.jdbc.basic_database.create(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-jdbc_static-1.0.6/lib/logstash/filters/jdbc/basic_database.rb:33)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_filter_minus_jdbc_static_minus_1_dot_0_dot_6.lib.logstash.filters.jdbc.loader.build_remote_db(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-jdbc_static-1.0.6/lib/logstash/filters/jdbc/loader.rb:18)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_filter_minus_jdbc_static_minus_1_dot_0_dot_6.lib.logstash.filters.jdbc.loader.RUBY$method$build_remote_db$0$__VARARGS__(usr/share/logstash/vendor/bundle/jruby/$2_dot_5_dot_0/gems/logstash_minus_filter_minus_jdbc_static_minus_1_dot_0_dot_6/lib/logstash/filters/jdbc//usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-jdbc_static-1.0.6/lib/logstash/filters/jdbc/loader.rb)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_filter_minus_jdbc_static_minus_1_dot_0_dot_6.lib.logstash.filters.jdbc_static.prepare_runner(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-jdbc_static-1.0.6/lib/logstash/filters/jdbc_static.rb:178)", "org.jruby.RubyArray.collect(org/jruby/RubyArray.java:2563)", "org.jruby.RubyArray.map(org/jruby/RubyArray.java:2577)", "org.jruby.RubyArray$INVOKER$i$0$0$map19.call(org/jruby/RubyArray$INVOKER$i$0$0$map19.gen)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_filter_minus_jdbc_static_minus_1_dot_0_dot_6.lib.logstash.filters.jdbc_static.prepare_runner(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-jdbc_static-1.0.6/lib/logstash/filters/jdbc_static.rb:175)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_filter_minus_jdbc_static_minus_1_dot_0_dot_6.lib.logstash.filters.jdbc_static.RUBY$method$prepare_runner$0$__VARARGS__(usr/share/logstash/vendor/bundle/jruby/$2_dot_5_dot_0/gems/logstash_minus_filter_minus_jdbc_static_minus_1_dot_0_dot_6/lib/logstash/filters//usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-jdbc_static-1.0.6/lib/logstash/filters/jdbc_static.rb)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_filter_minus_jdbc_static_minus_1_dot_0_dot_6.lib.logstash.filters.jdbc_static.register(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-jdbc_static-1.0.6/lib/logstash/filters/jdbc_static.rb:146)", "org.jruby.RubyClass.finvoke(org/jruby/RubyClass.java:548)", "org.jruby.RubyBasicObject.callMethod(org/jruby/RubyBasicObject.java:354)", "org.logstash.config.ir.compiler.FilterDelegatorExt.doRegister(org/logstash/config/ir/compiler/FilterDelegatorExt.java:63)", "org.logstash.config.ir.compiler.AbstractFilterDelegatorExt.register(org/logstash/config/ir/compiler/AbstractFilterDelegatorExt.java:56)", "usr.share.logstash.logstash_minus_core.lib.logstash.java_pipeline.register_plugins(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:191)", "org.jruby.RubyArray.each(org/jruby/RubyArray.java:1792)", "usr.share.logstash.logstash_minus_core.lib.logstash.java_pipeline.register_plugins(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:190)", "usr.share.logstash.logstash_minus_core.lib.logstash.java_pipeline.RUBY$method$register_plugins$0$__VARARGS__(usr/share/logstash/logstash_minus_core/lib/logstash//usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb)", "usr.share.logstash.logstash_minus_core.lib.logstash.java_pipeline.maybe_setup_out_plugins(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:446)", "usr.share.logstash.logstash_minus_core.lib.logstash.java_pipeline.RUBY$method$maybe_setup_out_plugins$0$__VARARGS__(usr/share/logstash/logstash_minus_core/lib/logstash//usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb)", "usr.share.logstash.logstash_minus_core.lib.logstash.java_pipeline.start_workers(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:203)", "usr.share.logstash.logstash_minus_core.lib.logstash.java_pipeline.RUBY$method$start_workers$0$__VARARGS__(usr/share/logstash/logstash_minus_core/lib/logstash//usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb)", "usr.share.logstash.logstash_minus_core.lib.logstash.java_pipeline.run(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:145)", "usr.share.logstash.logstash_minus_core.lib.logstash.java_pipeline.RUBY$method$run$0$__VARARGS__(usr/share/logstash/logstash_minus_core/lib/logstash//usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb)", "usr.share.logstash.logstash_minus_core.lib.logstash.java_pipeline.start(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:104)", "org.jruby.RubyProc.call(org/jruby/RubyProc.java:295)", "org.jruby.RubyProc.call(org/jruby/RubyProc.java:274)", "org.jruby.RubyProc.call(org/jruby/RubyProc.java:270)", "java.lang.Thread.run(java/lang/Thread.java:748)"], :thread=>"#<Thread:0x5f8951c6 run>"}
[2020-06-23T06:59:33,045][ERROR][logstash.agent ] Failed to execute action {:id=>:macau:
Any suggestions to what that error message means and how to debug appreciated, thanks