ORA-60 Deadlocks On OID 11.1.1.5 or 11.1.1.6 With Replication (Doc ID 1666013.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle Internet Directory - Version 11.1.1.5.0 to 11.1.1.6.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

On : 11.1.1.5.0 or 11.1.1.6.0 version, OID Replication Server

Intermittent ORA-60 deadlock occurrences on Production OID nodes with MMR.
the following error occurs in the oidldapd01s<pid>-0000.log.

[2014-04-16T09:01:42-07:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: prodoid01] [pid: 8622] [tid: 10] [ecid: 0006Fk6vChuDScWVLyvH8A00026i0043MD,0] ServerWorker (REG):[[
BEGIN
ConnID:9304 mesgID:10683 OpID:10682 OpName:bind ConnIP:198.51.100.21 ConnDN:cn=user51,cn=users,dc=au,dc=oracle,dc=com
gsldudiExecSql: ORA error = 60 message = ORA-00060: deadlock detected while waiting for resource
ORA-06512: at line 1

SQL=BEGIN IF (:firstTime = 1) THEN UPDATE ds_ATTRSTORE SET attrval = :MODDN WHERE EntryID = :entryID AND AttrName = 'modifiersname'; DELETE ds_Attrstore WHERE EntryID = :entryID AND AttrName = :atName AND attrkind = 't'; END IF; INSERT into ds_ATTRSTORE(EntryID, AttrName, attrkind, attrstype, AttrVer, AttrVal) VALUES(:entryID, :atName, :atKind, :atSType, :atVer || CHR(94) || :atTime || CHR(94) || :atServer , :atVal ); END;
END
]]
[2014-04-16T09:01:42-07:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: prodoid01] [pid: 8622] [tid: 10] [ecid: 0006Fk6vChuDScWVLyvH8A00026i0043MD,0] ServerWorker (REG):[[
BEGIN
ConnID:9304 mesgID:10683 OpID:10682 OpName:bind ConnIP:198.51.100.21 ConnDN:cn=user51,cn=users,dc=au,dc=oracle,dc=com
[gsldma_AddAttrVal]: ORA-60 : ORA-00060: deadlock detected while waiting for resource
ORA-06512: at line 1
encountered
END
]]
[2014-04-16T09:01:42-07:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: prodoid01] [pid: 8622] [tid: 10] [ecid: 0006Fk6vChuDScWVLyvH8A00026i0043MD,0] ServerWorker (REG):[[
BEGIN
ConnID:9304 mesgID:10683 OpID:10682 OpName:bind ConnIP:198.51.100.21 ConnDN:cn=user51,cn=users,dc=au,dc=oracle,dc=com
gslsbpmVGenChangeLogEntry: DB layer modify failed with error code 5
END
]]


The SQL is trying to replace 'modifiersname' for a BIND operation.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms