[jboss-jira] [JBoss JIRA] (JBFORUMS-304) Locking Issue with Jboss6
Rameshbabu Ananthrapu (JIRA)
issues at jboss.org
Wed Mar 26 02:43:12 EDT 2014
[ https://issues.jboss.org/browse/JBFORUMS-304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12956373#comment-12956373 ]
Rameshbabu Ananthrapu commented on JBFORUMS-304:
------------------------------------------------
please respond to this.... any update here...
> 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