vmware-vcd is often restarted by watchdog

Products

• VMware Cloud Director

Issue/Introduction

The article provides:

• Lockout issue observed while deploying Vapp/VM in VCD

Environment

10.3.3

Cause

• Issue is caused because of high load or concurrency and that could lead to restart of VCD service by watchdog, which eventually we see timeout error in logs similar to below entries:

Postgres logs:

2024-01-01 08:00:00.000 UTC [11276] ERROR:  canceling statement due to lock timeout
2024-00-00 08:00:00.002 UTC [11276] CONTEXT:  while locking tuple (27,31) in relation "user_session"
2024-01-01 08:00:00.003 UTC [11276] STATEMENT:  /* Method: unknown */ update user_session set date_last_accessed=$1 where session_id=$1
2024-01-01 08:00:00.004 UTC [11266] ERROR:  canceling statement due to lock timeout

 debug.log:

2024-01-01 08:00:00.000 | ERROR    | pool-jetty-2412262        | JDBCExceptionReporter          | ERROR: canceling statement due to lock timeout 

 

Resolution

Issue fixed in VMware Cloud Director 10.6 version