Solved

Transaction deadlock error

Posted on 2016-09-09
1
15 Views
Last Modified: 2016-09-13
Hello,
Hoe do I handle this error in the vb.net cde.

How can I set transaction priority to normal in the query.

Transaction (Process ID 52) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
0
Comment
Question by:RIAS
1 Comment
 
LVL 48

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 41790830
First you need to understand what's a deadlock and why it occurs.
After that you need to know how to detect and solve a deadlock for the RDBMS you're using.
With that said you can't set any priority. You need to identify the concurrent queries and work on them to avoid future deadlocks.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question