[
https://issues.apache.org/jira/browse/IGNITE-23431?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-23431:
--------------------------------------
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.
{code:sql}
COORDINATOR_NODE_ID VARCHAR
STATE VARCHAR
ID VARCHAR
START_TIME TIMESTAMP WITH LOCAL TIME ZONE
IMPLICIT BOOLEAN
TYPE VARCHAR -- possible values are [READ_ONLY|READ_WRITE]
PRIORITY VARCHAR
{code}
was:
Add a *node* system view *TRANSACTIONS* with a list of active transactions.
{code:sql}
COORDINATOR_NODE_ID VARCHAR
STATE VARCHAR
ID VARCHAR
START_TIME TIMESTAMP WITH LOCAL TIME ZONE
IMPLICIT BOOLEAN
TYPE VARCHAR -- possible values are [READ_ONLY|READ_WRITE]
PRIORITY VARCHAR
{code}
> Add TRANSACTIONS system view
> ----------------------------
>
> Key: IGNITE-23431
> URL: https://issues.apache.org/jira/browse/IGNITE-23431
> Project: Ignite
> Issue Type: Improvement
> Reporter: Konstantin Orlov
> Priority: Major
> Labels: ignite-3
>
> 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.
> {code:sql}
> COORDINATOR_NODE_ID VARCHAR
> STATE VARCHAR
> ID VARCHAR
> START_TIME TIMESTAMP WITH LOCAL TIME ZONE
> IMPLICIT BOOLEAN
> TYPE VARCHAR -- possible values are [READ_ONLY|READ_WRITE]
> PRIORITY VARCHAR
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
