Failed to create AppDomain 'xxx'. Exception has been Failed to create AppDomain

简介: 原文:Failed to create AppDomain 'xxx'. Exception has been Failed to create AppDomain一服务器上的数据库全部被置于紧急模式(EMERGENCY),在错误日志里面能看到大量下面的错误 Failed to create AppDomain "YourSQLDba.
原文: Failed to create AppDomain 'xxx'. Exception has been Failed to create AppDomain

一服务器上的数据库全部被置于紧急模式(EMERGENCY),在错误日志里面能看到大量下面的错误

Failed to create AppDomain "YourSQLDba.dbo[runtime].79". Exception has been thrown by the target of an invocation.

Failed to create AppDomain "YourSQLDba.dbo[runtime].76". Exception has been thrown by the target of an invocation.

....................................................................

在Error Log里面,我们可以看到甚至包括YourSQLDba这个库也被设置为单用户模式、紧急模式。如下截图所示,这个发生在凌晨YourSQLDba_FullBackups_And_Maintenance作业启动做备份、维护的时候。

Google 搜索了一下这方面资料,看到了官方的一个解释,如下所示。 具体参考这个链接Failed to create AppDomain "master.sys[runtime].X"

Microsoft 在 2011/12/6 於 22:24 公佈

Errors like:
Msg 6517, Level 16, State 1, Line 3
AppDomain "MDS.dbo [runtime] .20" Could not create.
Exception has been thrown by the target of an invocation.

come directly from .NET/CLR itself. It's usually about some inconsistency with the CLR/.NET itself. It means the CLR installation is corrupted (unlikely), or, more likely, a .NET patch was recently installed and the machine is pending a reboot.
Let us know if reboot doesn't fix the problem.
About the upgrade failure from upgrade step 677 to 678: this issue is fixed in Denali RC1.

翻译过来就是:这个错误通常是.NET/CLR 它本身导致的,通常是由于CLR/.NET它本身的一些不一致性导致(inconsistency),这意味着CLR安装损坏了(这个不太可能),大部分是由于最近安装了.NET 补丁,服务器没有重新启动导致。

继续查找更早的日志,其实发现9号就有这个“Failed to create AppDomain "YourSQLDba.dbo[runtime].xx". Exception has been thrown by the target of an invocation"这个错误出现,告警邮件也有收到,只是忙于处理其它事情,没有留意。

检查系统日志(Windows NT System log),发现确实存在Microsoft .NET Framework 自动更新的记录。如下所示

另外在”控制面板“->"程序”->"程序和功能“->"已安装更新"里面可以看到

解决方法很简单,需要重启数据库服务器来解决这个问题。

 

参考资料:

https://connect.microsoft.com/SQLServer/feedback/details/693184/failed-to-create-appdomain-master-sys-runtime-x

http://stackoverflow.com/questions/14912693/how-to-fix-the-error-failed-to-create-appdomain-ssisdb-dboruntime-x

目录
相关文章
|
16天前
|
编解码 数据处理
|
5月前
Failed to execute script ‘xxx‘ due to unhandled exception:No module named ‘ctypes‘
Failed to execute script ‘xxx‘ due to unhandled exception:No module named ‘ctypes‘
126 0
|
8月前
|
Java Android开发 Windows
成功解决eclipse启动报错 Error:Could not create the Java Virtual Machine Error:A fatal exception has occurred
成功解决eclipse启动报错 Error:Could not create the Java Virtual Machine Error:A fatal exception has occurred
|
8月前
|
IDE Java 开发工具
Idea 启动报错 failed to create jvmjvm path url或failed to create jvmerror code -1 jvm path
Idea 启动报错 failed to create jvmjvm path url或failed to create jvmerror code -1 jvm path
89 0
|
分布式计算 Ubuntu Hadoop
MapReduce报错:「MKDirs failed to create file」
MapReduce报错:「MKDirs failed to create file」
272 0
MapReduce报错:「MKDirs failed to create file」
How to resolve Unable to load groups error message
When you open Fiori launchpad, you can only see empty screen with the following error message:
How to resolve Unable to load groups error message
Error: <spyOn> : handleError() method does not exist
Error: <spyOn> : handleError() method does not exist
107 0
Error: <spyOn> : handleError() method does not exist
|
SQL 测试技术
The process could not read file xxx due to OS error 53
在不同地域的两个SQL Server服务器上配置了复制(Replication)用于同步数据(生产环境配置有Replication,测试环境也配有Replication),两地通过专线连接起来,这些复制(Replication)已经稳定运行了一两年了, 但是前阵子,测试环境的SQL Se...
1068 0
|
Windows Python
Fatal error in launcher:Unable to create process using
Windows 下同时存在 Python2 和 Python3 使用 pip 时系统报错:`Fatal error in launcher: Unable to create process using '"'` 的解决方案
5267 0