数据库死锁

最新推荐文章于 2023-06-20 17:14:31 发布
最新推荐文章于 2023-06-20 17:14:31 发布
阅读量905 收藏
点赞数
分类专栏： MySQL 文章标签： Trasactional
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/calm_encode/article/details/117476070
版权 
### Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
; Lock wait timeout exceeded; try restarting transaction; nested exception is com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
2021-06-02 17:16:54.355  [http-nio-8201-exec-2] ERROR c.q.p.printcommon.component.ExceptionTranslator.processOtherException - 遇到非预期的错误
org.springframework.dao.CannotAcquireLockException: 
### Error updating database.  Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
### The error may exist in com/qskj/print/printcommon/mapper/PrintLoanMapper.java (best guess)
### The error may involve com.qskj.print.printcommon.mapper.PrintLoanMapper.insert-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO print_loan  ( province,      area, postcode, version, phone,     image_synthesis_status,  supplier_id,  city,    del_flag,  uid, ship_money,    author_ids, address,  update_time, discount_money,   money, create_time,  recipient )  VALUES  ( ?,      ?, ?, ?, ?,     ?,  ?,  ?,    ?,  ?, ?,    ?, ?,  ?, ?,   ?, ?,  ? )
### Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
; Lock wait timeout exceeded; try restarting transaction; nested exception is com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:263)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
	at com.sun.proxy.$Proxy92.insert(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:58)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:61)
	at com.sun.proxy.$Proxy96.insert(Unknown Source)
	at com.qskj.print.printapp.service.AppLoanServiceImpl.dealCreateLoan(AppLoanServiceImpl.java:408)
	at com.qskj.print.printapp.service.AppLoanServiceImpl.createLoan(AppLoanServiceImpl.java:250)
	at com.qskj.print.printapp.service.AppLoanServiceImpl$$FastClassBySpringCGLIB$$1df63f76.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
	at com.qskj.print.printcommon.component.AOP.doInputOutputLogging(AOP.java:117)
	at com.qskj.print.printcommon.component.AOP.doServiceLogging(AOP.java:79)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
	at com.qskj.print.printapp.service.AppLoanServiceImpl$$EnhancerBySpringCGLIB$$2e51078b.createLoan(<generated>)
	at com.qskj.print.printapp.controller.loan.LoanController.createLoan(LoanController.java:62)
	at com.qskj.print.printapp.controller.loan.LoanController$$FastClassBySpringCGLIB$$594d0031.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
	at com.qskj.print.printcommon.component.AOP.doInputOutputLogging(AOP.java:117)
	at com.qskj.print.printcommon.component.AOP.doControllerLogging(AOP.java:74)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
	at com.qskj.print.printapp.controller.loan.LoanController$$EnhancerBySpringCGLIB$$6f2be942.createLoan(<generated>)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	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:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	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:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:123)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:955)
	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:372)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
	at com.sun.proxy.$Proxy249.execute(Unknown Source)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
	at com.sun.proxy.$Proxy247.update(Unknown Source)
	at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doUpdate(MybatisSimpleExecutor.java:54)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
	at com.baomidou.mybatisplus.extension.plugins.OptimisticLockerInterceptor.intercept(OptimisticLockerInterceptor.java:97)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy246.update(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
	... 106 common frames omitted

解决方法：

//查看造成锁表的进程,即trx_mysql_thread_id
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
//杀掉造成锁表的进程
kill 进程号；

 

至学者
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
at com.sun.proxy.$Proxy147.passwordLogin(Unknown Source)报错问题
qq_37526045的博客
03-05 1万+
java.lang.reflect.UndeclaredThrowableException at com.sun.proxy.Proxy147.passwordLogin(UnknownSource)atcn.love599.member.userinfo.UserInfoController.passwordLogin(UserInfoController.java:64)atcn.love5...
用ssh框架做项目时，输出数据出现错误
06-22 718
10:25:52.382 [http-bio-8080-exec-1] ERROR org.hibernate.proxy.pojo.javassist.JavassistProxyFactory - HHH000142: Javassist Enhancement failed: zhangyu.domain.Dict java.lang.ClassCastException: zhangy
线上项目运行中遇到的问题
芝麻的博客
09-30 1321
之前跑的好好的线上项目忽然就出现了问题.. 最初只是异常提示数据库连接不上, 连接池不够..类似这样的: Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection 第一次接触服务器和线上项目, 慌的一皮, 不...
windows下hadoop开发踩坑日志
cnheasy
08-31 532
NO.1 org.apache.hadoop.ipc.RemoteException(java.io.IOException): File /heasy/data could only be replicated to 0 nodes instead of minReplication (=1). There are 1 datanode(s) running and 1 node(s) are...
springboot hikari数据库连接池死链 出现异常
wangjun5159的专栏
05-28 3792
最近用户反应系统很慢，登录时，经常超时、无反应，查看log出现上述两种异常， 异常情况1 The last packet successfully received from the server was 995,202 milliseconds ago. The last packet sent successfully to the server was 995,202 milliseconds ago. at com.mysql.cj.jdbc.exceptions.SQLError.crea
method.invoke导致递归死循环，at com.sun.proxy.$Proxy0.add(Unknown Source)
weixin_58615151的博客
06-20 590
method.invoke导致递归死循环
关于mybatis的一个bug问题
超哥superb 的专栏
06-01 7583
错误：org.springframework.jdbc.BadSqlGrammarException:  ### Error updating database.  Cause: java.sql.SQLException: Unknown column 'derId' in 'where clause' ### The error may involve com.jiuyi.vggle.da
at com.sun.proxy.$Proxy5.createQuery(Unknown Source)
热门推荐
Halfopen的专栏
10-11 3万+
java.lang.reflect.UndeclaredThrowableException at com.sun.proxy.$Proxy5.createQuery(Unknown Source) java.lang.NoSuchMethodError: antlr.collections.AST.getLine()
解决java.lang.NoClassDefFoundError: Could not initialize class方案
weidianlun的博客
09-14 2万+
引用：https://blog.csdn.net/erlian1992/article/details/80683599 2018-06-12 10:03:34 [http-nio-8107-exec-3] ERROR com.huajin.assetserver.advice.ExpectionAdviceController - Handle request fail! org.sprin...
查看数据库死锁信息
02-26
服务器运行一天后，就开始频繁报错：Deadlock found when trying to get to lock; try restarting transaction. 死锁的头号原因是外键未加索引，第二号原因是位图索引遭到并发更改；
Mybatis update数据库死锁之获取数据库连接池等待
09-01
主要介绍了Mybatis update数据库死锁之获取数据库连接池等待的相关资料,非常不错，具有参考借鉴价值，需要的朋友可以参考下
mysql 数据库死锁原因及解决办法
09-10
主要介绍了mysql 数据库死锁原因及解决办法,需要的朋友可以参考下
分布式数据库死锁检测算法分析
12-25
分布式课堂上分享讲的ppt，简要介绍了死锁检测的基本概念，以及分布式数据库几种常见的死锁检测算法。
Java 调用WebService报错
lyc417356935的专栏
06-06 691
at com.sun.proxy.$Proxy65. Unknown Source)at com.sun.proxy.$Proxy65.qryAuthorizedDimData(Unknown Source) -- 传递的参数有问题，检查传递参数的类型和值是否正确。
mysqlplus 批量插入_解决SpringBoot+Druid+Mybatis Plus 执行MySQL批量插入，更新 报错的问题...
weixin_39727934的博客
12-20 741
项目实际开发中，使用到了MySQL批量插入的语法，在MySQL中执行成功后，移植到项目时发生了问题，语句如下：REPLACE INTO table1(id,works_fusion_id,statistics_date,chapter_number,new_chapter,works_hot,works_like_number,works_read_number,works_comment_num...
java.lang.NoClassDefFoundError: Could not initialize class com.baomidou.mybatisplus.toolkit.SqlUtils
一火的专栏
07-25 1909
java.lang.NoClassDefFoundError: Could not initialize class com.baomidou.mybatisplus.toolkit.SqlUtils
mybatis存在就不插入_mybatis批量插入失败的问题
weixin_39568653的博客
12-20 744
某日，同事说批量插入失败,异常如下2018-03-07 20:54:58,262 ERROR [][CardOperationVerifyServiceImpl.java:95] : 添加申请记录出现异常org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingEx...
mysql事务，索引产生死锁的问题
zaoHz的博客
04-24 1108
请求并发访问这个接口 实现类如下 第一条sql：select <include refid="Base_Column_List" /> from t_bank_card b where account_id = #{accountId,jdbcType=VARCHAR} and card_no=#{cardNo,jdbcType=VARCHAR} f...
oracle数据库死锁
最新发布
08-25
Oracle数据库死锁是指两个或多个事务相互等待对方释放所持有的资源，导致事务无法继续执行，并且无法通过自动机制解决该冲突。当发生死锁时，数据库会检测到该情况，并选择一个事务进行回滚，以解除死锁。 出现死锁的原因通常是事务并发执行时对资源的竞争导致的，例如不同的事务同时请求相同的资源但按不同的顺序获取，或者事务持有了某些资源并请求其他事务所持有的资源。 为了处理Oracle数据库中的死锁问题，可以采取以下几种方法： 1. 检测死锁：Oracle数据库提供了系统视图和命令来检测死锁，例如使用`DBA_DDL_LOCKS`视图或`SELECT * FROM V$LOCKED_OBJECT`命令来查看被锁定的对象。 2. 解决死锁：一旦检测到死锁，Oracle数据库会自动选择一个事务进行回滚以解除死锁。这个过程是自动的，可以通过配置数据库参数来调整死锁检测和解除的行为。 3. 优化事务设计：设计良好的事务可以减少死锁的发生。例如，可以按照固定的顺序获取资源，或者减少事务之间对同一资源的竞争。 4. 调整数据库参数：可以通过调整Oracle数据库的参数来减少死锁的风险。例如，通过调整`DML_LOCKS`参数来控制事务对数据行的锁定方式。 5. 使用锁超时机制：可以在事务等待资源时设置锁超时，如果超过一定时间仍未获取到资源，则自动回滚事务。这可以减少死锁持续时间，但也可能导致事务执行失败。 以上是一些处理Oracle数据库死锁问题的常见方法，具体应根据实际情况选择合适的解决方案。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值