Rameshbabu Ananthrapu created JBFORUMS-304: ---------------------------------------------- Summary: Locking Issue with Jboss6 Key: JBFORUMS-304 URL: https://issues.jboss.org/browse/JBFORUMS-304 Project: JBoss Forums Issue Type: Feature Request Components: Forum Enhancements Reporter: Rameshbabu Ananthrapu Assignee: Luca Stancapiano Hi, Our application is running on jboss6.00 fnal version and database is oracle 11g. After jboss starting we are getting the below exception. Could any one please help me here. I need to be resolve this ASAP as it is existing in production environment. We dont have this kind of issue in any test environments. 00:17:04,087 WARN [org.jboss.resource.connectionmanager.TxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@88e624[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@15950d8 handles=1 lastUse=1395702695471 permit=true trackByTx=true mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@ca9ed4 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@8197af xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@1fa249a txSync=null]: java.sql.SQLRecoverableException: I/U-unntak at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:101) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:521) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:634) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3470) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.rollback(LocalManagedConnection.java:97) [:6.0.0.Final] at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.rollback(TxConnectionManager.java:1172) [:6.0.0.Final] at com.arjuna.ats.internal.jta.resources.arjunacore.XAOnePhaseResource.rollback(XAOnePhaseResource.java:186) [:6.0.0.Final] at com.arjuna.ats.internal.arjuna.abstractrecords.LastResourceRecord.topLevelAbort(LastResourceRecord.java:123) [:6.0.0.Final] at com.arjuna.ats.arjuna.coordinator.BasicAction.doAbort(BasicAction.java:2902) [:6.0.0.Final] at com.arjuna.ats.arjuna.coordinator.BasicAction.doAbort(BasicAction.java:2881) [:6.0.0.Final] at com.arjuna.ats.arjuna.coordinator.BasicAction.Abort(BasicAction.java:1602) [:6.0.0.Final] at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.cancel(TwoPhaseCoordinator.java:119) [:6.0.0.Final] at com.arjuna.ats.arjuna.AtomicAction.cancel(AtomicAction.java:212) [:6.0.0.Final] at com.arjuna.ats.arjuna.coordinator.TransactionReaper.doCancellations(TransactionReaper.java:367) [:6.0.0.Final] at com.arjuna.ats.internal.arjuna.coordinator.ReaperWorkerThread.run(ReaperWorkerThread.java:79) [:6.0.0.Final] Caused by: java.io.InterruptedIOException at java.net.SocketOutputStream.socketWrite0(Native Method) [:1.6.0_35] at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92) [:1.6.0_35] at java.net.SocketOutputStream.write(SocketOutputStream.java:136) [:1.6.0_35] at oracle.net.ns.DataPacket.send(DataPacket.java:150) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:180) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:169) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.net.ns.NetInputStream.read(NetInputStream.java:117) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.net.ns.NetInputStream.read(NetInputStream.java:92) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.net.ns.NetInputStream.read(NetInputStream.java:77) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1034) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1010) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.T4C7Ocommoncall.receive(T4C7Ocommoncall.java:97) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:626) [:Oracle JDBC Driver version - "11.1.0.7.0-Production"] ... 12 more After getting the above error we are getting the below exception. Application running in unix server. 00:18:04,095 INFO [org.jboss.resource.connectionmanager.CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@c80233 00:18:04,096 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackException in method: public abstract void flow.framework.database.OrderDataMethods.setOrderData(java.lang.String,java.util.Map) throws javax.ejb.ObjectNotFoundException,java.rmi.RemoteException, causedBy:: simpleorm.core.SException$JDBC: ???Preparing [WOLocal 225634]'UPDATE WO_LOCAL SET Overdue_CompleteCount = ?, DueDate = ? WHERE LOCALPK = ? ': java.sql.SQLException: Unable to obtain lock in 60 seconds: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@15950d8 at simpleorm.core.SRecordInstance.flush(SRecordInstance.java:494) [:] at simpleorm.core.SConnection.flush(SConnection.java:388) [:] at flow.framework.database.impl.OrderDataContext.flush(OrderDataContext.java:144) [:] at flow.framework.database.impl.OrderDataImpl.setOrderDataInternal(OrderDataImpl.java:668) [:] at flow.framework.database.impl.workorder.WorkOrderDataImpl.setOrderDataInternal(WorkOrderDataImpl.java:160) [:] at flow.framework.database.impl.OrderDataImpl.setOrderData(OrderDataImpl.java:206) [:] at flow.framework.database.impl.OrderDataImpl.setOrderData(OrderDataImpl.java:177) [:] at flow.framework.database.impl.workorder.WorkOrderDataImpl.setOrderData(WorkOrderDataImpl.java:144) [:] at sun.reflect.GeneratedMethodAccessor377.invoke(Unknown Source) [:1.6.0_35] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_35] at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_35] at org.jboss.invocation.Invocation.performCall(Invocation.java:386) [:6.0.0.Final] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:233) [:6.0.0.Final] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:156) [:6.0.0.Final] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:173) [:6.0.0.Final] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63) [:6.0.0.Final] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121) [:6.0.0.Final] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350) [:6.0.0.Final] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181) [:6.0.0.Final] at org.jboss.ejb.plugins.SecurityInterceptor.process(SecurityInterceptor.java:228) [:6.0.0.Final] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:211) [:6.0.0.Final] at org.jboss.ejb.plugins.security.PreSecurityInterceptor.process(PreSecurityInterceptor.java:97) [:6.0.0.Final] at org.jboss.ejb.plugins.security.PreSecurityInterceptor.invoke(PreSecurityInterceptor.java:81) [:6.0.0.Final] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205) [:6.0.0.Final] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138) [:6.0.0.Final] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:650) [:6.0.0.Final] at org.jboss.ejb.Container.invoke(Container.java:1072) [:6.0.0.Final] at sun.reflect.GeneratedMethodAccessor341.invoke(Unknown Source) [:1.6.0_35] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_35] at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_35] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157) [:6.0.0.GA] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96) [:6.0.0.GA] at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) [:6.0.0.GA] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:271) [:6.0.0.GA] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:670) [:6.0.0.GA] at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169) [:6.0.0.Final] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118) [:6.0.0.Final] at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209) [:6.0.0.Final] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195) [:6.0.0.Final] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61) [:6.0.0.Final] at org.jboss.proxy.ejb.SecurityContextInterceptor.invoke(SecurityContextInterceptor.java:64) [:6.0.0.Final] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:68) [:6.0.0.Final] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112) [:6.0.0.Final] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:101) [:6.0.0.Final] at $Proxy329.setOrderData(Unknown Source) at flow.framework.oss.common.impl.UtilityBean.internalSetState(UtilityBean.java:379) [:] at flow.framework.oss.common.impl.UtilityBean.setState(UtilityBean.java:115) [:] at sun.reflect.GeneratedMethodAccessor378.invoke(Unknown Source) [:1.6.0_35] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_35] at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_35] at org.jboss.invocation.Invocation.performCall(Invocation.java:386) [:6.0.0.Final] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:233) [:6.0.0.Final] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:156) [:6.0.0.Final] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:173) [:6.0.0.Final] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63) [:6.0.0.Final] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121) [:6.0.0.Final] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350) [:6.0.0.Final] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181) [:6.0.0.Final] at org.jboss.ejb.plugins.SecurityInterceptor.process(SecurityInterceptor.java:228) [:6.0.0.Final] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:211) [:6.0.0.Final] at org.jboss.ejb.plugins.security.PreSecurityInterceptor.process(PreSecurityInterceptor.java:97) [:6.0.0.Final] at org.jboss.ejb.plugins.security.PreSecurityInterceptor.invoke(PreSecurityInterceptor.java:81) [:6.0.0.Final] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205) [:6.0.0.Final] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138) [:6.0.0.Final] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:650) [:6.0.0.Final] at org.jboss.ejb.Container.invoke(Container.java:1072) [:6.0.0.Final] at sun.reflect.GeneratedMethodAccessor341.invoke(Unknown Source) [:1.6.0_35] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_35] at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_35] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157) [:6.0.0.GA] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96) [:6.0.0.GA] at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) [:6.0.0.GA] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:271) [:6.0.0.GA] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:670) [:6.0.0.GA] at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169) [:6.0.0.Final] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118) [:6.0.0.Final] at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209) [:6.0.0.Final] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195) [:6.0.0.Final] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61) [:6.0.0.Final] at org.jboss.proxy.ejb.SecurityContextInterceptor.invoke(SecurityContextInterceptor.java:64) [:6.0.0.Final] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:68) [:6.0.0.Final] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112) [:6.0.0.Final] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:101) [:6.0.0.Final] at $Proxy339.setState(Unknown Source) at flow.framework.oss.workorder.impl.StateHandler.handleOverdueEvent(StateHandler.java:1523) [:] at flow.framework.oss.workorder.impl.StateHandler.overdueEvent(StateHandler.java:1336) [:] at flow.framework.oss.workorder.impl.WorkOrderTimeoutBean.handleOverdueEvents2(WorkOrderTimeoutBean.java:108) [:] at flow.framework.oss.workorder.impl.WorkOrderTimeoutBean.handleOverdueEvents(WorkOrderTimeoutBean.java:52) [:] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_35] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [:1.6.0_35] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_35] at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_35] at org.jboss.invocation.Invocation.performCall(Invocation.java:386) [:6.0.0.Final] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:233) [:6.0.0.Final] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:156) [:6.0.0.Final] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:173) [:6.0.0.Final] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63) [:6.0.0.Final] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121) [:6.0.0.Final] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350) [:6.0.0.Final] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181) [:6.0.0.Final] at org.jboss.ejb.plugins.SecurityInterceptor.process(SecurityInterceptor.java:228) [:6.0.0.Final] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:211) [:6.0.0.Final] at org.jboss.ejb.plugins.security.PreSecurityInterceptor.process(PreSecurityInterceptor.java:97) [:6.0.0.Final] at org.jboss.ejb.plugins.security.PreSecurityInterceptor.invoke(PreSecurityInterceptor.java:81) [:6.0.0.Final] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205) [:6.0.0.Final] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138) [:6.0.0.Final] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:650) [:6.0.0.Final] at org.jboss.ejb.Container.invoke(Container.java:1072) [:6.0.0.Final] at sun.reflect.GeneratedMethodAccessor341.invoke(Unknown Source) [:1.6.0_35] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_35] at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_35] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157) [:6.0.0.GA] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96) [:6.0.0.GA] at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) [:6.0.0.GA] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:271) [:6.0.0.GA] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:670) [:6.0.0.GA] at org.jboss.invocation.unified.server.UnifiedInvoker.invoke(UnifiedInvoker.java:232) [:6.0.0.Final] at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:898) [:6.0.0.Final] at org.jboss.remoting.transport.socket.ServerThread.completeInvocation(ServerThread.java:791) [:6.0.0.Final] at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:744) [:6.0.0.Final] at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:586) [:6.0.0.Final] at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:234) [:6.0.0.Final] -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira