"ORA-00060: deadlock detected while waiting for resource" error from SessionCleanupThread on MetaMatrix cluster

Solution Verified - Updated -

Issue

  • I'm getting the following error on Session_Cleanup in the MetaMatrix MMProcess.log:
[SessionCleanupThread|0] ERROR <SESSION_CLEANUP|0> SessionServiceImpl.removeNonActiveSessions SessionServiceException occurred
com.metamatrix.api.exception.security.SessionServiceException[0]: java.sql.SQLException: [MetaMatrix][Oracle JDBC Driver][Oracle]ORA-00060: deadlock detected while waiting for resource
at com.metamatrix.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.metamatrix.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.metamatrix.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at com.metamatrix.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.metamatrix.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at com.metamatrix.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at com.metamatrix.platform.security.session.spi.jdbc.JDBCSessionTransaction.removeServiceSession(JDBCSessionTransaction.java:1657)
at com.metamatrix.platform.security.session.spi.jdbc.JDBCSessionTransaction.removeSessions(JDBCSessionTransaction.java:1199)
at com.metamatrix.platform.security.session.service.SessionServiceImpl.removeNonActiveSessions(SessionServiceImpl.java:2136)
at com.metamatrix.platform.security.session.service.SessionServiceImpl.access$000(SessionServiceImpl.java:74)
at com.metamatrix.platform.security.session.service.SessionServiceImpl$SessionCleanupThread.run(SessionServiceImpl.java:2097)
  • My Oracle Trace file shows the following as the Query that it's giving the deadlock on:

     DELETE  FROM SERVICESESSIONS WHERE SESSIONUID=:v0
    

Environment

  • MetaMatrix Enterprise Server 5.5.3
  • 5 node MetaMatrix Server cluster with 2 MMProcesses running on each
  • Approximately 44 Open Sessions when Session_Cleanup is run

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.