Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-756 OutOfMemory Error on continous execution of select statement using COUNT() and DISTINCT on same connection
  3. DERBY-912

OutOfMemory error on continuous execution of SQL statement

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.0.2.0
    • 10.2.2.0, 10.3.1.4
    • Store
    • None
    • cygwin, jdk 1.4

    Description

      After fixing the original memory leak, I still run into problems on repeated execution of a sql statement. Take the sample program in the bug and run it with a small heap size (4m). After around 80-90K executions an outofmemory error is thrown. I took snapshots of the heap while the program was running but couldn't find anything obviously wrong.

      Attachments

        1. derby-912.diff
          2 kB
          Knut Anders Hatlen
        2. derby-912-v2.diff
          2 kB
          Knut Anders Hatlen

        Issue Links

          is duplicated by

          Sub-task - The sub-task of the issue DERBY-1978 OutOfMemory error still happens in 10.2.1.6

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-2176 OutOfMemoryError in Network Server after running DOTS-like test for weeks

          • Major - Major loss of function.
          • Closed

          Activity

            People

              knutanders Knut Anders Hatlen
              mkhettry Manish Khettry
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: