Same issue with CAS 6.6.8
On Wednesday, April 6, 2022 at 8:14:36 AM UTC-5 fred...@lohier.org 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 cas-user+unsubscr...@apereo.org. 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.
