Pavel Pereslegin created IGNITE-23755:
-----------------------------------------
Summary: 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: Bug
Components: sql
Reporter: Pavel Pereslegin
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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
