OPT_LOCK_WAIT_TIME_IN_SECS

OPT_LOCK_WAIT_TIME_IN_SECS is a load option that can be used to override the default object lock wait time in Workflow Orchestration.

Deployments and loads lock objects that they are processing. If there are multiple loads into a table and one (or more) of them is taking more than the default lock wait time to process, other loads will fail to get an object lock which will result in an error.

See also:

Load options

Usage

OPTION

OPT_LOCK_WAIT_TIME_IN_SECS: integer

Default: 5400

Notes

OPT_LOCK_WAIT_TIME_IN_SECS can be used with all table loads.

Examples

Increase wait time when a long-running load is causing others to fail

Let load A take on average 120 minutes to execute. Load B into the same entity often fails with error:

ERROR

"error":"Conflict",
"message":"Can't acquire lock"

OPT_LOCK_WAIT_TIME_IN_SECS is increased from default 90 minutes to 180 minutes in load B:

OPTION

OPT_LOCK_WAIT_TIME_IN_SECS: 10800

Load B will queue long enough for A to finish every time and errors will not be produced anymore.