Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3698

Bulk SQL INSERT, SELECT, UPDATE operations creates OutOfMemoryError after first Cleanup action on serverside

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 10.4.1.3
    • Fix Version/s: None
    • Component/s: Network Server
    • Labels:
      None
    • Environment:
      Windows XP, JDK 1.4

      Description

      In the migration of an DB,
      By using JDBC (connection is open one time in the begining)
      after many INSERT, SELECT,UPDATE statement executions (more than 3500)
      I got the following Exception on the client side:

      SELECT PK_SEQ, NAME, URL FROM EUPROJ.FIRM WHERE NAME ='INSTITUTE OF EDUCATION University OF LONDON'

      com.javaDevHome.ladyBeetle.exception.MicroJDBCException: java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ001, SQLERRMC: java.lang.OutOfMemoryErrorXJ001.U
      at com.javaDevHome.ladyBeetle.MicroJDBCConnection.executeQuery(MicroJDBCConnection.java:251)
      at com.javaDevHome.ladyBeetle.MicroJDBCDBase.selectRowSilent(MicroJDBCDBase.java:133)
      at euProj.transfer.Transfer.procFirmNew(Transfer.java:259)
      at euProj.transfer.Transfer.procshortListNew(Transfer.java:200)
      at euProj.transfer.Transfer.readConsortiums(Transfer.java:524)
      at euProj.transfer.Transfer.procContract(Transfer.java:107)
      at euProj.transfer.Transfer.readLine(Transfer.java:554)
      at euProj.transfer.Transfer.main(Transfer.java:594)
      Caused by: java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ001, SQLERRMC: java.lang.OutOfMemoryErrorXJ001.U
      at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
      at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
      at org.apache.derby.client.am.Statement.executeQuery(Unknown Source)
      at com.javaDevHome.ladyBeetle.MicroJDBCConnection.executeQuery(MicroJDBCConnection.java:247)
      ... 7 more
      Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ001, SQLERRMC: java.lang.OutOfMemoryErrorXJ001.U
      at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
      at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
      at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
      at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
      at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
      at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
      at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
      at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
      at org.apache.derby.client.am.Statement.executeQueryX(Unknown Source)
      ... 9 more

      in derby.log on the server side :

      2008-05-29 20:33:04.578 GMT Thread[DRDAConnThread_5,5,main] (XID = 171959), (SESSIONID = 4), (DATABASE = euProj03), (DRDAID = NF000001.H1CF-4339779978832484505

      {5}), Begin compiling prepared statement: SELECT PK_SEQ, NAME, URL FROM EUPROJ.FIRM WHERE NAME ='INSTITUTE OF EDUCATION University OF LONDON' :End prepared statement
      2008-05-29 20:33:04.609 GMT Thread[DRDAConnThread_5,5,main] (XID = 171959), (SESSIONID = 4), (DATABASE = euProj03), (DRDAID = NF000001.H1CF-4339779978832484505{5}

      ), End compiling prepared statement: SELECT PK_SEQ, NAME, URL FROM EUPROJ.FIRM WHERE NAME ='INSTITUTE OF EDUCATION University OF LONDON' :End prepared statement
      2008-05-29 20:33:07.499 GMT Thread[DRDAConnThread_5,5,main] (XID = 171959), (SESSIONID = 4), (DATABASE = euProj03), (DRDAID = NF000001.H1CF-4339779978832484505

      {5}), Cleanup action starting
      2008-05-29 20:33:07.499 GMT Thread[DRDAConnThread_5,5,main] (XID = 171959), (SESSIONID = 4), (DATABASE = euProj03), (DRDAID = NF000001.H1CF-4339779978832484505{5}

      ), Failed Statement is: SELECT PK_SEQ, NAME, URL FROM EUPROJ.FIRM WHERE NAME ='INSTITUTE OF EDUCATION University OF LONDON'
      java.lang.OutOfMemoryError
      Cleanup action completed
      2008-05-29 20:33:37.359 GMT Thread[DRDAConnThread_6,5,main] (XID = 169430), (SESSIONID = 6), (DATABASE = euProj03), (DRDAID = NF000001.H1D1-4255618960795994455

      {7}), Rolling back
      2008-05-29 20:33:37.359 GMT Thread[DRDAConnThread_6,5,main] (XID = 169430), (SESSIONID = 6), (DATABASE = euProj03), (DRDAID = NF000001.H1D1-4255618960795994455{7}

      ), Rolling back
      2008-05-29 20:33:37.359 GMT Thread[DRDAConnThread_4,5,main] (XID = 143043), (SESSIONID = 5), (DATABASE = euProj03), (DRDAID = NF000001.H1D0-4255900435772705908

      {6}), Rolling back
      2008-05-29 20:33:37.359 GMT Thread[DRDAConnThread_4,5,main] (XID = 143043), (SESSIONID = 5), (DATABASE = euProj03), (DRDAID = NF000001.H1D0-4255900435772705908{6}

      ), Rolling back

      in the derby.log there is no other Cleanup action, this is the first and the only one.

      I have started the server by default heap memory options:
      java -Dderby.system.home=C:\derby -jar %DERBY_HOME%\lib\derbyrun.jar server start

        Attachments

        1. log.txt
          11 kB
          Semih ARAL
        2. derby04.log
          0.1 kB
          Semih ARAL
        3. derby03.log
          1 kB
          Semih ARAL
        4. derby02.log
          0.9 kB
          Semih ARAL
        5. derby01.log
          1 kB
          Semih ARAL
        6. ac80220011x011ax5218x3922x0000760c8b635ec2.class
          3 kB
          Semih ARAL
        7. ac80220011x011ax620ax9a0bx0000760c8b63574a.class
          5 kB
          Semih ARAL
        8. ac80220011x011ax550cx96f4x0000760c8b63674e.class
          3 kB
          Semih ARAL
        9. ac80220011x011ax5c5ax34c5x0000760c8b636b66.class
          7 kB
          Semih ARAL
        10. ac80220011x011ax5a87xb7a0x0000760c8b6345b3.class
          3 kB
          Semih ARAL
        11. ac38c30028x011ax550cx96f4x0000760c8b6335b.class
          5 kB
          Semih ARAL
        12. ac004b0019x011ax5fe9x6337x0000760c8b634386.class
          5 kB
          Semih ARAL

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              semih Semih ARAL
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: