Sql-server – Getting deadlock on insert and select statement(sql server 2014) in java application

javasql server 2014

In my application there are many threads which uses insert and select statement to store/retrieve data from database.

I am getting deadlock in my production environment, I have observe deadlock from application log file.

enter image description here
I am not able to reproduce same situation on my development environment.

Please give me suggestion to:

  • How to resolve this kind of deadlock?

  • How to get more clear understanding to capture deadlock?

Thank you

Best Answer

How to resolve this kind of deadlock?

As you have not provided your deadlock graph it will be impossible to give an answer about how to resolve the deadlock. Even with just deadlock graph sometime it is not possible to give a solution. You might have to trace your calls and see the sequence of calls (involved in the deadlock), look at the execution plan, isolation level etc. Based on what you said (insert and select statement) I suggest you read this post which will give you a good start.

SELECT/INSERT Deadlock

How to get more clear understanding to capture deadlock?

As suggested by @spaghettidba in comment section you can look at the article mentioned there.

Few more articles for you:

Related Question