blocking_others_timeout option

Specifies the amount of time that another connection can block on the current connection's row and table locks before the current connection is rolled back. This option can be used to prevent a low priority task from blocking other connections for longer than the specified time.

Allowed values

Default

Scope

Remarks

When this option is set to 0, other connections can block on the current connection for an indefinite period of time.

If another connection is blocked on the current connection for longer than the number of milliseconds specified by this option, the current connection is rolled back. If the current connection is in the middle of a request, the request is interrupted. An error is returned if the connection was rolled back. The error may be returned twice if a request needs to be interrupted. If the connection was idle, the connection is rolled back immediately. The application must be prepared to fail or retry after a delay if it is rolled back.

Note

Locks created by LOCK TABLE table-name WITH HOLD are rolled back. Once a connection receives an error indicating that an operation was rolled back because of a blocking_others_timeout error, that connection receives the error on every request until the connection disconnects.

blocking_others_timeout option

Allowed values

Default

Scope

Remarks

Note

See also