![]() ![]() particularly if you are in the financial industry. it means you are doing dirty reads, which is often not appropriate. That's not really a fix, more of a band-aid. Hi,Thanks all.I had already detected my deadlock but from my code end couldnt figure out why a deadlock was occuring.I fixed my problem by setting TRANSACTION_READ_UNCOMMITTED in my Jboss Datasource.xml file. One thing that has helped me in the past in debugging them are some traceflags you can set that will print out deadlock information to the sql logs. Also how long it might take to roll back. I'd be very worried about whether that process was built to be able to rollback cleanly, or not so at the very least I would want to check precisely what that process had done, was in the middle of doing, and was not going to finish doing if I killed it. " 4) type "kill 480" and execute the command.(assume 480 is the number you find at spid.replace with the number)"Personally I can't remember the last time I killed a process. swethar, you'll need to follow the steps outlined in Books Online on how to troubleshoot deadlocking.Tara KizerMicrosoft MVP for Windows Server System - SQL Server Swetha,you first go to your database and there check for locks are there on the database.1)open the query analyzer and select that database2)type the command "DBCC OPENTRAN" Then execute the command by pressing F5.3) if you get an spid number there,4) type "kill 480" and execute the command.(assume 480 is the number you find at spid.replace with the number)then check your application.5)please let me know wether it worked for you or not Swetha,you first go to your database and there check for locks are there on the database.1)open the query analyzer and select that database2)type the command "DBCC OPENTRAN" Then execute the command by pressing F5.3) if you get an spid number there,4) type "kill 480" and execute the command.(assume 480 is the number you find at spid.replace with the number)then check your application.5)please let me know wether it worked for you or notVinodEven you learn 1%, Learn it with 100% confidence. The above code works on mysql with 20 objects in the list.Please help. Rerun the transaction.For log ,sqlprofiler I could narrow down that the deadlock is occurring on the below select statement in the code.//select statement to check if the Person already exists in DB Person prsn =entityManager.query("SELECT from Person where.") This code works if there is only one object in the list. This List has 5 value objects.In the session bean I iterate through this list and do the following : while(importListPeople.hasNext()) resources with another process and has been chosen as the deadlock victim. We have a JMS Queue which is unloading a object at a time. We use Java v 1.5 ,EJB 3.0 ,JBoss-4.2.0 and have sqljdbc.jar v 1.1 driver (to connect to sql server from jboss). Hi, Please help with the below deadlock problem :We are using SQL Server 2000. We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |