Sequel::PoolTimeout error when contacting Database


(Karthika Ar) #1

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:insync'
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:insync'
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:inacquire'
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:insynchronize'
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:inexecute'
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:ineach'
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:inexecute_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:incall'
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:indo_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:incall'
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:inloop'
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


(Karthika Ar) #2

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


(system) #3