# Logstash - Failed to execute action

**URL:** <https://discuss.elastic.co/t/logstash-failed-to-execute-action/168576>\
**Category:** Logstash\
**Created:** [February 15, 2019, 11:58am UTC](https://discuss.elastic.co/t/logstash-failed-to-execute-action/168576 "2019-02-15T11:58:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Osias](https://avatars.discourse-cdn.com/v4/letter/o/ee7513/32.png) [@Osias](https://discuss.elastic.co/u/Osias)\
**Post date:** [February 15, 2019, 11:58am UTC](https://discuss.elastic.co/t/logstash-failed-to-execute-action/168576/1 "2019-02-15T11:58:14Z")

</div>

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:in`_parse'", "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:in`set\_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:in`build\_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:in`register\_plugin'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:252:in `block in register_plugins'", "org/jruby/RubyArray.java:1734:in`each'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:252:in `register_plugins'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:395:in`start\_inputs'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:293:in `start_workers'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:199:in`run'", "/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}_

---

<div class="post-metadata">

**Author:** ![danhermann](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/danhermann/32/33024_2.png) [@danhermann](https://discuss.elastic.co/u/danhermann)\
**Post date:** [February 15, 2019, 1:30pm UTC](https://discuss.elastic.co/t/logstash-failed-to-execute-action/168576/2 "2019-02-15T13:30:44Z")

</div>

@Osias, that looks like the problem described here: [JDBC input Value tracking, "Can't dup Fixnum"](https://discuss.elastic.co/t/jdbc-input-value-tracking-cant-dup-fixnum/150473)

---

<div class="post-metadata">

**Author:** ![Osias](https://avatars.discourse-cdn.com/v4/letter/o/ee7513/32.png) [@Osias](https://discuss.elastic.co/u/Osias)\
**Post date:** [February 15, 2019, 3:03pm UTC](https://discuss.elastic.co/t/logstash-failed-to-execute-action/168576/3 "2019-02-15T15:03:02Z")

</div>

Thank you very much, the problem was solved with

tracking\_column\_type =\> "numeric"  
clean\_run =\> true

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 15, 2019, 3:03pm UTC](https://discuss.elastic.co/t/logstash-failed-to-execute-action/168576/4 "2019-03-15T15:03:04Z")

</div>

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