Upgraded to CAS 6.6.8 from 6.3.7. 

cas.ticket.registry.jpa.ddlAuto=create
also tried update. 

I only see one table created: postgres_jpa_ticket_entity

but I'm getting this error:


2023-07-07 16:25:05,647 ERROR 
[org.apereo.cas.ticket.registry.DefaultTicketRegistryCleaner] - <Failed to 
lock mutex at 9a2cc683-5ea9-3212-b465-44f88885980d; nested exception is 
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; 
bad SQL grammar [UPDATE INT_LOCK SET CLIENT_ID=?, CREATED_DATE=? WHERE 
REGION=? AND LOCK_KEY=? AND (CLIENT_ID=? OR CREATED_DATE<?)]; nested 
exception is org.postgresql.util.PSQLException: ERROR: relation "int_lock" 
does not exist
  Position: 8
        JdbcLockRegistry.java:rethrowAsLockException:197
        JdbcLockRegistry.java:tryLock:262
        DefaultLockRepository.java:lambda$execute$1:28


I see someone else manually installed a spring scema to create INT_LOCK 
table but that does not seem like a CAS table.

-psv

-- 
- 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/38fac90e-8d3b-41cf-9364-7ae75f62c884n%40apereo.org.

Reply via email to