"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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
