CAS 6.5.2 - JPA ticket service registry does not create int_lock table

[Frédéric Lohier]

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

[Pablo Vidaurri]

Same issue with CAS 6.6.8

[Andrey Nikolaev]

Add property

spring.integration.jdbc.initialize-schema=always