Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-23429

Sql. Kill Queries

    XMLWordPrintableJSON

Details

    • Epic
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • Kill Queries

    Description

      In a dynamic environment, users may occasionally execute queries that were not intended, or where the query logic is faulty (e.g., missing WHERE clauses in an update or delete statement, or incorrect joins causing Cartesian products). The ability to cancel these queries reduces the impact of such mistakes by preventing excessive data processing or modification.

      Besides, long-running or resource-intensive queries can degrade overall system performance, especially in environments where multiple users or applications share resources. Query cancellation allows administrators or users to terminate these queries before they fully execute, freeing up valuable resources such as CPU, memory, and I/O for other important tasks, preventing the entire system from crashing.

      This epic consolidates the work for improving UX by providing an ability to cancel long running processes (like queries, transactions, or compute jobs) from both user-facing and management API's.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              korlov Konstantin Orlov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h
                  1h