You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Konstantin Orlov (Jira)" <ji...@apache.org> on 2024/10/15 06:20:00 UTC
[jira] [Updated] (IGNITE-23431) Add TRANSACTIONS system view
[ 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)