deadlock error = job status OK
Posted: Fri Oct 03, 2008 3:49 pm
Hi, I'm hoping that someone can help here, I'm completely stumped. I have a two part problem.
1) We are updating a database in our parallel job. When the update ODBC stage is set to parallel mode, I get fatal deadlock errors. When the update ODBC stage is set to sequential mode, no error. Why would this happen? Each row update is unique (no overlapping updates).
2) When we recieve the fatal deadlock error, the job completes with a status = 1. This is NOT ok. Since the job status is fine, we don't know it has not successfully updated the database unless we open the log every time to visually check. Any idea why the status is okay and not aborted or with warnings?
This is the Fatal error that we recieve:
APT_CombinedOperatorController,0: [DataDirect][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 211) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Thanks in advance!!!
* editing to add *
The job is reading from a sequential file and then updating the database with the primary key column in the where clause.
1) We are updating a database in our parallel job. When the update ODBC stage is set to parallel mode, I get fatal deadlock errors. When the update ODBC stage is set to sequential mode, no error. Why would this happen? Each row update is unique (no overlapping updates).
2) When we recieve the fatal deadlock error, the job completes with a status = 1. This is NOT ok. Since the job status is fine, we don't know it has not successfully updated the database unless we open the log every time to visually check. Any idea why the status is okay and not aborted or with warnings?
This is the Fatal error that we recieve:
APT_CombinedOperatorController,0: [DataDirect][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 211) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Thanks in advance!!!
* editing to add *
The job is reading from a sequential file and then updating the database with the primary key column in the where clause.