Hello,
I am trying to update CAS from 6.5 to 6.6.12 and I had working application which is using cas login and redirecting to app. With CAS upgrade 6.6.12 it is generating this error and not redirecting to app and sending to login page.
I am able to see this in logs:
=============================================================
WHO: tstst
WHAT: could not execute batch; SQL [insert into Cas_Tickets (body, creation_Time, parent_Id, principal_Id, type, id) values (?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not execute batch
ACTION: OAUTH2_CODE_RESPONSE_CREATED
APPLICATION: CAS
WHEN: Thu Sep 28 16:09:45 UTC 2023
CLIENT IP ADDRESS: 0.0.0.32
SERVER IP ADDRESS: 23.2.2.22
=============================================================
>
2023-09-28 16:09:45,020 ERROR [org.apereo.cas.support.oauth.web.endpoints.OAuth20AuthorizeEndpointController] - <could not execute batch; SQL [insert into Cas_Tickets (body, creation_Time, parent_Id, principal_Id, type, id) values (?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not execute batch
HibernateJpaDialect.java:convertHibernateAccessException:280
HibernateJpaDialect.java:translateExceptionIfPossible:233
JpaTransactionManager.java:doCommit:566