Derby
  1. Derby
  2. DERBY-4294

java.lang.OutOfMemoryError from mailjdbc test after running for one hour from select * from REFRESH.INBOX

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.3.3.0, 10.4.2.0, 10.5.3.0, 10.6.2.1
    • Fix Version/s: 10.7.1.1
    • Component/s: Store
    • Environment:
      Window Vista
    • Urgency:
      Normal
    • Issue & fix info:
      Repro attached
    • Bug behavior facts:
      Crash

      Description

      After running mailjdbc test on 10.3 branch, select * from REFRESH.INBOX gave me error like:
      ERROR XJ001: Java exception: 'Java heap space: java.lang.OutOfMemoryError'

      I also see the same error on 10.5 branch.

      I inculde my mailsdb directory in this bug too.

      How to reproduce this issue:
      1. cd mailjdbc
      2. java org.apache.derbyTesting.system.mailjdbc.MailJdbc embedded
      3. Wait for an hour and ignore Primary key violation error
      ( : INFO :Refresh Thread : Error while inserting attachments:The statement was ab
      orted because it would have caused a duplicate key value in a unique or primary
      key constraint or unique index identified by 'ATTACH__PK' defined on 'ATTACH'.)

      1. Derby4294_pid6920.zip
        1.65 MB
        Lily Wei
      2. Heapspaceerror.zip
        536 kB
        Lily Wei

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 12467117 ] Default workflow, editable Closed status [ 12802805 ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Kristian Waagan made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Kristian Waagan made changes -
          Fix Version/s 10.7.1.1 [ 12315564 ]
          Affects Version/s 10.6.2.1 [ 12315343 ]
          Affects Version/s 10.5.3.0 [ 12314117 ]
          Affects Version/s 10.4.2.0 [ 12313345 ]
          Issue & fix info [Release Note Needed, Repro attached] [Repro attached]
          Kristian Waagan made changes -
          Link This issue relates to DERBY-5257 [ DERBY-5257 ]
          Kathey Marsden made changes -
          Labels derby_triage10_5_2
          Dag H. Wanvik made changes -
          Urgency Normal
          Bug behavior facts [Crash]
          Issue & fix info [Release Note Needed] [Release Note Needed, Repro attached]
          Knut Anders Hatlen made changes -
          Link This issue is related to DERBY-1511 [ DERBY-1511 ]
          Lily Wei made changes -
          Attachment Derby4294_pid6920.zip [ 12412215 ]
          Knut Anders Hatlen made changes -
          Comment [ I think you got the the digits right, but the total size of the CLOBs is 24MB, so they may exhaust a small heap if they for some reason aren't freed when moving to the next row.

          For the record, I didn't see the OOME when I tested with default heap settings on JDK 1.6.0_13 on OpenSolaris, but I did see it when reduced the heap size to 64 MB (-Xmx64M). ]
          Knut Anders Hatlen made changes -
          Original Estimate 0h [ 0 ]
          Remaining Estimate 0h [ 0 ]
          Dag H. Wanvik made changes -
          Issue & fix info [Existing Application Impact] [Release Note Needed]
          Lily Wei made changes -
          Field Original Value New Value
          Attachment Heapspaceerror.zip [ 12412100 ]
          Lily Wei created issue -

            People

            • Assignee:
              Unassigned
              Reporter:
              Lily Wei
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development