"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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content