Logstash Oracle JDBC issue


(Anusha Samarakkodi) #1

could you please help to resolve this issue????

Here is my logstash configuration file
input {
jdbc {
jdbc_validate_connection => true
jdbc_connection_string => "jdbc:oracle:thin:@172.22.28.52:1521/prod"
jdbc_user => "TIMS"
jdbc_password => "ohdear7"
jdbc_driver_library => "E:/test/Downloads/ojdbc7.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
schedule => "* * * * "
statement => "select count(
)as test from account_number where account_no='52384'"
type => "OCS"
clean_run => "false"
record_last_run => "true"
}

}

output {

stdout { codec => rubydebug }

}

when i run the logstash configuration file in version 2.4 and 5.0 then it will shown following error

Settings: Default pipeline workers: 4
e[31mPipeline aborted due to error {:exception=>"Sequel::DatabaseConnectionError", :backtrace=>["oracle.jdbc.driver.T4CTTIoer.processError(oracle/jdbc/driver/T4CTTIoer.java:447)", "oracle.jdbc.driver.T4CTTIoer.processError(oracle/jdbc/driver/T4CTTIoer.java:389)", "oracle.jdbc.driver.T4CTTIoer.processError(oracle/jdbc/driver/T4CTTIoer.java:382)", "oracle.jdbc.driver.T4CTTIfun.processError(oracle/jdbc/driver/T4CTTIfun.java:675)", "oracle.jdbc.driver.T4CTTIoauthenticate.processError(oracle/jdbc/driver/T4CTTIoauthenticate.java:448)", "oracle.jdbc.driver.T4CTTIfun.receive(oracle/jdbc/driver/T4CTTIfun.java:513)", "oracle.jdbc.driver.T4CTTIfun.doRPC(oracle/jdbc/driver/T4CTTIfun.java:227)", "oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(oracle/jdbc/driver/T4CTTIoauthenticate.java:383)", "oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(oracle/jdbc/driver/T4CTTIoauthenticate.java:776)", "oracle.jdbc.driver.T4CConnection.logon(oracle/jdbc/driver/T4CConnection.java:432)", "oracle.jdbc.driver.PhysicalConnection.(oracle/jdbc/driver/PhysicalConnection.java:553)", "oracle.jdbc.driver.T4CConnection.(oracle/jdbc/driver/T4CConnection.java:254)", "oracle.jdbc.driver.T4CDriverExtension.getConnection(oracle/jdbc/driver/T4CDriverExtension.java:32)", "oracle.jdbc.driver.OracleDriver.connect(oracle/jdbc/driver/OracleDriver.java:528)", "java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:606)", "RUBY.connect(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/adapters/jdbc.rb:222)", "RUBY.make_new(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool.rb:116)", "RUBY.make_new(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:228)", "RUBY.available(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:201)", "RUBY._acquire(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:137)", "RUBY.acquire(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:151)", "RUBY.sync(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:282)", "org.jruby.ext.thread.Mutex.synchronize(org/jruby/ext/thread/Mutex.java:149)", "RUBY.sync(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:282)", "RUBY.acquire(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:150)", "RUBY.acquire(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/extensions/connection_validator.rb:98)", "RUBY.hold(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:106)", "RUBY.synchronize(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/database/connecting.rb:256)", "RUBY.test_connection(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/database/connecting.rb:266)", "RUBY.prepare_jdbc_connection(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.1.0/lib/logstash/plugin_mixins/jdbc.rb:173)", "RUBY.register(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.1.0/lib/logstash/inputs/jdbc.rb:187)", "RUBY.start_inputs(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:330)", "org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)", "RUBY.start_inputs(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:329)", "RUBY.start_workers(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:180)", "RUBY.run(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:136)", "RUBY.start_pipeline(E:/C/Downloads/Kibana/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/agent.rb:491)", "java.lang.Thread.run(java/lang/Thread.java:745)"], :level=>:error}e[0m
stopping pipeline {:id=>"main"}
The signal HUP is in use by the JVM and will not work correctly on this platform

I also run this configuration file logstash 5.0 and 2.4 then also same error will shown .pls help

Thanks
Anusha Eranda
SriLanka


Logstash with jdbc input for Oracle DB
(Magnus Bäck) #2

Unfortunately Logstash 2.4.0 has a bug that hides the interesting error message. What error message do you get with Logstash 5.x? Please post the log as preformatted text (use the toolbar button).


(Anusha Samarakkodi) #3

Here I attached below error log file when i run the logstash version 5.x

Sending Logstash logs to F:/Servers/Elastic/v5/logstash-5.0.0/logs which is now configured via log4j2.properties.

[2017-01-17T12:11:46,676][ERROR][logstash.agent ] Pipeline aborted due to error {:exception=>#<Sequel::DatabaseConnectionError: Java::JavaSql::SQLException: ORA-00604: error occurred at recursive SQL level 1

ORA-01882: timezone region not found

, :backtrace=>["oracle.jdbc.driver.T4CTTIoer.processError(oracle/jdbc/driver/T4CTTIoer.java:450)", "oracle.jdbc.driver.T4CTTIoer.processError(oracle/jdbc/driver/T4CTTIoer.java:392)", "oracle.jdbc.driver.T4CTTIoer.processError(oracle/jdbc/driver/T4CTTIoer.java:385)", "oracle.jdbc.driver.T4CTTIfun.processError(oracle/jdbc/driver/T4CTTIfun.java:1018)", "oracle.jdbc.driver.T4CTTIoauthenticate.processError(oracle/jdbc/driver/T4CTTIoauthenticate.java:501)", "oracle.jdbc.driver.T4CTTIfun.receive(oracle/jdbc/driver/T4CTTIfun.java:522)", "oracle.jdbc.driver.T4CTTIfun.doRPC(oracle/jdbc/driver/T4CTTIfun.java:257)", "oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(oracle/jdbc/driver/T4CTTIoauthenticate.java:437)", "oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(oracle/jdbc/driver/T4CTTIoauthenticate.java:954)", "oracle.jdbc.driver.T4CConnection.logon(oracle/jdbc/driver/T4CConnection.java:639)", "oracle.jdbc.driver.PhysicalConnection.connect(oracle/jdbc/driver/PhysicalConnection.java:666)", "oracle.jdbc.driver.T4CDriverExtension.getConnection(oracle/jdbc/driver/T4CDriverExtension.java:32)", "oracle.jdbc.driver.OracleDriver.connect(oracle/jdbc/driver/OracleDriver.java:566)", "java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)", "RUBY.connect(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/adapters/jdbc.rb:222)", "RUBY.make_new(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool.rb:116)", "RUBY.make_new(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool/threaded.rb:228)", "RUBY.available(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool/threaded.rb:201)", "RUBY._acquire(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool/threaded.rb:137)", "RUBY.acquire(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool/threaded.rb:151)", "RUBY.sync(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool/threaded.rb:282)", "org.jruby.ext.thread.Mutex.synchronize(org/jruby/ext/thread/Mutex.java:149)", "RUBY.sync(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool/threaded.rb:282)", "RUBY.acquire(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool/threaded.rb:150)", "RUBY.acquire(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/extensions/connection_validator.rb:98)", "RUBY.hold(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool/threaded.rb:106)", "RUBY.synchronize(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/database/connecting.rb:284)", "RUBY.test_connection(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/database/connecting.rb:294)", "RUBY.prepare_jdbc_connection(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-4.1.3/lib/logstash/plugin_mixins/jdbc.rb:171)", "RUBY.register(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-4.1.3/lib/logstash/inputs/jdbc.rb:191)", "RUBY.start_inputs(F:/Servers/Elastic/v5/logstash-5.0.0/logstash-core/lib/logstash/pipeline.rb:319)", "org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)", "RUBY.start_inputs(F:/Servers/Elastic/v5/logstash-5.0.0/logstash-core/lib/logstash/pipeline.rb:318)", "RUBY.start_workers(F:/Servers/Elastic/v5/logstash-5.0.0/logstash-core/lib/logstash/pipeline.rb:195)", "RUBY.run(F:/Servers/Elastic/v5/logstash-5.0.0/logstash-core/lib/logstash/pipeline.rb:153)", "RUBY.start_pipeline(F:/Servers/Elastic/v5/logstash-5.0.0/logstash-core/lib/logstash/agent.rb:250)", "java.lang.Thread.run(java/lang/Thread.java:745)"]}

[2017-01-17T12:11:46,801][INFO ][logstash.agent ] Successfully started Logstash API endpoint {:port=>9600}


(Magnus Bäck) #4

The log message lists two Oracle-specific errors. I have no idea what they mean.

Why did you ignore my request to post the log as preformatted text?


(Anusha Samarakkodi) #5

Sorry.Here I attached formatted log file. pls help to resolve this problem.

Sending Logstash logs to F:/Servers/Elastic/v5/logstash-5.0.0/logs which is now configured via log4j2.properties.

[2017-01-17T12:11:46,676][ERROR][logstash.agent           ] Pipeline aborted due to error {:exception=>#<Sequel::DatabaseConnectionError: Java::JavaSql::SQLException: ORA-00604: error occurred at recursive SQL level 1

ORA-01882: timezone region  not found

>, :backtrace=>["oracle.jdbc.driver.T4CTTIoer.processError(oracle/jdbc/driver/T4CTTIoer.java:450)", "oracle.jdbc.driver.T4CTTIoer.processError(oracle/jdbc/driver/T4CTTIoer.java:392)", "oracle.jdbc.driver.T4CTTIoer.processError(oracle/jdbc/driver/T4CTTIoer.java:385)", "oracle.jdbc.driver.T4CTTIfun.processError(oracle/jdbc/driver/T4CTTIfun.java:1018)", "oracle.jdbc.driver.T4CTTIoauthenticate.processError(oracle/jdbc/driver/T4CTTIoauthenticate.java:501)", "oracle.jdbc.driver.T4CTTIfun.receive(oracle/jdbc/driver/T4CTTIfun.java:522)", "oracle.jdbc.driver.T4CTTIfun.doRPC(oracle/jdbc/driver/T4CTTIfun.java:257)", "oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(oracle/jdbc/driver/T4CTTIoauthenticate.java:437)", "oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(oracle/jdbc/driver/T4CTTIoauthenticate.java:954)", "oracle.jdbc.driver.T4CConnection.logon(oracle/jdbc/driver/T4CConnection.java:639)", "oracle.jdbc.driver.PhysicalConnection.connect(oracle/jdbc/driver/PhysicalConnection.java:666)", "oracle.jdbc.driver.T4CDriverExtension.getConnection(oracle/jdbc/driver/T4CDriverExtension.java:32)", "oracle.jdbc.driver.OracleDriver.connect(oracle/jdbc/driver/OracleDriver.java:566)", "java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)", "RUBY.connect(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/adapters/jdbc.rb:222)", "RUBY.make_new(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool.rb:116)", "RUBY.make_new(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool/threaded.rb:228)", "RUBY.available(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool/threaded.rb:201)", "RUBY._acquire(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool/threaded.rb:137)", "RUBY.acquire(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool/threaded.rb:151)", "RUBY.sync(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool/threaded.rb:282)", "org.jruby.ext.thread.Mutex.synchronize(org/jruby/ext/thread/Mutex.java:149)", "RUBY.sync(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool/threaded.rb:282)", "RUBY.acquire(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool/threaded.rb:150)", "RUBY.acquire(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/extensions/connection_validator.rb:98)", "RUBY.hold(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/connection_pool/threaded.rb:106)", "RUBY.synchronize(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/database/connecting.rb:284)", "RUBY.test_connection(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/sequel-4.39.0/lib/sequel/database/connecting.rb:294)", "RUBY.prepare_jdbc_connection(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-4.1.3/lib/logstash/plugin_mixins/jdbc.rb:171)", "RUBY.register(F:/Servers/Elastic/v5/logstash-5.0.0/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-4.1.3/lib/logstash/inputs/jdbc.rb:191)", "RUBY.start_inputs(F:/Servers/Elastic/v5/logstash-5.0.0/logstash-core/lib/logstash/pipeline.rb:319)", "org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)", "RUBY.start_inputs(F:/Servers/Elastic/v5/logstash-5.0.0/logstash-core/lib/logstash/pipeline.rb:318)", "RUBY.start_workers(F:/Servers/Elastic/v5/logstash-5.0.0/logstash-core/lib/logstash/pipeline.rb:195)", "RUBY.run(F:/Servers/Elastic/v5/logstash-5.0.0/logstash-core/lib/logstash/pipeline.rb:153)", "RUBY.start_pipeline(F:/Servers/Elastic/v5/logstash-5.0.0/logstash-core/lib/logstash/agent.rb:250)", "java.lang.Thread.run(java/lang/Thread.java:745)"]}

[2017-01-17T12:11:46,801][INFO ][logstash.agent           ] Successfully started Logstash API endpoint {:port=>9600}

(Anusha Samarakkodi) #6

Any one know how to resolve this problem????:fearful:


(Magnus Bäck) #7

Jeez, have patience! If you want guaranteed response times for questions there are paid subscription services.

There are two concrete Oracle-specific error messages. Have you investigated what they mean?


(system) #8

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