ORA-60 Deadlocks On OID 11.1.1.5 or 11.1.1.6 With Replication
(Doc ID 1666013.1)
Last updated on AUGUST 30, 2023
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: <HOSTNAME>] [pid: 8622] [tid: 10] [ecid: <ECID#>,0] ServerWorker (REG):[[
BEGIN
ConnID:9304 mesgID:10683 OpID:10682 OpName:bind ConnIP:<IP ADDRESS> ConnDN:cn=<USERNAME>,cn=users,dc=<COMPANY NAME>,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: <HOSTNAME>] [pid: 8622] [tid: 10] [ecid: <ECID#>,0] ServerWorker (REG):[[
BEGIN
ConnID:9304 mesgID:10683 OpID:10682 OpName:bind ConnIP:<IP ADDRESS> ConnDN:cn=<USERNAME>,cn=users,dc=<COMPANY NAME>,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: <HOSTNAME>] [pid: 8622] [tid: 10] [ecid: <ECID#>,0] ServerWorker (REG):[[
BEGIN
ConnID:9304 mesgID:10683 OpID:10682 OpName:bind ConnIP:<IP ADDRESS> ConnDN:cn=<USERNAME>,cn=users,dc=<COMPANY NAME>,dc=com
gslsbpmVGenChangeLogEntry: DB layer modify failed with error code 5
END
]]
BEGIN
ConnID:9304 mesgID:10683 OpID:10682 OpName:bind ConnIP:<IP ADDRESS> ConnDN:cn=<USERNAME>,cn=users,dc=<COMPANY NAME>,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: <HOSTNAME>] [pid: 8622] [tid: 10] [ecid: <ECID#>,0] ServerWorker (REG):[[
BEGIN
ConnID:9304 mesgID:10683 OpID:10682 OpName:bind ConnIP:<IP ADDRESS> ConnDN:cn=<USERNAME>,cn=users,dc=<COMPANY NAME>,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: <HOSTNAME>] [pid: 8622] [tid: 10] [ecid: <ECID#>,0] ServerWorker (REG):[[
BEGIN
ConnID:9304 mesgID:10683 OpID:10682 OpName:bind ConnIP:<IP ADDRESS> ConnDN:cn=<USERNAME>,cn=users,dc=<COMPANY NAME>,dc=com
gslsbpmVGenChangeLogEntry: DB layer modify failed with error code 5
END
]]
The SQL is trying to replace 'modifiersname' for a BIND operation.
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 |