Thanks, Juan. That's the direction our team is moving towards. Doing some reading, this appears to be less an issue with CAS and more an issue with *Hibernate ORM*. I need to read up more on it and how CAS implements *Hibernate*. Until then, we'll probably use our own cleanup.
-Nick -- Nathaniel N. Petersen Systems Architect IT - Administrative Information Systems University of Northern Iowa On Wed, Apr 3, 2019 at 12:46 PM Juan Quintanilla <[email protected]> wrote: > 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] > > > ------------------------------ > *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]. > 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 > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/SN6PR05MB518283459A77009013AD063E86550%40SN6PR05MB5182.namprd05.prod.outlook.com?utm_medium=email&utm_source=footer> > . > -- - 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/CAAWVSYRGrd1f2XUhOqKordzX%2BHG0FfB-uPMLVA7Ke72fWN5Exg%40mail.gmail.com.
