500 Servlet Exception
java.lang.RuntimeException: java.sql.SQLException: Transaction (Process
ID 71) was deadlocked on lock resources with another process and has been
chosen as the deadlock victim. Rerun the transaction.
at dl2.TestingQueue.GetQueue(TestingQueue.java:280)
at _admin._advancedqueue__jsp._jspService(/admin/advancedqueue/queue.jsp:138)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:497)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at dl2.webfilter.TimeLoad.doFilter(TimeLoad.java:55)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at dl2.webfilter.CheckerBan.doFilter(CheckerBan.java:131)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at dl2.webfilter.AdminAccessChecker.doFilter(AdminAccessChecker.java:117)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:344)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:536)
Caused by: java.sql.SQLException: Transaction (Process ID 71) was deadlocked
on lock resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.
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.isDataInResultSet(TdsCore.java:792)
at net.sourceforge.jtds.jdbc.JtdsResultSet.<init>(JtdsResultSet.java:146)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:424)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
at dl2.db.DBUtil.executeQuery(DBUtil.java:345)
at dl2.TestingQueue.GetQueue(TestingQueue.java:233)
... 16 more
--------------------------------------------------------------------------------
Resin 2.1.7 (built Fri Feb 14 12:48:13 PST 2003)
05.01.2007 10:37:13
Тема: Re:Взаимная блокировка (deadlock) в dl\admin
500 Servlet Exception
java.lang.RuntimeException: java.sql.SQLException: Transaction (Process
ID 72) was deadlocked on lock resources with another process and has been
chosen as the deadlock victim. Rerun the transaction.
at dl2.TestingQueue.GetQueue(TestingQueue.java:280)
at _admin._advancedqueue__jsp._jspService(/admin/advancedqueue/queue.jsp:138)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:497)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at dl2.webfilter.TimeLoad.doFilter(TimeLoad.java:55)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at dl2.webfilter.CheckerBan.doFilter(CheckerBan.java:131)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at dl2.webfilter.AdminAccessChecker.doFilter(AdminAccessChecker.java:117)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:344)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:536)
Caused by: java.sql.SQLException: Transaction (Process ID 72) was deadlocked
on lock resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.
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.isDataInResultSet(TdsCore.java:792)
at net.sourceforge.jtds.jdbc.JtdsResultSet.<init>(JtdsResultSet.java:146)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:424)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
at dl2.db.DBUtil.executeQuery(DBUtil.java:345)
at dl2.TestingQueue.GetQueue(TestingQueue.java:233)
... 16 more
--------------------------------------------------------------------------------
Resin 2.1.7 (built Fri Feb 14 12:48:13 PST 2003)
23.01.2007 13:10:23
Тема: Re:Взаимная блокировка (deadlock) в dl\admin
500 Servlet Exception
java.lang.RuntimeException: java.sql.SQLException: Transaction (Process
ID 63) was deadlocked on lock resources with another process and has been
chosen as the deadlock victim. Rerun the transaction.
at dl2.TestingQueue.GetQueue(TestingQueue.java:280)
at _admin._advancedqueue__jsp._jspService(/admin/advancedqueue/queue.jsp:138)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:497)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at dl2.webfilter.TimeLoad.doFilter(TimeLoad.java:55)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at dl2.webfilter.CheckerBan.doFilter(CheckerBan.java:134)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at dl2.webfilter.AdminAccessChecker.doFilter(AdminAccessChecker.java:117)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:344)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:536)
Caused by: java.sql.SQLException: Transaction (Process ID 63) was deadlocked
on lock resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.
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.isDataInResultSet(TdsCore.java:792)
at net.sourceforge.jtds.jdbc.JtdsResultSet.<init>(JtdsResultSet.java:146)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:424)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
at dl2.db.DBUtil.executeQuery(DBUtil.java:345)
at dl2.TestingQueue.GetQueue(TestingQueue.java:233)
... 16 more
--------------------------------------------------------------------------------
Resin 2.1.7 (built Fri Feb 14 12:48:13 PST 2003)
![[Logo]](/NForum/images/logo.gif){kind=logo}
![[DL]](/NForum/images/icon_mini_groups.gif){kind=icon}
На главную страницу
![[Post]](/NForum/images/icon_minipost.gif){kind=icon}
![[Up]](/NForum/images/icon_up.gif){kind=icon}
