Update Query with Deadlock Error in Parallel
Posted: Sun Oct 31, 2010 2:29 pm
Hi All,
I am trying to update 10 records in a table in oracle which are having same Key column value i.e they are having the same group value, so I want to set Y to all that records within the group.
I run the job on Default parallel node, it got aborted with the error -- Deadlock detected while waiting for the resource..
I ran the job on Single node config file, got the same error.
I added the environmental variable APT_ORA_IGNORE_CONFIG_FILE_PARALLELISM = True and run the job, got aborted with the same error.
I changed the Oracle Stage to execute in sequential mode and ran the job, it is successful.
Here what I could not understand is, running the job on single node means we are executing that in sequential manner only then why it got aborted with deadlock, and why it is successful when I convert a particular stage to run in sequential?
Any thoughts?
I am trying to update 10 records in a table in oracle which are having same Key column value i.e they are having the same group value, so I want to set Y to all that records within the group.
I run the job on Default parallel node, it got aborted with the error -- Deadlock detected while waiting for the resource..
I ran the job on Single node config file, got the same error.
I added the environmental variable APT_ORA_IGNORE_CONFIG_FILE_PARALLELISM = True and run the job, got aborted with the same error.
I changed the Oracle Stage to execute in sequential mode and ran the job, it is successful.
Here what I could not understand is, running the job on single node means we are executing that in sequential manner only then why it got aborted with deadlock, and why it is successful when I convert a particular stage to run in sequential?
Any thoughts?