java.sql.SQLException: Lock wait timeout exceeded --轉

來源:互聯網
上載者:User

標籤:

 org.springframework.dao.CannotAcquireLockException 的解決》

        直接上 bug 的詳細資料

 

2012-03-12 15:20:31 XmlBeanDefinitionReader [INFO] Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]2012-03-12 15:20:31 SQLErrorCodesFactory [INFO] SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]2012-03-12 15:20:31 ExceptionUtil [ERROR] SqlMapClient operation; SQL [];   --- The error occurred in com/defonds/syncpath/dao/operation.xml.  --- The error occurred while applying a parameter map.  --- Check the operation.updateShareStatus-InlineParameterMap.  --- Check the statement (update failed).  --- Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   --- The error occurred in com/defonds/syncpath/dao/operation.xml.  --- The error occurred while applying a parameter map.  --- Check the operation.updateShareStatus-InlineParameterMap.  --- Check the statement (update failed).  --- Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transactionorg.springframework.dao.CannotAcquireLockException: SqlMapClient operation; SQL [];   --- The error occurred in com/defonds/syncpath/dao/operation.xml.  --- The error occurred while applying a parameter map.  --- Check the operation.updateShareStatus-InlineParameterMap.  --- Check the statement (update failed).  --- Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   --- The error occurred in com/defonds/syncpath/dao/operation.xml.  --- The error occurred while applying a parameter map.  --- Check the operation.updateShareStatus-InlineParameterMap.  --- Check the statement (update failed).  --- Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transactionat org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:244)at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)at com.defonds.frameworkcommons.dao.BaseDaoImpl.execute(BaseDaoImpl.java:31)at com.defonds.frameworkcommons.dao.BaseDaoImpl.update(BaseDaoImpl.java:97)at com.defonds.syncpath.service.operation.impl.OperationServiceImpl.revokeSharedFolder(OperationServiceImpl.java:287)at com.defonds.syncpath.service.share.impl.ShareServiceImpl.handleRevokeSharedFolder(ShareServiceImpl.java:312)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:597)at com.defonds.interfaceframework.controller.Action.invokeMethod(Action.java:256)at com.defonds.interfaceframework.controller.Action.execute(Action.java:206)at com.defonds.interfaceframework.controller.DispatcherServlet.service(DispatcherServlet.java:144)at com.defonds.syncpath.common.ArcSyncDispatcherServlet.service(ArcSyncDispatcherServlet.java:51)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.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)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:128)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:286)at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)at java.lang.Thread.run(Thread.java:619)

        分析原因

        Spring 事務嵌套造成死結。FileServiceImpl 裡嵌入了 OperationService:

 

private OperationService operationService;

        FileServiceImpl 的 delete 方法裡對 MySQL 的 file 表有操作,而 OperationService 裡的 revokeSharedFolder 方法也對同一張表有更新操作。事務嵌套,造成死結。

        解決方案

        當前調用事務的方法設定為 Propagation.SUPPORTS:

 

@Transactional(propagation=Propagation.SUPPORTS)//by Defonds,for BUG094537@Overridepublic void delete(int uid, int[] itemIds) {if (itemIds != null && itemIds.length > 0) {

原文地址:http://www.xuebuyuan.com/958812.html

 

java.sql.SQLException: Lock wait timeout exceeded --轉

相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.