Error ContextSwitchDeadlock en Visual Basic.Net 2005

10 Sep

This days I been working trying to develop a VB.NET 2005 Application as a request from finance department.

They need a way to browse a table from MS SQL SERVER 2000 that have 60,000,000 records based on user parameters.

While was in the process of testing I get this error multiple times when the process takes too much.

ContextSwitchDeadlock was detected Message: The CLR has been unable to transition from COM context 0x1b2008 to COM context 0x1b2178 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages. This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over time. To avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations.

In this link I find the solution to the problem:

http://blog.wpfwonderland.com/2007/08/16/clr-has-been-unable-to-transition-from-com-context-for-60-seconds/

or this have the solution:

http://harriyott.com/2006/05/contextswitchdeadlock-was-detected.aspx

Instructions if the websites are not available:

Debug -> Exceptions -> Managed Debug Assistants
and unchecking the ContextSwitchDeadlock item. Thanks to Scott Munro

Thanks for the time of Publishing a solution to this situation.

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 60 other followers

%d bloggers like this: