ContextSwitchDeadlock was detected
在运行C#程序的时候得到如下错误信息:
The CLR has been unable to transition from COM context 0×197060 to COM context 0×196ef0 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.
简单的修复方法是:(VS2005下) 打开 Debug -> Exceptions -> Managed Debug Assistants,
把ContextSwitchDeadlock取消勾选就可以了。
SQL SERVER 2005中复制一个表的数据到另外一个表的时候出现的一个问题
问题显示:Cannot insert the value NULL into column ”, table ”; column does not allow nulls. INSERT fails.
解决办法:
在Table中,找到提示的Column,修改它的属性为:
allow Nulls=N
Identity = Y
Identity seed = 1
Identity increment = 1
