Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connectivity error: SQL Server: Deadlocked ??
Message
From
19/02/2007 10:40:42
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
To
19/02/2007 10:27:36
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01197028
Message ID:
01197032
Views:
14
This message has been marked as a message which has helped to the initial question of the thread.
>What that error means? Something's wrong in my transaction?
>
>Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 106) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

You may need to read the whole theory of deadlock and how is it practically solved. Two processes can read the same piece of a database (a few records, usually), and decide to update them. Usually this doesn't happen at the same time - however, in your case it did. The SQL server has a way to resolve this, by choosing which transaction will be allowed to complete and which won't. The toss of the coin has decided that your transaction takes a walk, while the other transaction goes through. You need to run yours again.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform