# Error integrating DB postgress to Logstash
**URL:** https://discuss.elastic.co/t/error-integrating-db-postgress-to-logstash/149363
**Category:** Logstash
**Created:** [September 20, 2018, 9:49pm UTC](https://discuss.elastic.co/t/error-integrating-db-postgress-to-logstash/149363 "2018-09-20T21:49:30Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@nusuga](https://discuss.elastic.co/u/nusuga)
#### Post date: [September 20, 2018, 9:49pm UTC](https://discuss.elastic.co/t/error-integrating-db-postgress-to-logstash/149363/1 "2018-09-20T21:49:30Z")
I´m try to integrate a DB postgress query in elasticsearch/Logstash, but I'm having this problem:
```
[ERROR][logstash.pipeline] Error registering plugin {:pipeline_id=>"main", :plugin=>"\"smmod_transacciones\", jdbc_validate_connection=>true, jdbc_driver_library=>\"/opt/logstash/drivers/postgresql-42.2.2.jar\", jdbc_driver_class=>\"org.postgresql.Driver\", jdbc_connection_string=>\"jdbc:postgresql://1.1.2.3:5432/smmod\", jdbc_user=>\"myuserelastic\", jdbc_password=>, statement=>\"SELECT * FROM smmod_transactions_ppal, ver_codes, db_usersppal, role\", id=>\"7add16aa48d0863b101f14a1cccc23123123c5f023b9e282c4044d52f37fd7\", enable_metric=>true, codec=>\"plain_f316caba-3c7f-4504-bd3a-71cfc62bae6c\", enable_metric=>true, charset=>\"UTF-8\">, jdbc_paging_enabled=>false, jdbc_page_size=>100000, 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=>\"/usr/share/logstash/.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=>"#"}
[ERROR][logstash.pipeline] Pipeline aborted due to error {:pipeline_id=>"main", :exception=>#, :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.9/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.9/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.9/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.9/lib/logstash/inputs/jdbc.rb:216:in `register'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:340:in `register_plugin'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:351:in `block in register_plugins'", "org/jruby/RubyArray.java:1734:in `each'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:351:in `register_plugins'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:498:in `start_inputs'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:392:in `start_workers'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:288:in `run'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:248:in `block in start'"], :thread=>"#"}
[2018-09-20T16:12:02,301][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}
```
Some idea for this error?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 18, 2018, 9:49pm UTC](https://discuss.elastic.co/t/error-integrating-db-postgress-to-logstash/149363/2 "2018-10-18T21:49:33Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.