SQLRecoverableException: No more data to read from socket

Elastic Stack Logstash
1

Anyone looks like this error?

Error registering plugin {:pipeline_id=>"main", :plugin=>"#<LogStash::FilterDelegator:0x1480f778 @metric_events_out=org.jruby.proxy.org.logstash.instrument.metrics.counter.LongCounter$Proxy2 - name: out value:0, @metric_events_in=org.jruby.proxy.org.logstash.instrument.metrics.counter.LongCounter$Proxy2 - name: in value:0, @metric_events_time=org.jruby.proxy.org.logstash.instrument.metrics.counter.LongCounter$Proxy2 - name: duration_in_millis value:0, @id="45c75852cfdf3e8e0583c293cb71c5cd0e3e4508617c7d89d9350056ac358eb0", @klass=LogStash::Filters::JdbcStreaming, @metric_events=#<LogStash::Instrument::NamespacedMetric:0x1da4ec3e @metric=#<LogStash::Instrument::Metric:0x62ce2d08 @collector=#<LogStash::Instrument::Collector:0x426d4c44 @agent=nil, @metric_store=#<LogStash::Instrument::MetricStore:0x51455846 @store=#<Concurrent::map:0x00000000000fac entries=3 default_proc=nil>, @structured_lookup_mutex=#Mutex:0x6bba9b4c, @fast_lookup=#<Concurrent::map:0x00000000000fb0 entries=191 default_proc=nil>>>>, @namespace_name=[:stats, :pipelines, :main, :plugins, :filters, :"45c75852cfdf3e8e0583c293cb71c5cd0e3e4508617c7d89d9350056ac358eb0", :events]>, @filter=<LogStash::Filters::JdbcStreaming jdbc_driver_library=>"/usr/share/logstash/vendor/jar/jdbc/ojdbc6.jar", jdbc_driver_class=>"Java::oracle.jdbc.driver.OracleDriver", jdbc_connection_string=>"jdbc:oracle:thin:@10.10.80.2:1521:SWMS", jdbc_user=>"SWMS", jdbc_password=>, statement=>"SELECT * FROM (SELECT A.CID, ROW_NUMBER() OVER (ORDER BY A.CID) AS NUM FROM TB_REN016_002 A WHERE A.LORA_DEVID = :lora_devid AND A.PORT = :port AND A.MEAIN_STAT_CODE_NO != 7005) WHERE NUM <= 1", parameters=>{"lora_devid"=>"LoraID", "port"=>"[inv_type][multi]"}, target=>"matchingCid", id=>"45c75852cfdf3e8e0583c293cb71c5cd0e3e4508617c7d89d9350056ac358eb0", enable_metric=>true, periodic_flush=>false, jdbc_validate_connection=>false, jdbc_validation_timeout=>3600, tag_on_failure=>["_jdbcstreamingfailure"], tag_on_default_use=>["_jdbcstreamingdefaultsused"], use_cache=>true, cache_expiration=>5.0, cache_size=>500>>", :error=>"Java::JavaSql::SQLRecoverableException: No more data to read from socket", :thread=>"#<Thread:0x50282167@/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:246 run>"}
[2018-08-27T19:45:19,056][ERROR][logstash.pipeline ] Pipeline aborted due to error {:pipeline_id=>"main", :exception=>#<Sequel::DatabaseConnectionError: Java::JavaSql::SQLRecoverableException: No more data to read from socket>, :backtrace=>["oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(oracle/jdbc/driver/T4CMAREngine.java:1157)", "oracle.jdbc.driver.T4CTTIfun.receive(oracle/jdbc/driver/T4CTTIfun.java:350)", "oracle.jdbc.driver.T4CTTIfun.doRPC(oracle/jdbc/driver/T4CTTIfun.java:227)", "oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(oracle/jdbc/driver/T4CTTIoauthenticate.java:407)", "oracle.jdbc.driver.T4CConnection.logon(oracle/jdbc/driver/T4CConnection.java:416)", "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:498)", "org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:468)", "org.jruby.javasupport.JavaMethod.invokeDirect(org/jruby/javasupport/JavaMethod.java:326)", "RUBY.connect(/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/sequel-5.5.0/lib/sequel/adapters/jdbc.rb:203)", "RUBY.make_new(/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/sequel-5.5.0/lib/sequel/connection_pool.rb:126)", "RUBY.assign_connection(/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/sequel-5.5.0/lib/sequel/connection_pool/threaded.rb:192)", "RUBY.acquire(/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/sequel-5.5.0/lib/sequel/connection_pool/threaded.rb:133)", "RUBY.hold(/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/sequel-5.5.0/lib/sequel/connection_pool/threaded.rb:90)", "RUBY.synchronize(/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/sequel-5.5.0/lib/sequel/database/connecting.rb:269)", "RUBY.test_connection(/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/sequel-5.5.0/lib/sequel/database/connecting.rb:279)", "RUBY.connect(/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/sequel-5.5.0/lib/sequel/database/connecting.rb:58)", "RUBY.connect(/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/sequel-5.5.0/lib/sequel/core.rb:116)", "RUBY.prepare_jdbc_connection(/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-filter-jdbc_streaming-1.0.3/lib/logstash/plugin_mixins/jdbc_streaming.rb:48)", "RUBY.prepare_connected_jdbc_cache(/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-filter-jdbc_streaming-1.0.3/lib/logstash/filters/jdbc_streaming.rb:194)", "RUBY.register(/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-filter-jdbc_streaming-1.0.3/lib/logstash/filters/jdbc_streaming.rb:116)", "org.jruby.RubyClass.finvoke(org/jruby/RubyClass.java:522)", "org.jruby.RubyBasicObject.send19(org/jruby/RubyBasicObject.java:1684)", "org.jruby.RubyBasicObject$INVOKER$i$send19.call(org/jruby/RubyBasicObject$INVOKER$i$send19.gen)", "RUBY.register_plugin(/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:341)", "RUBY.block in register_plugins(/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:352)", "org.jruby.RubyArray.each(org/jruby/RubyArray.java:1734)", "org.jruby.RubyArray$INVOKER$i$0$0$each.call(org/jruby/RubyArray$INVOKER$i$0$0$each.gen)", "RUBY.register_plugins(/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:352)", "RUBY.maybe_setup_out_plugins(/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:736)", "RUBY.start_workers(/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:362)", "RUBY.run(/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:289)", "RUBY.block in start(/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:249)", "org.jruby.RubyProc.call(org/jruby/RubyProc.java:289)", "org.jruby.RubyProc.call(org/jruby/RubyProc.java:246)", "java.lang.Thread.run(java/lang/Thread.java:748)"], :thread=>"#<Thread:0x50282167@/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:246 run>"}
[2018-08-27T19:45:19,076][ERROR][logstash.agent ] Failed to execute action {:id=>:main, :action_type=>LogStash::ConvergeResult::FailedAction, :message=>"Could not execute action: LogStash::PipelineAction::Create/pipeline_id:main, action_result: false", :backtrace=>nil}

2

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