(500) Server Error: Execution Timeout Expired. SqlConnection.OnError ... while clicking on "release" tab

[marc.ledent_9164]

Hi,

For about two months, we have from time to time (500) Server Error. In the log we have the following:

 URL: http://sara.services.gcloud.belgium.be/releases
Referrer: http://sara.services.gcloud.belgium.be/all-applications
User: smals-marled@gcloud.dom
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36
Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
...
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.TaskAsyncHelper.EndTask(IAsyncResult ar)
at Inedo.Web.Handlers.AsyncHandlerWrapper.EndProcessRequest(IAsyncResult result)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

It looks like a DB connection timeout, but the connection to DB is OK.
What could this be?

Marc

[rhessinger]

Hi @marc-ledent_9164,

Can you please tell me what version of BuildMaster you are running?

Thanks,
Rich

[marc.ledent_9164]

@rhessinger v 7.0.14

[rhessinger]

Hi @marc-ledent_9164,

Thanks for confirming that for me. How often do you see this issue? Is it always for the same application or does it happen on any application?

Thanks,
Rich

[marc.ledent_9164]

@rhessinger Hi Rich,

As this problem becomes blocking, I created a ticket.

KR,
Marc

[marc.ledent_9164]

Just to inform people here:

This was due to an over-fragmented indexes in the DB.

By reorganizing such indexes the problem was solved, even if the request itself still takes 10s.

For more info: https://inedo.com/support/kb/1167/sql-server-recommendations

Thanks to the Inedo team,
Marc

[Dan_Woolf]

Hi @marc-ledent_9164,

Thanks for following up and letting everyone know that this fixed your issue!

Thanks,
Dan