java.sql.SQLException: System or internal error java.io.IOException

sqoop-user | Jarek Jarcec Cecho | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Re: Sqoop connection to Informix Database

    sqoop-user | 4 years ago | Jarek Jarcec Cecho
    java.sql.SQLException: System or internal error java.io.IOException
  2. 0

    Caused by: org.hibernate.TransactionException: JDBC rollback failed

    Stack Overflow | 4 years ago | Shanmukha Bollapragada
    org.springframework.jdbc.UncategorizedSQLException: Hibernate flushing: Could not execute JDBC batch update; uncategorized SQLException for SQL [insert into user_restrict_acc (access_level, datatype_name, user_id, satellite) values (?, ?, ?, ?)]; SQL state [IX000]; error code [-79716]; System or internal error java.io.IOException; nested exception is java.sql.SQLException: System or internal error java.io.IOException

    Root Cause Analysis

    1. java.io.IOException

      No message provided

      at com.informix.asf.IfxDataInputStream.readFully()
    2. com.informix.asf
      IfxDataInputStream.readSmallInt
      1. com.informix.asf.IfxDataInputStream.readFully(IfxDataInputStream.java:148)
      2. com.informix.asf.IfxDataInputStream.readSmallInt(IfxDataInputStream.java:453)
      2 frames
    3. com.informix.jdbc
      IfxResultSet.next
      1. com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2597)
      2. com.informix.jdbc.IfxSqli.j(IfxSqli.java:2280)
      3. com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:4681)
      4. com.informix.jdbc.IfxResultSet.next(IfxResultSet.java:526)
      4 frames
    4. org.apache.sqoop
      DBRecordReader.nextKeyValue
      1. org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:238)
      1 frame
    5. Hadoop
      Mapper.run
      1. org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:458)
      2. org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:76)
      3. org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:85)
      4. org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:139)
      4 frames
    6. org.apache.sqoop
      AutoProgressMapper.run
      1. org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:182)
      1 frame
    7. Hadoop
      Child$4.run
      1. org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:645)
      2. org.apache.hadoop.mapred.MapTask.run(MapTask.java:325)
      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:1332)
      1 frame
    10. Hadoop
      Child.main
      1. org.apache.hadoop.mapred.Child.main(Child.java:262)
      1 frame