个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2022-08-30 00:24:28
模拟：
告警日志
trc部分内容：
-
create table emp (no int,sal number);
-
insert into emp values(1,100);
-
insert into emp values(2,300);
-
commit;
-
-
会话1：
-
update emp set sal=sal100 where no=1;
-
会话2：
-
update emp set sal=sal200 where no=2;
-
-
然后会话1：
-
update emp set sal=sal1 where no=2;
-
等执行完会话2的sql几秒后，报死锁 ora-00060
-
-
会话2：
-
update emp set sal=sal-2 where no=1;
- 挂起
告警日志
- 2022-08-29 09:11:28.720000 -07:00
- errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_5271.trc:
- ora-00060: deadlock detected. see note 60.1 at my oracle support for troubleshooting ora-60 errors.
- more info in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_5271.trc.
trc部分内容：
- 2022-08-29 09:11:28.712*:ksq.c@13169:ksqdld_hdr_dump():
- deadlock detected ( ora-00060 )
- see note 60.1 at my oracle support for troubleshooting ora-60 errors
- [transaction deadlock]
- the following deadlock is not an oracle error. it is a
- deadlock due to user error in the design of an application
- or from issuing incorrect ad-hoc sql. the following
- information may aid in determining the deadlock:
- deadlock graph:
- ------------blocker(s)----------- ------------waiter(s)------------
- resource name process session holds waits serial process session holds waits serial
- tx-00060000-000008d0-00000000-00000000 51 268 x 61619 37 277 x 49963
- tx-000a0018-00000739-00000000-00000000 37 277 x 49963 51 268 x 61619
- ----- information for waiting sessions -----
- session 268:
- sid: 268 ser: 61619 audsid: 4294967295 user: 0/sys
- flags: (0x8000041) usr/- flags2: (0x40009) -/-/inc
- flags_idl: (0x1) status: bsy/-/-/- kill: -/-/-/-
- pid: 51 o/s info: user: oracle, term: unknown, ospid: 5271
- image: oracle@bjdb (tns v1-v3)
- client details:
- o/s info: user: oracle, term: pts/2, ospid: 5270
- machine: bjdb program: sqlplus@bjdb (tns v1-v3)
- application name: sqlplus@bjdb (tns v1-v3), hash value=3524224488
- current sql:
- update emp set sal=sal 1 where no=2
- session 277:
- sid: 277 ser: 49963 audsid: 4294967295 user: 0/sys
- flags: (0x41) usr/- flags2: (0x40009) -/-/inc
- flags_idl: (0x1) status: bsy/-/-/- kill: -/-/-/-
- pid: 37 o/s info: user: oracle, term: unknown, ospid: 7328
- image: oracle@bjdb (tns v1-v3)
- client details:
- o/s info: user: oracle, term: pts/1, ospid: 7327
- machine: bjdb program: sqlplus@bjdb (tns v1-v3)
- application name: sqlplus@bjdb (tns v1-v3), hash value=3524224488
- current sql:
- update emp set sal=sal-2 where no=1
- ----- end of information for waiting sessions -----
给主人留下些什么吧！~~