Skip to content

UNLOCK CLUSTER

Description

The UNLOCK CLUSTER syntax is used to release the lock applied to the CLUSTER by the LOCK CLUSTER WITH statement.

Syntax

UnlockCluster ::=
  'UNLOCK' 'CLUSTER' ('TIMEOUT' timeoutMillis)?

timeoutMillis ::=
  long

Supplement

  • When the CLUSTER is not in a locked state, it is impossible to release the lock; otherwise, an exception will be thrown.
  • timeoutMillis is used to indicate the timeout duration for attempting to unlock, with the unit being milliseconds. When not specified, the default value is 3,000 milliseconds.

Example

  • Unlock the CLUSTER without setting a timeout.
UNLOCK CLUSTER;
  • Unlock the CLUSTER and set the timeout to 2000 milliseconds.
UNLOCK CLUSTER TIMEOUT 2000;

Reserved word

UNLOCK,CLUSTER

Related links