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

Memory "leak" when setting a query timeout

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 10.8.1.2
    • None
    • JDBC
    • Normal
    • Seen in production

    Description

      When setting a query timeout, a new CancelQueryTask is created and scheduled. This CancelQueryTask is still held in the java.util.Timer class's task queue even when the query is already finished until the query timeout is reached.

      For example, if i set a query timeout of 2h using statement.setQueryTimeout(7200) this means that the CancelQueryTask will remain for 2 hours even if the query is finished within 1 second. In scenarios with high load, this can lead to Out of Memory Situations.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4137 OOM issue using XA with timeouts

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              tbrandl Thomas Brandl
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: