"ORA-00060: deadlock detected while waiting for resource" error from SessionCleanupThread on MetaMatrix cluster
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.