# SQLRecoverableException: No more data to read from socket

**URL:** <https://discuss.elastic.co/t/sqlrecoverableexception-no-more-data-to-read-from-socket/146158>\
**Category:** Logstash\
**Created:** [August 27, 2018, 10:45am UTC](https://discuss.elastic.co/t/sqlrecoverableexception-no-more-data-to-read-from-socket/146158 "2018-08-27T10:45:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![seungtae](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/seungtae/32/71413_2.png) [@seungtae](https://discuss.elastic.co/u/seungtae)\
**Post date:** [August 27, 2018, 10:45am UTC](https://discuss.elastic.co/t/sqlrecoverableexception-no-more-data-to-read-from-socket/146158/1 "2018-08-27T10:45:01Z")

</div>

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:🗺0x00000000000fac entries=3 default\_proc=nil\>, @structured\_lookup\_mutex=#Mutex:0x6bba9b4c, @fast\_lookup=#\<Concurrent:🗺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}

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 24, 2018, 10:45am UTC](https://discuss.elastic.co/t/sqlrecoverableexception-no-more-data-to-read-from-socket/146158/2 "2018-09-24T10:45:07Z")

</div>

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