Oracle deadlock problem

[ankita]

Hi,
I am using Oracle as target with 'User defined update only' option.
While running the job with 4 node configuration it's throwing deadlock problem to update approx. 63,000 records .
There is no duplicate record in the input stream, what could be the reason ?

Thanks in advance !
Ankita

[Abburi]

Hi,
I am using Oracle as target with 'User defined update only' option.
While running the job with 4 node configuration it's throwing deadlock problem to update approx. 63,000 records .
There is no duplicate record in the input stream, what could be the reason ?

Thanks in advance !
Ankita

Check is there any other process trying to do the update or insert at the same time, when your job is running to do the same.

[DSguru2B]

Try running on a single node, just for debuggin purposes and see if the problem persists.

[ankita]

With single node it's running fine in dev, but the same job is running in production with 4 node configuration without any issue.
It's failing even with input hash partitoned with keys.

Why can it fail with 4 node ? Can it fail even if records are different but
belong to same Oracle block ?

No other job is running in dev, so there should not be any parallel process trying to load same table.

[DSguru2B]

What is the exact error message that you are getting?

[ankita]

The error message starts with " Open failed for update " followed by the update query and finally with below error code,

sqlcode is: -60
esql complaint: ORA-00060: deadlock detected while waiting for resource

[DSguru2B]

Ask your DBA to check the trace file to get exacts on what exactly happened.