论坛

主页 » Liferay Portal » English » Liferay Legacy

组合视图 统一视图 树状图
讨论主题 [ 上一个 | 下一个 ]
toggle
Ken Ko
Sybase Deadlock
2007年9月25日 下午5:28
答复

Ken Ko

等级: Junior Member

帖子: 35

加入日期: 2007年9月23日

最近的帖子

Has anyone encountered a sybase deadlock? This appears when a page loads, and there are multiple ajaxable portlets trying to refresh together. It happens with portlets bundled with liferay. Does not happen all the time, only sometimes.

  1
  22007-09-26 00:24:49,189 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/emgonline/portal].[MainServlet]] Servlet.service() for servlet MainServlet threw exception
  3org.hibernate.exception.LockAcquisitionException: could not update: [com.liferay.portal.model.impl.LayoutImpl#10100]
  4    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:82)
  5    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  6    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2425)
  7    at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307)
  8    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2607)
  9    at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)
 10    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
 11    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
 12    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
 13    at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
 14    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
 15    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
 16    at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
 17    at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
 18    at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:575)
 19    at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:662)
 20    at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
 21    at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:314)
 22    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:117)
 23    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
 24    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
 25    at $Proxy203.getLayout(Unknown Source)
 26    at com.liferay.portal.service.LayoutLocalServiceUtil.getLayout(LayoutLocalServiceUtil.java:151)
 27    at com.liferay.portal.service.permission.LayoutPermission.contains(LayoutPermission.java:102)
 28    at com.liferay.portal.service.permission.PortletPermission.contains(PortletPermission.java:88)
 29    at org.apache.jsp.html.portal.render_005fportlet_jsp._jspService(render_005fportlet_jsp.java:889)
 30    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
 31    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
 32    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
 33    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
 34    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
 35    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
 36    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 37    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 38    at com.liferay.filters.strip.StripFilter.doFilter(StripFilter.java:261)
 39    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 40    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 41    at com.liferay.filters.compression.CompressionFilter.doFilter(CompressionFilter.java:125)
 42    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 43    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 44    at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.doFilter(VirtualHostFilter.java:136)
 45    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 46    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 47    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
 48    at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)
 49    at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
 50    at com.liferay.portal.util.PortalUtil.renderPortlet(PortalUtil.java:1402)
 51    at com.liferay.portal.util.PortalUtil.renderPortlet(PortalUtil.java:1348)
 52    at com.liferay.portal.action.RenderPortletAction.execute(RenderPortletAction.java:79)
 53    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
 54    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
 55    at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:157)
 56    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
 57    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
 58    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 59    at com.liferay.portal.servlet.MainServlet.callParentService(MainServlet.java:280)
 60    at com.liferay.portal.servlet.MainServlet.service(MainServlet.java:534)
 61    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
 62    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 63    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 64    at com.liferay.filters.strip.StripFilter.doFilter(StripFilter.java:95)
 65    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 66    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 67    at com.liferay.filters.secure.SecureFilter.doFilter(SecureFilter.java:144)
 68    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 69    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 70    at com.liferay.filters.compression.CompressionFilter.doFilter(CompressionFilter.java:116)
 71    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 72    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 73    at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.doFilter(VirtualHostFilter.java:136)
 74    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 75    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 76    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
 77    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 78    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 79    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 80    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
 81    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
 82    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
 83    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
 84    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
 85    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
 86    at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
 87    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
 88    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
 89    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
 90    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
 91    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
 92    at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
 93    at java.lang.Thread.run(Thread.java:595)
 94Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Your server command (family id #0, process id #665) encountered a deadlock situation. Please re-run your command.
 95
 96    at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2636)
 97    at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1996)
 98    at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
 99    at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:204)
100    at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:187)
101    at com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1615)
102    at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1598)
103    at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:89)
104    at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
105    at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
106    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2403)
107    ... 87 more
sanjana abcd
RE: Sybase Deadlock
2011年11月10日 下午12:46
答复

sanjana abcd

等级: New Member

帖子: 3

加入日期: 2011年4月15日

最近的帖子

Sorry for replying an old thread. I am also getting the same error, has anyone know the reason?