java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLRecoverableException: IO Error: Connection reset

cloudera.com | 4 months ago
  1. 0

    Sqoop User Guide (v1.4.0-incubating)

    apache.org | 11 months ago
    java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLRecoverableException: IO Error: Connection reset
  2. 0

    [SQOOP-214] with default Sqoop connector, running into IO Error: Connection reset - Cloudera Open Source

    cloudera.org | 1 year ago
    java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLRecoverableException: IO Error: Connection reset
  3. 0

    Sqoop User Guide (v1.4.4)

    apache.org | 6 months ago
    java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLRecoverableException: IO Error: Connection reset
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    When using the default Sqoop connector for Oracle, some data does get transferred, but during the map-reduce job, seeing lots of errors as below: attempt_201105261333_0002_m_000001_0: log4j:WARN Not allowed to write to a closed appender. 11/05/26 16:23:47 INFO mapred.JobClient: Task Id : attempt_201105261333_0002_m_000002_0, Status : FAILED java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLRecoverableException: IO Error: Connection reset at com.cloudera.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:164) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62) at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:605) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:322) at org.apache.hadoop.mapred.Child$4.run(Child.java:268) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:396) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1115) at org.apache.hadoop.mapred.Child.main(Child.java:262) Caused by: java.lang.RuntimeException: java.sql.SQLRecoverableException: IO Error: Connection reset at com.cloudera.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:190) at com.cloudera.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:159) ... 9 more Caused by: java.sql.SQLRecoverableException: IO Error: Connection reset at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:428) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at com.cloudera.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:152) at com.cloudera.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:184) ... 10 more Caused by: java.net.SocketException: Connection reset at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96) at java.net.SocketOutputStream.write(SocketOutputStream.java:136) at oracle.net.ns.DataPacket.send(DataPacket.java:199) at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:211) at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:227) at oracle.net.ns.NetInputStream.read(NetInputStream.java:175) at oracle.net.ns.NetInputStream.read(NetInputStream.java:100) at oracle.net.ns.NetInputStream.read(NetInputStream.java:85) at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123) at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79) at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1122) at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1099) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:288) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:366) ... 18 more At the end: 11/05/26 16:27:51 INFO mapred.JobClient: Job complete: job_201105261333_0002 11/05/26 16:27:51 INFO mapred.JobClient: Counters: 13 11/05/26 16:27:51 INFO mapred.JobClient: Job Counters 11/05/26 16:27:51 INFO mapred.JobClient: SLOTS_MILLIS_MAPS=790364 11/05/26 16:27:51 INFO mapred.JobClient: Total time spent by all reduces waiting after reserving slots (ms)=0 11/05/26 16:27:51 INFO mapred.JobClient: Total time spent by all maps waiting after reserving slots (ms)=0 11/05/26 16:27:51 INFO mapred.JobClient: Launched map tasks=10 11/05/26 16:27:51 INFO mapred.JobClient: SLOTS_MILLIS_REDUCES=0 11/05/26 16:27:51 INFO mapred.JobClient: Failed map tasks=1 11/05/26 16:27:51 INFO mapred.JobClient: FileSystemCounters 11/05/26 16:27:51 INFO mapred.JobClient: HDFS_BYTES_READ=222 11/05/26 16:27:51 INFO mapred.JobClient: FILE_BYTES_WRITTEN=108922 11/05/26 16:27:51 INFO mapred.JobClient: HDFS_BYTES_WRITTEN=462 11/05/26 16:27:51 INFO mapred.JobClient: Map-Reduce Framework 11/05/26 16:27:51 INFO mapred.JobClient: Map input records=8 11/05/26 16:27:51 INFO mapred.JobClient: Spilled Records=0 11/05/26 16:27:51 INFO mapred.JobClient: Map output records=8 11/05/26 16:27:51 INFO mapred.JobClient: SPLIT_RAW_BYTES=222 11/05/26 16:27:51 INFO mapreduce.ImportJobBase: Transferred 462 bytes in 379.7796 seconds (1.2165 bytes/sec) 11/05/26 16:27:51 INFO mapreduce.ImportJobBase: Retrieved 8 records. 11/05/26 16:27:51 ERROR tool.ImportTool: Error during import: Import job failed! As Paul Socha pointed out, the workaround is to change the setup for your application, by adding this parameter to the java command: -Djava.security.egd=file:/dev/../dev/urandom This should be documented in the Sqoop User Guide.

    Cloudera Open Source | 6 years ago | Kathleen Ting
    java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLRecoverableException: IO Error: Connection reset
  6. 0

    Sqoop User Guide (v1.3.0-cdh3u6)

    cloudera.com | 6 months ago
    java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLRecoverableException: IO Error: Connection reset

  1. linxiaolong 1 times, last 1 week ago
  2. Tahir 11 times, last 1 month ago
  3. serious2monkeys 7 times, last 1 week ago
  4. linxiaolong 1 times, last 4 months ago
  5. regisso 1 times, last 5 months ago
5 more registered users
90 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.net.SocketException

    Connection reset

    at java.net.SocketOutputStream.socketWrite()
  2. Java RT
    SocketOutputStream.write
    1. java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
    2. java.net.SocketOutputStream.write(SocketOutputStream.java:136)
    2 frames
  3. Oracle jdbc
    OracleDriver.connect
    1. oracle.net.ns.DataPacket.send(DataPacket.java:199)
    2. oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:211)
    3. oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:227)
    4. oracle.net.ns.NetInputStream.read(NetInputStream.java:175)
    5. oracle.net.ns.NetInputStream.read(NetInputStream.java:100)
    6. oracle.net.ns.NetInputStream.read(NetInputStream.java:85)
    7. oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123)
    8. oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79)
    9. oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1122)
    10. oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1099)
    11. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:288)
    12. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
    13. oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366)
    14. oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752)
    15. oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:366)
    16. oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
    17. oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
    18. oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
    19. oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
    19 frames
  4. Java RT
    DriverManager.getConnection
    1. java.sql.DriverManager.getConnection(DriverManager.java:582)
    2. java.sql.DriverManager.getConnection(DriverManager.java:185)
    2 frames
  5. com.cloudera.sqoop
    DBInputFormat.setConf
    1. com.cloudera.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:152)
    2. com.cloudera.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:184)
    3. com.cloudera.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:159)
    3 frames
  6. Hadoop
    ReflectionUtils.newInstance
    1. org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62)
    2. org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
    2 frames
  7. Hadoop
    Child$4.run
    1. org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:605)
    2. org.apache.hadoop.mapred.MapTask.run(MapTask.java:322)
    3. org.apache.hadoop.mapred.Child$4.run(Child.java:268)
    3 frames
  8. Java RT
    Subject.doAs
    1. java.security.AccessController.doPrivileged(Native Method)
    2. javax.security.auth.Subject.doAs(Subject.java:396)
    2 frames
  9. Hadoop
    UserGroupInformation.doAs
    1. org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1115)
    1 frame
  10. Hadoop
    Child.main
    1. org.apache.hadoop.mapred.Child.main(Child.java:262)
    1 frame