[jboss-jira] [JBoss JIRA] (JBFORUMS-304) Locking Issue with Jboss6
Rameshbabu Ananthrapu (JIRA)
issues at jboss.org
Tue Mar 25 03:51:13 EDT 2014
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 at 88e624[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection at 15950d8 handles=1 lastUse=1395702695471 permit=true trackByTx=true mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool at ca9ed4 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 8197af xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource at 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 at 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 at 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
More information about the jboss-jira
mailing list