68067580

Date: 2021-06-21 13:04:41
Score: 6
Natty: 3.5
Report link

Similar for me also deadlock happens with parent and child

Can you please help Deadlock graph: ---------Blocker(s)-------- ---------Waiter(s)--------- Resource Name process session holds waits process session holds waits TX-00170002-000260AA-00000000-00000000 203 1398 X 112 2022 X TX-001A000A-0002126E-00000000-00000000 112 2022 X 203 1398 X

session 1398: DID 0001-00CB-00086A47 session 2022: DID 0001-0070-0002E3D7 session 2022: DID 0001-0070-0002E3D7 session 1398: DID 0001-00CB-00086A47

Rows waited on: Session 1398: obj - rowid = 000301CC - AAAwHMABOAAD6Z9ACK (dictionary objn - 197068, file - 78, block - 1025661, slot - 138) Session 2022: obj - rowid = 000302C6 - AAAwLGAAfAAFYgtAAB (dictionary objn - 197318, file - 31, block - 1411117, slot - 1)

----- Information for the OTHER waiting sessions ----- Session 2022: sid: 2022 ser: 5169 audsid: 1840248 user: 144/AFLSOPS flags: (0x41) USR/- flags_idl: (0x1) BSY/-/-/-/-/- flags2: (0x40009) -/-/INC pid: 112 O/S info: user: oracle, term: UNKNOWN, ospid: 7235 image: oracle@afdbopt01.ec2.internal client details: O/S info: user: afklm, term: unknown, ospid: 1234 machine: afptapp01.ec2.internal program: JDBC Thin Client application name: JDBC Thin Client, hash value=2546894660 enter code here DELETE FROM PARENT D WHERE (SELECT 1 FROM DOC_KEY_PURGE_TEMP TMP WHERE TMP.DOC_KEY = D.DOC_KEY);

current SQL: delete from CHILD_TABLE where CHILD_PK =:1

Please share comments on this please

Reasons:
  • RegEx Blacklisted phrase (1.5): Please share
  • RegEx Blacklisted phrase (3): Can you please help
  • Long answer (-1):
  • No code block (0.5):
  • Unregistered user (0.5):
  • Filler text (0.5): ---------
  • Filler text (0): --------
  • Filler text (0): ---------
  • Filler text (0): ---------
  • Filler text (0): 00000000
  • Filler text (0): 00000000
  • Filler text (0): 00000000
  • Filler text (0): 00000000
  • Low reputation (1):
Posted by: kohila