# Sequel::PoolTimeout error when contacting Database **URL:** \ **Category:** Logstash\ **Created:** [September 1, 2015, 9:31am UTC](https://discuss.elastic.co/t/sequel-pooltimeout-error-when-contacting-database/28414 "2015-09-01T09:31:26Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![KarthikaAr](https://avatars.discourse-cdn.com/v4/letter/k/958977/32.png) [@KarthikaAr](https://discuss.elastic.co/u/KarthikaAr)\ **Post date:** [September 1, 2015, 9:31am UTC](https://discuss.elastic.co/t/sequel-pooltimeout-error-when-contacting-database/28414/1 "2015-09-01T09:31:26Z")
Can Somebody explains what this Error means. How it can be fixed, { 11754 rufus-scheduler intercepted an error: 11754 job: 11754 Rufus::Scheduler::CronJob "\*/14 \* \* \* \*" {} 11754 error: 11754 11754 11754 Sequel::PoolTimeout 11754 timeout: 5.0, elapsed: 5.001 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/sequel-4.25.0/lib/sequel/connection\_pool/threaded.rb:161:in `acquire' 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/sequel-4.25.0/lib/sequel/connection_pool/threaded.rb:263:in`sync' 11754 org/jruby/ext/thread/Mutex.java:149:in `synchronize' 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/sequel-4.25.0/lib/sequel/connection_pool/threaded.rb:263:in`sync' 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/sequel-4.25.0/lib/sequel/connection\_pool/threaded.rb:144:in `acquire' 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/sequel-4.25.0/lib/sequel/extensions/connection_validator.rb:86:in`acquire' 11754 /users/home/xbbkfn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/sequel-4.25.0/lib/sequel/connection\_pool/threaded.rb:102:in `hold' 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/sequel-4.25.0/lib/sequel/database/connecting.rb:254:in`synchronize' 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/sequel-4.25.0/lib/sequel/adapters/jdbc.rb:245:in `execute' 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/sequel-4.25.0/lib/sequel/dataset/actions.rb:921:in`execute' 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/sequel-4.25.0/lib/sequel/adapters/jdbc.rb:721:in `fetch_rows' 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/sequel-4.25.0/lib/sequel/dataset/actions.rb:139:in`each' 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-1.0.0/lib/logstash/plugin\_mixins/jdbc.rb:118:in `execute_statement ' 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-1.0.0/lib/logstash/inputs/jdbc.rb:189:in`execute\_query' 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-1.0.0/lib/logstash/inputs/jdbc.rb:165:in `run' 11754 org/jruby/RubyProc.java:271:in`call' 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:234:in `do_call' 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:258:in`do\_trigger' 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:300:in `start_work_thread' 11754 org/jruby/RubyProc.java:271:in`call' 11754 /users/home/bbkzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:299:in `start_work_thread' 11754 org/jruby/RubyKernel.java:1511:in`loop' 11754 /users/home/xbbkfzn/opt/logstash/logstash-1.5.3/vendor/bundle/jruby/1.9/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:289:in `start\_work\_thread' 11754 tz: 11754 ENV['TZ']: 11754 Time.now: 2015-09-01 05:14:05 -0400 11754 scheduler: 11754 object\_id: 11750 11754 opts: 11754 {} 11754 frequency: 0.3 11754 scheduler\_lock: #Rufus::Scheduler::NullLock:0x73031cf0 11754 trigger\_lock: #Rufus::Scheduler::NullLock:0x7dc4ece0 11754 uptime: 3095.614 (51m35s614) 11754 down?: false 11754 threads: 6 11754 thread: #Thread:0x79fb7780 11754 thread\_key: rufus\_scheduler\_11750 11754 work\_threads: 5 11754 active: 5 11754 vacant: 0 11754 max\_work\_threads: 28 11754 mutexes: {} 11754 jobs: 1 11754 at\_jobs: 0 11754 in\_jobs: 0 11754 every\_jobs: 0 11754 interval\_jobs: 0 11754 cron\_jobs: 1 11754 running\_jobs: 1 11754 work\_queue: 0 } 11754 . Thanks ---
**Author:** ![KarthikaAr](https://avatars.discourse-cdn.com/v4/letter/k/958977/32.png) [@KarthikaAr](https://discuss.elastic.co/u/KarthikaAr)\ **Post date:** [September 4, 2015, 6:28am UTC](https://discuss.elastic.co/t/sequel-pooltimeout-error-when-contacting-database/28414/2 "2015-09-04T06:28:08Z")
Somebody please help with the above exception,I am getting this when I connecting to the SQL Server in schedules. Please refer to my conf file below and advise me input{ jdbc{ jdbc\_driver\_library =\> "/pathto/opt/sqljdbc\_4.2/enu/sqljdbc4.jar" jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver" jdbc\_connection\_string =\> "jdbc:sqlserver://xxx.xx.xx:14432;databaseName=DBNAME;" jdbc\_user =\> "USER" jdbc\_password =\> "\*\*\*\*\*_" schedule =\> "_/15 \* \* \* \*" record\_last\_run =\> true statement =\> "Select \* from SensorData1 where alertdatetime \> :sql\_last\_start" } } filter{ mutate{ add\_field=\>{view =\> "SensorData1" } } } output{ tcp{ codec =\> "json\_lines" host =\> "XXX.XXX.XXX" port =\> 8886 } } Thanks, Karthika ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 5:30am UTC](https://discuss.elastic.co/t/sequel-pooltimeout-error-when-contacting-database/28414/3 "2017-07-06T05:30:08Z")