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:
or this have the solution:
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.