afaca 分析报告

1、【重点，优先处理】动态程序集：
   A、建议对 Application_BeginRequest 中大量的 Regex 采用缓存策略
      不需要对每个 Request 生成多个 Regex ，会造成服务器动态程序集过多，内存碎片超大
   B、检查代码中是否存在手动调用 XmlSerialization 对象，
 此对象也会动态生成程序集，解决方法见：http://support.microsoft.com/kb/886385/en-us

2、系统异常【详见随后文档中的详细附录】

3、其他问题：
   A、系统中的部分数据连接未关闭，一直保持连接，请检查相关代码。
      特别是 SqlConnection , SqlCommand, DataReader
   B、系统多余使用 DataTable 并未得到及时的释放，导致内存占用过大
      Total 243 DataTable objects

请先按照上述问题进行修改。
若IIS再次出现crash 情况，请到我的博客或CSDN资源中心下载工具，运行以监控IIS。
下载完成后，请查阅其“使用说明.txt”以了解其使用方法。

博客： http://blog.csdn.net/alonesword/
CSDN资源中心：

【附录：系统中异常信息】以上分析报告基于 dump1 进行，可能与现有系统的运行情况有出入。
 
      
0x79b9689c 1 64 System.Exception   
Exception 07f3aa68 in MT 79b9689c: System.Exception
_message: Critical error: The skinfile /Skins/en-US/default/Mall/MallStoreView.ascx could not be found. The skin must exist for this control to render.
_stackTrace:
0ebce660 [DEFAULT] [hasThis] Class System.Web.UI.Control Acafa.Controls.SkinnedWebControl.LoadSkin()
023ef460
0eb618c0
0ebce4b2 [DEFAULT] [hasThis] Void Acafa.Controls.SkinnedWebControl.CreateChildControls()
023ef52c
0eb618b0
1836ed0c [DEFAULT] [hasThis] Void Acafa.Controls.MallStoreView.CreateChildControls()
023ef538
180bcc58
0eb5f91c [DEFAULT] [hasThis] Void System.Web.UI.Control.EnsureChildControls()
023ef53c
0eb486f0
1836eb1b [DEFAULT] [hasThis] Void Acafa.Controls.MallStoreView.DataBind()
023ef564
180bcc88
1836ea9c [DEFAULT] [hasThis] Void Acafa.Controls.MallStoreView.OnLoad(Class System.EventArgs)
023ef580
180bcc78
0eb5f5c3 [DEFAULT] [hasThis] Void System.Web.UI.Control.LoadRecursive()
023ef590
0eb484b0
0eb5f602 [DEFAULT] [hasThis] Void System.Web.UI.Control.LoadRecursive()
023ef5a4
0eb484b0
0eb5f602 [DEFAULT] [hasThis] Void System.Web.UI.Control.LoadRecursive()
023ef5b8
0eb484b0
0eb5ecd6 [DEFAULT] [hasThis] Void System.Web.UI.Page.ProcessRequestMain()
023ef5cc
0eb496d0
_stackTraceString:
   at Acafa.Controls.SkinnedWebControl.LoadSkin()
   at Acafa.Controls.SkinnedWebControl.CreateChildControls()
   at Acafa.Controls.MallStoreView.CreateChildControls()
   at System.Web.UI.Control.EnsureChildControls()
   at Acafa.Controls.MallStoreView.DataBind()
   at Acafa.Controls.MallStoreView.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain()   
0x0c7dbb18 11 132 System.Web.HttpApplication/CancelModuleException   
修正了其他错误后，再看看此错误是否会继续发生   
0x0e54189c 2 136 System.Data.SqlClient.SqlException   
Exception 28e5e974 in MT 0e54189c: System.Data.SqlClient.SqlException
_message: System error.
重点分析如下sql 错误：
SELECT TOP         12 NL.*, AC.*, Country = dbo.Fn_GetAreaName(U.AreaCode,1,'en-US'),Province = dbo.Fn_GetAreaName(U.AreaCode,2,'en-US'),City = dbo.Fn_GetAreaName(U.AreaCode,3,'en-US'),Town = dbo.Fn_GetAreaName(U.AreaCode,4,'en-US') FROM ProductList NL,V_CompanyRoles U,AreaCode AC WHERE
   NL.Language = 'en-US' AND NL.UserId = U.UserId AND U.AreaCode = AC.AreaCode AND U.Language='en-US' AND AC.Language='en-US' AND NL.UserId=     25717 ORDER BY NL.RefreshDate DESC   
0x79bfc0a4 2 144 System.IO.FileNotFoundException   
Exception 07d4d8c8 in MT 79bfc0a4: System.IO.FileNotFoundException
_message: E:/WWWScript/Acafa-com/www-acafa-com/WebRun/ShoppingCart.aspx
_stackTrace:
0eb57ef2 [DEFAULT] [hasThis] Class System.Web.UI.ParserCacheItem System.Web.UI.TemplateParser.GetParserCacheItem()
0e7fee50
0c6f2090
0eb57015 [DEFAULT] [hasThis] Class System.Web.UI.ParserCacheItem System.Web.UI.TemplateControlParser.CompileAndGetParserCacheItem(String,String,Class System.Web.HttpContext)
0e7fee7c
0eb46220
0eb56e54 [DEFAULT] [hasThis] Object System.Web.UI.TemplateControlParser.GetCompiledInstance(String,String,Class System.Web.HttpContext)
0e7fee98
0eb46200
0eb56d7b [DEFAULT] Class System.Web.IHttpHandler System.Web.UI.PageParser.GetCompiledPageInstanceInternal(String,String,Class System.Web.HttpContext)
0e7feed8
0eb46648
0eb56cec [DEFAULT] [hasThis] Class System.Web.IHttpHandler System.Web.UI.PageHandlerFactory.GetHandler(Class System.Web.HttpContext,String,String,String)
0e7feeec
0eb45240
0eb52da3 [DEFAULT] [hasThis] Class System.Web.IHttpHandler System.Web.HttpApplication.MapHttpHandler(Class System.Web.HttpContext,String,String,String,Boolean)
0e7fef08
024cd888
_stackTraceString:
   at System.Web.UI.TemplateParser.GetParserCacheItem()
   at System.Web.UI.TemplateControlParser.CompileAndGetParserCacheItem(String virtualPath, String inputFile, HttpContext context)
   at System.Web.UI.TemplateControlParser.GetCompiledInstance(String virtualPath, String inputFile, HttpContext context)
   at System.Web.UI.PageParser.GetCompiledPageInstanceInternal(String virtualPath, String inputFile, HttpContext context)
   at System.Web.UI.PageHandlerFactory.GetHandler(HttpContext context, String requestType, String url, String path)
   at System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, String path, String pathTranslated, Boolean useAppConfig)   
0x0ff6aa84 8 576 System.Web.HttpUnhandledException   
Exception 09184b00 in MT 0ff6aa84: System.Web.HttpUnhandledException
_innerException:
   Exception 09184944 in MT 0c8809f8: Acafa.Components.WebException
   _message: 25194
   _stackTrace:
   1031975c [DEFAULT] [hasThis] Void Acafa.Controls.CompanyProductShow.InitializeSkin(Class System.Web.UI.Control)
   0f0af2c4
   0eb6b688
   0ebce4c0 [DEFAULT] [hasThis] Void Acafa.Controls.SkinnedWebControl.CreateChildControls()
   0f0af2dc
   0eb618b0
   0f9d935a [DEFAULT] [hasThis] Void Acafa.Controls.SkinnedWebsiteControl.CreateChildControls()
   0f0af2e8
   0eb61dc0
   0eb5f91c [DEFAULT] [hasThis] Void System.Web.UI.Control.EnsureChildControls()
   0f0af304
   0eb486f0
   102b0082 [DEFAULT] [hasThis] Void Acafa.Controls.CompanyProductShow.DataBind()
   0f0af32c
   0eb6b6a8
   0ffef6df [DEFAULT] [hasThis] Void Acafa.Controls.CompanyProductShow.OnLoad(Class System.EventArgs)
   0f0af534
   0eb6b698
   0eb5f5c3 [DEFAULT] [hasThis] Void System.Web.UI.Control.LoadRecursive()
   0f0af540
   0eb484b0
   0eb5f602 [DEFAULT] [hasThis] Void System.Web.UI.Control.LoadRecursive()
   0f0af554
   0eb484b0
   0eb5f602 [DEFAULT] [hasThis] Void System.Web.UI.Control.LoadRecursive()
   0f0af568
   0eb484b0
   0eb5f602 [DEFAULT] [hasThis] Void System.Web.UI.Control.LoadRecursive()
   0f0af57c
   0eb484b0
   0eb5f602 [DEFAULT] [hasThis] Void System.Web.UI.Control.LoadRecursive()
   0f0af590
   0eb484b0
   0eb5f602 [DEFAULT] [hasThis] Void System.Web.UI.Control.LoadRecursive()
   0f0af5a4
   0eb484b0
   0eb5f602 [DEFAULT] [hasThis] Void System.Web.UI.Control.LoadRecursive()
   0f0af5b8
   0eb484b0
   0eb5ecd6 [DEFAULT] [hasThis] Void System.Web.UI.Page.ProcessRequestMain()
   0f0af5cc
   0eb496d0

_stackTrace:
10c2073e [DEFAULT] [hasThis] Boolean System.Web.UI.Page.HandleError(Class System.Exception)
0f0af550
0eb49240
0eb5f21c [DEFAULT] [hasThis] Void System.Web.UI.Page.ProcessRequestMain()
0f0af584
0eb496d0
0eb5dab2 [DEFAULT] [hasThis] Void System.Web.UI.Page.ProcessRequest()
0f0af5c8
0eb49690
0eb5d322 [DEFAULT] [hasThis] Void System.Web.UI.Page.ProcessRequest(Class System.Web.HttpContext)
0f0af64c
0eb49680
0eb5d2fb [DEFAULT] [hasThis] Void System.Web.HttpApplication/CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
0f0af654
0c6f3df8
0c827e87 [DEFAULT] [hasThis] Class System.Exception System.Web.HttpApplication.ExecuteStep(Class IExecutionStep,ByRef Boolean)
0f0af664
024cd9b8   
0x79baeb74 11 704 System.InvalidCastException   
Exception 28955b44 in MT 79baeb74: System.InvalidCastException
_message: Object cannot be cast from DBNull to other types.
_stackTrace:
79a11968 [DEFAULT] [hasThis] I4 System.DBNull.System.IConvertible.ToInt32(Class System.IFormatProvider)
01daf70c
79bc0768
799d3df4 [DEFAULT] I4 System.Convert.ToInt32(Object)
01daf714
79bc00a0
0e4d2efc [DEFAULT] Class Acafa.Components.Area Acafa.Components.AcafaDataProvider.PopulateAreaFromIDataReader(Class System.Data.IDataReader)
01daf718
0c880c28   
0x79bcac64 19 1,216 System.NullReferenceException   
Exception 29037d68 in MT 79bcac64: System.NullReferenceException
_message: Object reference not set to an instance of an object.
_stackTrace:
0ebcb12d [DEFAULT] [hasThis] Void Acafa.Web.CnAcafa.Utility.AreaDropDownList.Page_Load(Object,Class System.EventArgs)
023ef578
0eb62b88   
0x024c874c 24 1,728 System.Web.HttpException   
Exception 295e2d60 in MT 024c874c: System.Web.HttpException
_message: Cannot redirect after HTTP headers have been sent.
_stackTrace:
0ff5274e [DEFAULT] [hasThis] Void System.Web.HttpResponse.Redirect(String,Boolean)
1019f460
024c7c80
0ffe3d21 [DEFAULT] Void Acafa.AspNetForums.Components.ForumContext.RedirectToMessage(Class System.Web.HttpContext,Class Acafa.Components.WebException)
1019f47c
0e4bb398
0ffe3c5e [DEFAULT] [hasThis] Void Acafa.AspNetForums.ForumsHttpModule.Application_OnError(Object,Class System.EventArgs)
1019f48c
0c7c5368
00000000
00000000
79bc5940
0ff51c7f [DEFAULT] [hasThis] Void System.Web.HttpApplication.RaiseOnError()
1019f4e4
024cd778   
0x79bcfee4 31 1,984 System.Threading.ThreadAbortException   
先修正其他错误后，再检查此错误是否可发生
Exception 28978a38 in MT 79bcfee4: System.Threading.ThreadAbortException
_message: Thread was being aborted.
_stackTrace:
0eb5f1ed [DEFAULT] [hasThis] Void System.Web.UI.Page.ProcessRequestMain()
01daf8cc
0eb496d0
0eb5dab2 [DEFAULT] [hasThis] Void System.Web.UI.Page.ProcessRequest()
01daf8c8
0eb49690
0eb5d322 [DEFAULT] [hasThis] Void System.Web.UI.Page.ProcessRequest(Class System.Web.HttpContext)
01daf94c
0eb49680
0eb5d2fb [DEFAULT] [hasThis] Void System.Web.HttpApplication/CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
01daf954
0c6f3df8
0c827e87 [DEFAULT] [hasThis] Class System.Exception System.Web.HttpApplication.ExecuteStep(Class IExecutionStep,ByRef Boolean)
01daf964
024cd9b8   
0x79c0019c 62 3,968 System.Runtime.Serialization.SerializationException   
Exception 2960c794 in MT 79c0019c: System.Runtime.Serialization.SerializationException
_message: End of Stream encountered before parsing was completed.
_stackTrace:
799c0714 [DEFAULT] [hasThis] Void System.Runtime.Serialization.Formatters.Binary.__BinaryParser.Run()
1019f2a8
79be46e8
799c004c [DEFAULT] [hasThis] Object System.Runtime.Serialization.Formatters.Binary.ObjectReader.Deserialize(Class System.Runtime.Remoting.Messaging.HeaderHandler,Class System.Runtime.Serialization.Formatters.Binary.__BinaryParser,Boolean,Class System.Runtime.Remoting.Messaging.IMethodCallMessage)
1019f324
79be40e0
799bfc77 [DEFAULT] [hasThis] Object System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(Class System.IO.Stream,Class System.Runtime.Remoting.Messaging.HeaderHandler,Boolean,Class System.Runtime.Remoting.Messaging.IMethodCallMessage)
1019f364
79bd2130
0ea908bd [DEFAULT] [hasThis] Void Acafa.AspNetForums.Components.ForumUser.DeserializeExtendedAttributes(SZArray UI1)
1019f384
0e4bf588   
0x79bd1414 62 3,968 System.IO.EndOfStreamException   
Exception 2960c700 in MT 79bd1414: System.IO.EndOfStreamException
_message: Unable to read beyond the end of the stream.
_stackTrace:
79aa8dd8 [DEFAULT] Void System.IO.__Error.EndOfFile()
1019f294
79bf7e10
799ae2a3 [DEFAULT] [hasThis] Void System.IO.BinaryReader.FillBuffer(I4)
1019f29c
79ba2578
799ae1e9 [DEFAULT] [hasThis] I4 System.IO.BinaryReader.ReadInt32()
1019f2b0
79ba2498
799c07f3 [DEFAULT] [hasThis] Void System.Runtime.Serialization.Formatters.Binary.SerializationHeaderRecord.Read(Class System.Runtime.Serialization.Formatters.Binary.__BinaryParser)
1019f2b8
79be00b0
799c075b [DEFAULT] [hasThis] Void System.Runtime.Serialization.Formatters.Binary.__BinaryParser.ReadSerializationHeaderRecord()
1019f2e0
79be4848
799c02c8 [DEFAULT] [hasThis] Void System.Runtime.Serialization.Formatters.Binary.__BinaryParser.Run()
1019f2f0
79be46e8   
0x79bc8d1c 70 4,480 System.IndexOutOfRangeException   
Exception 295d3cb4 in MT 79bc8d1c: System.IndexOutOfRangeException
_message: RegisterCompanyId
_stackTrace:
0e667257 [DEFAULT] [hasThis] Void System.Data.Common.FieldNameLookup.GenerateLookup()
1019efd4
0e6518a0
0e666ed6 [DEFAULT] [hasThis] I8 System.Data.SqlClient.SqlDataReader.GetBytes(I4,I8,SZArray UI1,I4,I4)
1019efdc
0e542150
0e666e72 [DEFAULT] [hasThis] I8 System.Data.SqlClient.SqlDataReader.GetChars(I4,I8,SZArray Char,I4,I4)
1019efec
0e542170
0e4d1f6b [DEFAULT] Class Acafa.Components.TradeCompany Acafa.Components.AcafaDataProvider.PopulateTradeCompanyFromIDataReader(Class System.Data.IDataReader)
1019eff4
0c881298   
0x79b9fd5c 887 60,316 System.ArgumentNullException   
Exception 29603838 in MT 79b9fd5c: System.ArgumentNullException
_message: Value cannot be null.
_stackTrace:
7999bb35 [DEFAULT] Object System.Enum.Parse(Class System.Type,String,Boolean)
1019eef0
79b95e90
0ea8b22f [DEFAULT] [hasThis] Void Acafa.Components.WebContext..ctor()
1019ef3c
0c7ca4f0   
Total 1,193 objects, Total size: 79,608