This issue occurs if the vCenter Server database virtual machine is in a quiesced state during a snapshot operation.
The error Connection commit failed: -1 indicates that the vCenter Server is unaware whether the database commit operation was successful or failed.
The vCenter database layer (Vdb) replays the failed SQL statement requests to continue the vCenter operation. During the replay process, if it turns out that the previously failed SQL statement has been committed to the database, and if there is a unique constraint definition on the specific table, the ODBC driver reports the unique constraint violated error to the VMware VirtualCenter Server service and the service shuts down to prevent corruption of the vCenter Server database.