Issue: Deploy UI not loading active release tasks and error in logs

Issue

Deploy UI not loading active release tasks and error in logs

2022-03-15 08:47:15.959 [qtp2013054638-76] {username=paul.ferguson} ERROR
a.d.d.r.m.UnhandledExceptionMapper - Unhandled Exception: {} 

org.springframework.dao.TransientDataAccessResourceException: StatementCallback;
SQL [select t.`task_id`, t.`description`, t.`task_owner`, t.`scheduled_date`,
t.`worker_address`, t.`queued_date`, t.`is_sent_to_queue`, md.`metadata_key`,
md.`metadata_value` from `XLD_PENDING_TASKS` t left join `XLD_PENDING_TASKS_METADATA`
md on t.`task_id` = md.`task_id`]; HOUR_OF_DAY: 2 -> 3; nested exception
is java.sql.SQLException: HOUR_OF_DAY: 2 -> 3
  

Affected Products & Versions

Deploy

Cause

Bug in MySQL related daylight saving: https://bugs.mysql.com/bug.php?id=96276

Workaround/Resolution Action

Deleting or modifying the records which are in the non-existent time.

Make sure to take a database backup before performing any of these operations.