[Seasar-user:21363] Re: SQLのデッドロック発生について
YASUO HIGA
[E-MAIL ADDRESS DELETED]
2012年 7月 2日 (月) 14:18:12 JST
$B$R$,$G$9!#(B
$B%G%C%I%m%C%/$O!"(BSQL$B$NH/9T$N=gHV$K5/0x$7$F$*$3$k$N$G!"(B
$B$[$H$s$I$N>l9g!"860x$O%"%W%jB&$N(BSQL$B$NH/9T$N;EJ}$K$J$j$^$9!#(B
________________________________________
$B:9=P?M(B: seasar-user-bounces ＠ ml.seasar.org [seasar-user-bounces ＠ ml.seasar.org] $B$,<!$N?M$NBeM}$GAw?.$7$^$7$?(B: okunaka [okunaka ＠ tec-pw.com]
$BAw?.F|;~(B: 2012$BG/(B7$B7n(B2$BF|(B 13:41
$B08 ＠ h(B: seasar-user ＠ ml.seasar.org
$B7oL>(B: [Seasar-user:21362] SQL$B$N%G%C%I%m%C%/H/@8$K$D$$$F(B
$B$*@$OC$K$J$j$^$9!#1|Cf$H?=$7$^$9!#(B
Seasar(SASTRUS+S2JDBC+SQLServer)$B$G%7%9%F%`$r3+H/$7$F<B1?MQ$7$F$$$k$N$G$9$,!"(B
SQL$B$N%G%C%I%m%C%/%(%i!<$,H/@8$7$F:$$C$F$$$^$9!#(B
$B$4;XF3$*4j$$$$$?$7$^$9!#(B
$B!Z(BWEB$B%5!<%P!<![(B
$B!&(BVMWare$B>e$G2<5-$N ＠ _Dj$GF0$$$F$$$^$9!#(B
CPU 2
$B%a%b%j(B 3072MB
SCSI$B%3%s%H%m!<%i(B LSI Logic SAS
HDD 20GB
NIC VMXNET3
OS CentOS6.2 64bit
$B!&%=%U%H9=@.(B
Apache Ver2.2
Tomcat Ver6.0.24
Sastruts Ver1.0.4 sp8
S2JDBC Ver2.4.43
$B!Z(BDB$B%5!<%P!<![(B
Quad Core X-E5410 2.33GHzx1
$B%a%b%j(B8G
SQLServer2008R2
$B!ZH/@8$7$F$$$k%=!<%9$N2U=j![(B
Action$B%/%i%9$N(B ＠ Execute$B%a%=%C%I<B9T;~$K!"(B
$B2?8D$+$N(BSQL$B$r<B9T8e$K!"H/@8$7$^$9!#(B
SQL$B$N<B9TJ}K!$O!"(B
$B-!(BString strSql = "update ***"; <---update$BJ8$J$I$r:n ＠ .!#(B
$B-"(BjdbcManager$B$G(BstrSql$B$NFbMF$r<B9T!#(B
$B!Z%m%0$N0lNc![(B
org.seasar.framework.exception.SQLRuntimeException: [ESSR0072]SQL$B$GNc30(B(SQL=[UPDATE $B%F!<%V%kL>(B SET day_regist_date = CURRENT_TIMESTAMP, record_staff_no = '$B!v!v!v!v!v(B', record_date = CURRENT_TIMESTAMP WHERE DATEPART(year,work_time_date) = 2012 AND DATEPART(month,work_time_date) = 6 AND DATEPART(day,work_time_date) = 18 AND staff_no = '$B!v!v!v!v!v(B' AND valid_flg = '0'], Message=[[ESSR0072]SQL$B$GNc30(B(SQL=[UPDATE $B%F!<%V%kL>(B SET day_regist_date = CURRENT_TIMESTAMP, record_staff_no = '$B!v!v!v!v!v(B', record_date = CURRENT_TIMESTAMP WHERE DATEPART(year,work_time_date) = 2012 AND DATEPART(month,work_time_date) = 6 AND DATEPART(day,work_time_date) = 18 AND staff_no = '$B!v!v!v!v!v(B' AND valid_flg = '0'], Message=[1205], ErrorCode=40001, SQLState={3})$B$,H/@8$7$^$7$?(B : [SQL$B$GNc30(B(Message=[$B%H%i%s%6%/%7%g%s(B ($B%W%m%;%9(B ID 55) $B$,!"%m%C%/(B $B8D$N%j%=!<%9$GB>$N%W%m%;%9$H%G%C%I%m%C%/$7$F!"$3$N%H%i%s%6%/%7%g%s$,$=$N%G%C%I%m%C%/$NBP>]$H$J$j$^$7$?!#%H%i%s%6%/%7%g%s$r:F<B9T$7$F$/$@$5$$!#(B], ErrorCode=1205, SQLState=40001)$B$,H/@8$7$^$7$?!#(B], [$B%H%i%s%6%/%7%g%s(B ($B%W%m%;%9(B ID 55) $B$,!"%m%C%/(B $B8D$N%j%=!<%9$GB>$N%W%m%;%9$H%G%C%I%m%C%/$7$F!"$3$N%H%i%s%6%/%7%g%s$,$=$N%G%C%I%m%C%/$NBP>]$H$J$j$^$7$?!#%H%i%s%6%/%7%g%s$r:F<B9T$7$F$/$@$5$$!#(B], ErrorCode=1205, SQLState=40001)$B$,H/@8$7$^$7$?(B
at org.seasar.framework.util.PreparedStatementUtil.executeUpdate(PreparedStatementUtil.java:68)
at org.seasar.extension.jdbc.query.SqlUpdateImpl.executeInternal(SqlUpdateImpl.java:112)
at org.seasar.extension.jdbc.query.SqlUpdateImpl.execute(SqlUpdateImpl.java:81)
at jp.co.maintec.wtm.service.CommonService.updateBySql(CommonService.java:15)
at jp.co.maintec.wtm.service.CommonService$$EnhancedByS2AOP$$1286d597.$$updateBySql$$invokeSuperMethod$$(CommonService$$EnhancedByS2AOP$$1286d597.java)
at jp.co.maintec.wtm.service.CommonService$$EnhancedByS2AOP$$1286d597$$MethodInvocation$$updateBySql0.proceed(MethodInvocationClassGenerator.java)
at org.seasar.extension.tx.DefaultTransactionCallback.execute(DefaultTransactionCallback.java:58)
at org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.required(JTATransactionManagerAdapter.java:65)
at org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:50)
at jp.co.maintec.wtm.service.CommonService$$EnhancedByS2AOP$$1286d597$$MethodInvocation$$updateBySql0.proceed(MethodInvocationClassGenerator.java)
at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:56)
at jp.co.maintec.wtm.service.CommonService$$EnhancedByS2AOP$$1286d597$$MethodInvocation$$updateBySql0.proceed(MethodInvocationClassGenerator.java)
at jp.co.maintec.wtm.service.CommonService$$EnhancedByS2AOP$$1286d597.updateBySql(CommonService$$EnhancedByS2AOP$$1286d597.java)
at jp.co.maintec.wtm.action.InputAction.entryHigotoJisu(InputAction.java:3656)
at jp.co.maintec.wtm.action.InputAction.higotoSyuryo(InputAction.java:2655)
at jp.co.maintec.wtm.action.InputAction$$EnhancedByS2AOP$$4fc0cb76.$$higotoSyuryo$$invokeSuperMethod$$(InputAction$$EnhancedByS2AOP$$4fc0cb76.java)
at jp.co.maintec.wtm.action.InputAction$$EnhancedByS2AOP$$4fc0cb76$$MethodInvocation$$higotoSyuryo21.proceed(MethodInvocationClassGenerator.java)
at jp.co.maintec.wtm.interceptor.LoginInterceptor.invoke(LoginInterceptor.java:54)
at jp.co.maintec.wtm.action.InputAction$$EnhancedByS2AOP$$4fc0cb76$$MethodInvocation$$higotoSyuryo21.proceed(MethodInvocationClassGenerator.java)
at org.seasar.extension.tx.DefaultTransactionCallback.execute(DefaultTransactionCallback.java:58)
at org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.never(JTATransactionManagerAdapter.java:114)
at org.seasar.extension.tx.NeverInterceptor.invoke(NeverInterceptor.java:38)
at jp.co.maintec.wtm.action.InputAction$$EnhancedByS2AOP$$4fc0cb76$$MethodInvocation$$higotoSyuryo21.proceed(MethodInvocationClassGenerator.java)
at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:56)
at jp.co.maintec.wtm.action.InputAction$$EnhancedByS2AOP$$4fc0cb76$$MethodInvocation$$higotoSyuryo21.proceed(MethodInvocationClassGenerator.java)
at org.seasar.framework.aop.interceptors.ThrowsInterceptor.invoke(ThrowsInterceptor.java:79)
at jp.co.maintec.wtm.action.InputAction$$EnhancedByS2AOP$$4fc0cb76$$MethodInvocation$$higotoSyuryo21.proceed(MethodInvocationClassGenerator.java)
at jp.co.maintec.wtm.action.InputAction$$EnhancedByS2AOP$$4fc0cb76.higotoSyuryo(InputAction$$EnhancedByS2AOP$$4fc0cb76.java)
at sun.reflect.GeneratedMethodAccessor146.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.seasar.framework.util.MethodUtil.invoke(MethodUtil.java:96)
at org.seasar.struts.action.ActionWrapper.execute(ActionWrapper.java:139)
at org.seasar.struts.action.ActionWrapper.execute(ActionWrapper.java:87)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.seasar.struts.action.S2RequestProcessor.process(S2RequestProcessor.java:132)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.seasar.extension.filter.RequestDumpFilter.doFilter(RequestDumpFilter.java:127)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.seasar.framework.container.filter.S2ContainerFilter.doFilter(S2ContainerFilter.java:79)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.seasar.framework.container.hotdeploy.HotdeployFilter.doFilter(HotdeployFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at org.seasar.struts.filter.RoutingFilter.forward(RoutingFilter.java:219)
at org.seasar.struts.filter.RoutingFilter.doFilter(RoutingFilter.java:90)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.seasar.framework.container.filter.S2ContainerFilter.doFilter(S2ContainerFilter.java:79)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.seasar.framework.container.hotdeploy.HotdeployFilter.doFilter(HotdeployFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.seasar.extension.filter.EncodingFilter.doFilter(EncodingFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:662)
@Execute$B$N%a%=%C%I$G!"J#?t$N(BSQL$B$r<B9T$7$F$$$^$9$,!"$=$l$>$l!"=hM}$,40N;$7$F!"<!$N=hM}$,F0$1$P!"%G%C%I%m%C%/$O!"(B
$B5/$3$i$J$$$H;W$&$N$G$9$,!#(B
$BH/@8860x$*$h$S2sHrJ}K!$J$I$r65$($F$$$?$@$1$J$$$G$7$g$&$+!#(B
$B59$7$/!"$*4j$$$$$?$7$^$9!#(B
// Kenji Okunaka
Seasar-user メーリングリストの案内