java.sql.SQLRecoverableException: Io exception: Socket closed

Stack Overflow | Shweta | 7 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Apache Flink JDBC InputFormat throwing java.net.SocketException: Socket closed

    Stack Overflow | 7 months ago | Shweta
    java.sql.SQLRecoverableException: Io exception: Socket closed

    Root Cause Analysis

    1. java.sql.SQLRecoverableException

      Io exception: Socket closed

      at oracle.jdbc.driver.SQLStateMapping.newSQLException()
    2. Oracle jdbc
      ScrollableResultSet.isLast
      1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:101)
      2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
      3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
      4. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
      5. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:521)
      6. oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1024)
      7. oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:314)
      8. oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:228)
      9. oracle.jdbc.driver.ScrollableResultSet.cacheRowAt(ScrollableResultSet.java:1839)
      10. oracle.jdbc.driver.ScrollableResultSet.isValidRow(ScrollableResultSet.java:1823)
      11. oracle.jdbc.driver.ScrollableResultSet.isLast(ScrollableResultSet.java:349)
      11 frames
    3. Unknown
      JDBCInputFormat.reachedEnd
      1. JDBCInputFormat.reachedEnd(JDBCInputFormat.java:98)
      1 frame
    4. flink-runtime
      Task.run
      1. org.apache.flink.runtime.operators.DataSourceTask.invoke(DataSourceTask.java:173)
      2. org.apache.flink.runtime.taskmanager.Task.run(Task.java:559)
      2 frames
    5. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame