Deadlock message

We are seeing deadlock message in the event viewer when
running a transaction in sql server 7.0 database.
Following is the message:
"The description for Event ID ( 4 ) in Source ( TEST)
cannot be found. The local computer may not have the
necessary registry information or message DLL files to
display messages from a remote computer. The following
information is part of the event:
User Id: msqi1
E7009 : The database returned the following message:
com.ms.wfc.data.AdoException: Your transaction (process ID
#36) was deadlocked with another process and has been
chosen as the deadlock victim. Rerun your transaction.
at
com/server/fm/dataservices/ObjectBinder.executeUpdate01_Loc
ks at java/lang/reflect/Method.invoke
at com/server/fm/dataservices/DataServices.update
at com/server/fm/dataservices/DataServices.update
at
com/server/fm/util/dataservices/testLockDataServices.modify
at com/server/test/CCRAInfoEngine.processOutgoingInfo"
The transaction that deadlocks is an execute of a stored
procedure called Update01_locks. This procedure does a
select of a particular row in a table called Locks and
then updates that row. When another transaction selects a
different row and tries to update that row, it deadlocks.
Why is it deadlocked when they are 2 different rows in the
same table. The table Locks has only 3 rows and there are
no indexes.
Please let me know if there is a way to find the cause of
the deadlock and how to resolve it.
ThanksI am also seeing a deadlock message and trying to investigate the cause
of it.
In the past, I seem to recall being able to set the SQL Server logs so
that they record more information. It seems that these logs, if
detailed enough, should be able to provide clues.
Currently, all I see in the log is a record that my backups are being
done. I know it can be configured to show logon attempts and all sorts
of things, but I can't seem to find the opeions and settings for this
Does anyone know where they are?
Rick.
Gayathri wrote:
> We are seeing deadlock message in the event viewer when
> running a transaction in sql server 7.0 database.
> Following is the message:
> "The description for Event ID ( 4 ) in Source ( TEST)
> cannot be found. The local computer may not have the
> necessary registry information or message DLL files to
> display messages from a remote computer. The following
> information is part of the event:
> User Id: msqi1
> E7009 : The database returned the following message:
> com.ms.wfc.data.AdoException: Your transaction (process ID
> #36) was deadlocked with another process and has been
> chosen as the deadlock victim. Rerun your transaction.
> at
> com/server/fm/dataservices/ObjectBinder.executeUpdate01_Loc
> ks at java/lang/reflect/Method.invoke
> at com/server/fm/dataservices/DataServices.update
> at com/server/fm/dataservices/DataServices.update
> at
> com/server/fm/util/dataservices/testLockDataServices.modify
> at com/server/test/CCRAInfoEngine.processOutgoingInfo"
> The transaction that deadlocks is an execute of a stored
> procedure called Update01_locks. This procedure does a
> select of a particular row in a table called Locks and
> then updates that row. When another transaction selects a
> different row and tries to update that row, it deadlocks.
> Why is it deadlocked when they are 2 different rows in the
> same table. The table Locks has only 3 rows and there are
> no indexes.
> Please let me know if there is a way to find the cause of
> the deadlock and how to resolve it.
> Thanks