java.sql.SQLException: OALL8 处于不一致状态

fan_bo0627 2011-08-10 10:02:07
各位大虾帮忙看看下面这个错误,webloigc + oracle10g

<BEA-010025> <Exception occurred during rollback of transaction Name=[EJB com.bea.wlw.runtime.core.bean.SyncDispatcherBean.invoke(com.bea.wlw.runtime.core.request.Request)],Xid=BEA1-278A67C9FA6BC3D8A523(126448118),Status=Rolled back. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 300 seconds
BEA1-278A67C9FA6BC3D8A523],HeuristicErrorCode=XA_HEURHAZ,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=1062,seconds left=28,XAServerResourceInfo[weblogic.jdbc.wrapper.JTSXAResourceImpl]=(ServerResourceInfo[weblogic.jdbc.wrapper.JTSXAResourceImpl]=(state=rolledback,assigned=new_Server_2),xar=weblogic.jdbc.wrapper.JTSXAResourceImpl@78ce9c8,re-Registered = false),SCInfo[eppmcp_cluster+new_Server_2]=(state=rolledback),properties=({weblogic.transaction.name=[EJB com.bea.wlw.runtime.core.bean.SyncDispatcherBean.invoke(com.bea.wlw.runtime.core.request.Request)], weblogic.jdbc=t3://10.148.1.133:7011, START_AND_END_THREAD_EQUAL=false}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=new_Server_2+10.148.1.133:7011+eppmcp_cluster+t3+, XAResources={JMS_cgJMSStore_auto_1, weblogic.jdbc.wrapper.JTSXAResourceImpl},NonXAResources={})],CoordinatorURL=new_Server_2+10.148.1.133:7011+eppmcp_cluster+t3+): javax.transaction.SystemException: Heuristic hazard: (weblogic.jdbc.wrapper.JTSXAResourceImpl, HeuristicHazard, (javax.transaction.xa.XAException: 无法从套接字读取更多的数据))
at weblogic.transaction.internal.ServerTransactionImpl.internalRollback(ServerTransactionImpl.java:384)
at weblogic.transaction.internal.ServerTransactionImpl.rollback(ServerTransactionImpl.java:350)
at weblogic.ejb20.internal.BaseEJBObject.postInvoke(BaseEJBObject.java:300)
at weblogic.ejb20.internal.StatelessEJBObject.postInvoke(StatelessEJBObject.java:168)
at com.bea.wlw.runtime.core.bean.SyncDispatcher_k1mrl8_EOImpl.invoke(SyncDispatcher_k1mrl8_EOImpl.java:110)
at com.bea.wlw.runtime.core.dispatcher.Dispatcher.remoteDispatch(Dispatcher.java:161)
at com.bea.wlw.runtime.core.dispatcher.ServiceHandleImpl.invoke(ServiceHandleImpl.java:436)
at com.bea.wlw.runtime.core.dispatcher.WlwProxyImpl._invoke(WlwProxyImpl.java:328)
at com.bea.wlw.runtime.core.dispatcher.WlwProxyImpl.invoke(WlwProxyImpl.java:317)
at $Proxy339.insertXscf([Lcom.bea.control.DatabaseControl$SQLParameter;)V(Unknown Source)
at pageFlow.nqwm.wsdj.xscf.Xscf.submitInsert(Xscf.jpf:397)
at jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source)
at java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Unknown Source)
at com.bea.wlw.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:1512)
at com.bea.wlw.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:1447)
at com.bea.wlw.netui.pageflow.FlowController.internalExecute(FlowController.java:778)
at com.bea.wlw.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:211)
at com.bea.wlw.netui.pageflow.FlowController.execute(FlowController.java:608)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at com.bea.wlw.netui.pageflow.PageFlowRequestProcessor.processActionPerform(PageFlowRequestProcessor.java:1492)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at com.bea.wlw.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:691)
at com.bea.wlw.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:527)
at com.bea.wlw.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:152)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1077)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)


<ExecuteThread: '2' for queue: 'weblogic.kernel.Default'> <<anonymous>> <BEA1-2DF367C9FA6BC3D8A523> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "EppmcpPool" failed with exception: "java.sql.SQLException: OALL8 处于不一致状态".>


...全文
2063 5 打赏 收藏 转发到动态 举报
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
gggidt 2011-09-01
  • 打赏
  • 举报
回复
你是怎么解决的啊???是什么办法解决的,我现在的也锁住了[Quote=引用 2 楼 fan_bo0627 的回复:]
引用 1 楼 dbcat2002 的回复:

重启WEBLOGIC
重启没用的。
问题已经解决了原来是数据库的几张表被锁死了
[/Quote]
EverWHL 2011-08-12
  • 打赏
  • 举报
回复
记得结贴
EverWHL 2011-08-12
  • 打赏
  • 举报
回复
呵呵 学习了!
dbcat2002 2011-08-11
  • 打赏
  • 举报
回复
重启WEBLOGIC
fan_bo0627 2011-08-11
  • 打赏
  • 举报
回复
[Quote=引用 1 楼 dbcat2002 的回复:]

重启WEBLOGIC
[/Quote]重启没用的。
问题已经解决了原来是数据库的几张表被锁死了

81,092

社区成员

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧