This feature kills transactions that have been idle for the specified time period to release resources in time.
If a connection starts a transaction (explicitly using begin
/start transaction
or implicitly) but no new statement has been executed for the specified threshold period, the connection will be killed.
Use the cdb_kill_idle_trans_timeout
parameter to enable or disable the feature. If it is 0
, the feature is disabled; otherwise, a connection idle for cdb_kill_idle_trans_timeout
or wait_timeout
seconds, whichever is smaller, will be killed. (wait_timeout
is a session parameter.)
Parameter | Effective Immediately | Type | Default Value | Valid Values/Value Range | Description |
---|---|---|---|---|---|
cdb_kill_idle_trans_timeout | Yes | ulong | 0 | [0, 31536000] | If it is 0 , the feature is disabled; otherwise, a transaction idle for cdb_kill_idle_trans_timeout seconds will be killed. |
Note:Currently, you cannot directly modify the values of the above parameter. If needed, submit a ticket for assistance.
Was this page helpful?