Hello, I am upgrading our CAS 6.4.6.1 to CAS 6.5.2. We are using the JPA ticket registry (PostgreSQL 11).
During startup, CAS creates the "postgres_jpa_ticket_entity" table (name changed from "cas_tickets" in 6.4.x) but *does not create the "int_locks" table* (name changed from "locks" in 6.4.x). As a result, during an saml or oidc authentication, I get the following error: 2022-04-06 14:28:25,148 DEBUG [org.hibernate.engine.transaction.internal.TransactionImpl] - <On TransactionImpl creation, JpaCompliance#isJpaTransactionComplianceEnabled == false> 2022-04-06 14:28:25,148 DEBUG [org.hibernate.engine.transaction.internal.TransactionImpl] - <begin> 2022-04-06 14:28:25,160 DEBUG [org.hibernate.engine.transaction.internal.TransactionImpl] - <On TransactionImpl creation, JpaCompliance#isJpaTransactionComplianceEnabled == false> 2022-04-06 14:28:25,160 DEBUG [org.hibernate.engine.transaction.internal.TransactionImpl] - <begin> 2022-04-06 14:28:25,410 DEBUG [org.hibernate.engine.transaction.internal.TransactionImpl] - <rolling back> 2022-04-06 14:28:25,414 INFO [org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit trail record BEGIN ============================================================= WHO: <username> WHAT: https:// <idp-host>/<idp-context-path>/idp/profile/SAML2/Callback?entityId=<entity-id> ACTION: SERVICE_TICKET_NOT_CREATED APPLICATION: CAS WHEN: Wed Apr 06 14:28:25 CEST 2022 CLIENT IP ADDRESS: <client-ip> SERVER IP ADDRESS: <server-ip> ============================================================= > 2022-04-06 14:28:25,414 DEBUG [org.hibernate.engine.transaction.internal.TransactionImpl] - <rolling back> 2022-04-06 14:28:25,415 DEBUG [org.springframework.webflow.engine.impl.FlowExecutionImpl] - <Attempting to handle [org.springframework.webflow.execution.ActionExecutionException: Exception thrown executing org.apereo.cas.web.flow.GenerateServiceTicketAction@3d3709d0 in state 'generateServiceTicket' of flow 'login' -- action execution attributes were 'map[[empty]]'] with root cause *[org.postgresql.util.PSQLException: ERROR: relation "int_lock" does not exist* Position: 8]> I was able to workaround this by manually creating the int_lock table using the spring_integration SQL script here : https://github.com/spring-projects/spring-integration/blob/5.5.x/spring-integration-jdbc/src/main/resources/org/springframework/integration/jdbc/schema-postgresql.sql -Frederic -- - Website: https://apereo.github.io/cas - Gitter Chatroom: https://gitter.im/apereo/cas - List Guidelines: https://goo.gl/1VRrw7 - Contributions: https://goo.gl/mh7qDG --- You received this message because you are subscribed to the Google Groups "CAS Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/CALRGK0oo6LHu%3DFUM87v7iVgqPXw8MPvdizpoMaNCr12RJA6tQQ%40mail.gmail.com.
