none
wsus迁移之后,数据库错误。 RRS feed

  • 问题

  • 本来wsus服务是正常的,wsus目录是在D盘;d:\wsus

    但是最近D盘空间不够了,就将wsus数据迁移到E盘去;

    迁移步骤参照如下:

    1. 以本地管理员身份登录到WSUS服务器.
    2. 在目标分区建立文件夹以存放更新文件如e:\wsus。
    3. 打开一个CMD命令行窗口,然后进入以下路径:
    C:\program files\update services\tools
    4. 运行以下命令以转移更新文件:
    wsusutil.exe movecontent <new contentpath> <logfile>
    如:
    wsusutil.exe movecontent e:\WSUS e:\move.log
    "e:\WSUS" 是新的目标路径;"e:\move.log" 是转移过程中的日志。
    5.从日志中确认转移过程已完成;

    从日志文件看,迁移过程是成功的。(原来的D盘wsus目录的文件,都没有删除

    这是迁移日志文件内容:

    2014-02-06T02:21:52 Successfully stopped WsusService.
    2014-02-06T02:21:52 Beginning content file location change to e:\wsus
    2014-02-06T09:30:29 Successfully copied content files.
    2014-02-06T09:30:29 Successfully copied application files.
    2014-02-06T09:30:31 Successfully changed WUS configuration.
    2014-02-06T09:30:32 Successfully changed IIS virtual directory path.
    2014-02-06T09:30:32 Successfully removed existing local content network shares.
    2014-02-06T09:30:32 Successfully created local content network shares.
    2014-02-06T09:30:32 Successfully changed registry value for content store directory.
    2014-02-06T09:30:32 Successfully changed content file location.
    2014-02-06T09:30:34 Successfully started WsusService.
    2014-02-06T09:30:34 Content integrity check and repair...
    2014-02-06T09:30:34 Initiated content integrity check and repair.

    但是再打开wsus控制台,控制台会包错误:数据库错误;

    并且softwaredistribution.log文件错误如下:

    2014-02-11 01:16:43.202 UTC Error w3wp.24 SusEventDispatcher.DispatchManagerDatabasePollingThreadProc SusEventDispatcher got exception while polling database. Polling will continue: Excpetion details: System.Data.SqlClient.SqlException: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.runTryCode(Object userData)
       在 System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
       在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:16:43.217 UTC Error w3wp.13 SusEventDispatcher.DispatchManagerDatabasePollingThreadProc SusEventDispatcher got exception while polling database. Polling will continue: Excpetion details: System.Data.SqlClient.SqlException: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.runTryCode(Object userData)
       在 System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
       在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:16:43.233 UTC Error w3wp.16 SusEventDispatcher.DispatchManagerDatabasePollingThreadProc SusEventDispatcher got exception while polling database. Polling will continue: Excpetion details: System.Data.SqlClient.SqlException: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.runTryCode(Object userData)
       在 System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
       在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:16:43.358 UTC Error WsusService.7 SusEventDispatcher.DispatchManagerDatabasePollingThreadProc SusEventDispatcher got exception while polling database. Polling will continue: Excpetion details: System.Data.SqlClient.SqlException: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.runTryCode(Object userData)
       在 System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
       在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:16:43.499 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: ExecuteReader() 
     CommandText: spGetChangeTrackingInformation
     SqlException:
    System.Data.SqlClient.SqlException: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:16:43.499 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: Dumping SqlException.Errors:
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:16:43.514 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER:   Errors[0]: Source .Net SqlClient Data Provider, Server \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query, Number -2, Class 11, State 0, Procedure , LineNumber 0: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:16:43.514 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: End of SqlException.Errors.  Rethrowing the exception.
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:16:43.530 UTC Error FCSDS.7 SusEventDispatcher.DispatchManagerDatabasePollingThreadProc SusEventDispatcher got exception while polling database. Polling will continue: Excpetion details: System.Data.SqlClient.SqlException: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:18:29.013 UTC Info w3wp.69 ThreadEntry ISAPIRuntime.ProcessRequest
    2014-02-11 01:18:29.013 UTC Error w3wp.69 ClientImplementation.GetExtendedUpdateInfo System.Threading.ThreadAbortException: Thread was being aborted.
       在 System.Threading.Monitor.Enter(Object obj)
       在 System.Data.SqlClient.TdsParser.get_Errors()
       在 System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
       在 System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
       在 System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
       在 System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
       在 System.Data.SqlClient.TdsParserStateObject.ReadByte()
       在 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       在 System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       在 System.Data.SqlClient.SqlDataReader.get_MetaData()
       在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       在 System.Data.SqlClient.SqlCommand.ExecuteReader()
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSpGetCoreUpdateXml(Int32[] revisionIds)
       在 Microsoft.UpdateServices.Internal.DataAccessCache.GetCoreUpdateXml(Int32[] revisionIds, DataAccess da, Int64 maxXmlPerRequest)
       在 Microsoft.UpdateServices.Internal.ClientImplementation.GetExtendedUpdateInfo(Cookie cookie, Int32[] revisionIds, XmlUpdateFragmentType[] fragmentTypes, String[] locales)
       在 Microsoft.UpdateServices.Internal.ClientImplementation.GetExtendedUpdateInfo(Cookie cookie, Int32[] revisionIds, XmlUpdateFragmentType[] fragmentTypes, String[] locales)
       在 Microsoft.UpdateServices.Internal.Client.GetExtendedUpdateInfo(Cookie cookie, Int32[] revisionIDs, XmlUpdateFragmentType[] infoTypes, String[] locales)
       在 System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
       在 System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
       在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       在 System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
       在 System.Web.Services.Protocols.WebServiceHandler.Invoke()
       在 System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
       在 System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
       在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
       在 System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)
       在 System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
       在 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
       在 System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
       在 System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
    2014-02-11 01:18:29.029 UTC Warning w3wp.69 SoapUtilities.CreateException ThrowException: actor = http://192.168.1.6/ClientWebService/client.asmx, ID=c0307f16-51d0-418a-8279-6594bfc9d53a, ErrorCode=InternalServerError, Message=, Client=03b5f804-746a-4c66-981b-ba500ffd8b7f
    2014-02-11 01:19:23.529 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: Dumping SqlException.Errors:
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:19:23.529 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER:   Errors[0]: Source .Net SqlClient Data Provider, Server \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query, Number -2, Class 11, State 0, Procedure , LineNumber 0: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:19:23.544 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: End of SqlException.Errors.  Rethrowing the exception.
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:19:27.138 UTC Info w3wp.74 ThreadEntry ThreadHelper.ThreadStart
    2014-02-11 01:19:27.138 UTC Error w3wp.74 DataAccess.ExecuteSpGetGlobalUpdates Error: ExecuteSpGetGlobalUpdates: - 超时时间已到。在操作完成之前超时时间已过或服务器未响应。.
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSpGetGlobalUpdates(Int64 lastChangeNumber, Int64 newChangeNumber)
       在 Microsoft.UpdateServices.Internal.SyncUpdatesHelper.BuildGlobalUpdates(GlobalUpdate[] oldData, Int64 oldChangeNumber, Int64 newChangeNumber)
       在 Microsoft.UpdateServices.Internal.SyncUpdatesHelper.InitializeRefreshCache()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.runTryCode(Object userData)
       在 System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
       在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:19:32.576 UTC Error w3wp.35 ClientImplementation.GetExtendedUpdateInfo System.Threading.ThreadAbortException: Thread was being aborted.
       在 System.Threading.Monitor.Enter(Object obj)
       在 System.Data.SqlClient.TdsParser.get_Errors()
       在 System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
       在 System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
       在 System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
       在 System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
       在 System.Data.SqlClient.TdsParserStateObject.ReadByte()
       在 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       在 System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       在 System.Data.SqlClient.SqlDataReader.get_MetaData()
       在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       在 System.Data.SqlClient.SqlCommand.ExecuteReader()
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSpGetCoreUpdateXml(Int32[] revisionIds)
       在 Microsoft.UpdateServices.Internal.DataAccessCache.GetCoreUpdateXml(Int32[] revisionIds, DataAccess da, Int64 maxXmlPerRequest)
       在 Microsoft.UpdateServices.Internal.ClientImplementation.GetExtendedUpdateInfo(Cookie cookie, Int32[] revisionIds, XmlUpdateFragmentType[] fragmentTypes, String[] locales)
       在 Microsoft.UpdateServices.Internal.ClientImplementation.GetExtendedUpdateInfo(Cookie cookie, Int32[] revisionIds, XmlUpdateFragmentType[] fragmentTypes, String[] locales)
       在 Microsoft.UpdateServices.Internal.Client.GetExtendedUpdateInfo(Cookie cookie, Int32[] revisionIDs, XmlUpdateFragmentType[] infoTypes, String[] locales)
       在 System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
       在 System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
       在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       在 System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
       在 System.Web.Services.Protocols.WebServiceHandler.Invoke()
       在 System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
       在 System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
       在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
       在 System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)
       在 System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
       在 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
       在 System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
       在 System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
    2014-02-11 01:19:32.576 UTC Warning w3wp.35 SoapUtilities.CreateException ThrowException: actor = http://192.168.1.6/ClientWebService/client.asmx, ID=d2a26f2c-89cb-43b1-b497-215f47026275, ErrorCode=InternalServerError, Message=, Client=03b5f804-746a-4c66-981b-ba500ffd8b7f
    2014-02-11 01:20:24.606 UTC Error WsusService.8 HealthMonitoringTasks.ExecuteSubtask Health Monitoring Thread caught an exception: System.Data.SqlClient.SqlException: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteGetSingleResult()
       在 Microsoft.UpdateServices.Internal.SingleValueSPHandler.ExecuteStoredProcedure(DBConnection connection)
       在 Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler, Int32 queryTimeoutInSeconds)
       在 Microsoft.UpdateServices.Internal.DatabaseAccess.CommonDataAccess.ExecuteSPSingleValue(String spName, DBParameterCollection args, Int32 queryTimeoutInSeconds)
       在 Microsoft.UpdateServices.Internal.DatabaseAccess.CommonDataAccess.ExecuteSPSingleValue(String spName, DBParameterCollection args)
       在 Microsoft.UpdateServices.Internal.DatabaseAccess.CommonDataAccess.ExecuteSPSingleValue(String spName)
       在 Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetFailedToDownloadUpdatesCount()
       在 Microsoft.UpdateServices.Internal.BaseApi.UpdateServer.GetFailedToDownloadUpdatesCount()
       在 Microsoft.UpdateServices.Internal.HealthMonitoring.HmtCore.CheckForContentSyncFailures(EventLoggingType type, HealthEventLogger logger)
       在 Microsoft.UpdateServices.Internal.HealthMonitoring.HealthMonitoringTasks.ExecuteSubtask(HealthMonitoringSubtask subtask, EventLoggingType type, HealthEventLogger logger)
       在 Microsoft.UpdateServices.Internal.HealthMonitoring.HealthMonitoringTasks.ExecuteSubtask(HealthMonitoringSubtask subtask, EventLoggingType type, HealthEventLogger logger)
       在 Microsoft.UpdateServices.Internal.HealthMonitoring.HmtCore.Execute(EventLoggingType type)
       在 Microsoft.UpdateServices.Internal.HealthMonitoring.HealthMonitoringTasks.Execute(EventLoggingType type)
       在 Microsoft.UpdateServices.Internal.HealthMonitoring.HealthMonitoringThreadManager.Execute(Boolean waitIfNecessary, EventLoggingType loggingType)
       在 Microsoft.UpdateServices.Internal.HealthMonitoring.HealthMonitoringThreadManager.PeriodicTask()
       在 Microsoft.UpdateServices.Internal.HealthMonitoring.PeriodicTaskExecuter.ThreadStart()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.runTryCode(Object userData)
       在 System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
       在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:21:58.543 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: Dumping SqlException.Errors:
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:21:58.559 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER:   Errors[0]: Source .Net SqlClient Data Provider, Server \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query, Number -2, Class 11, State 0, Procedure , LineNumber 0: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:21:58.559 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: End of SqlException.Errors.  Rethrowing the exception.
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:24:06.027 UTC Warning w3wp.1 SoapUtilities.CreateException ThrowException: actor = http://192.168.1.6/ClientWebService/client.asmx, ID=0ed71a91-1cec-4e3e-8bbc-9aeed4afacd8, ErrorCode=ServerChanged, Message=Server rolled back since last call to GetCookie, Client=a6dab232-d2d7-4480-9827-a6c403c76c84
    2014-02-11 01:24:33.558 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: Dumping SqlException.Errors:
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
    2014-02-11 01:24:33.558 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER:   Errors[0]: Source .Net SqlClient Data Provider, Server \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query, Number -2, Class 11, State 0, Procedure , LineNumber 0: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
       在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
       在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()

    先就此谢过!


    张杰

    2014年2月11日 8:53

答案