Derby
  1. Derby
  2. DERBY-4571

Memory leak on server when using "SET ROLE" command

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.5.1.1, 10.5.3.0
    • Fix Version/s: 10.5.3.1, 10.6.1.0
    • Component/s: Network Server
    • Labels:
    • Environment:
      Windows XP, Java 6 (build doesn't matter: 10-18)
    • Bug behavior facts:
      Crash, Data corruption

      Description

      Scenario:
      -connect into database
      -use command SET ROLE
      -repeat simple selects many times -> memory consumtions ends with database "outOfMemory: heap space" crash.

      Sometimes this crash ends with loosing (of course previously commited) data in different tables - this is in the case using "UPDATE" etc. command.
      Without command SET ROLE everythings works OK.

      1. D4571.java
        0.6 kB
        Knut Anders Hatlen
      2. DbRoleMemoryLeak.java
        0.8 kB
        Roman Musil
      3. memRole.sql
        0.8 kB
        Roman Musil
      4. memRole.sql
        0.8 kB
        Knut Anders Hatlen
      5. clear_deps.diff
        0.6 kB
        Knut Anders Hatlen
      6. test.diff
        4 kB
        Knut Anders Hatlen
      7. derby-4571-1a.diff
        5 kB
        Knut Anders Hatlen
      8. derby-4571-1a.stat
        0.2 kB
        Knut Anders Hatlen

        Activity

        Roman Musil created issue -
        Knut Anders Hatlen made changes -
        Field Original Value New Value
        Attachment D4571.java [ 12437065 ]
        Roman Musil made changes -
        Attachment DbRoleMemoryLeak.java [ 12437226 ]
        Attachment memRole.sql [ 12437227 ]
        Knut Anders Hatlen made changes -
        Attachment memRole.sql [ 12437348 ]
        Knut Anders Hatlen made changes -
        Attachment clear_deps.diff [ 12437349 ]
        Knut Anders Hatlen made changes -
        Assignee Knut Anders Hatlen [ knutanders ]
        Knut Anders Hatlen made changes -
        Attachment test.diff [ 12437486 ]
        Knut Anders Hatlen made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        Knut Anders Hatlen made changes -
        Attachment derby-4571-1a.diff [ 12437614 ]
        Attachment derby-4571-1a.stat [ 12437615 ]
        Knut Anders Hatlen made changes -
        Issue & fix info [Patch Available]
        Knut Anders Hatlen made changes -
        Status In Progress [ 3 ] Resolved [ 5 ]
        Issue & fix info [Patch Available]
        Fix Version/s 10.6.0.0 [ 12313727 ]
        Resolution Fixed [ 1 ]
        Knut Anders Hatlen made changes -
        Fix Version/s 10.5.3.1 [ 12314182 ]
        Knut Anders Hatlen made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Gavin made changes -
        Workflow jira [ 12500190 ] Default workflow, editable Closed status [ 12802790 ]

          People

          • Assignee:
            Knut Anders Hatlen
            Reporter:
            Roman Musil
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development