[IGNITE-23431] Add TRANSACTIONS system view

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Done
• Component/s: sql
• Labels: ignite-3
• Epic Link: Kill Queries
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Pavel Pereslegin
• Reporter: Konstantin Orlov
• Created: 15/Oct/24 06:14
• Updated: 15/Nov/24 09:40
• Resolved: 15/Nov/24 09:40

Description

In order to improve maintainability of the cluster, as well as to improve insight to the active transactions in the cluster and provide an ability to the cluster administrator to find problematic long-running resource consuming processes, let's add a node system view TRANSACTIONS with a list of active transactions.

  COORDINATOR_NODE    VARCHAR
  STATE               VARCHAR
  ID                  VARCHAR
  START_TIME          TIMESTAMP WITH LOCAL TIME ZONE
  TYPE                VARCHAR -- possible values are [READ_ONLY|READ_WRITE]
  PRIORITY            VARCHAR

Issue Links

• blocks: IGNITE-23488 Sql. Integrate cancellation of transaction with sql kill handler
• blocks: IGNITE-23489 Rest. Introduce new endpoints returning active transactions and running queries
• links to: GitHub Pull Request #4690