错误:javax.servlet.ServletException: org.springframework.dao.DeadlockLoserDataAccessException: Hibernate operation: could not execute update query; SQL [update J_WenZhang set PDF_XiaZaiCiShu=isnull(PDF_XiaZaiCiShu, 0)+1 where ID=7818]; 事务(进程 ID 101)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。; nested exception is java.sql.SQLException: 事务(进程 ID 101)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。
错误码:500
异常:null
exception:javax.servlet.ServletException: org.springframework.dao.DeadlockLoserDataAccessException: Hibernate operation: could not execute update query; SQL [update J_WenZhang set PDF_XiaZaiCiShu=isnull(PDF_XiaZaiCiShu, 0)+1 where ID=7818]; 事务(进程 ID 101)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。; nested exception is java.sql.SQLException: 事务(进程 ID 101)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。
cause:org.springframework.dao.DeadlockLoserDataAccessException: Hibernate operation: could not execute update query; SQL [update J_WenZhang set PDF_XiaZaiCiShu=isnull(PDF_XiaZaiCiShu, 0)+1 where ID=7818]; 事务(进程 ID 101)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。; nested exception is java.sql.SQLException: 事务(进程 ID 101)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。
message:org.springframework.dao.DeadlockLoserDataAccessException: Hibernate operation: could not execute update query; SQL [update J_WenZhang set PDF_XiaZaiCiShu=isnull(PDF_XiaZaiCiShu, 0)+1 where ID=7818]; 事务(进程 ID 101)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。; nested exception is java.sql.SQLException: 事务(进程 ID 101)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。
localizedMessage:org.springframework.dao.DeadlockLoserDataAccessException: Hibernate operation: could not execute update query; SQL [update J_WenZhang set PDF_XiaZaiCiShu=isnull(PDF_XiaZaiCiShu, 0)+1 where ID=7818]; 事务(进程 ID 101)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。; nested exception is java.sql.SQLException: 事务(进程 ID 101)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。
stackTrace:javax.servlet.ServletException: org.springframework.dao.DeadlockLoserDataAccessException: Hibernate operation: could not execute update query; SQL [update J_WenZhang set PDF_XiaZaiCiShu=isnull(PDF_XiaZaiCiShu, 0)+1 where ID=7818]; 事务(进程 ID 101)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。; nested exception is java.sql.SQLException: 事务(进程 ID 101)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。
at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:656)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:765)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.lyt.util.filter.CountDayBrowseFilter.doFilter(CountDayBrowseFilter.java:47)
at com.lyt.util.HttpFilter.doFilter(HttpFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:164)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:406)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.lyt.util.filter.UrlRedirectFilter.doFilter(UrlRedirectFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.magtech.filter.UserGroupMapFilter.doFilter(UserGroupMapFilter.java:39)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.magtech.filter.XssFilter.doFilter(XssFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.lyt.util.web.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:44)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.lyt.util.filter.FrameTaoFilter.doFilter(FrameTaoFilter.java:29)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.lyt.util.filter.JournalIDFilter.doFilter(JournalIDFilter.java:80)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.lyt.util.filter.ReadRequestRefererFilter.doFilter(ReadRequestRefererFilter.java:32)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.lyt.util.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:89)
at com.lyt.util.HttpFilter.doFilter(HttpFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:367)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:885)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1693)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.springframework.dao.DeadlockLoserDataAccessException: Hibernate operation: could not execute update query; SQL [update J_WenZhang set PDF_XiaZaiCiShu=isnull(PDF_XiaZaiCiShu, 0)+1 where ID=7818]; 事务(进程 ID 101)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。; nested exception is java.sql.SQLException: 事务(进程 ID 101)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:248)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
at com.lyt.util.dao.BaseDaoImpl.updateHQL(BaseDaoImpl.java:175)
at com.wkxt.download.DownloadServiceImpl$36.doInTransaction(DownloadServiceImpl.java:561)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
at com.wkxt.download.DownloadServiceImpl.addDownload(DownloadServiceImpl.java:557)
at com.wkxt.article.web.action.ArticleDownloadFileAction.execute(ArticleDownloadFileAction.java:1101)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
... 63 more
Caused by: java.sql.SQLException: 事务(进程 ID 101)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:71)
at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:322)
at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1019)
at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:89)
at com.lyt.util.dao.BaseDaoImpl$4.doInHibernate(BaseDaoImpl.java:178)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
... 70 more