Same issue with CAS 6.6.8
On Wednesday, April 6, 2022 at 8:14:36 AM UTC-5 [email protected] wrote: > 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/3c3c0244-aa71-4b73-8241-e096b02dbe58n%40apereo.org.
