Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.

If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!

SQL Timeout



  • On our UAT PRoGet server we often get sql timeouts performing various tasks. Trying to manage a feed has just resulted in this

    [Win32Exception (0x80004005): The wait operation timed out]

    [SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]
    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) +3180428 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +332 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4224 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +87 System.Data.SqlClient.SqlDataReader.get_MetaData() +99 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption) +584 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3069 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +674
    System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +83
    System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +301
    Inedo.Data.DatabaseContext.ExecuteInternal(String storedProcName, GenericDbParameter[] parameters) +164
    Inedo.ProGet.Data.Context.Dashboards_GetDashboardInfo(Nullable1 Packages_Count, Nullable1 IncludeInactive_Indicator) +394
    Inedo.ProGet.WebApplication.Pages.Administration.Feeds.Management.ManageFeedPage.CreateChildControls() +926
    Inedo.ProGet.WebApplication.Pages.<InitializeAsync>d__2.MoveNext() +197
    System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
    System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +60
    Inedo.Web.PageFree.<ProcessRequestAsync>d__46.MoveNext() +278
    System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
    System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +60
    System.Web.TaskAsyncHelper.EndTask(IAsyncResult ar) +64
    Inedo.Web.Handlers.AsyncHandlerWrapper.EndProcessRequest(IAsyncResult result) +33
    System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +393
    System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +195
    System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +128

    Our UAT ProGet and database server are both on virtual machines, so I appreciate that performance won't be as good as a physical setup. However I'm wondering if there is a timeout config setting I can change to workaround this error?

    Product: ProGet
    Version: 5.0.12


  • inedo-engineer

    I'm afraid there's not any further configuration. This will happen on any server, physical or virtual, when the SQL Server cannot be contacted.

    It's usually related to network connections, or the SQL Server is just totally bogged down from other things. See if rebooting fixed it, that will often help.


Log in to reply
 

Inedo Website HomeSupport HomeCode of ConductForums GuideDocumentation