How to avoid deadlock whicle processing the xml file using window service and wcf service.

Question

0.00/5 (No votes)

See more:

Hi There,
I have one application which consist of one window service and one wcf service.Window service calls the wcf service after every 15 min. adn then wcf service takes xml file from ftp server and processes this files and inserts the records into SQL serve database. We have used transaction(begin/commit or rollback) for all insert, update and delete operation.
But we are facing some issue like
"Transaction (Process ID 152) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Source : .Net SqlClient Data Provider Help link : Errors". This case is happening only when we update same xml file data. But we are not able to reproduce this same scenario locally, this is happening only on production. So could you please tell me how to reproduce this same scenario locally or solution for the above issue.

Posted 21-Sep-15 0:56am

nira.parmar

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Kizyan · Answer 1 · 2015-09-22T01:04:00

Solution 1

If two processes are trying to use same file you should synchronize this operation. Try to use Mutex for read and write operations, this should help.

Posted 22-Sep-15 1:04am

Sergey Kizyan