[
https://issues.apache.org/jira/browse/IGNITE-23755?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Pereslegin updated IGNITE-23755:
--------------------------------------
Description:
We need to provide more user-friendly information about locked objects in LOCKS
system view.
At the moment, the value returned by the {{toString()}} method of the
{{LockedKey}} class is displayed as the value of the locked object (OBJECT_ID).
Example:
||OWNING_NODE_ID 1||TX_ID|| OBJECT_ID || MODE ||
| ilsvt_n_0 | 0193537b-2340-0001-3668-6b4e00000001 | LockKey [ctx=17,
key=java.nio.HeapByteBuffer[pos=0 lim=3 cap=3]]
| X |
| ilsvt_n_0 | 0193537b-2340-0001-3668-6b4e00000001 | LockKey [ctx=null,
key=16_part_16] |
IX |
| ilsvt_n_0 | 0193537b-2341-0000-3668-6b4e00000001 | LockKey [ctx=17,
key=java.nio.HeapByteBuffer[pos=0 lim=3 cap=3]]
| S |
| ilsvt_n_0 | 0193537b-2341-0001-3668-6b4e00000001 | LockKey [ctx=17,
key=java.nio.HeapByteBuffer[pos=0 lim=3 cap=3]]
| X |
| ilsvt_n_0 | 0193537b-2341-0001-3668-6b4e00000001 | LockKey [ctx=16_part_8,
key=RowId [partitionId=8, uuid=00000193-537b-22a2-c8bf-bf1e67f0506e]] | X |
| ilsvt_n_0 | 0193537b-2341-0001-3668-6b4e00000001 | LockKey [ctx=null,
key=16_part_8] |
IX |
| ilsvt_n_1 | 0193537b-2341-0000-3668-6b4e00000001 | LockKey [ctx=17,
key=java.nio.HeapByteBuffer[pos=0 lim=3 cap=3]]
| X |
| ilsvt_n_1 | 0193537b-2341-0000-3668-6b4e00000001 | LockKey [ctx=16_part_10,
key=RowId [partitionId=10, uuid=00000193-537b-22a2-c402-15dd1ea44ed7]] | X |
| ilsvt_n_1 | 0193537b-2341-0000-3668-6b4e00000001 | LockKey [ctx=null,
key=16_part_10] |
IX |
| ilsvt_n_1 | 0193537b-2341-0001-3668-6b4e00000001 | LockKey [ctx=17,
key=java.nio.HeapByteBuffer[pos=0 lim=3 cap=3]]
| S |
A more readable output format needs to be defined and implemented.
For example:
{noformat}
INDEX_ID=<ID>, partition=<ID>, key=<VALUE/HASH>,
TABLE_ID=<ID> partition=<ID> rowId=<ROWID>
...
{noformat}
The format and information we can display must be agreed upon with the
engineers working on the transaction protocol.
was:
We need to provide more user-friendly information about locked objects in LOCKS
system view.
At the moment, the value returned by the {{toString()}} method of the
{{LockedKey}} class is displayed as the value of the locked object (OBJECT_ID).
Example:
||OWNING_NODE_ID 1||TX_ID|| OBJECT_ID || MODE ||
| ilsvt_n_0 | 0193537b-2340-0001-3668-6b4e00000001 | LockKey [ctx=17,
key=java.nio.HeapByteBuffer[pos=0 lim=3 cap=3]]
| X |
| ilsvt_n_0 | 0193537b-2340-0001-3668-6b4e00000001 | LockKey [ctx=null,
key=16_part_16] |
IX |
| ilsvt_n_0 | 0193537b-2341-0000-3668-6b4e00000001 | LockKey [ctx=17,
key=java.nio.HeapByteBuffer[pos=0 lim=3 cap=3]]
| S |
| ilsvt_n_0 | 0193537b-2341-0001-3668-6b4e00000001 | LockKey [ctx=17,
key=java.nio.HeapByteBuffer[pos=0 lim=3 cap=3]]
| X |
| ilsvt_n_0 | 0193537b-2341-0001-3668-6b4e00000001 | LockKey [ctx=16_part_8,
key=RowId [partitionId=8, uuid=00000193-537b-22a2-c8bf-bf1e67f0506e]] | X |
| ilsvt_n_0 | 0193537b-2341-0001-3668-6b4e00000001 | LockKey [ctx=null,
key=16_part_8] |
IX |
| ilsvt_n_1 | 0193537b-2341-0000-3668-6b4e00000001 | LockKey [ctx=17,
key=java.nio.HeapByteBuffer[pos=0 lim=3 cap=3]]
| X |
| ilsvt_n_1 | 0193537b-2341-0000-3668-6b4e00000001 | LockKey [ctx=16_part_10,
key=RowId [partitionId=10, uuid=00000193-537b-22a2-c402-15dd1ea44ed7]] | X |
| ilsvt_n_1 | 0193537b-2341-0000-3668-6b4e00000001 | LockKey [ctx=null,
key=16_part_10] |
IX |
| ilsvt_n_1 | 0193537b-2341-0001-3668-6b4e00000001 | LockKey [ctx=17,
key=java.nio.HeapByteBuffer[pos=0 lim=3 cap=3]]
| S |
A more readable output format needs to be defined and implemented.
For example:
{noformat}
INDEX_ID=<ID>, partition=<ID>, key=<VALUE>,
TABLE_ID=<ID> partition=<ID> rowId=<ROWID>
...
{noformat}
The format and information we can display must be agreed upon with the
engineers working on the transaction protocol.
> Provide more user-friendly information about locked objects in LOCKS system
> view.
> ---------------------------------------------------------------------------------
>
> Key: IGNITE-23755
> URL: https://issues.apache.org/jira/browse/IGNITE-23755
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Pavel Pereslegin
> Priority: Major
> Labels: ignite-3
>
> We need to provide more user-friendly information about locked objects in
> LOCKS system view.
> At the moment, the value returned by the {{toString()}} method of the
> {{LockedKey}} class is displayed as the value of the locked object
> (OBJECT_ID).
> Example:
> ||OWNING_NODE_ID 1||TX_ID|| OBJECT_ID || MODE ||
> | ilsvt_n_0 | 0193537b-2340-0001-3668-6b4e00000001 | LockKey [ctx=17,
> key=java.nio.HeapByteBuffer[pos=0 lim=3 cap=3]]
> | X |
> | ilsvt_n_0 | 0193537b-2340-0001-3668-6b4e00000001 | LockKey [ctx=null,
> key=16_part_16]
> | IX |
> | ilsvt_n_0 | 0193537b-2341-0000-3668-6b4e00000001 | LockKey [ctx=17,
> key=java.nio.HeapByteBuffer[pos=0 lim=3 cap=3]]
> | S |
> | ilsvt_n_0 | 0193537b-2341-0001-3668-6b4e00000001 | LockKey [ctx=17,
> key=java.nio.HeapByteBuffer[pos=0 lim=3 cap=3]]
> | X |
> | ilsvt_n_0 | 0193537b-2341-0001-3668-6b4e00000001 | LockKey [ctx=16_part_8,
> key=RowId [partitionId=8, uuid=00000193-537b-22a2-c8bf-bf1e67f0506e]] | X
> |
> | ilsvt_n_0 | 0193537b-2341-0001-3668-6b4e00000001 | LockKey [ctx=null,
> key=16_part_8]
> | IX |
> | ilsvt_n_1 | 0193537b-2341-0000-3668-6b4e00000001 | LockKey [ctx=17,
> key=java.nio.HeapByteBuffer[pos=0 lim=3 cap=3]]
> | X |
> | ilsvt_n_1 | 0193537b-2341-0000-3668-6b4e00000001 | LockKey [ctx=16_part_10,
> key=RowId [partitionId=10, uuid=00000193-537b-22a2-c402-15dd1ea44ed7]] | X |
> | ilsvt_n_1 | 0193537b-2341-0000-3668-6b4e00000001 | LockKey [ctx=null,
> key=16_part_10]
> | IX |
> | ilsvt_n_1 | 0193537b-2341-0001-3668-6b4e00000001 | LockKey [ctx=17,
> key=java.nio.HeapByteBuffer[pos=0 lim=3 cap=3]]
> | S |
> A more readable output format needs to be defined and implemented.
> For example:
> {noformat}
> INDEX_ID=<ID>, partition=<ID>, key=<VALUE/HASH>,
> TABLE_ID=<ID> partition=<ID> rowId=<ROWID>
> ...
> {noformat}
> The format and information we can display must be agreed upon with the
> engineers working on the transaction protocol.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
