# JDBC\_static lookup timeout

**URL:** <https://discuss.elastic.co/t/jdbc-static-lookup-timeout/253134>\
**Category:** Logstash\
**Created:** [October 23, 2020, 1:29pm UTC](https://discuss.elastic.co/t/jdbc-static-lookup-timeout/253134 "2020-10-23T13:29:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![chapmantrain](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chapmantrain/32/22646_2.png) [@chapmantrain](https://discuss.elastic.co/u/chapmantrain)\
**Post date:** [October 23, 2020, 1:29pm UTC](https://discuss.elastic.co/t/jdbc-static-lookup-timeout/253134/1 "2020-10-23T13:29:13Z")

</div>

I'm running a static lookup to enhance my syslog data and I'm seeing this WARN in the log. Is there some configuration I can hit to help this timeout problem?

[2020-10-23T13:25:35,278][WARN][logstash.filters.jdbc.lookup] Exception when executing Jdbc query {:lookup\_id=\>"info\_devices\_lk\_02", :exception=\>"timeout: 5.0, elapsed: 5.000156980007887", :backtrace=\>["/opt/app/logstash-6.8.10/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/connection\_pool/threaded.rb:264:in `raise_pool_timeout'", "/opt/app/logstash-6.8.10/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/connection_pool/threaded.rb:155:in `acquire'", "/opt/app/logstash-6.8.10/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/connection\_pool/threaded.rb:91:in `hold'", "/opt/app/logstash-6.8.10/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/database/connecting.rb:270:in `synchronize'", "/opt/app/logstash-6.8.10/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/adapters/jdbc.rb:250:in `execute'", "/opt/app/logstash-6.8.10/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/dataset/actions.rb:1089:in `execute'", "/opt/app/logstash-6.8.10/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/adapters/jdbc.rb:743:in `fetch_rows'", "/opt/app/logstash-6.8.10/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/dataset/actions.rb:152:in `each'"]}

---

<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:** [November 20, 2020, 1:29pm UTC](https://discuss.elastic.co/t/jdbc-static-lookup-timeout/253134/2 "2020-11-20T13:29:14Z")

</div>

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