HTTP Status 500 - Request processing failed; nested exception is org.hibernate.exception.LockAcquisitionException: could not execute query using iterate


type Exception report

message Request processing failed; nested exception is org.hibernate.exception.LockAcquisitionException: could not execute query using iterate

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.exception.LockAcquisitionException: could not execute query using iterate
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:656)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:38)

root cause

org.hibernate.exception.LockAcquisitionException: could not execute query using iterate
	org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
	org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:450)
	org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:405)
	org.hibernate.engine.query.HQLQueryPlan.performIterate(HQLQueryPlan.java:248)
	org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1220)
	org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:69)
	com.jeecms.common.hibernate3.HibernateSimpleDao.countQueryResult(HibernateSimpleDao.java:185)
	com.jeecms.common.hibernate3.HibernateSimpleDao.find(HibernateSimpleDao.java:74)
	com.jeecms.cms.dao.main.impl.ContentDaoImpl.getPageByChannelIdsForTag(ContentDaoImpl.java:310)
	com.jeecms.cms.manager.main.impl.ContentMngImpl.getPageByChannelIdsForTag(ContentMngImpl.java:148)
	sun.reflect.GeneratedMethodAccessor568.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	com.sun.proxy.$Proxy20.getPageByChannelIdsForTag(Unknown Source)
	com.jeecms.cms.action.directive.abs.AbstractContentDirective.getData(AbstractContentDirective.java:345)
	com.jeecms.cms.action.directive.ContentPageDirective.execute(ContentPageDirective.java:46)
	freemarker.core.Environment.visit(Environment.java:263)
	freemarker.core.UnifiedCall.accept(UnifiedCall.java:126)
	freemarker.core.Environment.visit(Environment.java:210)
	freemarker.core.MixedContent.accept(MixedContent.java:92)
	freemarker.core.Environment.visit(Environment.java:210)
	freemarker.core.Environment.process(Environment.java:190)
	freemarker.template.Template.process(Template.java:237)
	com.jeecms.common.web.springmvc.SimpleFreeMarkerView.renderMergedTemplateModel(SimpleFreeMarkerView.java:114)
	org.springframework.web.servlet.view.AbstractTemplateView.renderMergedOutputModel(AbstractTemplateView.java:167)
	org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:250)
	org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1047)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:817)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:38)

root cause

java.sql.SQLException: 事务(进程 ID 93)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。
	net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
	net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
	net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
	net.sourceforge.jtds.jdbc.TdsCore.isDataInResultSet(TdsCore.java:838)
	net.sourceforge.jtds.jdbc.JtdsResultSet.<init>(JtdsResultSet.java:149)
	net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:511)
	net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029)
	com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
	org.hibernate.loader.Loader.getResultSet(Loader.java:1812)
	org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:427)
	org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:405)
	org.hibernate.engine.query.HQLQueryPlan.performIterate(HQLQueryPlan.java:248)
	org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1220)
	org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:69)
	com.jeecms.common.hibernate3.HibernateSimpleDao.countQueryResult(HibernateSimpleDao.java:185)
	com.jeecms.common.hibernate3.HibernateSimpleDao.find(HibernateSimpleDao.java:74)
	com.jeecms.cms.dao.main.impl.ContentDaoImpl.getPageByChannelIdsForTag(ContentDaoImpl.java:310)
	com.jeecms.cms.manager.main.impl.ContentMngImpl.getPageByChannelIdsForTag(ContentMngImpl.java:148)
	sun.reflect.GeneratedMethodAccessor568.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	com.sun.proxy.$Proxy20.getPageByChannelIdsForTag(Unknown Source)
	com.jeecms.cms.action.directive.abs.AbstractContentDirective.getData(AbstractContentDirective.java:345)
	com.jeecms.cms.action.directive.ContentPageDirective.execute(ContentPageDirective.java:46)
	freemarker.core.Environment.visit(Environment.java:263)
	freemarker.core.UnifiedCall.accept(UnifiedCall.java:126)
	freemarker.core.Environment.visit(Environment.java:210)
	freemarker.core.MixedContent.accept(MixedContent.java:92)
	freemarker.core.Environment.visit(Environment.java:210)
	freemarker.core.Environment.process(Environment.java:190)
	freemarker.template.Template.process(Template.java:237)
	com.jeecms.common.web.springmvc.SimpleFreeMarkerView.renderMergedTemplateModel(SimpleFreeMarkerView.java:114)
	org.springframework.web.servlet.view.AbstractTemplateView.renderMergedOutputModel(AbstractTemplateView.java:167)
	org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:250)
	org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1047)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:817)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:38)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.42 logs.


Apache Tomcat/7.0.42