Derby
  1. Derby
  2. DERBY-2029

Query timeout does not take effect if server machine crashes

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.2.2.0, 10.3.1.4
    • Fix Version/s: None
    • Component/s: JDBC, Network Client
    • Environment:
      Solaris 10, JDK 1.5
    • Urgency:
      Normal
    • Issue & fix info:
      Repro attached

      Description

      An application using the client driver will hang "infinite" if the
      server machine running the Derby server crashes during execution of a
      query even if it has specified a query timeout using
      Statement.setQueryTimeout().

      This problem can be reproduced (at least on Solaris 10) by:

      1. starting a Derby server on one machine and a Derby client on the second machine.
      2. In a Java program, create a connection and a statement and set the
      query timeout for the statement to a few seconds by:

      Statement.setQueryTimeout(10)

      3. Execute a query that take some time (more than 10 seconds).
      4. During execute of the query, take the power on the machine running
      the Derby server.
      5. Your program will hang "infinite".

      I will post a short repro program that can be used.

      1. QueryTimeout.java
        2 kB
        Olav Sandstaa

        Activity

        Olav Sandstaa created issue -
        Olav Sandstaa made changes -
        Field Original Value New Value
        Attachment QueryTimeout.java [ 12344166 ]
        Knut Anders Hatlen made changes -
        Issue & fix info [Repro attached]
        Kathey Marsden made changes -
        Labels derby_triage10_5_2
        Kathey Marsden made changes -
        Labels derby_triage10_5_2 derby_triage10_9
        Gavin made changes -
        Workflow jira [ 12388265 ] Default workflow, editable Closed status [ 12798332 ]

          People

          • Assignee:
            Unassigned
            Reporter:
            Olav Sandstaa
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:

              Development