"LockAcquisitionException: could not execute statement" in Red Hat Single Sign-On

Issue

When running Red Hat Single Sign-On (SSO), we're seeing Hibernate error LockAcquisitionException: could not execute statement that associated with database lock timeout.
For example, the error stacktrace looks like below when using MySQL database:

2021-01-18 19:31:39,500 ERROR [org.keycloak.services.error.KeycloakErrorHandler] (default task-14) Uncaught server error: org.keycloak.models.ModelException: org.hibernate.exception.LockAcquisitionException: could not execute statement
    at org.keycloak.connections.jpa.PersistenceExceptionConverter.convert(PersistenceExceptionConverter.java:61)
    at org.keycloak.connections.jpa.JpaExceptionConverter.convert(JpaExceptionConverter.java:31)
    at org.keycloak.transaction.JtaTransactionWrapper.handleException(JtaTransactionWrapper.java:65)
    at org.keycloak.transaction.JtaTransactionWrapper.commit(JtaTransactionWrapper.java:94)
    at org.keycloak.services.DefaultKeycloakTransactionManager.commit(DefaultKeycloakTransactionManager.java:136)
    at org.keycloak.services.filters.KeycloakTransactionCommitter.filter(KeycloakTransactionCommitter.java:43)
......
Caused by: org.hibernate.exception.LockAcquisitionException: could not execute statement
    at org.hibernate.dialect.MySQLDialect$3.convert(MySQLDialect.java:511)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
......
    at org.keycloak.transaction.JtaTransactionWrapper.commit(JtaTransactionWrapper.java:92)
    ... 55 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
    at sun.reflect.GeneratedConstructorAccessor253.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.Util.getInstance(Util.java:408)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:951)