Logstash - Failed to execute action

Please, I need help with this error. I could not find a solution to this.

<[2019-02-15T08:25:09,520][ERROR][logstash.pipeline ] Error registering plugin {:pipeline_id=>"main", :plugin=>"<LogStash::Inputs::Jdbc jdbc_user=>"usr_elastic", jdbc_password=>, statement=>"SELECT \n XXXXXX ", jdbc_driver_library=>"/home/userdebian/sqljdbc_6.4/enu/mssql-jdbc-6.4.0.jre8.jar", jdbc_connection_string=>"jdbc:sqlserver://x.x.x.x:1433;databaseName=bd", id=>"7e7bc2cad2930e3aa461fbdb03fdcdcc9b7ad4b6d1198595a233183f2144b538", jdbc_driver_class=>"com.microsoft.sqlserver.jdbc.SQLServerDriver", enable_metric=>true, codec=><LogStash::Codecs::Plain id=>"plain_3e7016f3-997d-483b-a293-694599025800", enable_metric=>true, charset=>"UTF-8">, jdbc_paging_enabled=>false, jdbc_page_size=>100000, jdbc_validate_connection=>false, jdbc_validation_timeout=>3600, jdbc_pool_timeout=>5, sql_log_level=>"info", connection_retry_attempts=>1, connection_retry_attempts_wait_time=>0.5, last_run_metadata_path=>"/root/.logstash_jdbc_last_run", use_column_value=>false, tracking_column_type=>"numeric", clean_run=>false, record_last_run=>true, lowercase_column_names=>true>", :error=>"can't dup Fixnum", :thread=>"#<Thread:0x4ef7b7d run>"}
_[2019-02-15T08:25:09,818][ERROR][logstash.pipeline ] Pipeline aborted due to error {:pipeline_id=>"main", :exception=>#<TypeError: can't dup Fixnum>, :backtrace=>["org/jruby/RubyKernel.java:1882:in dup'", "uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/date/format.rb:838:inparse'", "uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/date.rb:1830:in parse'", "/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.11/lib/logstash/plugin_mixins/value_tracking.rb:87:inset_value'", "/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.11/lib/logstash/plugin_mixins/value_tracking.rb:36:in initialize'", "/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.11/lib/logstash/plugin_mixins/value_tracking.rb:29:inbuild_last_value_tracker'", "/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.11/lib/logstash/inputs/jdbc.rb:216:in register'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:241:inregister_plugin'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:252:in block in register_plugins'", "org/jruby/RubyArray.java:1734:ineach'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:252:in register_plugins'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:395:instart_inputs'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:293:in start_workers'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:199:inrun'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:159:in `block in start'"], :thread=>"#<Thread:0x4ef7b7d run>"}
[2019-02-15T08:25:09,847][ERROR][logstash.agent ] Failed to execute action {:id=>:main, :action_type=>LogStash::ConvergeResult::FailedAction, :message=>"Could not execute action: PipelineAction::Create, action_result: false", :backtrace=>nil}

@Osias, that looks like the problem described here: JDBC input Value tracking, "Can't dup Fixnum"

Thank you very much, the problem was solved with

tracking_column_type => "numeric"
clean_run => true

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