[Seasar-user:21364] Re: SQLのデッドロック発生について

2012年 7月 2日 (月) 14:26:05 JST

$B$R$,!!MM(B

$B$4JVEz$"$j$,$H$&$4$6$$$^$9!#(B
$BN;2r$7$^$7$?!#(B
SQL$B$NFbMF$K$D$$$F!"8+D>$7$^$9!#(B

$BM-Fq$&$4$6$$$^$7$?!#(B
-----Original Message-----
From: seasar-user-bounces ＠ ml.seasar.org
[mailto:seasar-user-bounces ＠ ml.seasar.org] On Behalf Of YASUO HIGA
Sent: Monday, July 02, 2012 2:18 PM
To: seasar-user ＠ ml.seasar.org
Subject: [Seasar-user:21363] Re: SQL$B$N%G%C%I%m%C%/H/@8$K$D$$$F(B

$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(B
$B%/%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(B
$B%/$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%/(B
$B%7%g%s$r:F<B9T$7$F$/$@$5$$!#(B], ErrorCode=1205, SQLState=40001)$B$,H/@8$7$^$7(B
$B$?!#(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(B
$B%;%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$^(B
$B$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(PreparedStatem
entUtil.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.$$updateB
ySql$$invokeSuperMethod$$(CommonService$$EnhancedByS2AOP$$1286d597.java)
        at
jp.co.maintec.wtm.service.CommonService$$EnhancedByS2AOP$$1286d597$$MethodIn
vocation$$updateBySql0.proceed(MethodInvocationClassGenerator.java)
        at
org.seasar.extension.tx.DefaultTransactionCallback.execute(DefaultTransactio
nCallback.java:58)
        at
org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.required(JTATra
nsactionManagerAdapter.java:65)
        at
org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:
50)
        at
jp.co.maintec.wtm.service.CommonService$$EnhancedByS2AOP$$1286d597$$MethodIn
vocation$$updateBySql0.proceed(MethodInvocationClassGenerator.java)
        at
org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceIntercept
or.java:56)
        at
jp.co.maintec.wtm.service.CommonService$$EnhancedByS2AOP$$1286d597$$MethodIn
vocation$$updateBySql0.proceed(MethodInvocationClassGenerator.java)
        at
jp.co.maintec.wtm.service.CommonService$$EnhancedByS2AOP$$1286d597.updateByS
ql(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.$$higotoSyur
yo$$invokeSuperMethod$$(InputAction$$EnhancedByS2AOP$$4fc0cb76.java)
        at
jp.co.maintec.wtm.action.InputAction$$EnhancedByS2AOP$$4fc0cb76$$MethodInvoc
ation$$higotoSyuryo21.proceed(MethodInvocationClassGenerator.java)
        at
jp.co.maintec.wtm.interceptor.LoginInterceptor.invoke(LoginInterceptor.java:
54)
        at
jp.co.maintec.wtm.action.InputAction$$EnhancedByS2AOP$$4fc0cb76$$MethodInvoc
ation$$higotoSyuryo21.proceed(MethodInvocationClassGenerator.java)
        at
org.seasar.extension.tx.DefaultTransactionCallback.execute(DefaultTransactio
nCallback.java:58)
        at
org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.never(JTATransa
ctionManagerAdapter.java:114)
        at org.seasar.extension.tx.NeverInterceptor.invoke(NeverInterceptor.
java:38)
        at
jp.co.maintec.wtm.action.InputAction$$EnhancedByS2AOP$$4fc0cb76$$MethodInvoc
ation$$higotoSyuryo21.proceed(MethodInvocationClassGenerator.java)
        at
org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceIntercept
or.java:56)
        at
jp.co.maintec.wtm.action.InputAction$$EnhancedByS2AOP$$4fc0cb76$$MethodInvoc
ation$$higotoSyuryo21.proceed(MethodInvocationClassGenerator.java)
        at
org.seasar.framework.aop.interceptors.ThrowsInterceptor.invoke(ThrowsInterce
ptor.java:79)
        at
jp.co.maintec.wtm.action.InputAction$$EnhancedByS2AOP$$4fc0cb76$$MethodInvoc
ation$$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(RequestProces
sor.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(Application
FilterChain.java:290)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
org.seasar.extension.filter.RequestDumpFilter.doFilter(RequestDumpFilter.jav
a:127)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
org.seasar.framework.container.filter.S2ContainerFilter.doFilter(S2Container
Filter.java:79)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
org.seasar.framework.container.hotdeploy.HotdeployFilter.doFilter(HotdeployF
ilter.java:71)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.
java:646)
        at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDis
patcher.java:436)
        at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatch
er.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(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
org.seasar.framework.container.filter.S2ContainerFilter.doFilter(S2Container
Filter.java:79)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
org.seasar.framework.container.hotdeploy.HotdeployFilter.doFilter(HotdeployF
ilter.java:71)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
org.seasar.extension.filter.EncodingFilter.doFilter(EncodingFilter.java:69)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:233)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va: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.jav
a: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(B
$B$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