Can vertica doc team document the mechanics of lock timeouts ?
To clarify, what i am asking is to explain how lock timeouts work. The LockTimeout parameter in our cluster is set to 800, but the dc_lock_attempts table shows 3 different values for timeout_in_seconds : 8, 800 , 1800.
This information would be useful when troubleshooting lock timeout, and it is information an administrator would need to know. Based on conversation with support in the past , I know that certain timeout in dc_errors are benign because there are multiple attempts to get a table lock.