Error: ora-60 deadlock detected
When creating a geometric network it is possible to encounter the Oracle error:
"ora-60 deadlock detected"
This occurs when using the LOB storage type for the logical network.
Additional information is present in the sde.errlog: S_update_attr_LOBS::OCILobWrite error (-51)
Additional information is also present in the Oracle alert log:
ORA-000060 Deadlock detected. More info in file <path>/<name>.trc
The cause of the problem is Oracle bug '3166756 Self deadlock (ORA-60) possible on LOB index update'.
See Oracle's Metalink for additional information.
The problem is present in releases 188.8.131.52, 184.108.40.206 and 220.127.116.11 and reported as being fixed in releases 18.104.22.168 and 10.1.0.3.
Solution or Workaround
Select an option below:
- Upgrade to Oracle release 22.214.171.124/10.1.0.3
- Set the following Oracle event in the init.ora file:
event='10235 trace name context forever, level 2'
Once enabled the geometric network builds successfully.