ORA-00060: Deadlock detected during Dbms_rule_adm.drop_rule Or Dbms_rule_adm.remove_rule
(Doc ID 3069985.1)
Last updated on FEBRUARY 06, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 19.25.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
ORA-00060: deadlock detected during Dbms_rule_adm.drop_rule Or Dbms_rule_adm.remove_rule
Remove_rule err ORA-24155: rule SYS.SCHEDULER$_RN$_591777 not in rule set EXXXT_NEW.EVENT_QUEUE_R <==============
DEADLOCK DETECTED ( ORA-00060 )
[Transaction Deadlock]
Deadlock graph:
------------Blocker(s)----------- ------------Waiter(s)------------
Resource Name process session holds waits serial process session holds waits serial
KR-000907AE-00000000-00000000-00000000 52 165 S 6578 52 165 X 6578
----- Information for waiting sessions -----
Session 165:
Holds resource KR-000907AE-00000000-00000000-00000000 acquired 3 seconds ago.
sid: 165 ser: 6578 audsid: 100843760 user: 0/SYS
flags: (0x8000045) USR/- flags2: (0x40009) -/-/INC
flags_idl: (0x1) status: BSY/-/-/- kill: -/-/-/-
pid: 52 O/S info: user: oracle, term: UNKNOWN, ospid: 3547247
image: oracle@inf-poc-mfmpw
client details:
O/S info: user: Pruadm, term: INF-PRO-DBRDP1, ospid: 19852:20280
machine: PRUICICI\INF-PRO-DBRDP1 program: sqldeveloper64W.exe
application name: sqldeveloper64W.exe, hash value=3352594603
current SQL:
begin dbms_rule_adm.drop_rule(:1, TRUE); end; <==================HERE drop_rule
----- End of information for waiting sessions -----
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=1, mask=0x0)
----- Error Stack Dump -----
at 0x7fff30d28800 placed kpoodr.c@248
----- Current SQL Statement for this session (sql_id=80t48xwm8wfzm) -----
begin dbms_rule_adm.drop_rule(:1, TRUE); end; <================
----- Parser State -----
Parser state1: len1=0 len2=29 pos1=29 pos2=29
Parser state2: flg=0x2 xflg=0x80000 xxflg=0x0
Parser state3: tty=0 tlen=21
Parser string: prx=0x7f148e37dd60 base=(nil) cur=0x7f1488e9c5a5
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x923a07e0 359 package body SYS.DBMS_RULEADM_INTERNAL.DROP_RULE
0x923b79d8 624 package body SYS.DBMS_RULE_ADM.DROP_RULE
0x9231f270 1 anonymous block
0x924c9d30 3229 package body SYS.DBMS_ISCHED.DISABLE
0x924f53c0 2966 package body SYS.DBMS_SCHEDULER.DISABLE
0x92534580 1 anonymous block
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |