暂无图片
update导致死锁
我来答
分享
Donnieyen
2022-01-05
update导致死锁

环境:

Oracle12C Rac

业务系统近期出现2次死锁,日志如下:

2021-12-27T15:28:28.665240+08:00
Global Enqueue Services Deadlock detected (DID = 28_1_1). More information in file
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmd0_10328.trc.
2021-12-27T15:29:28.788629+08:00
Global Enqueue Services Deadlock detected (DID = 28_1_2). More information in file
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmd0_10328.trc.
2021-12-27T15:29:58.931100+08:00
Global Enqueue Services Deadlock detected (DID = 28_1_3). More information in file
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmd0_10328.trc.
2021-12-27T15:30:58.908192+08:00
Global Enqueue Services Deadlock detected (DID = 28_1_4). More information in file
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmd0_10328.trc.
2021-12-27T15:41:48.910468+08:00
Global Enqueue Services Deadlock detected (DID = 28_1_5). More information in file
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmd0_10328.trc.
2021-12-27T15:53:12.776506+08:00
Global Enqueue Services Deadlock detected (DID = 28_1_6). More information in file
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmd0_10328.trc.
2021-12-27T15:54:22.873278+08:00
Global Enqueue Services Deadlock detected (DID = 28_1_7). More information in file
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmd0_10328.trc.
2021-12-27T16:46:48.908953+08:00
Global Enqueue Services Deadlock detected (DID = 28_1_8). More information in file
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmd0_10328.trc

我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
Donnieyen
上传附件:lmd0_10328.trc
暂无图片 评论
暂无图片 有用 0
Uncopyrightable

有专家已经留的文档,参考下
https://www.modb.pro/db/4571

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
附件列表
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏