Description
Displays the locks held or requested by the current user on tables.
Note
This view is introduced in V4.2.0.
Columns
| Column |
Type |
NULL? |
Description |
| SVR_IP |
varchar(46) |
NO |
The IP address of the OBServer node that holds or requests the lock. |
| SVR_PORT |
bigint(20) |
NO |
The port number of the OBServer node that holds or requests the lock. |
| TENANT_ID |
bigint(20) |
NO |
The ID of the tenant that holds or requests the lock. |
| TRANS_ID |
bigint(20) |
NO |
The transaction ID of the transaction that holds or requests the lock. |
| SESSION_ID |
bigint(20) |
NO |
The session ID of the transaction that holds or requests the lock.
Note
- This column is introduced in V4.3.2 of the V4.3.x series.
- This column is introduced in V4.2.5 of the V4.2.x series.
|
| TYPE |
varchar(9) |
NO |
The lock type.
- TM: table lock
- TX: transaction lock
- TR: row lock
|
| ID1 |
bigint(20) |
NO |
Lock identifier 1.
- For table locks, this field stores the value of TABLE_ID or TABLET_ID.
- For transaction locks, this field stores the value of TX_ID.
- For row locks, this field stores the value of TABLET_ID.
|
| ID2 |
varchar(533) |
NO |
Lock identifier 2.
- For table locks, this field stores NULL.
- For transaction locks, this field stores NULL.
- For row locks, this field stores the combination of TX_ID and row key.
|
| ID3 |
varchar(512) |
NO |
Lock identifier 3.
- For table locks, this field stores the value of TABLE_ID or TABLET_ID.
- For transaction locks, this field stores NULL.
- For row locks, this field stores the combination of TABLET_ID and row key.
Note
- This column is introduced in V4.3.2 of the V4.3.x series.
- This column is introduced in V4.2.5 of the V4.2.x series.
|
| LMODE |
varchar(8) |
NO |
The mode in which the lock is held.
- NONE: indicates that no lock is held.
- RS: ROW SHARE
- RX: ROW EXCLUSIVE
- S: SHARE
- SRX: SHARE ROW EXCLUSIVE
- X: EXCLUSIVE
|
| REQUEST |
varchar(8) |
NO |
The mode in which the lock is requested.
- NONE: indicates that no lock is requested.
- RS: ROW SHARE
- RX: ROW EXCLUSIVE
- S: SHARE
- SRX: SHARE ROW EXCLUSIVE
- X: EXCLUSIVE
|
| CTIME |
bigint(20) |
NO |
The time when the lock was held or requested, in microseconds. |
| BLOCK |
bigint(1) |
NO |
Whether the lock requested by the transaction is held by another transaction.
- 0: The requested lock is not held by another transaction, which means that the transaction holds the lock.
- 1: The requested lock is held by another transaction, which means that the transaction is blocked.
|
