Hello,
We are running 2 CAS 5.1.9 instances with ORacle 12 for the JPA ticket registry and we seeing the following error in the logs: ERROR [org.apereo.cas.ticket.registry.DefaultTicketRegistryCleaner] - <Unable to find org.apereo.cas.ticket.TicketGrantingTicketImpl with id TGT The ticket mentioned in the logs belongs to the 2nd webserver and the cleanup process seems to be only running on the 1st webserver every 30 minutes even though it configured on both. It never goes to the second webserver. The problem we run into is that because the cleanup process fails to find the ticket everything is rolled back and no ticket is removed. From what we can find the issue occurs when the TGT is removed from the 2nd server because of a user initiated logout at the same time that the 1st server initiates the cleanup process. Has anyone encountered something similar is there maybe a workaround to this so that tickets are cleaned up. Below is the configuration we have for the Ticket Registry and Cleanup Process: cas.ticket.registry.jpa.ticketLockType=NONE cas.ticket.registry.jpa.jpaLockingTimeout=3600 #cas.ticket.registry.jpa.healthQuery=select 1 cas.ticket.registry.jpa.isolateInternalQueries=false cas.ticket.registry.jpa.url=xxxxxxxxx cas.ticket.registry.jpa.failFast=true cas.ticket.registry.jpa.dialect=org.hibernate.dialect.Oracle12cDialect cas.ticket.registry.jpa.leakThreshold=10 #cas.ticket.registry.jpa.jpaLockingTgtEnabled=false cas.ticket.registry.jpa.batchSize=10 #cas.ticket.registry.jpa.defaultCatalog= #cas.ticket.registry.jpa.defaultSchema= cas.ticket.registry.jpa.user=xxxxxxxxxx cas.ticket.registry.jpa.ddlAuto=update cas.ticket.registry.jpa.password=xxxxxxxxxxx cas.ticket.registry.jpa.autocommit=false cas.ticket.registry.jpa.driverClass=oracle.jdbc.OracleDriver cas.ticket.registry.jpa.idleTimeout=5000 #cas.ticket.registry.jpa.dataSourceName= cas.ticket.registry.jpa.dataSourceProxy=false cas.ticket.registry.jpa.pool.suspension=false #Added to help with JPA Deadlock, space out the ticket cleanup # cas.ticket.registry.cleaner.appId=cas-ticket-registry-cleaner # cas.ticket.registry.cleaner.startDelay=10000 cas.ticket.registry.cleaner.repeatInterval=1800000 # cas.ticket.registry.cleaner.enabled=true ___________________ Juan Quintanilla [email protected]<mailto:[email protected]> -- - 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/SN6PR05MB518214A166A91403497A292F86400%40SN6PR05MB5182.namprd05.prod.outlook.com.
