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

Add a mechanism for cancelling runaway transactions.

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • SQL
    • Normal
    • High Value Fix

    Description

      We should add a mechanism by which the DBA can cancel a runaway transaction. Perhaps we could implement this as a new system procedure. This issue comes up on the user list frequently. For instance, see this thread: http://www.nabble.com/cancel-a-running-query--td19903183.html#a19903183 On the implementation side, Knut points out that EmbedConnection.cancelRunningStatement() might be a useful place to start.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. DERBY-6817 Cannot stop Query

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-6985 Document how to configure the keepAlive timeout on network sockets

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              rhillegas Richard N. Hillegas
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: