please restart the database, it will work

"message": "could not execute statement; SQL [n/a]; nested exception is org.hibernate.PessimisticLockException: could not execute statement",

Select @@innodb_lock_wait_timeout;

set innodb_lock_wait_timeout=100