Hi Nathaniel,
We had to disable to the defaultticketcleaner for JPA because it was not cleaning up the tickets, after disabling the cleaner we no longer experienced the Deadlock issue but we had to setup some external scripts to perform the cleanup on the tickets. Thanks! ___________________ Juan Quintanilla [email protected]<mailto:[email protected]> ________________________________ From: [email protected] <[email protected]> on behalf of Nathaniel Petersen <[email protected]> Sent: Friday, March 29, 2019 4:20 PM To: CAS Community Subject: [cas-user] Re: CAS 5.1.2 Database Deadlock Juan, Where you able to identify the cause or implement a fix for this issue? I'm experiencing a similar issue in 5.2.6. On Monday, January 28, 2019 at 10:58:02 AM UTC-6, jquin014 wrote: 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<https://urldefense.proofpoint.com/v2/url?u=https-3A__apereo.github.io_cas&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=hk-s-5x_MvcAfVeF-O0-CA&m=cyOeqej4p1BB2zz4j8oh0W1zcE3WsGSXIStnW4RhnZ4&s=rSSUycZV1m8y61vIvH-uMLUqfDn4n4sGSkhyaUHeqro&e=> - Gitter Chatroom: https://gitter.im/apereo/cas<https://urldefense.proofpoint.com/v2/url?u=https-3A__gitter.im_apereo_cas&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=hk-s-5x_MvcAfVeF-O0-CA&m=cyOeqej4p1BB2zz4j8oh0W1zcE3WsGSXIStnW4RhnZ4&s=5SU0QikProVtP8cX7ys_en5gRVIM62ftp0n49vHOkzE&e=> - List Guidelines: https://goo.gl/1VRrw7<https://urldefense.proofpoint.com/v2/url?u=https-3A__goo.gl_1VRrw7&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=hk-s-5x_MvcAfVeF-O0-CA&m=cyOeqej4p1BB2zz4j8oh0W1zcE3WsGSXIStnW4RhnZ4&s=rnMqRzq3_dspV8eZeUQnquFbujxqmf5J54bkkiJzMWU&e=> - Contributions: https://goo.gl/mh7qDG<https://urldefense.proofpoint.com/v2/url?u=https-3A__goo.gl_mh7qDG&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=hk-s-5x_MvcAfVeF-O0-CA&m=cyOeqej4p1BB2zz4j8oh0W1zcE3WsGSXIStnW4RhnZ4&s=5K5a4RCvLttOQ1NWqE33a119AbFYSOnoUb8UmnIfzOg&e=> --- 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]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/a9b11052-8ef5-41cb-8c7b-cba03c659ee6%40apereo.org<https://urldefense.proofpoint.com/v2/url?u=https-3A__groups.google.com_a_apereo.org_d_msgid_cas-2Duser_a9b11052-2D8ef5-2D41cb-2D8c7b-2Dcba03c659ee6-2540apereo.org-3Futm-5Fmedium-3Demail-26utm-5Fsource-3Dfooter&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=hk-s-5x_MvcAfVeF-O0-CA&m=cyOeqej4p1BB2zz4j8oh0W1zcE3WsGSXIStnW4RhnZ4&s=9IfTn1B40VWaE_chBua464D4wmf5bqEmgSJ1siI5nmM&e=>. -- - 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/SN6PR05MB518283459A77009013AD063E86550%40SN6PR05MB5182.namprd05.prod.outlook.com.
