[Logstash.filters.jdbc.readwritedatabase]- No current connection


(Scopy) #1

Hello, I'm trying to set up a logstash 6.2.1 pipeline that does an enrichment lookup via the jdbc_static plugin. But I got an error like this:
[2018-07-23 05:39:26.291] [ERROR] [[main]-pipeline-manager] [logstash.filters.jdbc.readwritedatabase] - Exception when filling lookup db from loader query results, original exception: Java::JavaSql::SQLNonTransientConnectionException, original message: No current connection. {:backtrace=>["org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(org/apache/derby/impl/jdbc/SQLExceptionFactory)", "org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(org/apache/derby/impl/jdbc/SQLExceptionFactory)", "org.apache.derby.impl.jdbc.Util.generateCsSQLException(org/apache/derby/impl/jdbc/Util)", "org.apache.derby.impl.jdbc.Util.generateCsSQLException(org/apache/derby/impl/jdbc/Util)", "org.apache.derby.impl.jdbc.Util.noCurrentConnection(org/apache/derby/impl/jdbc/Util)", "org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(org/apache/derby/impl/jdbc/EmbedConnection)", "org.apache.derby.impl.jdbc.EmbedConnection.setAutoCommit(org/apache/derby/impl/jdbc/EmbedConnection)", "java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)", "org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:423)", "org.jruby.javasupport.JavaMethod.invokeDirect(org/jruby/javasupport/JavaMethod.java:290)", "usr.local.logstash_minus_6_dot_2_dot_1.vendor.bundle.jruby.$2_dot_3_dot_0.gems.sequel_minus_5_dot_4_dot_0.lib.sequel.adapters.jdbc.transactions.remove_transaction(/usr/local/logstash-6.2.1/vendor/bundle/jruby/2.3.0/gems/sequel-5.4.0/lib/sequel/adapters/jdbc/transactions.rb:84)", "usr.local.logstash_minus_6_dot_2_dot_1.vendor.bundle.jruby.$2_dot_3_dot_0.gems.sequel_minus_5_dot_4_dot_0.lib.sequel.adapters.jdbc.transactions.RUBY$method$remove_transaction$0$VARARGS(usr/local/logstash_minus_6_dot_2_dot_1/vendor/bundle/jruby/$2_dot_3_dot_0/gems/sequel_minus_5_dot_4_dot_0/lib/sequel/adapters/jdbc//usr/local/logstash-6.2.1/vendor/bundle/jruby/2.3.0/gems/sequel-5.4.0/lib/sequel/adapters/jdbc/transactions.rb)", "usr.local.logstash_minus_6_dot_2_dot_1.vendor.bundle.jruby.$2_dot_3_dot_0.gems.sequel_minus_5_dot_4_dot_0.lib.sequel.database.transactions._transaction(/usr/local/logstash-6.2.1/vendor/bundle/jruby/2.3.0/gems/sequel-5.4.0/lib/sequel/database/transactions.rb:228)", "usr.local.logstash_minus_6_dot_2_dot_1.vendor.bundle.jruby.$2_dot_3_dot_0.gems.sequel_minus_5_dot_4_dot_0.lib.sequel.database.transactions.block in transaction(/usr/local/logstash-6.2.1/vendor/bundle/jruby/2.3.0/gems/sequel-5.4.0/lib/sequel/database/transactions.rb:179)", "usr.local.logstash_minus_6_dot_2_dot_1.vendor.bundle.jruby.$2_dot_3_dot_0.gems.sequel_minus_5_dot_4_dot_0.lib.sequel.connection_pool.threaded.hold(/usr/local/logstash-6.2.1/vendor/bundle/jruby/2.3.0/gems/sequel-5.4.0/lib/sequel/connection_pool/threaded.rb:91)", "usr.local.logstash_minus_6_dot_2_dot_1.vendor.bundle.jruby.$2_dot_3_dot_0.gems.sequel_minus_5_dot_4_dot_0.lib.sequel.database.connecting.synchronize(/usr/local/logstash-6.2.1/vendor/bundle/jruby/2.3.0/gems/sequel-5.4.0/lib/sequel/database/connecting.rb:269)"]}
And what's the root cause?
Any suggestion will be appreciate.Thanks.


(Guy Boertje) #2

When to you get the error? Once at startup? After running for some time?


(system) #3

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