[IGNITE-23489] Rest. Introduce new endpoints returning active transactions and running queries

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: rest
• Labels: ignite-3
• Epic Link: Kill Queries
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Konstantin Orlov
• Created: 18/Oct/24 10:52
• Updated: 18/Oct/24 10:53

Description

Need to introduce new set of endpoints to expose information similar to one exposed through SQL_QUERIES and TRANSACTIONS system views:

GET /management/v1/transactions/
GET /management/v1/transactions/{tx_id}
DELETE /management/v1/transactions/{tx_id}

GET /management/v1/sql/queries/
GET /management/v1/sql/queries/{query_id}
DELETE /management/v1/sql/queries/{query_id}

Issue Links

• is blocked by: IGNITE-23431 Add TRANSACTIONS system view
• is blocked by: IGNITE-23432 Provide System View for running queries