Open topic with navigation
A pseudo table generated to show information about all transactional locks known to the local Transaction Engine (TE). This table shows all local
SHARED locks and all distributed
SHARED locks on remote TEs will not be part of the pseudo table.
SOURCENODE column in this table specifies the TE from where this lock held is being reported, but not necessarily the TE where the transaction is executing.
NODEID column in this table specifies the TE on which the transaction owning the lock is currently running. This value for a given transaction does not change.
Caution: Client applications should never contain code that accesses
SYSTEM pseudo tables as they are subject to, and furthermore likely to, change from release to release.
|OBJECTID||integer||A unique ID identifying the database object.|
|TRANSACTIONID||bigint||The identifier of the transaction owning the lock.|
The Identifier of the TE where this transaction is running.
The type of lock to be set (
Note: At the time of writing, NuoDB 3.2.2 does not support the acquiring of
When connected to TE1, SELECT * FROM system.localtransactionallocks;==================================== Row #1 ==================================== OBJECTID: 72 TRANSID: 2050 NODEID: 2 LOCKTYPE: Shared SOURCENODE: 2 ==================================== Row #2 ==================================== OBJECTID: 70 TRANSID: 898 NODEID: 2 LOCKTYPE: Exclusive SOURCENODE: 2 When connected to TE2, SELECT * FROM system.localtransactionallocks; ==================================== Row #1 ==================================== OBJECTID: 70 TRANSID: 898 NODEID: 2 LOCKTYPE: Exclusive SOURCENODE: 3