Hi, We are running CAS 5.1.2 with Oracle 12 as the backend database for ticketing/audit logs and while load testing the environment we started running into issues with the database being deadlocked. In our oracle trace logs we are seeing the following:
delete from TICKETGRANTINGTICKET where ticketGrantingTicket_ID=:1 In the cas logs we have the following: 2019-01-25 16:55:27,127 ERROR [org.springframework.boot.web.support.ErrorPageFilter] - <Forwarding to error page from request [/logout] due to exception [Exception thrown executing org.apereo.cas.web.flow.TerminateSessionAction@23fdf9ec in state 'terminateSession' of flow 'logout' -- action execution attributes were 'map[[empty]]']> org.springframework.webflow.execution.ActionExecutionException: Exception thrown executing org.apereo.cas.web.flow.TerminateSessionAction@23fdf9ec in state 'terminateSession' of flow 'logout' -- action execution attributes were 'map[[empty]]' Caused by: javax.persistence.PersistenceException: org.hibernate.exception.LockAcquisitionException: could not execute statement Caused by: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource It seems to only be occurring during logout requests and not does seem to happen to all the requests. Has anyone encountered something similar with deadlocks on the Database. Thanks! ___________________ Juan Quintanilla -- - 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/CY4PR05MB2807D8B6D010AEE47A2F1AF286960%40CY4PR05MB2807.namprd05.prod.outlook.com.
