Weblogic运行了一段时间(2天)后，为何就连简单的查询也会超时？详情见内！
####<2003-6-3 上午10时43分09秒> <Error> <EJB> <misserverb> <myserver> <ExecuteThread: '23' for queue: 'default'> <> <> <010026> <Exception during commit of transaction Name=[EJB macsys.ass.server.BusiMacAssBean.findBySql(java.lang.String)],Xid=22717:80111fd77f28edb9(4739),Status=Rolled back. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 36 seconds
Name=[EJB macsys.ass.server.BusiMacAssBean.findBySql(java.lang.String)],Xid=22717:80111fd77f28edb9(4739),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=36,seconds left=30,activeThread=Thread[ExecuteThread: '23' for queue: 'default',5,Thread Group for Queue: 'default'],SCInfo[mydomain+myserver]=(state=active),properties=({weblogic.transaction.name=[EJB macsys.ass.server.BusiMacAssBean.findBySql(java.lang.String)]}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=myserver+10.138.210.5:7001+mydomain+, Resources={})],CoordinatorURL=myserver+10.138.210.5:7001+mydomain+)],numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=56,seconds left=3,SCInfo[mydomain+myserver]=(state=rolledback),properties=({weblogic.transaction.name=[EJB macsys.ass.server.BusiMacAssBean.findBySql(java.lang.String)]}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=myserver+10.138.210.5:7001+mydomain+, Resources={})],CoordinatorURL=myserver+10.138.210.5:7001+mydomain+): weblogic.transaction.internal.TimedOutException: Transaction timed out after 36 seconds
Name=[EJB macsys.ass.server.BusiMacAssBean.findBySql(java.lang.String)],Xid=22717:80111fd77f28edb9(4739),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=36,seconds left=30,activeThread=Thread[ExecuteThread: '23' for queue: 'default',5,Thread Group for Queue: 'default'],SCInfo[mydomain+myserver]=(state=active),properties=({weblogic.transaction.name=[EJB macsys.ass.server.BusiMacAssBean.findBySql(java.lang.String)]}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=myserver+10.138.210.5:7001+mydomain+, Resources={})],CoordinatorURL=myserver+10.138.210.5:7001+mydomain+)
at weblogic.transaction.internal.ServerTransactionImpl.wakeUp(I)V(Unknown Source)
at weblogic.transaction.internal.ServerTransactionManagerImpl.processTimedOutTransactions(Ljava.util.List;I)V(Unknown Source)
at weblogic.transaction.internal.TransactionManagerImpl.wakeUp()V(Unknown Source)
at weblogic.transaction.internal.ServerTransactionManagerImpl.wakeUp()V(Unknown Source)
at weblogic.transaction.internal.TransactionManagerImpl$1.run()V(Unknown Source)
at java.lang.Thread.run()V(Unknown Source)
at java.lang.Thread.startThreadFromVM(Ljava.lang.Thread;)V(Unknown Source)
--------------- nested within: ------------------
weblogic.transaction.RollbackException: Transaction timed out after 36 seconds
Name=[EJB macsys.ass.server.BusiMacAssBean.findBySql(java.lang.String)],Xid=22717:80111fd77f28edb9(4739),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=36,seconds left=30,activeThread=Thread[ExecuteThread: '23' for queue: 'default',5,Thread Group for Queue: 'default'],SCInfo[mydomain+myserver]=(state=active),properties=({weblogic.transaction.name=[EJB macsys.ass.server.BusiMacAssBean.findBySql(java.lang.String)]}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=myserver+10.138.210.5:7001+mydomain+, Resources={})],CoordinatorURL=myserver+10.138.210.5:7001+mydomain+) - with nested exception:
[weblogic.transaction.internal.TimedOutException: Transaction timed out after 36 seconds
Name=[EJB macsys.ass.server.BusiMacAssBean.findBySql(java.lang.String)],Xid=22717:80111fd77f28edb9(4739),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=36,seconds left=30,activeThread=Thread[ExecuteThread: '23' for queue: 'default',5,Thread Group for Queue: 'default'],SCInfo[mydomain+myserver]=(state=active),properties=({weblogic.transaction.name=[EJB macsys.ass.server.BusiMacAssBean.findBySql(java.lang.String)]}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=myserver+10.138.210.5:7001+mydomain+, Resources={})],CoordinatorURL=myserver+10.138.210.5:7001+mydomain+)]
at weblogic.transaction.internal.TransactionImpl.throwRollbackException()V(Unknown Source)
at weblogic.transaction.internal.TransactionImpl.checkIfCommitPossible()V(Unknown Source)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit()V(Unknown Source)
at weblogic.transaction.internal.ServerTransactionImpl.commit()V(Unknown Source)
at weblogic.ejb20.internal.BaseEJBObject.postInvoke(Lweblogic.ejb20.interfaces.InvocationWrapper;Ljava.lang.Throwable;)V(Unknown Source)
at macsys.ass.server.BusiMacAssBean_plve1x_EOImpl.findBySql(Ljava.lang.String;)Ljavax.sql.RowSet;(Unknown Source)
at macsys.ass.server.BusiMacAssBean_plve1x_EOImpl_WLSkel.invoke(Lweblogic.rmi.internal.ServerReference;ILweblogic.rmi.spi.InboundRequest;Lweblogic.rmi.spi.OutboundResponse;)Lweblogic.rmi.spi.OutboundResponse;(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(Lweblogic.rmi.internal.MethodDescriptor;Lweblogic.rmi.spi.InboundRequest;Lweblogic.rmi.spi.OutboundResponse;)V(Unknown Source)
at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(Lweblogic.rmi.internal.MethodDescriptor;Lweblogic.rmi.spi.InboundRequest;Lweblogic.rmi.spi.OutboundResponse;)V(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.handleRequest(Lweblogic.rmi.spi.InboundRequest;)V(Unknown Source)
at weblogic.rmi.internal.BasicExecuteRequest.execute(Lweblogic.kernel.ExecuteThread;)V(Unknown Source)
at weblogic.kernel.ExecuteThread.execute(Lweblogic.kernel.ExecuteRequest;)V(Unknown Source)
at weblogic.kernel.ExecuteThread.run()V(Unknown Source)
at java.lang.Thread.startThreadFromVM(Ljava.lang.Thread;)V(Unknown Source)
>
问题点数：0、回复次数：3Top
1 楼saintKnight（saintKnight）回复于 2003-06-06 09:56:29 得分 0
upTop
2 楼xqiqi（╰☆╮不懂╰☆╮）回复于 2003-06-06 10:04:39 得分 0
connectionPool的连接数太小了吧Top
3 楼saintKnight（saintKnight）回复于 2003-06-08 09:26:59 得分 0
connectionPool的连接已经设为20了，应该不小了Top
