SET SESSION GRACEPERIOD
Sets how long a session socket remains blocked while awaiting client input or output for a given query. If the socket is blocked for a continuous period that exceeds the grace period setting, the server shuts down the socket and throws a fatal error. The session is then terminated. If no grace period is set, the query can maintain its block on the socket indefinitely.
Vertica applies a session's grace period and
RUNTIMECAP settings independently. If no grace period is set, a query can continue to block indefinitely on a session socket, regardless of the query's
SET SESSION GRACEPERIOD duration
Specifies how long a query can block on any session socket, one of the following:
- Superusers can increase session grace period to any value, regardless of database or node settings.
- Non-superusers can only set the session grace period to a value equal to or lower than their own user setting. If no grace period is explicitly set for a user, the grace period for that user is inherited from the node or database settings.
See Handling Session Socket Blocking in the Administrator's Guide.