Possible deadlock condition
Hi,I am running Windows Server 2003 SP2 as a Database Server and have recently noticed the following error message on the console:Windows - Exception Possible deadlock condition(I could not find any additional info aboutthis errorin System and Application Logs)How can I find out which application is causing this message?Thank you for your timeEvgeniya
June 9th, 2009 8:31am
Hello, This is not a default behaviour of Windows OS. The error which you are getting "Possible deadlock condition" has some thing to do with SQL or Thrid Party Application which is installed on your computer. A deadlock is when two processes are locking each other out and you end up with a circular lock situation.
Free Windows Admin Tool Kit Click here and download it now
June 9th, 2009 9:32am
hi there, A deadlock is a condition where 2 (or more) processes attempt to access a resource that the other holds a lock on. Since each process has a request for the other's resource, neither process can be completed. when do you get this error message, is it occur when you are working on the database ? what database are you running on your system ( SQL , ORACLE etc.. ) sainath
windows driver development.
June 9th, 2009 9:58am
Hello,thank you for explanations!i am running MS SQL SErver 2005 SP3.i have made atest:i have made a deadlock in SQL Server (i can see it in SQL Server Profiler) but i have not become any error messages from Windows like "Possible deadlock condition"So i havethought this error messagehas nothing to do with databases...Do you think the problem relates to Databases?Thank you for your timeEvgeniya
Free Windows Admin Tool Kit Click here and download it now
June 9th, 2009 10:33am
Hi there,
the above exception can be caused by different components which might not be related to sql server. In order to check which windows component is responsible for the exception , you would need to provide us a) event id ( along with description ) b) When does the error message pop up c) is tehre any windows functionality ./ sql functionality which gets affected when you see the error. It would be worth posting your query under sQL server forums.
http://social.technet.microsoft.com/Forums/en-US/category/sqlserversainath
windows driver development.
June 9th, 2009 10:55am
Hi,a) Event ID: 26Source: Application PopupType: InformationDescription: Application popup: Windows - EXCEPTION : Possible deadlock condition.b-c) the error message pop up at night (not every night).During this time SQL Server Agent Jobs (Database Backups, ETL) starts and also it isbacked up the local disks of the Server.So maybe this error message is really related with database tasks.i do not know...Anywayipost my query under sql server forums.Thank you for your timeEvgeniya
Free Windows Admin Tool Kit Click here and download it now
June 9th, 2009 1:23pm
hi evgeniya,yes , this seems problem with the SQL rather than another application causing. So as i suggested earlier please post your query under SQL forums and if they feel that issue is not with SQL, please do reply on to this thread , so that we will resume troubleshooting. sainath
windows driver development.
June 9th, 2009 3:11pm


